explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WhPT

Settings
# exclusive inclusive rows x rows loops node
1. 0.450 9.912 ↓ 8.3 850 1

Nested Loop (cost=433.53..2,597.99 rows=103 width=4) (actual time=2.875..9.912 rows=850 loops=1)

  • Buffers: shared hit=3933
2. 0.521 4.982 ↓ 7.2 896 1

Hash Join (cost=433.24..2,239.99 rows=124 width=8) (actual time=2.859..4.982 rows=896 loops=1)

  • Hash Cond: (p.id = d.poc_id)
  • Buffers: shared hit=1007
3. 1.711 1.925 ↓ 1.0 906 1

Bitmap Heap Scan on poc p (cost=91.59..1,879.00 rows=905 width=4) (actual time=0.312..1.925 rows=906 loops=1)

  • Recheck Cond: (status = ANY ('{ASSISTED_OPERATIONAL,OPERATIONAL}'::poc_status[]))
  • Heap Blocks: exact=794
  • Buffers: shared hit=831
4. 0.214 0.214 ↓ 1.8 1,614 1

Bitmap Index Scan on ix_poc_status (cost=0.00..91.36 rows=905 width=0) (actual time=0.214..0.214 rows=1,614 loops=1)

  • Index Cond: (status = ANY ('{ASSISTED_OPERATIONAL,OPERATIONAL}'::poc_status[]))
  • Buffers: shared hit=37
5. 0.314 2.536 ↓ 1.1 1,482 1

Hash (cost=324.05..324.05 rows=1,408 width=8) (actual time=2.536..2.536 rows=1,482 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 74kB
  • Buffers: shared hit=176
6. 2.222 2.222 ↓ 1.1 1,482 1

Seq Scan on poc_work_day d (cost=0.00..324.05 rows=1,408 width=8) (actual time=0.007..2.222 rows=1,482 loops=1)

  • Filter: (active AND (week_day = 6))
  • Rows Removed by Filter: 10376
  • Buffers: shared hit=176
7. 4.480 4.480 ↑ 1.0 1 896

Index Scan using poc_working_interval_work_day_id_idx on poc_working_interval i (cost=0.29..2.88 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=896)

  • Index Cond: (work_day_id = d.id)
  • Filter: (((now())::time without time zone >= opening_time) AND ((now())::time without time zone <= closing_time))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=2926
Planning time : 0.606 ms
Execution time : 10.035 ms