explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BiYg

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 513.071 ↑ 1.0 10 1

Limit (cost=103,058.17..103,058.20 rows=10 width=175) (actual time=513.065..513.071 rows=10 loops=1)

2. 4.989 513.067 ↑ 1,942.2 10 1

Sort (cost=103,058.17..103,106.73 rows=19,422 width=175) (actual time=513.063..513.067 rows=10 loops=1)

  • Sort Key: (count(*)) DESC
  • Sort Method: top-N heapsort Memory: 26kB
3. 74.031 508.078 ↑ 1.3 15,323 1

HashAggregate (cost=102,444.25..102,638.47 rows=19,422 width=175) (actual time=502.694..508.078 rows=15,323 loops=1)

  • Group Key: d_pages.page_url
  • Filter: (count(*) >= 0)
4. 93.421 434.047 ↓ 1.0 19,441 1

Merge Join (cost=72,258.89..102,298.59 rows=19,422 width=167) (actual time=48.060..434.047 rows=19,441 loops=1)

  • Merge Cond: (d_pages.page_key = f_survey_views.page_key)
5. 292.754 292.754 ↓ 1.0 357,920 1

Index Scan using d_pages_pkey on d_pages (cost=0.42..28,855.30 rows=357,914 width=171) (actual time=0.003..292.754 rows=357,920 loops=1)

6. 14.384 47.872 ↓ 1.0 19,442 1

Sort (cost=72,257.43..72,305.99 rows=19,422 width=4) (actual time=41.947..47.872 rows=19,442 loops=1)

  • Sort Key: f_survey_views.page_key
  • Sort Method: quicksort Memory: 1680kB
7. 26.911 33.488 ↓ 1.0 19,445 1

Bitmap Heap Scan on f_survey_views (cost=10,087.08..70,874.06 rows=19,422 width=4) (actual time=9.107..33.488 rows=19,445 loops=1)

  • Recheck Cond: (survey_key = 150623074)
  • Heap Blocks: exact=15688
8. 6.577 6.577 ↓ 1.0 19,445 1

Bitmap Index Scan on f_survey_views_pkey (cost=0.00..10,082.22 rows=19,422 width=0) (actual time=6.577..6.577 rows=19,445 loops=1)

  • Index Cond: (survey_key = 150623074)