explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RKKD

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

Unique (cost=18,691,562.62..19,343,651.92 rows=8,694,524 width=76) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=18,691,562.62..18,908,925.72 rows=86,945,240 width=76) (actual rows= loops=)

  • Sort Key: "THD_ID_N", "ACTS_ID_N", "CREA_S" DESC, "UPD_S" DESC
3. 0.000 0.000 ↓ 0.0

Seq Scan on qadacc (cost=0.00..2,700,698.40 rows=86,945,240 width=76) (actual rows= loops=)