explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OYXM

Settings
# exclusive inclusive rows x rows loops node
1. 0.086 0.714 ↑ 1.0 1 1

Sort (cost=10.84..10.84 rows=1 width=1,352) (actual time=0.713..0.714 rows=1 loops=1)

  • Sort Key: pv.parametercategorycode, pv.valuecode, pv.sequence
  • Sort Method: quicksort Memory: 26kB
2. 0.024 0.628 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.12..10.83 rows=1 width=1,352) (actual time=0.609..0.628 rows=1 loops=1)

3. 0.021 0.549 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.85..8.52 rows=1 width=1,088) (actual time=0.531..0.549 rows=1 loops=1)

  • Join Filter: (pv.parametervalueid = pr.productcodeparamid)
4. 0.015 0.461 ↑ 1.0 1 1

Nested Loop (cost=2.58..6.22 rows=1 width=846) (actual time=0.443..0.461 rows=1 loops=1)

5. 0.042 0.408 ↑ 1.0 1 1

Hash Right Join (cost=2.31..3.90 rows=1 width=617) (actual time=0.389..0.408 rows=1 loops=1)

  • Hash Cond: ((ipc.internalparametercategorycode)::text = (pv.internalparametercategorycode)::text)
6. 0.030 0.030 ↓ 1.0 47 1

Seq Scan on internalparametercategory ipc (cost=0.00..1.46 rows=46 width=350) (actual time=0.021..0.030 rows=47 loops=1)

7. 0.009 0.336 ↑ 1.0 1 1

Hash (cost=2.29..2.29 rows=1 width=267) (actual time=0.335..0.336 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 0.327 0.327 ↑ 1.0 1 1

Index Scan using parametervalueid on parametervalue pv (cost=0.28..2.29 rows=1 width=267) (actual time=0.325..0.327 rows=1 loops=1)

  • Index Cond: (parametervalueid = 900,002)
9. 0.038 0.038 ↑ 1.0 1 1

Index Scan using parametercategoryid on parametercategory pc (cost=0.27..2.29 rows=1 width=229) (actual time=0.037..0.038 rows=1 loops=1)

  • Index Cond: ((parametercategorycode)::text = (pv.parametercategorycode)::text)
10. 0.067 0.067 ↑ 1.0 1 1

Index Scan using product_pkey on product pr (cost=0.27..2.29 rows=1 width=242) (actual time=0.067..0.067 rows=1 loops=1)

  • Index Cond: (productcodeparamid = 900,002)
11. 0.055 0.055 ↑ 1.0 1 1

Index Scan using internalparametervalue_pkey on internalparametervalue ipv (cost=0.27..2.29 rows=1 width=287) (actual time=0.055..0.055 rows=1 loops=1)

  • Index Cond: (((internalparametercategorycode)::text = (pv.internalparametercategorycode)::text) AND ((internalparametervaluecode)::text = (pv.internalparametervaluecode)::text))
Planning time : 5.080 ms
Execution time : 0.926 ms