explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A78V

Settings
# exclusive inclusive rows x rows loops node
1. 6.825 1,657.852 ↓ 1.5 1,591 1

HashAggregate (cost=1,082,157.29..1,082,163.51 rows=1,038 width=32) (actual time=1,656.896..1,657.852 rows=1,591 loops=1)

  • Filter: (sum(s_rt_zvk.transit) >= 0::double precision)
  • Total runtime: 1658.022 ms
2. 1,651.027 1,651.027 ↑ 3,128.9 6,932 1

Seq Scan on s_rt_zvk (cost=0.00..431,477.63 rows=21,689,322 width=32) (actual time=1,175.426..1,651.027 rows=6,932 loops=1)

  • Filter: (program_id = 4)