explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c2X2

Settings
# exclusive inclusive rows x rows loops node
1. 1.426 144.429 ↑ 1.0 1 1

Aggregate (cost=88,163.53..88,163.54 rows=1 width=8) (actual time=144.429..144.429 rows=1 loops=1)

2. 43.697 143.003 ↓ 2.9 17,679 1

Nested Loop (cost=1.16..88,148.25 rows=6,114 width=0) (actual time=0.257..143.003 rows=17,679 loops=1)

3. 5.424 39.395 ↓ 6.2 59,911 1

Nested Loop (cost=0.73..74,789.55 rows=9,590 width=4) (actual time=0.028..39.395 rows=59,911 loops=1)

4. 0.046 0.046 ↓ 1.8 23 1

Index Scan using survey_surveyinstance_f on survey_surveyinstance (cost=0.29..33.43 rows=13 width=4) (actual time=0.013..0.046 rows=23 loops=1)

  • Index Cond: ((final_date_time < now()) AND (final_date_time > (now() - '7 days'::interval)))
5. 33.925 33.925 ↓ 1.2 2,605 23

Index Scan using survey_surveytaker_instance_id on survey_surveytaker t (cost=0.43..5,728.27 rows=2,220 width=8) (actual time=0.012..1.475 rows=2,605 loops=23)

  • Index Cond: (instance_id = survey_surveyinstance.id)
6. 59.911 59.911 ↓ 0.0 0 59,911

Index Only Scan using survey_takercomment_81e8199a on survey_takercomment c (cost=0.43..1.05 rows=34 width=4) (actual time=0.001..0.001 rows=0 loops=59,911)

  • Index Cond: (taker_id = t.id)
  • Heap Fetches: 17,679
Planning time : 0.606 ms
Execution time : 144.470 ms