explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zdk

Settings
# exclusive inclusive rows x rows loops node
1. 3.763 317.521 ↑ 1.0 1 1

Aggregate (cost=173,230.50..173,230.51 rows=1 width=8) (actual time=317.520..317.521 rows=1 loops=1)

2. 221.298 313.758 ↓ 4.4 52,126 1

Nested Loop (cost=0.87..173,200.97 rows=11,812 width=0) (actual time=0.065..313.758 rows=52,126 loops=1)

  • -> 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 lo
3. 82.731 92.460 ↓ 7.1 133,615 1

Nested Loop (cost=0.43..147,138.66 rows=18,709 width=4) (actual time=0.023..92.460 rows=133,615 loops=1)

  • -> Index Scan using survey_surveytaker_instance_id on survey_surveytaker t (cost=0.43..5643.01 rows=2,236 width=8) (actual time=0.012..2.832 ro
  • Index Cond: (taker_id = t.id)
  • Heap Fetches: 86,846
4. 9.729 9.729 ↑ 1.0 25 1

Seq Scan on survey_surveyinstance (cost=0.00..5,504.52 rows=25 width=4) (actual time=0.009..9.729 rows=25 loops=1)

  • Filter: ((final_date_time < now()) AND (final_date_time > (now() - '7 days'::interval)))
  • Rows Removed by Filter: 12,709
  • Index Cond: (instance_id = survey_surveyinstance.id)
Planning time : 0.683 ms
Execution time : 317.559 ms