explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YsLI

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 229.689 ↑ 1.0 20 1

Limit (cost=101,214.22..101,215.37 rows=20 width=224) (actual time=229.682..229.689 rows=20 loops=1)

2.          

CTE rankquery

3. 3.408 209.853 ↓ 9.0 8,891 1

Hash Join (cost=1,215.15..100,775.95 rows=992 width=74) (actual time=34.852..209.853 rows=8,891 loops=1)

  • Hash Cond: ((sr.account_name__c)::text = (a.sfid)::text)
4. 184.428 197.729 ↓ 8.5 8,978 1

Bitmap Heap Scan on service_request1__c sr (cost=657.47..100,215.47 rows=1,062 width=74) (actual time=26.118..197.729 rows=8,978 loops=1)

  • Recheck Cond: ((createddate >= '2019-04-10 07:00:00'::timestamp without time zone) AND (createddate < '2019-05-11 07:00:00'::timestamp without time zone))
  • Filter: (ic_call_answered_by_ah__c AND ((ic_skill__c)::text <> ALL ('{"Spanish Translator","Customer Service"}'::text[])) AND ((status__c)::text = ANY ('{"In Progress","Request Sent"}'::text[])) AND (NULLIF((property_consultant__c)::text, ' (...)
  • Rows Removed by Filter: 24741
  • Heap Blocks: exact=27113
5. 13.301 13.301 ↓ 1.1 33,895 1

Bitmap Index Scan on hc_idx_service_request1__c_createddate (cost=0.00..657.20 rows=31,277 width=0) (actual time=13.301..13.301 rows=33,895 loops=1)

  • Index Cond: ((createddate >= '2019-04-10 07:00:00'::timestamp without time zone) AND (createddate < '2019-05-11 07:00:00'::timestamp without time zone))
6. 1.389 8.716 ↓ 1.0 2,555 1

Hash (cost=526.61..526.61 rows=2,486 width=19) (actual time=8.716..8.716 rows=2,555 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 160kB
7. 7.327 7.327 ↓ 1.0 2,555 1

Seq Scan on account a (cost=0.00..526.61 rows=2,486 width=19) (actual time=0.035..7.327 rows=2,555 loops=1)

  • Filter: ((NOT test_account__c) AND (NOT exclude_from_dashboards__c))
  • Rows Removed by Filter: 106
8. 2.752 229.684 ↑ 24.8 20 1

WindowAgg (cost=438.28..466.80 rows=496 width=224) (actual time=229.680..229.684 rows=20 loops=1)

9. 223.104 226.932 ↓ 17.3 8,586 1

CTE Scan on rankquery ra (cost=438.28..460.60 rows=496 width=216) (actual time=44.467..226.932 rows=8,586 loops=1)

  • Filter: (NOT (hashed SubPlan 2))
  • Rows Removed by Filter: 305
10.          

SubPlan (forCTE Scan)

11. 3.828 3.828 ↑ 1.0 12,282 1

Index Only Scan using ah_idx_service_request_pop on qa_form__c qa (cost=0.29..407.08 rows=12,479 width=19) (actual time=0.055..3.828 rows=12,282 loops=1)

  • Index Cond: (service_request_pop__c IS NOT NULL)
  • Heap Fetches: 87
Planning time : 1.769 ms
Execution time : 230.332 ms