explain.depesz.com

PostgreSQL's explain analyze made readable

Result: loQn

Settings
# exclusive inclusive rows x rows loops node
1. 0.149 5.249 ↓ 8.5 213 1

Hash Semi Join (cost=338.50..542.83 rows=25 width=4) (actual time=4.898..5.249 rows=213 loops=1)

  • Hash Cond: (p.id = d.poc_id)
2. 0.227 0.265 ↑ 1.0 240 1

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

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

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

  • Index Cond: (status = ANY ('{OPERATIONAL,ASSISTED_OPERATIONAL}'::poc_status[]))
4. 0.186 4.835 ↓ 1.2 554 1

Hash (cost=322.50..322.50 rows=446 width=4) (actual time=4.835..4.835 rows=554 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
5. 0.382 4.649 ↓ 1.2 554 1

Hash Semi Join (cost=269.29..322.50 rows=446 width=4) (actual time=4.027..4.649 rows=554 loops=1)

  • Hash Cond: (d.id = i.work_day_id)
6. 0.259 0.323 ↓ 1.1 675 1

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

  • Recheck Cond: ((week_day = 6) AND active)
  • Heap Blocks: exact=38
7. 0.064 0.064 ↓ 1.1 675 1

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

  • Index Cond: (week_day = 6)
8. 1.289 3.944 ↓ 1.0 4,103 1

Hash (cost=200.88..200.88 rows=4,093 width=4) (actual time=3.943..3.944 rows=4,103 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 209kB
9. 2.655 2.655 ↓ 1.0 4,103 1

Seq Scan on poc_working_interval i (cost=0.00..200.88 rows=4,093 width=4) (actual time=0.008..2.655 rows=4,103 loops=1)

  • Filter: (period @> 12.30)
  • Rows Removed by Filter: 2127
Planning time : 0.443 ms
Execution time : 5.339 ms