explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qPR

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

Sort (cost=417,034.71..418,715.09 rows=672,152 width=462) (actual rows= loops=)

  • Sort Key: exaas_entry_classification_05_pivotaccounts.line_number, exaas_entry_classification_05_pivotaccounts.comptenum
2. 0.000 0.000 ↓ 0.0

Subquery Scan on exaas_entry_classification_05_pivotaccounts (cost=0.00..71688.68 rows=672152 width=462)" -> Seq Scan on exaas_entry_classification_04_mvtsecrituresaccountclass4 (cost=0.00..61,606.40 rows=672,152 width=430) (actual rows= loops=)