explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DPmG

Settings
# exclusive inclusive rows x rows loops node
1. 0.157 0.872 ↓ 6.6 238 1

Hash Semi Join (cost=41.94..246.69 rows=36 width=4) (actual time=0.478..0.872 rows=238 loops=1)

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

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

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

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

  • Index Cond: (status = ANY ('{OPERATIONAL,ASSISTED_OPERATIONAL}'::poc_status[]))
4. 0.198 0.411 ↓ 1.1 675 1

Hash (cost=23.50..23.50 rows=641 width=4) (actual time=0.411..0.411 rows=675 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
5. 0.213 0.213 ↓ 1.1 675 1

Index Only Scan using test_poc_work_day on poc_work_day d (cost=0.28..23.50 rows=641 width=4) (actual time=0.019..0.213 rows=675 loops=1)

  • Index Cond: (week_day = 6)
  • Heap Fetches: 0
Planning time : 0.283 ms
Execution time : 0.962 ms