explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bGPB

Settings
# exclusive inclusive rows x rows loops node
1. 0.099 0.712 ↓ 98.0 98 1

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

2. 0.027 0.388 ↓ 75.0 75 1

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

3. 0.012 0.295 ↓ 11.0 11 1

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

4. 0.007 0.239 ↓ 11.0 11 1

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

5. 0.007 0.210 ↓ 11.0 11 1

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

6. 0.069 0.137 ↓ 6.0 6 1

Bitmap Heap Scan on poc (cost=4.18..19.94 rows=1 width=52) (actual time=0.090..0.137 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.068 0.068 ↓ 8.0 32 1

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

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

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

  • Recheck Cond: (poc.id = poc_id)
  • Filter: active
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=18
9. 0.030 0.030 ↑ 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.005 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.044 0.044 ↑ 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.004..0.004 rows=1 loops=11)

  • Index Cond: (id = poc.address_id)
12. 0.066 0.066 ↓ 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.006 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 : 50.067 ms
Execution time : 0.847 ms