explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CI75

Settings
# exclusive inclusive rows x rows loops node
1. 0.108 2.186 ↓ 1.1 49 1

Sort (cost=1,389.55..1,389.66 rows=44 width=61) (actual time=2.173..2.186 rows=49 loops=1)

  • Sort Key: product_variant.title
  • Sort Method: quicksort Memory: 31kB
  • Buffers: shared hit=1044
2. 0.070 2.078 ↓ 1.1 49 1

Nested Loop Left Join (cost=57.88..1,388.35 rows=44 width=61) (actual time=0.917..2.078 rows=49 loops=1)

  • Buffers: shared hit=1044
3. 0.025 1.959 ↓ 1.1 49 1

Nested Loop (cost=57.74..1,380.55 rows=44 width=56) (actual time=0.914..1.959 rows=49 loops=1)

  • Buffers: shared hit=946
4. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on category (cost=0.00..1.07 rows=1 width=13) (actual time=0.004..0.006 rows=1 loops=1)

  • Filter: (id = 94)
  • Rows Removed by Filter: 5
  • Buffers: shared hit=1
5. 0.052 1.928 ↓ 1.1 49 1

Nested Loop (cost=57.74..1,379.04 rows=44 width=51) (actual time=0.908..1.928 rows=49 loops=1)

  • Buffers: shared hit=945
6. 0.076 1.778 ↓ 1.1 49 1

Nested Loop (cost=57.47..1,360.30 rows=44 width=55) (actual time=0.904..1.778 rows=49 loops=1)

  • Buffers: shared hit=796
7. 0.092 1.444 ↓ 1.1 129 1

Hash Join (cost=57.19..1,312.09 rows=122 width=47) (actual time=0.870..1.444 rows=129 loops=1)

  • Hash Cond: (inventory_item.product_variant_id = product_variant.id)
  • Buffers: shared hit=407
8. 0.532 0.606 ↓ 1.1 129 1

Bitmap Heap Scan on inventory_item (cost=16.60..1,269.82 rows=122 width=12) (actual time=0.117..0.606 rows=129 loops=1)

  • Recheck Cond: (poc_id = 21)
  • Filter: ((available_date IS NOT NULL) AND (price > '0'::double precision))
  • Rows Removed by Filter: 475
  • Heap Blocks: exact=384
  • Buffers: shared hit=389
9. 0.074 0.074 ↓ 1.1 604 1

Bitmap Index Scan on poc_product_variant (cost=0.00..16.57 rows=570 width=0) (actual time=0.074..0.074 rows=604 loops=1)

  • Index Cond: (poc_id = 21)
  • Buffers: shared hit=5
10. 0.364 0.746 ↓ 1.0 1,030 1

Hash (cost=28.04..28.04 rows=1,004 width=39) (actual time=0.746..0.746 rows=1,030 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 90kB
  • Buffers: shared hit=18
11. 0.382 0.382 ↓ 1.0 1,030 1

Seq Scan on product_variant (cost=0.00..28.04 rows=1,004 width=39) (actual time=0.005..0.382 rows=1,030 loops=1)

  • Buffers: shared hit=18
12. 0.258 0.258 ↓ 0.0 0 129

Index Scan using ix_product_id on product_category (cost=0.28..0.39 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=129)

  • Index Cond: (product_id = product_variant.product_id)
  • Filter: (category_id = 94)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=389
13. 0.098 0.098 ↑ 1.0 1 49

Index Scan using product_pkey on product (cost=0.28..0.42 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=49)

  • Index Cond: (id = product_variant.product_id)
  • Buffers: shared hit=149
14. 0.049 0.049 ↑ 1.0 1 49

Index Scan using brand_pkey on brand (cost=0.14..0.17 rows=1 width=13) (actual time=0.001..0.001 rows=1 loops=49)

  • Index Cond: (id = product.brand_id)
  • Buffers: shared hit=98
Planning time : 0.787 ms
Execution time : 2.250 ms