explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EjH79

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

WindowAgg (cost=17,473,324.78..19,942,871.28 rows=75,986,046 width=58) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=17,473,324.78..17,663,289.90 rows=75,986,046 width=32) (actual rows= loops=)

  • Sort Key: agecgr, codmod, anoced, nroced, codage, ctasoc, datvct
3. 0.000 0.000 ↓ 0.0

Seq Scan on cgra (cost=0.00..2,072,965.46 rows=75,986,046 width=32) (actual rows= loops=)