explain.depesz.com

PostgreSQL's explain analyze made readable

Result: taDx

Settings
# exclusive inclusive rows x rows loops node
1. 1.096 7.555 ↑ 1.0 1 1

Aggregate (cost=7,913.17..7,913.18 rows=1 width=32) (actual time=7.555..7.555 rows=1 loops=1)

2. 0.477 6.459 ↑ 1.0 1,000 1

Nested Loop Left Join (cost=0.72..7,903.17 rows=1,000 width=16) (actual time=0.254..6.459 rows=1,000 loops=1)

3. 0.056 0.982 ↑ 1.0 1,000 1

Limit (cost=0.29..102.17 rows=1,000 width=16) (actual time=0.245..0.982 rows=1,000 loops=1)

4. 0.926 0.926 ↑ 33.1 1,000 1

Index Scan using index_mesreg_2 on mesreg a (cost=0.29..3,371.59 rows=33,091 width=16) (actual time=0.244..0.926 rows=1,000 loops=1)

  • Index Cond: ((smpdate >= '2000-01-01 00:00:00+01'::timestamp with time zone) AND (smpdate <= '2020-08-01 00:00:00+02'::timestamp with time zone))
  • Filter: (((paramtype)::text = ANY ('{FIL,UPL}'::text[])) AND (stationid = 4))
  • Rows Removed by Filter: 1,999
5. 5.000 5.000 ↑ 1.0 1 1,000

Index Scan using index_mesval_1 on mesval b (cost=0.42..7.78 rows=1 width=16) (actual time=0.002..0.005 rows=1 loops=1,000)

  • Index Cond: (smpid = a.smpid)
  • Filter: (channelid = 2)
  • Rows Removed by Filter: 20