explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wqcr

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.034 ↑ 6.0 1 1

Nested Loop (cost=0.14..27.09 rows=6 width=156) (actual time=0.033..0.034 rows=1 loops=1)

2. 0.014 0.014 ↑ 1.0 1 1

Index Scan using hc_idx_cpq_plan_threshold_definition__c_cpq_plan__c on cpq_plan_threshold_definition__c def (cost=0.06..4.06 rows=1 width=123) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: ((def.cpq_plan__c)::text = 'a310z000001tAy5AAE'::text)
3. 0.017 0.017 ↑ 13.0 1 1

Index Scan using hc_idx_cpq_rule_criteria__c_cpq_plan_threshold_definition__c on cpq_rule_criteria__c rule (cost=0.09..22.99 rows=13 width=52) (actual time=0.016..0.017 rows=1 loops=1)

  • Index Cond: ((def.sfid)::text = (rule.cpq_plan_threshold_definition__c)::text)