explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NvFR

Settings
# exclusive inclusive rows x rows loops node
1. 0.138 0.798 ↓ 98.0 98 1

Nested Loop Left Join (cost=9.47..67.28 rows=1 width=175) (actual time=0.175..0.798 rows=98 loops=1)

2. 0.027 0.435 ↓ 75.0 75 1

Nested Loop Left Join (cost=9.18..66.77 rows=1 width=155) (actual time=0.159..0.435 rows=75 loops=1)

3. 0.009 0.331 ↓ 11.0 11 1

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

4. 0.011 0.267 ↓ 11.0 11 1

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

5. 0.011 0.234 ↓ 11.0 11 1

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

6. 0.077 0.151 ↓ 6.0 6 1

Bitmap Heap Scan on poc (cost=4.18..19.94 rows=1 width=52) (actual time=0.098..0.151 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.074 0.074 ↓ 8.0 32 1

Bitmap Index Scan on idx_poc_coverage_area (cost=0.00..4.18 rows=4 width=0) (actual time=0.074..0.074 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.005..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.077 0.077 ↓ 1.4 7 11

Index Scan using ix_poc_id_work_day on poc_work_day (cost=0.28..23.31 rows=5 width=13) (actual time=0.004..0.007 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.47 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.422 ms
Execution time : 0.934 ms