explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2OyA

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 5,066.100 ↑ 1.0 10 1

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

2. 0.021 5,066.094 ↑ 1,286.0 10 1

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

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

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

4. 568.439 5,065.667 ↑ 1,169.1 11 1

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

  • Group Key: f_survey_views.page_key
  • Filter: (count(1) > 50)
  • Rows Removed by Filter: 8316
5. 4,021.721 4,497.228 ↓ 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=506.588..4,497.228 rows=1,668,209 loops=1)

  • Recheck Cond: (survey_key = 881918575)
  • Rows Removed by Index Recheck: 18143385
  • Heap Blocks: exact=106919 lossy=725382
6. 475.507 475.507 ↓ 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=475.507..475.507 rows=2,114,817 loops=1)

  • Index Cond: (survey_key = 881918575)
7. 0.385 0.385 ↑ 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.035 rows=1 loops=11)

  • Index Cond: (page_key = f_survey_views.page_key)