explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8OJE

Settings
# exclusive inclusive rows x rows loops node
1. 0.245 2.224 ↑ 1.0 1 1

Aggregate (cost=525.64..525.65 rows=1 width=8) (actual time=2.224..2.224 rows=1 loops=1)

2. 1.979 1.979 ↓ 1.0 4,461 1

Index Scan using index_mesreg_2 on mesreg (cost=0.29..514.69 rows=4,382 width=8) (actual time=0.023..1.979 rows=4,461 loops=1)

  • Index Cond: ((smpdate >= '2020-01-01 00:00:00+01'::timestamp with time zone) AND (smpdate <= '2020-02-01 00:00:00+01'::timestamp with time zone))
  • Filter: ((stationid = 4) AND ((paramtype)::text = ANY ('{FIL,UPL,STD}'::text[])))
  • Rows Removed by Filter: 4,461