explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mE4D

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 820.752 ↓ 0.0 0 1

Limit (cost=98,888.24..98,888.24 rows=1 width=322) (actual time=820.752..820.752 rows=0 loops=1)

2. 0.005 820.751 ↓ 0.0 0 1

Sort (cost=98,888.24..98,888.24 rows=1 width=322) (actual time=820.751..820.751 rows=0 loops=1)

  • Sort Key: tranzact_on_zayo_network_status__c
  • Sort Method: quicksort Memory: 25kB
3. 0.000 820.746 ↓ 0.0 0 1

WindowAgg (cost=1,000.00..98,888.23 rows=1 width=322) (actual time=820.746..820.746 rows=0 loops=1)

4. 8.932 826.720 ↓ 0.0 0 1

Gather (cost=1,000.00..98,888.23 rows=1 width=290) (actual time=820.744..826.720 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
5. 817.788 817.788 ↓ 0.0 0 2

Parallel Seq Scan on search_address (cost=0.00..97,888.13 rows=1 width=290) (actual time=817.788..817.788 rows=0 loops=2)

  • Filter: ((lower((city__c)::text) ~~ '45678iyd99cwwercni1%'::text) AND (lower((state__c)::text) ~~ 'Cali%'::text) AND (lower((postal_code__c)::text) ~~ '8732%'::text))
  • Rows Removed by Filter: 994518
Planning time : 0.204 ms
Execution time : 826.798 ms