explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Janu : v4

Settings
# exclusive inclusive rows x rows loops node
1. 20.962 61.833 ↑ 14.2 2,466 1

Hash Join (cost=16.53..6,343.12 rows=35,084 width=65) (actual time=54.031..61.833 rows=2,466 loops=1)

  • Hash Cond: ((pci.product_category_id_)::text = (pcs.product_category_id_)::text)
2. 40.632 40.632 ↓ 1.0 126,532 1

Seq Scan on product_category_info pci (cost=0.00..5,501.27 rows=126,527 width=78) (actual time=0.021..40.632 rows=126,532 loops=1)

3. 0.034 0.239 ↓ 1.1 108 1

Hash (cost=15.36..15.36 rows=94 width=45) (actual time=0.239..0.239 rows=108 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
4. 0.205 0.205 ↓ 1.1 108 1

Seq Scan on product_category_setting pcs (cost=0.00..15.36 rows=94 width=45) (actual time=0.129..0.205 rows=108 loops=1)

  • Filter: (((site_id_)::text = '0000'::text) AND ((product_classification_id_)::text = 'C059GOODS'::text) AND ((product_category_type_id_)::text = ANY ('{MKTCATEGORY1,MKTCATEGORY2,MKTCATEGORY3}'::text[])))
  • Rows Removed by Filter: 253
Planning time : 1.624 ms
Execution time : 61.990 ms