RE: attempting to retrieve column names from information schemafails. - Mailing list pgsql-general

From Day, David
Subject RE: attempting to retrieve column names from information schemafails.
Date
Msg-id c3aed4403f514b2e83212a2b5a8036f8@exch-02.redcom.com
Whole thread Raw
In response to Re: attempting to retrieve column names from information schema fails.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Thank you Tom.

I'll log that suggestion with our internal trouble report for actions to take on it's next occurrence.
I should have thought of using your suggested view.   It's been some time since I have had any
suspicious postgresql behavior to explore and had forgotten about some of the better  power tools.
Admin skills get rusty.



Best

Dave

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, December 04, 2017 11:08 AM
To: Day, David <dday@redcom.com>
Cc: pgsql-general@postgresql.org
Subject: Re: attempting to retrieve column names from information schema fails.

"Day, David" <dday@redcom.com> writes:
> I'm looking on some insights on the following problem on retrieving
> table column names from the information schema ( postgres 9.6.6 FreeBSD 11.1 ) When my client starts up up.  Each
thread( 10 ) run this command. 
> select column_name from information_schema.columns where table_name =
> 'pep_port_log'; I have encountered two instances of testing Where the server does not respond to that  command.

Hm.  Next time it happens, look into pg_stat_activity to see if the backend process is waiting, and if so for what, and
whatother processes are waiting.  (I'm wondering about undetected deadlocks, for instance.) If it's running, maybe you
couldcollect some stack traces to try to narrow down what it's doing.  Actually, a stack trace would be useful if it's
waiting,too. 

https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD

            regards, tom lane



pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Centos 6.9 and centos 7
Next
From: "David G. Johnston"
Date:
Subject: Re: WAL reducing size