explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SqnF

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.152 ↑ 1.0 1 1

Result (cost=101.60..101.61 rows=1 width=1) (actual time=0.152..0.152 rows=1 loops=1)

2.          

Initplan (for Result)

3. 0.003 0.151 ↑ 1.0 1 1

Nested Loop Semi Join (cost=4.46..101.60 rows=1 width=0) (actual time=0.150..0.151 rows=1 loops=1)

4. 0.029 0.106 ↓ 2.0 2 1

Bitmap Heap Scan on poc (cost=4.18..19.94 rows=1 width=18) (actual time=0.096..0.106 rows=2 loops=1)

  • Recheck Cond: (coverage_area ~ '0101000000382F4E7CB55147C0DD7C23BA679137C0'::geometry)
  • Filter: ((is_open IS TRUE) AND (status = ANY ('{ASSISTED_OPERATIONAL,OPERATIONAL}'::poc_status[])) AND _st_contains(coverage_area, '0101000000382F4E7CB55147C0DD7C23BA679137C0'::geometry))
  • Heap Blocks: exact=2
5. 0.077 0.077 ↓ 8.2 33 1

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

  • Index Cond: (coverage_area ~ '0101000000382F4E7CB55147C0DD7C23BA679137C0'::geometry)
6. 0.031 0.042 ↓ 0.0 0 2

Index Scan using ix_poc_id_work_day on poc_work_day (cost=0.28..81.64 rows=1 width=12) (actual time=0.021..0.021 rows=0 loops=2)

  • Index Cond: (poc_id = poc.id)
  • Filter: ((active IS TRUE) AND (date_part('dow'::text, timezone((poc.poc_timezone)::text, now())) = (week_day)::double precision) AND (SubPlan 1))
  • Rows Removed by Filter: 4
7.          

SubPlan (for Index Scan)

8. 0.011 0.011 ↑ 1.0 1 1

Index Scan using poc_working_interval_work_day_id_idx on poc_working_interval (cost=0.28..8.32 rows=1 width=0) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (poc_work_day.id = work_day_id)
  • Filter: (((timezone((poc.poc_timezone)::text, now()))::time without time zone >= opening_time) AND ((timezone((poc.poc_timezone)::text, now()))::time without time zone <= closing_time))
Planning time : 0.608 ms
Execution time : 0.209 ms