explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J1Nv

Settings
# exclusive inclusive rows x rows loops node
1. 0.944 5,367.276 ↓ 95.0 95 1

Nested Loop (cost=1,872.19..384,315.03 rows=1 width=124) (actual time=14.430..5,367.276 rows=95 loops=1)

  • Join Filter: (emissions.event_time = generation.event_time)
2. 8.043 5,364.907 ↓ 95.0 95 1

Nested Loop (cost=1,871.78..384,307.52 rows=1 width=88) (actual time=14.396..5,364.907 rows=95 loops=1)

  • Join Filter: (eg_realpower_15min.local_15min = emissions.event_time)
  • Rows Removed by Join Filter: 9025
3. 10.454 10.454 ↓ 95.0 95 1

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

  • 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))
  • Rows Removed by Filter: 84285
4. 932.330 5,346.410 ↑ 5.9 96 95

Subquery Scan on eg_realpower_15min (cost=1,871.78..379,414.88 rows=571 width=44) (actual time=4.422..56.278 rows=96 loops=95)

  • 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))
  • Rows Removed by Filter: 15616
5. 1,782.485 4,414.080 ↑ 7.3 15,712 95

Append (cost=1,871.78..377,701.67 rows=114,214 width=2,476) (actual time=2.255..46.464 rows=15,712 loops=95)

6. 0.095 1.140 ↓ 0.0 0 95

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

7. 0.190 1.045 ↓ 0.0 0 95

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

  • Recheck Cond: (dataid = 43)
8. 0.855 0.855 ↓ 0.0 0 95

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

  • Index Cond: (dataid = 43)
9. 2,488.810 2,630.455 ↓ 1.1 15,712 95

Bitmap Heap Scan on egauge_15min_wide_real_2019 (cost=650.51..43,030.62 rows=14,187 width=310) (actual time=2.241..27.689 rows=15,712 loops=95)

  • Recheck Cond: (dataid = 43)
  • Heap Blocks: exact=363660
10. 141.645 141.645 ↓ 1.1 15,712 95

Bitmap Index Scan on egauge_15min_wide_real_2019_idx (cost=0.00..646.96 rows=14,187 width=0) (actual time=1.491..1.491 rows=15,712 loops=95)

  • Index Cond: (dataid = 43)
11. 1.425 1.425 ↑ 1.0 1 95

Index Scan using generation_un on generation (cost=0.42..7.46 rows=1 width=77) (actual time=0.015..0.015 rows=1 loops=95)

  • 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))
  • Filter: (((date_part('minute'::text, event_time))::integer % 15) = 0)
Planning time : 1.093 ms