explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B9Qs

Settings
# exclusive inclusive rows x rows loops node
1. 8.331 30.033 ↓ 1.3 19,003 1

Nested Loop (cost=41.38..763.53 rows=14,538 width=12) (actual time=0.688..30.033 rows=19,003 loops=1)

  • Buffers: shared hit=9736
2. 0.200 0.758 ↓ 6.6 238 1

HashAggregate (cost=37.80..38.16 rows=36 width=8) (actual time=0.652..0.758 rows=238 loops=1)

  • Group Key: p.id
  • Buffers: shared hit=7
3. 0.302 0.558 ↓ 6.6 238 1

Merge Semi Join (cost=0.43..37.71 rows=36 width=8) (actual time=0.032..0.558 rows=238 loops=1)

  • Merge Cond: (p.id = d.poc_id)
  • Buffers: shared hit=7
4. 0.073 0.073 ↑ 1.0 240 1

Index Only Scan using test_poc on poc p (cost=0.14..11.74 rows=240 width=4) (actual time=0.013..0.073 rows=240 loops=1)

  • Heap Fetches: 0
  • Buffers: shared hit=2
5. 0.183 0.183 ↓ 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.016..0.183 rows=675 loops=1)

  • Index Cond: (week_day = 6)
  • Heap Fetches: 0
  • Buffers: shared hit=5
6. 17.374 20.944 ↓ 3.5 80 238

Bitmap Heap Scan on inventory_item i (cost=3.59..19.92 rows=23 width=16) (actual time=0.022..0.088 rows=80 loops=238)

  • Recheck Cond: (poc_id = d.poc_id)
  • Filter: ((available_date IS NOT NULL) AND (price > '0'::double precision))
  • Rows Removed by Filter: 97
  • Heap Blocks: exact=9144
  • Buffers: shared hit=9729
7. 3.570 3.570 ↓ 2.4 177 238

Bitmap Index Scan on poc_product_variant (cost=0.00..3.58 rows=74 width=0) (actual time=0.015..0.015 rows=177 loops=238)

  • Index Cond: (poc_id = d.poc_id)
  • Buffers: shared hit=585
Planning time : 0.554 ms
Execution time : 33.953 ms