Re: Need help identifying a periodic performance issue. - Mailing list pgsql-performance

On Wed, Nov 17, 2021 at 11:40 AM Robert Creager
<robertc@spectralogic.com> wrote:
> Presuming this is the type of output you are expecting:
>
> CPU     ID                    FUNCTION:NAME
>   0  58709                        :tick-10s
>
>
>               postgres`AtEOXact_LargeObject+0x11
>               postgres`CommitTransaction+0x127
>               postgres`CommitTransactionCommand+0xf2
>               postgres`PostgresMain+0x1fef
>               postgres`process_startup_packet_die
>               postgres`0x73055b
>               postgres`PostmasterMain+0xf36
>               postgres`0x697837
>               postgres`_start+0x100
>               `0x80095f008
>                 1

It's the right output format, but isn't /pid == '$PID'/ only going to
match one single process called "postgres"?   Maybe /execname ==
"postgres"/ to catch them all?  Hopefully it'll be obvious what's
going on from an outlier stack with a high sample count.  Can also be
useful to convert the output to flamegraph format if CPU time is
distributed over many distinct stacks.