explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k3CI

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 5,336.586 ↑ 1.0 10 1

Limit (cost=2,215,748.35..2,215,748.38 rows=10 width=212) (actual time=5,336.580..5,336.586 rows=10 loops=1)

2. 0.022 5,336.579 ↑ 1,286.0 10 1

Sort (cost=2,215,748.35..2,215,780.50 rows=12,860 width=212) (actual time=5,336.578..5,336.579 rows=10 loops=1)

  • Sort Key: (count(1)) DESC
  • Sort Method: quicksort Memory: 26kB
3. 0.028 5,336.557 ↑ 1,286.0 10 1

Nested Loop (cost=2,110,897.79..2,215,470.45 rows=12,860 width=212) (actual time=5,334.719..5,336.557 rows=10 loops=1)

4. 560.660 5,336.133 ↑ 1,169.1 11 1

HashAggregate (cost=2,110,897.35..2,111,025.95 rows=12,860 width=12) (actual time=5,334.693..5,336.133 rows=11 loops=1)

  • Group Key: f_survey_views.page_key
  • Filter: (count(1) > 50)
  • Rows Removed by Filter: 8316
5. 4,062.712 4,775.473 ↓ 1.1 1,668,209 1

Bitmap Heap Scan on f_survey_views (cost=284,968.54..2,099,028.98 rows=1,582,449 width=4) (actual time=745.905..4,775.473 rows=1,668,209 loops=1)

  • Recheck Cond: (survey_key = 881918575)
  • Rows Removed by Index Recheck: 18143385
  • Heap Blocks: exact=106919 lossy=725382
6. 712.761 712.761 ↓ 1.3 2,114,817 1

Bitmap Index Scan on index_f_survey_views_on_survey_key (cost=0.00..284,572.93 rows=1,582,449 width=0) (actual time=712.761..712.761 rows=2,114,817 loops=1)

  • Index Cond: (survey_key = 881918575)
7. 0.396 0.396 ↑ 1.0 1 11

Index Scan using d_pages_pkey on d_pages (cost=0.44..8.10 rows=1 width=208) (actual time=0.006..0.036 rows=1 loops=11)

  • Index Cond: (page_key = f_survey_views.page_key)