explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dbme

Settings
# exclusive inclusive rows x rows loops node
1. 6.452 2,448.351 ↓ 1.5 1,596 1

HashAggregate (cost=1,083,581.61..1,083,587.84 rows=1,038 width=32) (actual time=2,447.488..2,448.351 rows=1,596 loops=1)

  • Filter: (sum(transit) >= 0::double precision)
2. 2,441.899 2,441.899 ↑ 3,127.6 6,944 1

Seq Scan on s_rt_zvk (cost=0.00..432,045.54 rows=21,717,869 width=32) (actual time=1,228.241..2,441.899 rows=6,944 loops=1)

  • Filter: (program_id = 4)