explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4l3y

Settings
# exclusive inclusive rows x rows loops node
1. 33.778 86,478.883 ↓ 4,679.0 4,679 1

Nested Loop (cost=1.00..22,338.16 rows=1 width=32) (actual time=14.457..86,478.883 rows=4,679 loops=1)

2. 22.475 22.475 ↓ 1,172.5 4,690 1

Index Scan using secondary_category_catalog_category_id_idx on secondary_category_mapping categ (cost=0.57..511.72 rows=4 width=8) (actual time=0.030..22.475 rows=4,690 loops=1)

  • Index Cond: (catalog_category_id = 5526747)
  • Filter: (secondary_category_id = 11644)
3. 86,422.630 86,422.630 ↑ 1.0 1 4,690

Index Scan using product_13876_pkey on product_13876 cp13876 (cost=0.42..5,456.60 rows=1 width=1,338) (actual time=8.942..18.427 rows=1 loops=4,690)

  • Index Cond: (id = categ.product_id)