explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HXZm : slow query, tag that has not been queried.

Settings
# exclusive inclusive rows x rows loops node
1. 172,903.905 172,903.905 ↑ 1.0 3,153,601 1

Index Scan using timetagindx on observations (cost=0.71..1,651,689.33 rows=3,281,830 width=20) (actual time=22.392..172,903.905 rows=3,153,601 loops=1)

  • Index Cond: ((tagid = 8309) AND ("time" >= '2018-01-01 00:00:00+00'::timestamp with time zone) AND ("time" <= '2019-01-01 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=3765 read=46730
Planning time : 0.089 ms
Execution time : 173,089.401 ms