explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I828

Settings
# exclusive inclusive rows x rows loops node
1. 0.156 6.307 ↓ 8.3 232 1

Hash Semi Join (cost=358.08..562.51 rows=28 width=4) (actual time=5.947..6.307 rows=232 loops=1)

  • Hash Cond: (p.id = d.poc_id)
  • Buffers: shared hit=235
2. 0.227 0.264 ↑ 1.0 240 1

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

  • Recheck Cond: (status = ANY ('{ASSISTED_OPERATIONAL,OPERATIONAL}'::poc_status[]))
  • Heap Blocks: exact=134
  • Buffers: shared hit=139
3. 0.037 0.037 ↑ 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.037 rows=240 loops=1)

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

Hash (cost=341.43..341.43 rows=498 width=4) (actual time=5.887..5.887 rows=593 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
  • Buffers: shared hit=96
5. 0.414 5.696 ↓ 1.2 593 1

Hash Semi Join (cost=287.58..341.43 rows=498 width=4) (actual time=5.033..5.696 rows=593 loops=1)

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

Bitmap Heap Scan on poc_work_day d (cost=17.25..63.26 rows=641 width=8) (actual time=0.063..0.329 rows=675 loops=1)

  • Recheck Cond: ((week_day = 6) AND active)
  • Heap Blocks: exact=38
  • Buffers: shared hit=42
7. 0.056 0.056 ↓ 1.1 675 1

Bitmap Index Scan on test_poc_work_day (cost=0.00..17.09 rows=641 width=0) (actual time=0.056..0.056 rows=675 loops=1)

  • Index Cond: (week_day = 6)
  • Buffers: shared hit=4
8. 1.383 4.953 ↑ 1.0 4,537 1

Hash (cost=213.18..213.18 rows=4,572 width=4) (actual time=4.953..4.953 rows=4,537 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 224kB
  • Buffers: shared hit=54
9. 3.570 3.570 ↑ 1.0 4,537 1

Seq Scan on poc_working_interval i (cost=0.00..213.18 rows=4,572 width=4) (actual time=0.010..3.570 rows=4,537 loops=1)

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