explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RJrR

Settings
# exclusive inclusive rows x rows loops node
1. 18.762 1,048.774 ↑ 1.0 100 1

HashAggregate (cost=291,509.37..291,510.62 rows=100 width=36) (actual time=1,048.731..1,048.774 rows=100 loops=1)

  • Group Key: b.bid
2. 18.177 1,030.012 ↓ 1.1 95,330 1

Hash Join (cost=4.25..291,068.69 rows=88,137 width=8) (actual time=0.327..1,030.012 rows=95,330 loops=1)

  • Hash Cond: (a.bid = b.bid)
3. 1,011.669 1,011.669 ↓ 1.1 95,330 1

Seq Scan on pgbench_accounts a (cost=0.00..290,823.28 rows=88,137 width=8) (actual time=0.138..1,011.669 rows=95,330 loops=1)

  • Filter: (abalance > 0)
  • Rows Removed by Filter: 9904670
4. 0.081 0.166 ↑ 1.0 100 1

Hash (cost=3.00..3.00 rows=100 width=4) (actual time=0.166..0.166 rows=100 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
5. 0.085 0.085 ↑ 1.0 100 1

Seq Scan on pgbench_branches b (cost=0.00..3.00 rows=100 width=4) (actual time=0.017..0.085 rows=100 loops=1)