explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ppms

Settings
# exclusive inclusive rows x rows loops node
1. 4.644 368.598 ↑ 1.0 1 1

Aggregate (cost=172,866.29..172,866.30 rows=1 width=8) (actual time=368.598..368.598 rows=1 loops=1)

2. 263.500 363.954 ↓ 4.5 52,126 1

Nested Loop (cost=0.87..172,837.18 rows=11,645 width=0) (actual time=0.065..363.954 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.002 rows=0 lo
3. 90.648 100.454 ↓ 7.2 133,615 1

Nested Loop (cost=0.43..147,142.76 rows=18,445 width=4) (actual time=0.023..100.454 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.013..3.103 ro
  • Index Cond: (taker_id = t.id)
  • Heap Fetches: 86,846
4. 9.806 9.806 ↑ 1.0 25 1

Seq Scan on survey_surveyinstance (cost=0.00..5,508.61 rows=25 width=4) (actual time=0.009..9.806 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.607 ms
Execution time : 368.635 ms