explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X7lN

Settings
# exclusive inclusive rows x rows loops node
1. 53.910 173.804 ↑ 6.0 1 1

Hash Join (cost=25.08..35,833.77 rows=6 width=156) (actual time=168.821..173.804 rows=1 loops=1)

2. 119.718 119.718 ↑ 1.0 1,192,479 1

Seq Scan on cpq_rule_criteria__c rule (cost=0.00..35,182.59 rows=1,192,531 width=52) (actual time=0.003..119.718 rows=1,192,479 loops=1)

3. 0.005 0.176 ↑ 1.0 1 1

Hash (cost=25.07..25.07 rows=1 width=123) (actual time=0.176..0.176 rows=1 loops=1)

4. 0.171 0.171 ↑ 1.0 1 1

Seq Scan on cpq_plan_threshold_definition__c def (cost=0.00..25.07 rows=1 width=123) (actual time=0.123..0.171 rows=1 loops=1)

  • Filter: ((def.cpq_plan__c)::text = 'a310z000001tAy5AAE'::text)