explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jIF

Settings
# exclusive inclusive rows x rows loops node
1. 554.583 26,669.127 ↓ 291.8 58,368 1

Sort (cost=1,956.93..1,957.43 rows=200 width=86) (actual time=26,657.441..26,669.127 rows=58,368 loops=1)

  • Output: c."SP_ID", (btrim(to_char((trunc_timestamp2(timezone((sys_config_value('LOCAL_TIME_ZONE'::character varying))::text, (c."RECORDED_TIME")::timestamp with time zone), (sys_config_value('HISTORY_TRAFFIC_GRANULARITY'::character varying))::integer)), (...)
  • Sort Key: c."SP_ID", (trunc_timestamp2(timezone((sys_config_value('LOCAL_TIME_ZONE'::character varying))::text, (c."RECORDED_TIME")::timestamp with time zone), (sys_config_value('HISTORY_TRAFFIC_GRANULARITY'::character varying))::integer))
  • Sort Method: quicksort Memory: 9745kB
  • Buffers: shared hit=3044311 read=5594
2. 1,616.779 26,114.544 ↓ 291.8 58,368 1

HashAggregate (cost=1,836.29..1,949.29 rows=200 width=86) (actual time=25,337.796..26,114.544 rows=58,368 loops=1)

  • Output: c."SP_ID", btrim(to_char((trunc_timestamp2(timezone((sys_config_value('LOCAL_TIME_ZONE'::character varying))::text, (c."RECORDED_TIME")::timestamp with time zone), (sys_config_value('HISTORY_TRAFFIC_GRANULARITY'::character varying))::intege (...)
  • Buffers: shared hit=3044311 read=5594
3. 24,497.765 24,497.765 ↓ 583.7 583,680 1

Function Scan on public.get_load_negated_interval_records_between c (cost=1.29..1,808.79 rows=1,000 width=68) (actual time=1,164.186..24,497.765 rows=583,680 loops=1)

  • Output: c."SP_ID", trunc_timestamp2(timezone((sys_config_value('LOCAL_TIME_ZONE'::character varying))::text, (c."RECORDED_TIME")::timestamp with time zone), (sys_config_value('HISTORY_TRAFFIC_GRANULARITY'::character varying))::integer), (trun (...)
  • Function Call: get_load_negated_interval_records_between((timezone((sys_config_value('LOCAL_TIME_ZONE'::character varying))::text, (date_trunc('week'::text, timezone((sys_config_value('LOCAL_TIME_ZONE'::character varying))::text, ((now())::ti (...)
  • Buffers: shared hit=2927575 read=5594