explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vhjF

Settings
# exclusive inclusive rows x rows loops node
1. 0.817 100.021 ↑ 1.0 1 1

Aggregate (cost=161,459.14..161,459.15 rows=1 width=8) (actual time=100.021..100.021 rows=1 loops=1)

2. 0.154 99.204 ↑ 1.7 5,533 1

Nested Loop (cost=459.73..161,436.16 rows=9,191 width=0) (actual time=5.425..99.204 rows=5,533 loops=1)

3. 7.760 12.330 ↑ 1.0 21,680 1

Bitmap Heap Scan on tour_schedules (cost=459.29..2,538.53 rows=21,939 width=4) (actual time=5.345..12.330 rows=21,680 loops=1)

  • Recheck Cond: (tour_shipments_counter_cache > 0)
  • Heap Blocks: exact=1777
4. 4.570 4.570 ↑ 1.0 21,763 1

Bitmap Index Scan on index_tour_schedules_on_tour_date_and_pick_up_address_id_and_id (cost=0.00..453.81 rows=21,939 width=0) (actual time=4.570..4.570 rows=21,763 loops=1)

5. 86.720 86.720 ↓ 0.0 0 21,680

Index Scan using addresses_pkey on addresses (cost=0.43..7.23 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=21,680)

  • Index Cond: (id = tour_schedules.pick_up_address_id)
  • Filter: ((city)::text ~~* '%berlin%'::text)
  • Rows Removed by Filter: 1
Planning time : 1.145 ms
Execution time : 100.147 ms