explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LBfp

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

Limit (cost=97,133.20..97,133.20 rows=1 width=322) (actual time=694.281..694.281 rows=0 loops=1)

2. 0.005 694.280 ↓ 0.0 0 1

Sort (cost=97,133.20..97,133.20 rows=1 width=322) (actual time=694.280..694.280 rows=0 loops=1)

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

WindowAgg (cost=1,000.00..97,133.20 rows=1 width=322) (actual time=694.275..694.275 rows=0 loops=1)

4. 9.592 695.399 ↓ 0.0 0 1

Gather (cost=1,000.00..97,133.20 rows=1 width=290) (actual time=694.272..695.399 rows=0 loops=1)

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

Parallel Seq Scan on search_address (cost=0.00..96,133.10 rows=1 width=290) (actual time=685.807..685.807 rows=0 loops=2)

  • Filter: (((city__c)::text ~~ '%45678iysfd99cwwercni1%'::text) AND ((state__c)::text ~~ '%Cdsali%'::text) AND ((postal_code__c)::text ~~ '%87sdf32%'::text))
  • Rows Removed by Filter: 994518
Planning time : 0.266 ms
Execution time : 695.478 ms