query pg_stat_ssl hang 100%cpu

2023-09-05 Thread James Pang (chaolpan)
Hi, PGv14.8, OS RHEL8, no SSL enabled in this database, we have a lot of client sessions who check it's ssl state by query, all other sessions got done very quickly, but only 1 session hang there in 100% cpu tens of hours, even pg_terminate_backend does not make it stopped either. It looks

query pg_stat_ssl hang 100%cpu

2023-09-05 Thread James Pang (chaolpan)
Hi, PGv14.8, OS RHEL8, no SSL enabled in this database, we have a lot of client sessions who check it's ssl state by query, all other sessions got done very quickly, but only 1 session hang there in 100% cpu. It looks like abnormal. select ssl from pg_stat_ssl where pid=pg_backend_pid();