explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t9ju : https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/27904#note_167823038

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.033 ↓ 0.0 0 1

Sort (cost=6.96..6.96 rows=2 width=520) (actual time=0.033..0.033 rows=0 loops=1)

  • Sort Key: (NULL::integer) NULLS FIRST
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=6
2. 0.000 0.030 ↓ 0.0 0 1

Unique (cost=6.91..6.93 rows=2 width=520) (actual time=0.030..0.030 rows=0 loops=1)

  • Buffers: shared hit=6
3. 0.004 0.030 ↓ 0.0 0 1

Sort (cost=6.91..6.92 rows=2 width=520) (actual time=0.030..0.030 rows=0 loops=1)

  • Sort Key: (NULL::integer), users.email
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=6
4. 0.000 0.026 ↓ 0.0 0 1

Append (cost=0.43..6.90 rows=2 width=520) (actual time=0.026..0.026 rows=0 loops=1)

  • Buffers: shared hit=6
5. 0.015 0.015 ↓ 0.0 0 1

Index Scan using users_pkey on users (cost=0.43..3.45 rows=1 width=27) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (id = 30000)
  • Buffers: shared hit=3
6. 0.011 0.011 ↓ 0.0 0 1

Index Scan using index_emails_on_user_id on emails (cost=0.42..3.44 rows=1 width=28) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (user_id = 30000)
  • Buffers: shared hit=3
Planning time : 0.290 ms
Execution time : 0.056 ms