explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B79Q

Settings
# exclusive inclusive rows x rows loops node
1. 3,320.453 4,134.147 ↑ 1.0 1 1

Aggregate (cost=105,927.42..105,927.43 rows=1 width=32) (actual time=4,134.147..4,134.147 rows=1 loops=1)

  • Buffers: shared hit=38133, temp read=16009 written=16009
2. 813.694 813.694 ↑ 1.0 3,390,500 1

Seq Scan on carta carta (cost=0.00..72,022.21 rows=3,390,521 width=6) (actual time=0.011..813.694 rows=3,390,500 loops=1)

  • Buffers: shared hit=38117
Planning time : 0.404 ms
Execution time : 4,134.271 ms