explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oUls

Settings
# exclusive inclusive rows x rows loops node
1. 4,062.814 4,062.814 ↑ 1.9 547 1

Index Scan using node_grid_cache_cell_z_index_idx on node_grid_cache_cell c (cost=0.43..472.38 rows=1,015 width=32) (actual time=44.730..4,062.814 rows=547 loops=1)

  • Index Cond: ((z_index >= 4000) AND (z_index < 4001))
  • Filter: ((msgpack_data IS NOT NULL) AND (x_index >= '-32'::integer) AND (x_index <= 82) AND (y_index >= '-17'::integer) AND (y_index <= 47) AND (grid_id = 1))
  • Buffers: shared hit=2320 read=4125 dirtied=27