explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2x1i : Optimization for: plan #S4F2

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.145 0.825 ↓ 98.0 98 1

Nested Loop Left Join (cost=9.47..67.35 rows=1 width=175) (actual time=0.177..0.825 rows=98 loops=1)

2. 0.031 0.455 ↓ 75.0 75 1

Nested Loop (cost=9.18..66.84 rows=1 width=155) (actual time=0.160..0.455 rows=75 loops=1)

3. 0.009 0.336 ↓ 11.0 11 1

Nested Loop Left Join (cost=8.90..43.41 rows=1 width=146) (actual time=0.150..0.336 rows=11 loops=1)

4. 0.015 0.272 ↓ 11.0 11 1

Nested Loop Left Join (cost=8.62..35.11 rows=1 width=65) (actual time=0.129..0.272 rows=11 loops=1)

5. 0.011 0.235 ↓ 11.0 11 1

Nested Loop Left Join (cost=8.49..34.94 rows=1 width=61) (actual time=0.120..0.235 rows=11 loops=1)

6. 0.077 0.152 ↓ 6.0 6 1

Bitmap Heap Scan on poc (cost=4.18..19.94 rows=1 width=52) (actual time=0.098..0.152 rows=6 loops=1)

  • Recheck Cond: (coverage_area ~ '0101000000382F4E7CB55147C0DD7C23BA679137C0'::geometry)
  • Filter: ((status = ANY ('{OPERATIONAL,ASSISTED_OPERATIONAL}'::poc_status[])) AND _st_contains(coverage_area, '0101000000382F4E7CB55147C0DD7C23BA679137C0'::geometry))
  • Rows Removed by Filter: 8
  • Heap Blocks: exact=14
7. 0.075 0.075 ↓ 8.0 32 1

Bitmap Index Scan on idx_poc_coverage_area (cost=0.00..4.18 rows=4 width=0) (actual time=0.075..0.075 rows=32 loops=1)

  • Index Cond: (coverage_area ~ '0101000000382F4E7CB55147C0DD7C23BA679137C0'::geometry)
8. 0.036 0.072 ↓ 2.0 2 6

Bitmap Heap Scan on poc_delivery_type (cost=4.31..14.98 rows=1 width=13) (actual time=0.010..0.012 rows=2 loops=6)

  • Recheck Cond: (poc.id = poc_id)
  • Filter: active
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=18
9. 0.036 0.036 ↑ 1.0 3 6

Bitmap Index Scan on poc_delivery_type_poc_id_index (cost=0.00..4.31 rows=3 width=0) (actual time=0.006..0.006 rows=3 loops=6)

  • Index Cond: (poc.id = poc_id)
10. 0.022 0.022 ↑ 1.0 1 11

Index Scan using delivery_type_pkey on delivery_type (cost=0.13..0.16 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=11)

  • Index Cond: (id = poc_delivery_type.delivery_type_id)
11. 0.055 0.055 ↑ 1.0 1 11

Index Scan using poc_address_pkey on poc_address (cost=0.29..8.30 rows=1 width=85) (actual time=0.005..0.005 rows=1 loops=11)

  • Index Cond: (id = poc.address_id)
12. 0.088 0.088 ↓ 1.4 7 11

Index Scan using ix_poc_id_work_day on poc_work_day (cost=0.28..23.38 rows=5 width=13) (actual time=0.004..0.008 rows=7 loops=11)

  • Index Cond: (poc_id = poc.id)
  • Filter: active
  • Rows Removed by Filter: 0
13. 0.225 0.225 ↑ 1.0 1 75

Index Scan using poc_working_interval_work_day_id_idx on poc_working_interval (cost=0.28..0.48 rows=1 width=24) (actual time=0.002..0.003 rows=1 loops=75)

  • Index Cond: (poc_work_day.id = work_day_id)
Planning time : 1.693 ms
Execution time : 0.964 ms