explain.depesz.com

PostgreSQL's explain analyze made readable

Result: evj16

Settings
# exclusive inclusive rows x rows loops node
1. 1.039 6.913 ↑ 1.0 1 1

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

2. 0.000 5.874 ↑ 1.0 1,000 1

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

3. 0.042 1.087 ↑ 1.0 1,000 1

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

4. 1.045 1.045 ↑ 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.478..1.045 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