explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7aOP

Settings
# exclusive inclusive rows x rows loops node
1. 3.754 333.710 ↑ 1.0 1 1

Aggregate (cost=173,228.89..173,228.90 rows=1 width=8) (actual time=333.709..333.710 rows=1 loops=1)

2. 99.580 329.956 ↓ 4.4 52,126 1

Nested Loop (cost=0.87..173,199.38 rows=11,801 width=0) (actual time=0.067..329.956 rows=52,126 loops=1)

3. 11.750 96.761 ↓ 7.1 133,615 1

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

4. 10.186 10.186 ↑ 1.0 25 1

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

  • Filter: ((final_date_time < now()) AND (final_date_time > (now() - '7 days'::interval)))
  • Rows Removed by Filter: 12,709
5. 74.825 74.825 ↓ 2.4 5,345 25

Index Scan using survey_surveytaker_instance_id on survey_surveytaker t (cost=0.43..5,643.01 rows=2,236 width=8) (actual time=0.013..2.993 rows=5,345 loops=25)

  • Index Cond: (instance_id = survey_surveyinstance.id)
6. 133.615 133.615 ↓ 0.0 0 133,615

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=133,615)

  • Index Cond: (taker_id = t.id)
  • Heap Fetches: 79,794
Planning time : 0.618 ms
Execution time : 333.755 ms