• Amit Kapila's avatar
    Avoid counting transaction stats for parallel worker cooperating · bdf35744
    Amit Kapila authored
    transaction.
    
    The transaction that is initiated by the parallel worker to cooperate
    with the actual transaction started by the main backend to complete the
    query execution should not be counted as a separate transaction.  The
    other internal transactions started and committed by the parallel worker
    are still counted as separate transactions as we that is what we do in
    other places like autovacuum.
    
    This will partially fix the bloat in transaction stats due to additional
    transactions performed by parallel workers.  For a complete fix, we need to
    decide how we want to show all the transactions that are started internally
    for various operations and that is a matter of separate patch.
    
    Reported-by: Haribabu Kommi
    Author: Haribabu Kommi
    Reviewed-by: Amit Kapila, Jamison Kirk and Rahila Syed
    Backpatch-through: 9.6
    Discussion: https://postgr.es/m/CAJrrPGc9=jKXuScvNyQ+VNhO0FZk7LLAShAJRyZjnedd2D61EQ@mail.gmail.com
    bdf35744
pgstat.h 40 KB