explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hX1

Settings
# exclusive inclusive rows x rows loops node
1. 0.175 8.733 ↓ 8.3 850 1

Hash Semi Join (cost=1,128.87..2,921.21 rows=103 width=4) (actual time=7.803..8.733 rows=850 loops=1)

  • Hash Cond: (p.id = d.poc_id)
  • Buffers: shared hit=1233
2. 0.854 1.015 ↓ 1.0 906 1

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

  • Recheck Cond: (status = ANY ('{ASSISTED_OPERATIONAL,OPERATIONAL}'::poc_status[]))
  • Heap Blocks: exact=782
  • Buffers: shared hit=819
3. 0.161 0.161 ↓ 1.7 1,566 1

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

  • Index Cond: (status = ANY ('{ASSISTED_OPERATIONAL,OPERATIONAL}'::poc_status[]))
  • Buffers: shared hit=37
4. 0.196 7.543 ↓ 1.2 1,357 1

Hash (cost=1,022.71..1,022.71 rows=1,165 width=4) (actual time=7.543..7.543 rows=1,357 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 64kB
  • Buffers: shared hit=414
5. 0.341 7.347 ↓ 1.2 1,357 1

Hash Semi Join (cost=680.55..1,022.71 rows=1,165 width=4) (actual time=5.727..7.347 rows=1,357 loops=1)

  • Hash Cond: (d.id = i.work_day_id)
  • Buffers: shared hit=414
6. 1.332 1.332 ↓ 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..1.332 rows=1,482 loops=1)

  • Filter: (active AND (week_day = 6))
  • Rows Removed by Filter: 10376
  • Buffers: shared hit=176
7. 1.351 5.674 ↑ 1.0 9,645 1

Hash (cost=558.03..558.03 rows=9,802 width=4) (actual time=5.674..5.674 rows=9,645 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 468kB
  • Buffers: shared hit=238
8. 4.323 4.323 ↑ 1.0 9,645 1

Seq Scan on poc_working_interval i (cost=0.00..558.03 rows=9,802 width=4) (actual time=0.006..4.323 rows=9,645 loops=1)

  • Filter: (((now())::time without time zone >= opening_time) AND ((now())::time without time zone <= closing_time))
  • Rows Removed by Filter: 3169
  • Buffers: shared hit=238
Planning time : 0.414 ms
Execution time : 8.824 ms