explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5JyG

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 6,566.854 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,104.29..10,117.67 rows=1 width=66) (actual time=6,566.854..6,566.854 rows=0 loops=1)

2. 9.549 6,566.853 ↓ 0.0 0 1

Nested Loop (cost=1,104.01..10,110.65 rows=1 width=85) (actual time=6,566.853..6,566.853 rows=0 loops=1)

3. 11.501 95.310 ↓ 5,467.0 10,934 1

Hash Join (cost=1,103.45..10,093.74 rows=2 width=104) (actual time=1.819..95.310 rows=10,934 loops=1)

  • Hash Cond: ((qa.property_consultant__c)::text = (co.sfid)::text)
4. 82.105 82.105 ↓ 2.6 10,936 1

Seq Scan on qa_form__c qa (cost=0.00..8,979.38 rows=4,156 width=104) (actual time=0.091..82.105 rows=10,936 loops=1)

  • Filter: ((service_request_pop__c IS NULL) AND ((shop_category__c)::text = ANY ('{Leasing,Audit}'::text[])) AND ((shop_status__c)::text = 'Completed'::text))
  • Rows Removed by Filter: 56689
5. 0.326 1.704 ↑ 7.7 684 1

Hash (cost=1,037.44..1,037.44 rows=5,281 width=19) (actual time=1.704..1.704 rows=684 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 99kB
6. 1.378 1.378 ↑ 7.7 684 1

Index Scan using hc_idx_contact_recordtypeid on contact co (cost=0.56..1,037.44 rows=5,281 width=19) (actual time=0.047..1.378 rows=684 loops=1)

  • Index Cond: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
7. 6,461.994 6,461.994 ↓ 0.0 0 10,934

Index Scan using hcu_idx_case_sfid on "case" c (cost=0.56..8.45 rows=1 width=19) (actual time=0.591..0.591 rows=0 loops=10,934)

  • Index Cond: ((sfid)::text = (qa.case__c)::text)
  • Filter: ((createddate >= '2019-05-09 19:06:36'::timestamp without time zone) AND (createddate < '2019-05-10 19:06:36'::timestamp without time zone))
  • Rows Removed by Filter: 1
8. 0.000 0.000 ↓ 0.0 0

Index Scan using hc_idx_internal_app_permissions__c_contact__c on internal_app_permissions__c ip (cost=0.28..7.01 rows=1 width=19) (never executed)

  • Index Cond: ((contact__c)::text = (co.sfid)::text)
  • Filter: ((employment_status__c)::text = 'Active'::text)