explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AaLa

Settings
# exclusive inclusive rows x rows loops node
1. 0.149 69.003 ↑ 1.0 1 1

Aggregate (cost=9,818.18..9,818.19 rows=1 width=176) (actual time=69.003..69.003 rows=1 loops=1)

2. 0.021 68.854 ↓ 124.0 124 1

Nested Loop Left Join (cost=2,070.45..9,818.09 rows=1 width=54) (actual time=7.800..68.854 rows=124 loops=1)

3. 0.000 68.337 ↓ 124.0 124 1

Nested Loop (cost=2,070.17..9,812.42 rows=1 width=73) (actual time=7.788..68.337 rows=124 loops=1)

4. 4.103 17.467 ↓ 6,372.0 6,372 1

Hash Join (cost=2,069.74..9,804.07 rows=1 width=92) (actual time=7.081..17.467 rows=6,372 loops=1)

  • Hash Cond: ((qa.property_consultant__c)::text = (co.sfid)::text)
5. 7.132 12.402 ↓ 11.7 6,374 1

Bitmap Heap Scan on qa_form__c qa (cost=966.29..8,699.18 rows=546 width=92) (actual time=6.105..12.402 rows=6,374 loops=1)

  • Recheck Cond: ((service_request_pop__c IS NOT NULL) AND ((shop_status__c)::text = 'Completed'::text))
  • Filter: ((shop_category__c)::text = ANY ('{Maintenance,"Maintenance Audit"}'::text[]))
  • Rows Removed by Filter: 1015
  • Heap Blocks: exact=3818
6. 0.337 5.270 ↓ 0.0 0 1

BitmapAnd (cost=966.29..966.29 rows=5,695 width=0) (actual time=5.270..5.270 rows=0 loops=1)

7. 1.361 1.361 ↑ 1.0 12,314 1

Bitmap Index Scan on ah_idx_service_request_pop (cost=0.00..253.88 rows=12,479 width=0) (actual time=1.361..1.361 rows=12,314 loops=1)

  • Index Cond: (service_request_pop__c IS NOT NULL)
8. 3.572 3.572 ↓ 1.0 31,093 1

Bitmap Index Scan on hc_idx_qa_form__c_shop_status__c (cost=0.00..711.88 rows=30,862 width=0) (actual time=3.572..3.572 rows=31,093 loops=1)

  • Index Cond: ((shop_status__c)::text = 'Completed'::text)
9. 0.171 0.962 ↑ 7.7 684 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 99kB
10. 0.791 0.791 ↑ 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.025..0.791 rows=684 loops=1)

  • Index Cond: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
11. 50.976 50.976 ↓ 0.0 0 6,372

Index Scan using service_request1__c_idx_sfid on service_request1__c sr (cost=0.43..8.36 rows=1 width=19) (actual time=0.008..0.008 rows=0 loops=6,372)

  • Index Cond: ((sfid)::text = (qa.service_request_pop__c)::text)
  • Filter: ((createddate >= '2019-04-10 18:59:11'::timestamp without time zone) AND (createddate < '2019-05-10 18:59:11'::timestamp without time zone))
  • Rows Removed by Filter: 1
12. 0.496 0.496 ↑ 1.0 1 124

Index Scan using hc_idx_internal_app_permissions__c_contact__c on internal_app_permissions__c ip (cost=0.28..5.66 rows=1 width=19) (actual time=0.004..0.004 rows=1 loops=124)

  • Index Cond: ((contact__c)::text = (qa.property_consultant__c)::text)
  • Filter: ((employment_status__c)::text = 'Active'::text)
  • Rows Removed by Filter: 0
Planning time : 1.844 ms
Execution time : 69.256 ms