explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BEqm

Settings
# exclusive inclusive rows x rows loops node
1. 0.429 74.726 ↑ 1.0 1 1

Aggregate (cost=93,749.50..93,749.51 rows=1 width=8) (actual time=74.725..74.726 rows=1 loops=1)

2. 39.005 74.297 ↑ 19.5 1,940 1

Bitmap Heap Scan on booking (cost=1,721.49..93,655.00 rows=37,798 width=0) (actual time=72.029..74.297 rows=1,940 loops=1)

  • Recheck Cond: (owner = '50903810'::text)
  • Heap Blocks: exact=10,705
3. 35.292 35.292 ↑ 1.1 33,485 1

Bitmap Index Scan on owner_bookings_idx (cost=0.00..1,712.04 rows=37,798 width=0) (actual time=35.292..35.292 rows=33,485 loops=1)

  • Index Cond: (owner = '50903810'::text)
Planning time : 0.133 ms
Execution time : 74.789 ms