explain.depesz.com

PostgreSQL's explain analyze made readable

Result: celm

Settings
# exclusive inclusive rows x rows loops node
1. 0.989 2,987.350 ↓ 149.0 149 1

GroupAggregate (cost=5,511.08..5,511.18 rows=1 width=278) (actual time=2,986.364..2,987.350 rows=149 loops=1)

  • Group Key: co.firstname, co.lastname, ip.team__c, qa.property_consultant__c, ip.employment_status__c
2. 1.267 2,986.361 ↓ 1,022.0 1,022 1

Sort (cost=5,511.08..5,511.08 rows=1 width=81) (actual time=2,986.324..2,986.361 rows=1,022 loops=1)

  • Sort Key: co.firstname, co.lastname, ip.team__c, qa.property_consultant__c
  • Sort Method: quicksort Memory: 168kB
3. 110.478 2,985.094 ↓ 1,022.0 1,022 1

Nested Loop (cost=58.47..5,511.07 rows=1 width=81) (actual time=0.405..2,985.094 rows=1,022 loops=1)

  • Join Filter: ((co.sfid)::text = (qa.property_consultant__c)::text)
  • Rows Removed by Join Filter: 280310
4. 0.949 1.760 ↓ 244.0 244 1

Hash Join (cost=58.47..1,158.01 rows=1 width=73) (actual time=0.391..1.760 rows=244 loops=1)

  • Hash Cond: ((co.sfid)::text = (ip.contact__c)::text)
5. 0.476 0.476 ↑ 10.3 497 1

Index Scan using hc_idx_contact_recordtypeid on contact co (cost=0.56..1,080.91 rows=5,114 width=34) (actual time=0.038..0.476 rows=497 loops=1)

  • Index Cond: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
6. 0.102 0.335 ↑ 1.0 244 1

Hash (cost=54.84..54.84 rows=246 width=39) (actual time=0.335..0.335 rows=244 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
7. 0.233 0.233 ↑ 1.0 244 1

Seq Scan on internal_app_permissions__c ip (cost=0.00..54.84 rows=246 width=39) (actual time=0.008..0.233 rows=244 loops=1)

  • Filter: ((employment_status__c)::text = 'Active'::text)
  • Rows Removed by Filter: 223
8. 2,872.856 2,872.856 ↓ 1.4 1,153 244

Seq Scan on qa_form__c qa (cost=0.00..4,343.00 rows=805 width=46) (actual time=0.003..11.774 rows=1,153 loops=244)

  • Filter: (((shop_category__c)::text = ANY ('{Leasing,Maintenance}'::text[])) AND (qa_form_created_date__c >= '2018-10-09 14:30:45'::timestamp without time zone) AND (qa_form_created_date__c < '2019-01-07 15:30:45'::timestamp without time (...)
  • Rows Removed by Filter: 19345