OCA / OCB / 894

pending completion

Build # 894

Build Type

Pull #273

travis-ci

Committed by

guewen

Commit Message

Add a partial index on account move line

An log analysis showed that the normalized query below was executed very often
with a slow explain plan using a seq scan.

  SELECT move_id, date
  FROM account_move_line
  WHERE journal_id = 0
  AND period_id = 0
  AND create_uid = 0
  AND state = ''
  ORDER BY id DESC LIMIT 0;

This query is called in the _default_get of account_move_line to find the last
unbalanced move line. The state is always 'draft' and the fields always
journal_id, period_id and create_uid so it is a good candidate for a partial
index with combined fields.

The explain plan shows an impressive improvement, dropping from ~800ms to
~0.030 ms for a table with 3906500 records. This query was called 7700 times in
a working day for a cumulated duration of 25m32s.

Pull Request Pull Request #273: Add a partial index on account move line

Run Details

4 of 4 new or added lines in 1 file covered. (100.0%)

19446 of 62953 relevant lines covered (30.89%)

0.31 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

7.62

/addons/account/account_move_line.py

Build SHA Not Found

The commit SHA "51259fbb0571ffaf576967c7a1ef09aea2f16ef6" was not found in your repository, so the file cannot be loaded. This may be because you posted from a local development environment, or your CI created an ephemeral commit.

OCA / OCB / 894

Source File Press 'n' to go to next uncovered line, 'b' for previous

Build SHA Not Found

Source File
Press 'n' to go to next uncovered line, 'b' for previous