explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7nxw

Settings
# exclusive inclusive rows x rows loops node
1. 0.136 1.954 ↑ 1.0 1 1

Aggregate (cost=766.48..766.49 rows=1 width=68) (actual time=1.954..1.954 rows=1 loops=1)

2. 0.002 1.818 ↑ 1.0 301 1

Nested Loop (cost=5.20..764.20 rows=303 width=10) (actual time=0.169..1.818 rows=301 loops=1)

3. 0.496 0.612 ↑ 1.0 301 1

Bitmap Heap Scan on seats (cost=4.91..324.61 rows=313 width=16) (actual time=0.153..0.612 rows=301 loops=1)

  • Recheck Cond: (seat_owner_id = 'a12abdb3-a97a-4e3d-b12b-dee6bf467819'::uuid)
  • Heap Blocks: exact=268
4. 0.116 0.116 ↑ 1.0 301 1

Bitmap Index Scan on seats_seat_owner_id_index (cost=0.00..4.83 rows=313 width=0) (actual time=0.116..0.116 rows=301 loops=1)

  • Index Cond: (seat_owner_id = 'a12abdb3-a97a-4e3d-b12b-dee6bf467819'::uuid)
5. 1.204 1.204 ↑ 1.0 1 301

Index Scan using seat_balance_seat_id_index on seat_balance balance (cost=0.29..1.39 rows=1 width=26) (actual time=0.004..0.004 rows=1 loops=301)

  • Index Cond: (seat_id = seats.seat_id)
Planning time : 0.353 ms
Execution time : 2.011 ms