explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6oid

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.702 8.102 ↑ 1.0 1,000 1

Limit (cost=0.00..26.87 rows=1,000 width=97) (actual time=0.119..8.102 rows=1,000 loops=1)

  • Buffers: shared read=18 dirtied=15
2. 7.400 7.400 ↑ 5,076.9 1,000 1

Seq Scan on pgbench_accounts (cost=0.00..136,404.72 rows=5,076,872 width=97) (actual time=0.114..7.400 rows=1,000 loops=1)

  • Buffers: shared read=18 dirtied=15