explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SB87

Settings
# exclusive inclusive rows x rows loops node
1. 4.804 147.508 ↓ 1.1 6,233 1

Sort (cost=2,165.13..2,179.69 rows=5,826 width=47) (actual time=146.948..147.508 rows=6,233 loops=1)

  • Sort Key: (_st_distance(COALESCE(geodata), '0101000020E610000000000000008048400000000000002040'::geography, '0'::double precision, true)), zip_code
  • Sort Method: quicksort Memory: 799kB
2. 142.704 142.704 ↓ 1.1 6,233 1

Seq Scan on zone (cost=0.00..1,800.76 rows=5,826 width=47) (actual time=0.013..142.704 rows=6,233 loops=1)

Planning time : 0.187 ms
Execution time : 147.831 ms