explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tP7x

Settings
# exclusive inclusive rows x rows loops node
1. 5,487.490 6,572.259 ↑ 1.0 1 1

Aggregate (cost=205,149.63..205,149.64 rows=1 width=8) (actual time=6,572.259..6,572.259 rows=1 loops=1)

  • Buffers: shared hit=416 read=160,613, temp read=103,989 written=104,348
2. 1,084.769 1,084.769 ↑ 1.1 3,311,284 1

Seq Scan on interviewsummaries interviewsummaries (cost=0..196,325.5 rows=3,529,650 width=33) (actual time=0.03..1,084.769 rows=3,311,284 loops=1)

  • Buffers: shared hit=416 read=160,613
Planning time : 0.176 ms
Execution time : 6,572.279 ms