explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EUq3

Settings
# exclusive inclusive rows x rows loops node
1. 1.089 11.371 ↑ 1.0 1 1

Hash Join (cost=1,105.94..1,349.79 rows=1 width=4) (actual time=4.938..11.371 rows=1 loops=1)

  • Hash Cond: (corde.order_id = orde.id)
2. 8.562 8.562 ↓ 1.1 4,394 1

Index Scan using orders_is_active_index on orders corde (cost=0.44..228.85 rows=4,112 width=4) (actual time=0.024..8.562 rows=4,394 loops=1)

  • Index Cond: (is_active = true)
  • Filter: (is_active IS TRUE)
3. 0.117 1.720 ↑ 3.7 258 1

Hash (cost=1,093.52..1,093.52 rows=959 width=4) (actual time=1.720..1.720 rows=258 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
4. 0.562 1.603 ↑ 3.7 258 1

Bitmap Heap Scan on orders orde (cost=28.60..1,093.52 rows=959 width=4) (actual time=1.135..1.603 rows=258 loops=1)

  • Recheck Cond: ((storekeeper_id = 95216) OR (deliveryboy_id = 95216))
  • Heap Blocks: exact=257
5. 0.003 1.041 ↓ 0.0 0 1

BitmapOr (cost=28.60..28.60 rows=959 width=0) (actual time=1.041..1.041 rows=0 loops=1)

6. 0.085 0.085 ↑ 2.9 249 1

Bitmap Index Scan on orders_storekeeper_id_index (cost=0.00..19.19 rows=723 width=0) (actual time=0.085..0.085 rows=249 loops=1)

  • Index Cond: (storekeeper_id = 95216)
7. 0.953 0.953 ↑ 26.2 9 1

Bitmap Index Scan on orders_deliveryboy_id_index (cost=0.00..8.93 rows=236 width=0) (actual time=0.953..0.953 rows=9 loops=1)

  • Index Cond: (deliveryboy_id = 95216)