explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OCP7

Settings
# exclusive inclusive rows x rows loops node
1. 0.097 0.723 ↓ 98.0 98 1

Nested Loop (cost=9.47..67.35 rows=1 width=175) (actual time=0.162..0.723 rows=98 loops=1)

2. 0.028 0.401 ↓ 75.0 75 1

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

3. 0.006 0.307 ↓ 11.0 11 1

Nested Loop (cost=8.90..43.41 rows=1 width=146) (actual time=0.138..0.307 rows=11 loops=1)

4. 0.012 0.246 ↓ 11.0 11 1

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

5. 0.011 0.212 ↓ 11.0 11 1

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

6. 0.070 0.135 ↓ 6.0 6 1

Bitmap Heap Scan on poc (cost=4.18..19.94 rows=1 width=52) (actual time=0.087..0.135 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.065 0.065 ↓ 8.0 32 1

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

  • Index Cond: (coverage_area ~ '0101000000382F4E7CB55147C0DD7C23BA679137C0'::geometry)
8. 0.030 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.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.066 0.066 ↓ 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.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.48 rows=1 width=24) (actual time=0.002..0.003 rows=1 loops=75)

  • Index Cond: (work_day_id = poc_work_day.id)
Planning time : 1.562 ms
Execution time : 0.849 ms