explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JHGF

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.065 ↑ 1.0 1 1

Aggregate (cost=17.10..17.11 rows=1 width=68) (actual time=0.065..0.065 rows=1 loops=1)

2. 0.011 0.057 ↓ 1.5 6 1

Hash Join (cost=6.51..17.07 rows=4 width=14) (actual time=0.040..0.057 rows=6 loops=1)

  • Hash Cond: (balance.seat_id = seats.seat_id)
3. 0.028 0.028 ↓ 1.4 61 1

Seq Scan on seat_balance balance (cost=0.00..10.43 rows=43 width=30) (actual time=0.008..0.028 rows=61 loops=1)

4. 0.011 0.018 ↑ 1.0 6 1

Hash (cost=6.44..6.44 rows=6 width=16) (actual time=0.018..0.018 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.003 0.007 ↑ 1.0 6 1

Bitmap Heap Scan on seats (cost=1.29..6.44 rows=6 width=16) (actual time=0.006..0.007 rows=6 loops=1)

  • Recheck Cond: (seat_owner_id = 'dd237735-7816-46e0-9f3a-5bb1f1dced37'::uuid)
  • Heap Blocks: exact=1
6. 0.004 0.004 ↑ 1.0 6 1

Bitmap Index Scan on seats_seat_owner_id_index (cost=0.00..1.28 rows=6 width=0) (actual time=0.004..0.004 rows=6 loops=1)

  • Index Cond: (seat_owner_id = 'dd237735-7816-46e0-9f3a-5bb1f1dced37'::uuid)
Planning time : 0.226 ms
Execution time : 0.097 ms