explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l62A

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

Sort (cost=11,066,172.89..11,113,903.65 rows=19,092,304 width=120) (actual rows= loops=)

  • Sort Key: open_position_hist.position_date DESC, open_position_hist.acc_client_acc_ref, open_position_hist.instr_ref
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,958.59..1,709,546.99 rows=19,092,304 width=120) (actual rows= loops=)

  • Hash Cond: ((open_position_hist.instr_ref)::text = (instr.instr_ref)::text)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=16.89..773,735.11 rows=19,092,304 width=120) (actual rows= loops=)

  • Hash Cond: ((open_position_hist.acc_client_acc_ref)::text = (acc_client_acc.acc_client_acc_ref)::text)
4. 0.000 0.000 ↓ 0.0

Seq Scan on open_position_hist (cost=0.00..511,199.04 rows=19,092,304 width=120) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=14.73..14.73 rows=173 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on acc_client_acc (cost=0.00..14.73 rows=173 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=1,554.31..1,554.31 rows=20,031 width=29) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on instr (cost=0.00..1,554.31 rows=20,031 width=29) (actual rows= loops=)