Re: Need help identifying a periodic performance issue.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Nov 17, 2021 at 11:40 AM Robert Creager
<robertc@xxxxxxxxxxxxxxxx> 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.





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux