explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qrEs

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 35,682.653 ↑ 1.0 10 1

Sort (cost=479,052.78..479,052.81 rows=10 width=4) (actual time=35,682.653..35,682.653 rows=10 loops=1)

  • Sort Key: (date_part('year'::text, (periodoinfo)::timestamp without time zone))
  • Sort Method: quicksort Memory: 25kB
2. 2,729.441 35,682.641 ↑ 1.0 10 1

HashAggregate (cost=479,052.47..479,052.62 rows=10 width=4) (actual time=35,682.640..35,682.641 rows=10 loops=1)

  • Group Key: date_part('year'::text, (periodoinfo)::timestamp without time zone)
3. 32,953.200 32,953.200 ↑ 1.0 10,532,536 1

Seq Scan on map_dw_ft_vw_liquidaciones (cost=0.00..452,721.12 rows=10,532,541 width=4) (actual time=0.020..32,953.200 rows=10,532,536 loops=1)

Planning time : 0.186 ms
Execution time : 35,693.292 ms