explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5Scp

Settings
# exclusive inclusive rows x rows loops node
1. 0.141 6.629 ↓ 8.1 228 1

Hash Semi Join (cost=407.13..611.56 rows=28 width=4) (actual time=6.272..6.629 rows=228 loops=1)

  • Hash Cond: (p.id = d.poc_id)
  • Buffers: shared hit=231
2. 0.239 0.275 ↑ 1.0 240 1

Bitmap Heap Scan on poc p (cost=10.43..213.56 rows=240 width=4) (actual time=0.053..0.275 rows=240 loops=1)

  • Recheck Cond: (status = ANY ('{ASSISTED_OPERATIONAL,OPERATIONAL}'::poc_status[]))
  • Heap Blocks: exact=134
  • Buffers: shared hit=139
3. 0.036 0.036 ↑ 1.0 240 1

Bitmap Index Scan on ix_poc_status (cost=0.00..10.37 rows=240 width=0) (actual time=0.036..0.036 rows=240 loops=1)

  • Index Cond: (status = ANY ('{ASSISTED_OPERATIONAL,OPERATIONAL}'::poc_status[]))
  • Buffers: shared hit=5
4. 0.231 6.213 ↓ 1.2 598 1

Hash (cost=390.41..390.41 rows=504 width=4) (actual time=6.212..6.213 rows=598 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
  • Buffers: shared hit=92
5. 0.361 5.982 ↓ 1.2 598 1

Hash Semi Join (cost=270.99..390.41 rows=504 width=4) (actual time=4.879..5.982 rows=598 loops=1)

  • Hash Cond: (d.id = i.work_day_id)
  • Buffers: shared hit=92
6. 0.765 0.765 ↓ 1.1 675 1

Seq Scan on poc_work_day d (cost=0.00..111.50 rows=641 width=8) (actual time=0.007..0.765 rows=675 loops=1)

  • Filter: (active AND (week_day = 6))
  • Rows Removed by Filter: 5205
  • Buffers: shared hit=38
7. 1.426 4.856 ↑ 1.0 4,518 1

Hash (cost=213.18..213.18 rows=4,625 width=4) (actual time=4.856..4.856 rows=4,518 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 223kB
  • Buffers: shared hit=54
8. 3.430 3.430 ↑ 1.0 4,518 1

Seq Scan on poc_working_interval i (cost=0.00..213.18 rows=4,625 width=4) (actual time=0.008..3.430 rows=4,518 loops=1)

  • Filter: (((now())::time without time zone >= opening_time) AND ((now())::time without time zone <= closing_time))
  • Rows Removed by Filter: 1849
  • Buffers: shared hit=54
Planning time : 0.390 ms
Execution time : 6.730 ms