explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VSs4

Settings
# exclusive inclusive rows x rows loops node
1. 39.611 39.611 ↑ 1.0 101,335 1

Index Scan using parameter_91_pkey on data.parameter_91 d (cost=0.42..3,791.15 rows=104,036 width=12) (actual time=0.040..39.611 rows=101,335 loops=1)

  • Output: "timestamp", value
  • Index Cond: ((d."timestamp" >= '2019-10-30 13:31:50'::timestamp without time zone) AND (d."timestamp" < '2019-11-29 13:31:50'::timestamp without time zone))
  • Buffers: shared hit=1 read=828 written=1