explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GWBa

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

Limit (cost=425.66..425.66 rows=1 width=322) (actual time=0.101..0.101 rows=0 loops=1)

2. 0.003 0.100 ↓ 0.0 0 1

Sort (cost=425.66..425.66 rows=1 width=322) (actual time=0.100..0.100 rows=0 loops=1)

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

WindowAgg (cost=162.20..425.66 rows=1 width=322) (actual time=0.096..0.097 rows=0 loops=1)

4. 0.001 0.095 ↓ 0.0 0 1

Bitmap Heap Scan on search_address (cost=162.20..425.66 rows=1 width=290) (actual time=0.095..0.095 rows=0 loops=1)

  • Recheck Cond: ((city__c)::text ~~* '%45678sdfiysfd99cwwercni1%'::text)
  • Filter: (((state__c)::text ~~ 'Cddssali%'::text) AND ((postal_code__c)::text ~~ '%87sfsddf32%'::text))
5. 0.094 0.094 ↓ 0.0 0 1

Bitmap Index Scan on search_address_city__c_gist_trgm_idx_name (cost=0.00..162.20 rows=134 width=0) (actual time=0.094..0.094 rows=0 loops=1)

  • Index Cond: ((city__c)::text ~~* '%45678sdfiysfd99cwwercni1%'::text)
Planning time : 0.432 ms
Execution time : 0.163 ms