explain.depesz.com

PostgreSQL's explain analyze made readable

Result: znlb

Settings
# exclusive inclusive rows x rows loops node
1. 0.038 79,029.839 ↑ 719.3 25 1

Nested Loop (cost=522,217.73..814,633.01 rows=17,983 width=16) (actual time=78,978.310..79,029.839 rows=25 loops=1)

2. 0.036 79,011.201 ↑ 719.3 25 1

Nested Loop (cost=522,217.29..676,346.86 rows=17,983 width=16) (actual time=78,977.684..79,011.201 rows=25 loops=1)

3. 11.694 78,999.090 ↑ 719.3 25 1

Unique (cost=522,216.72..522,313.06 rows=17,983 width=16) (actual time=78,977.010..78,999.090 rows=25 loops=1)

4. 67.776 78,987.396 ↓ 9.6 184,436 1

Sort (cost=522,216.72..522,264.89 rows=19,268 width=16) (actual time=78,977.009..78,987.396 rows=184,436 loops=1)

  • Sort Key: producttable.productcategoryid
  • Sort Method: quicksort Memory: 14,790kB
5. 78,919.620 78,919.620 ↓ 9.6 184,436 1

Index Scan using idx_storeid_producttable on producttable (cost=0.57..520,845.42 rows=19,268 width=16) (actual time=0.406..78,919.620 rows=184,436 loops=1)

  • Index Cond: (storeid = 237,053)
  • Filter: (productcategoryid = ANY ('{1,3594630,3695450,3594676,8763295,12211166,3853963,6845727,420022,3691964,4072531,9345602,3729094,3646952,8330635,4093951,4093891,8341627,9292918,3638382,5396238,419999,851238,13202909,11590722}'::bigint[]))
  • Rows Removed by Filter: 146,178
6. 12.075 12.075 ↑ 1.0 1 25

Index Scan using producttable_pkey on producttable pt (cost=0.57..8.56 rows=1 width=16) (actual time=0.483..0.483 rows=1 loops=25)

  • Index Cond: (productid = producttable.parentproductid)
7. 18.600 18.600 ↑ 1.0 1 25

Index Scan using productcategorytable_pkey on productcategorytable pct (cost=0.44..7.69 rows=1 width=16) (actual time=0.744..0.744 rows=1 loops=25)

  • Index Cond: (productcategoryid = pt.productcategoryid)
Planning time : 9.434 ms
Execution time : 79,030.765 ms