explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Rl1

Settings
# exclusive inclusive rows x rows loops node
1. 2,729.478 7,611.262 ↓ 1.4 2,539,058 1

HashAggregate (cost=2,468,714.90..2,492,115.88 rows=1,872,079 width=44) (actual time=6,491.217..7,611.262 rows=2,539,058 loops=1)

  • Group Key: ecritures_id, pool_name
2. 4,881.784 4,881.784 ↓ 1.0 3,507,276 1

Seq Scan on mouvementswithpool0 (cost=0.00..2,442,871.52 rows=3,445,783 width=18) (actual time=0.099..4,881.784 rows=3,507,276 loops=1)

  • Filter: (pool_name = 'VAT'::text)
  • Rows Removed by Filter: 23,773,704