Re: Performance problem postgresql 9.5

From: Chapman Flack <chap(at)anastigmatix(dot)net>
To: Miguel Angel Sanchez Sandoval <massanche(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Performance problem postgresql 9.5
Date: 2018-06-08 21:06:43
Message-ID: 40bd111e-ba2a-d69d-ba29-80ee90960f7a@anastigmatix.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On 06/08/2018 03:56 PM, Miguel Angel Sanchez Sandoval wrote:
> I see the querys active and encounter
> select fun ('./ 2yhdgrfrt63788')

Would it be possible (observing appropriate precautions for
a compromised server) to report here the language and definition
of any function(s) named 'fun' in that database? Effectively:

select lanname, prosrc, probin
from pg_proc join pg_language as l on l.oid = prolang
where proname = 'fun';

Regards,
-Chap

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ahmed, Nawaz 2018-06-08 21:41:29 Re: pg_basebackup: could not get write-ahead log end position from server: ERROR
Previous Message Steve Atkins 2018-06-08 20:26:12 Re: Performance problem postgresql 9.5

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Shutyaev 2018-06-09 10:46:16 pg_upgrade and wraparound
Previous Message Adrian Klaver 2018-06-08 20:59:32 Re: Multiple PostgreSQL instances on one machine