explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wh6w

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

Unique (cost=124,391,630.15..126,072,303.74 rows=139,679 width=47) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=124,391,630.15..125,231,966.95 rows=336,134,717 width=47) (actual rows= loops=)

  • Sort Key: xxx_id
3. 0.000 0.000 ↓ 0.0

Seq Scan on xxx_journal (cost=0.00..35,427,111.17 rows=336,134,717 width=47) (actual rows= loops=)