explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7JIN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,872.19..408,131.50 rows=1 width=124) (actual rows= loops=)

  • Join Filter: (emissions.event_time = generation.event_time)
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,871.78..408,124.06 rows=1 width=88) (actual rows= loops=)

  • Join Filter: (eg_realpower_15min.local_15min = emissions.event_time)
3. 0.000 0.000 ↓ 0.0

Seq Scan on emissions (cost=0.00..4,885.50 rows=1 width=44) (actual rows= loops=)

  • Filter: ((event_time >= '2019-07-01 00:00:00'::timestamp without time zone) AND (event_time < '2019-07-02 00:00:00'::timestamp without time zone) AND (((date_part('minute'::text, event_time))::integer % 15) = 0))
4. 0.000 0.000 ↓ 0.0

Subquery Scan on eg_realpower_15min (cost=1,871.78..403,230.76 rows=624 width=44) (actual rows= loops=)

  • Filter: ((eg_realpower_15min.local_15min >= '2019-07-01 00:00:00-05'::timestamp with time zone) AND (eg_realpower_15min.local_15min < '2019-07-02 00:00:00-05'::timestamp with time zone))
5. 0.000 0.000 ↓ 0.0

Append (cost=1,871.78..401,359.82 rows=124,729 width=2,476) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=1,871.78..333,958.11 rows=100,027 width=2,424) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on egauge_15min_wide_real_2012to2018 (cost=1,871.78..332,707.77 rows=100,027 width=2,424) (actual rows= loops=)

  • Recheck Cond: (dataid = 9983)
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on electricity_egauge_15min_did_idx (cost=0.00..1,846.77 rows=100,027 width=0) (actual rows= loops=)

  • Index Cond: (dataid = 9983)
9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on egauge_15min_wide_real_2019 (cost=1,128.00..66,531.05 rows=24,702 width=310) (actual rows= loops=)

  • Recheck Cond: (dataid = 9983)
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on egauge_15min_wide_real_2019_idx (cost=0.00..1,121.82 rows=24,702 width=0) (actual rows= loops=)

  • Index Cond: (dataid = 9983)
11. 0.000 0.000 ↓ 0.0

Index Scan using generation_un on generation (cost=0.42..7.39 rows=1 width=77) (actual rows= loops=)

  • Index Cond: ((event_time = eg_realpower_15min.local_15min) AND (event_time >= '2019-07-01 00:00:00'::timestamp without time zone) AND (event_time < '2019-07-02 00:00:00'::timestamp without time zone))