explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KTuf

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=31,465.84..31,715.84 rows=100,000 width=197) (actual rows= loops=)

  • Sort Key: a.aid
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.02..4,016.02 rows=100,000 width=197) (actual rows= loops=)

  • Hash Cond: (a.bid = b.bid)
3. 0.000 0.000 ↓ 0.0

Seq Scan on pgbench_accounts a (cost=0.00..2,640.00 rows=100,000 width=97) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=1.01..1.01 rows=1 width=100) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on pgbench_branches b (cost=0.00..1.01 rows=1 width=100) (actual rows= loops=)