explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IWOV

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.045 ↑ 1.0 1 1

Limit (cost=0.13..0.73 rows=1 width=71) (actual time=0.044..0.045 rows=1 loops=1)

2. 0.043 0.043 ↑ 14.0 1 1

Index Scan using user_loc_index on app_user (cost=0.13..8.51 rows=14 width=71) (actual time=0.043..0.043 rows=1 loops=1)

  • Order By: (loc <-> '01010000009ED1562591135D4056D4601A86054440'::geometry)
  • Filter: ((name)::text <> '苹果'::text)
Planning time : 0.131 ms
Execution time : 0.065 ms