explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XdbP

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.007 ↑ 1.0 1 1

Aggregate (cost=8.34..8.35 rows=1 width=16) (actual time=0.007..0.007 rows=1 loops=1)

2. 0.005 0.005 ↓ 0.0 0 1

Index Scan using hc_idx_qa_form__c_qa_form_created_date__c on qa_form__c qa (cost=0.29..8.32 rows=1 width=3) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((qa_form_created_date__c >= '2019-05-03 17:58:27'::timestamp without time zone) AND (qa_form_created_date__c < '2019-05-10 17:58:27'::timestamp without time zone))
  • Filter: ((NOT dismiss_from_qa__c) AND ((shop_category__c)::text = ANY ('{Leasing,Maintenance}'::text[])) AND ((shop_status__c)::text = 'Completed'::text) AND ((property_consultant__c)::text = '0030H00004unYPhQAM'::text))