explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ynbL

Settings
# exclusive inclusive rows x rows loops node
1. 24,585.815 24,585.815 ↓ 312.0 312 1

Index Scan using level1_listing_internal_is_active_idx on level1_listing (cost=0.56..3,927,010.10 rows=1 width=89) (actual time=943.598..24,585.815 rows=312 loops=1)

  • Index Cond: (internal_is_active = true)
  • Filter: (internal_is_active AND (listing_geog && '0103000020E610000001000000050000004535177EAD0C54C0C04CB9F926343A404535177EAD0C54C0E452BFD8C14C3A4005852A360B0554C0E452BFD8C14C3A4005852A360B0554C0C04CB9F926343A404535177EAD0C54C0C04CB9F926343A40'::geography(Polygon,4326)) AND ((internal_site_id)::text = 'fli'::text) AND (_st_distance(listing_geog, '0103000020E610000001000000050000004535177EAD0C54C0C04CB9F926343A404535177EAD0C54C0E452BFD8C14C3A4005852A360B0554C0E452BFD8C14C3A4005852A360B0554C0C04CB9F926343A404535177EAD0C54C0C04CB9F926343A40'::geography(Polygon,4326), '0'::double precision, false) < '1e-05'::double precision))
  • Rows Removed by Filter: 8583005
Planning time : 0.379 ms
Execution time : 24,585.924 ms