explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pg21

Settings
# exclusive inclusive rows x rows loops node
1. 0.357 0.554 ↑ 1.0 634 1

HashAggregate (cost=34.51..47.19 rows=634 width=10) (actual time=0.394..0.554 rows=634 loops=1)

  • Group Key: account.id
2. 0.095 0.197 ↓ 1.0 657 1

Hash Left Join (cost=2.87..26.59 rows=634 width=24) (actual time=0.038..0.197 rows=657 loops=1)

  • Hash Cond: (account.id = account_packet.account_id)
3. 0.079 0.079 ↑ 1.0 634 1

Seq Scan on account (cost=0.00..17.34 rows=634 width=8) (actual time=0.010..0.079 rows=634 loops=1)

4. 0.009 0.023 ↑ 1.0 83 1

Hash (cost=1.83..1.83 rows=83 width=24) (actual time=0.023..0.023 rows=83 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
5. 0.014 0.014 ↑ 1.0 83 1

Seq Scan on account_packet (cost=0.00..1.83 rows=83 width=24) (actual time=0.008..0.014 rows=83 loops=1)