explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OvfJ

Settings
# exclusive inclusive rows x rows loops node
1. 111,485.505 197,210.371 ↑ 1.0 19,092,303 1

Sort (cost=9,867,824.94..9,915,555.70 rows=19,092,304 width=120) (actual time=178,437.130..197,210.371 rows=19,092,303 loops=1)

  • Sort Key: position_date, acc_client_acc_ref, instr_ref
  • Sort Method: external merge Disk: 2142448kB
2. 85,724.866 85,724.866 ↑ 1.0 19,092,303 1

Seq Scan on open_position_hist (cost=0.00..511,199.04 rows=19,092,304 width=120) (actual time=0.007..85,724.866 rows=19,092,303 loops=1)

Planning time : 0.105 ms
Execution time : 199,058.248 ms