explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7SXm

Settings
# exclusive inclusive rows x rows loops node
1. 17,403.758 34,731.253 ↓ 2.4 7,404,082 1

Hash Join (cost=83.36..936,340.97 rows=3,069,763 width=285) (actual time=1.442..34,731.253 rows=7,404,082 loops=1)

  • Hash Cond: (t1.dataid = metadata.dataid)
2. 17,326.122 17,326.122 ↑ 1.0 12,283,073 1

Index Scan using electricity_egauge_15min_local_15min_idx on egauge_15min_wide_real_2012to2018 t1 (cost=0.57..903,604.14 rows=12,407,590 width=285) (actual time=0.054..17,326.122 rows=12,283,073 loops=1)

  • Index Cond: ((local_15min >= '2018-01-01 00:00:00'::timestamp without time zone) AND (local_15min < '2019-01-01 00:00:00'::timestamp without time zone))
3. 0.213 1.373 ↑ 1.2 327 1

Hash (cost=77.72..77.72 rows=406 width=2) (actual time=1.372..1.373 rows=327 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
4. 1.160 1.160 ↑ 1.2 327 1

Seq Scan on metadata (cost=0.00..77.72 rows=406 width=2) (actual time=0.041..1.160 rows=327 loops=1)

  • Filter: ((active_record = 'yes'::text) AND (air1 = 'yes'::text) AND ((state)::text = 'Texas'::text))
  • Rows Removed by Filter: 1314
Planning time : 0.762 ms