explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VKZl

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.117 ↑ 1.0 1 1

Aggregate (cost=21.81..21.82 rows=1 width=68) (actual time=0.117..0.117 rows=1 loops=1)

2. 0.004 0.102 ↑ 1.0 6 1

Nested Loop (cost=1.69..21.76 rows=6 width=12) (actual time=0.074..0.102 rows=6 loops=1)

3. 0.057 0.068 ↑ 1.0 6 1

Bitmap Heap Scan on seats (cost=1.42..7.86 rows=6 width=16) (actual time=0.063..0.068 rows=6 loops=1)

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

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

  • Index Cond: (seat_owner_id = 'dd237735-7816-46e0-9f3a-5bb1f1dced37'::uuid)
5. 0.030 0.030 ↑ 1.0 1 6

Index Scan using seat_balance_seat_id_index on seat_balance balance (cost=0.27..2.31 rows=1 width=28) (actual time=0.005..0.005 rows=1 loops=6)

  • Index Cond: (seat_id = seats.seat_id)
Planning time : 0.313 ms
Execution time : 0.165 ms