explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EJhY

Settings
# exclusive inclusive rows x rows loops node
1. 0.670 11.630 ↑ 1.0 1,000 1

Sort (cost=7,958.00..7,960.50 rows=1,000 width=24) (actual time=11.587..11.630 rows=1,000 loops=1)

  • Sort Key: (date_part('epoch'::text, (a.smpdate - '1970-01-01 00:00:00+01'::timestamp with time zone)))
  • Sort Method: quicksort Memory: 103kB
2. 1.314 10.960 ↑ 1.0 1,000 1

Nested Loop Left Join (cost=0.72..7,908.17 rows=1,000 width=24) (actual time=1.903..10.960 rows=1,000 loops=1)

3. 0.047 1.646 ↑ 1.0 1,000 1

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

4. 1.599 1.599 ↑ 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.832..1.599 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. 8.000 8.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.004..0.008 rows=1 loops=1,000)

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