explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MWja

Settings
# exclusive inclusive rows x rows loops node
1. 1,636.373 7,467.365 ↓ 83.0 105,216 1

Sort (cost=8,657.86..8,661.03 rows=1,268 width=16) (actual time=6,821.567..7,467.365 rows=105,216 loops=1)

  • Sort Key: d.datetime
  • Sort Method: external sort Disk: 2672kB
2. 2,571.673 5,830.992 ↓ 83.0 105,216 1

Nested Loop Left Join (cost=0.57..8,592.50 rows=1,268 width=16) (actual time=272.549..5,830.992 rows=105,216 loops=1)

3. 944.567 944.567 ↓ 105.2 105,216 1

Function Scan on generate_series d (cost=0.01..10.01 rows=1,000 width=8) (actual time=272.476..944.567 rows=105,216 loops=1)

4. 2,314.752 2,314.752 ↑ 1.0 1 105,216

Index Scan using profile_coeff_ff_series_pkey on profile_coeff_ff_series origin (cost=0.56..8.57 rows=1 width=16) (actual time=0.016..0.022 rows=1 loops=105,216)

  • Index Cond: ((sub_profile_code = ‘’RES1-P1'’::text) AND (profile_type = ‘’STATIC’’::text) AND (horizon = ‘’FORECASTED_MLT’’::text) AND (temperature_type = ‘’NORMAL’‘::text) AND (d.datetime = start_datetime) AND (start_datetime >= ‘'2018-12-31 23:00:00+00'‘::timestamp with time zone))
  • Filter: (end_datetime <= ‘'2024-12-31 23:00:00+00'‘::timestamp with time zone)
Planning time : 7.834 ms
Execution time : 8,093.204 ms