explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qz0E : product page query

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.021 ↑ 1.0 1 1

Nested Loop (cost=1.42..23.53 rows=1 width=540) (actual time=0.020..0.021 rows=1 loops=1)

2. 0.003 0.015 ↑ 1.0 1 1

Nested Loop (cost=1.00..17.03 rows=1 width=8) (actual time=0.014..0.015 rows=1 loops=1)

3. 0.007 0.007 ↑ 1.0 1 1

Index Scan using producttable_pkey on producttable (cost=0.57..8.59 rows=1 width=16) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (productid = 258619156)
4. 0.005 0.005 ↑ 1.0 1 1

Index Scan using wholesalecatalogueproducttable_pkey on wholesalecatalogueproducttable (cost=0.42..8.44 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (productid = COALESCE(producttable.parentproductid, producttable.productid))
5. 0.005 0.005 ↑ 1.0 1 1

Index Scan using wholesalecataloguetable_pkey on wholesalecataloguetable (cost=0.42..6.50 rows=1 width=540) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (catalogueid = wholesalecatalogueproducttable.catalogueid)
Planning time : 0.247 ms
Execution time : 0.043 ms