explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fWh7

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 0.174 ↓ 10.5 21 1

Nested Loop Left Join (cost=5.45..51.51 rows=2 width=166) (actual time=0.074..0.174 rows=21 loops=1)

2. 0.012 0.114 ↓ 10.5 21 1

Nested Loop Left Join (cost=5.17..50.69 rows=2 width=146) (actual time=0.068..0.114 rows=21 loops=1)

3. 0.003 0.075 ↓ 3.0 3 1

Nested Loop Left Join (cost=0.84..29.55 rows=1 width=137) (actual time=0.058..0.075 rows=3 loops=1)

4. 0.006 0.066 ↓ 3.0 3 1

Nested Loop Left Join (cost=0.56..21.24 rows=1 width=67) (actual time=0.054..0.066 rows=3 loops=1)

5. 0.002 0.054 ↓ 3.0 3 1

Nested Loop Left Join (cost=0.43..21.08 rows=1 width=63) (actual time=0.049..0.054 rows=3 loops=1)

6. 0.044 0.044 ↑ 1.0 1 1

Index Scan using idx_poc_coverage_area on poc (cost=0.14..8.41 rows=1 width=54) (actual time=0.043..0.044 rows=1 loops=1)

  • Index Cond: (coverage_area ~ '010100000028EE78935FF450C02145F872FAF123C0'::geometry)
  • Filter: ((status = ANY ('{OPERATIONAL,ASSISTED_OPERATIONAL}'::poc_status[])) AND _st_contains(coverage_area, '010100000028EE78935FF450C02145F872FAF123C0'::geometry))
  • Rows Removed by Filter: 1
7. 0.008 0.008 ↓ 3.0 3 1

Index Scan using poc_delivery_type_poc_id_index on poc_delivery_type (cost=0.28..12.65 rows=1 width=13) (actual time=0.004..0.008 rows=3 loops=1)

  • Index Cond: (poc.id = poc_id)
  • Filter: active
8. 0.006 0.006 ↑ 1.0 1 3

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=3)

  • Index Cond: (id = poc_delivery_type.delivery_type_id)
9. 0.006 0.006 ↑ 1.0 1 3

Index Scan using poc_address_pkey on poc_address (cost=0.28..8.30 rows=1 width=74) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (id = poc.address_id)
10. 0.021 0.027 ↓ 1.2 7 3

Bitmap Heap Scan on poc_work_day (cost=4.33..21.08 rows=6 width=13) (actual time=0.006..0.009 rows=7 loops=3)

  • Recheck Cond: (poc_id = poc.id)
  • Filter: active
  • Heap Blocks: exact=3
11. 0.006 0.006 ↑ 1.0 7 3

Bitmap Index Scan on ix_poc_id_work_day (cost=0.00..4.33 rows=7 width=0) (actual time=0.002..0.002 rows=7 loops=3)

  • Index Cond: (poc_id = poc.id)
12. 0.021 0.021 ↑ 1.0 1 21

Index Scan using poc_working_interval_work_day_id_idx on poc_working_interval (cost=0.28..0.38 rows=1 width=24) (actual time=0.001..0.001 rows=1 loops=21)

  • Index Cond: (poc_work_day.id = work_day_id)
Planning time : 0.766 ms
Execution time : 0.277 ms