Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)

Subject: Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
From: MichaelDBA <MichaelDBA@xxxxxxxxxxx>
Date: Thu, 5 Jan 2023 06:31:46 -0500
Cc: pgsql-performance@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAK-MWwRxnjLTTTkM_muvBrHMoYYbT5xYFm=5cML9Q+SfRAwkXQ@mail.gmail.com>
References: <CAK-MWwSfx7SmUQ=_rB4q61sE8uP6LqH-1wM0DSYyBadjBe9BDw@mail.gmail.com> <CAK-MWwRxnjLTTTkM_muvBrHMoYYbT5xYFm=5cML9Q+SfRAwkXQ@mail.gmail.com>
Ui-outboundreport: notjunk:1;M01:P0:6Uc67z6AwHA=;a/9tnduP+CvK8JyQTZ1vohxplld ppTdxpzzLynEUbab7Tr3CWqpWqzXGVt1xEiWTz4nLeJdGAWb4Gw5ic1KusU3y6D0xmgznSMC6 /MI54dTKUIPxLHwblH1sBgpeDese843V8SE+2hRbYaW4PaET3gltr2qbGXEf9EJI2lhPgXcdm Kx8vR7opAcpbB0rfuCM3vCnj9JPFkbbu8gP92NUvMwGysfY3f9Lf/QuoxVxUBR9MbcZAuBfod IVAzyjafGrb1d5FfDnGJ/9FlYD8wyLSXDSidADCWTeK0aK2ErAghFKaMZl7G231NgJjJUmPlP P83G/rT+g0WCWPWsfxL3rml2gYC/C5K2ZnexMu3KlMCRPE0HH2UR4IjESA3qh00d7MjtO1l9O DbIvAhQgWeRefVubFkMaYmK1aYYbxpecB5lBirwS7MQHcGewXYmVYPquuRi2FH3HToNw3cQxu c9/fDUoB3BxhLMWXiicAlsrQLCOdggB2YESkbRX+R3FcvKuXgeHFeBodUAacpxc4/XF1KPSNM v9jaafQ0fPg6NeyNfhJnqwRUcSzkutvWhPZRJ2XK4h0VwvdA5TnRZTLUeo2xplTtSgATVNdDN pDLHWrCo4c5+5mOBDKM1gq/6e/Gj+Xc+hsQ3N3WMjsN2BrDX6k718QhnlD1GyjB2cYTU1XDjj g2Ku5MkIT06uGcwkYR+N6tR3tM/LTcjaEblnW/PXBQ==
User-agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 PostboxApp/7.0.59

What happens if you take pg_stat_statements out of the picture (remove from shared_preload_libraries)? Does your BIND problem go away?

Follow-Ups:
- Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
  - From: Maxim Boguk

References:
- How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
  - From: Maxim Boguk
- Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
  - From: Maxim Boguk