explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DUK : Optimization for: t; plan #Xnjr

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 426.837 2,422.532 ↑ 3,561.8 97 1

GroupAggregate (cost=104,303.80..176,857.54 rows=345,494 width=520) (actual time=1,356.935..2,422.532 rows=97 loops=1)

  • Group Key: (((((date_system_stat)::date)::text || ' '::text) || "right"(('0'::text || (date_part('hours'::text, date_system_stat))::text), 2)))
2. 1,455.292 1,995.695 ↑ 1.0 345,494 1

Sort (cost=104,303.80..105,167.54 rows=345,494 width=152) (actual time=1,346.250..1,995.695 rows=345,494 loops=1)

  • Sort Key: (((((date_system_stat)::date)::text || ' '::text) || "right"(('0'::text || (date_part('hours'::text, date_system_stat))::text), 2)))
  • Sort Method: external merge Disk: 49256kB
3. 540.403 540.403 ↑ 1.0 345,494 1

Seq Scan on system_stats (cost=0.00..20,560.29 rows=345,494 width=152) (actual time=0.067..540.403 rows=345,494 loops=1)