explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4if9

Settings
# exclusive inclusive rows x rows loops node
1. 0.340 0.340 ↑ 2.6 69 1

Index Only Scan using states_deviceid_online_offline_uindex on io.states s (cost=0.28..33.32 rows=179 width=16) (actual time=0.191..0.340 rows=69 loops=1)

  • Output: online, offline
  • Index Cond: (s.deviceid = 12)
  • Filter: (((s.online <= '2019-10-30 13:31:50'::timestamp without time zone) AND (s.offline > '2019-10-30 13:31:50'::timestamp without time zone)) OR ((s.online >= '2019-10-30 13:31:50'::timestamp without time zone) AND (s.offline < '2019-11-29 13:31:50'::timestamp without time zone)))
  • Rows Removed by Filter: 405
  • Heap Fetches: 4
  • Buffers: shared hit=1 read=10 dirtied=2