On Thu, Mar 24, 2022 at 03:59:54PM +, Kumar, Mukesh wrote:
> Can anyone suggest to improve the query as from application end 1 min time is
> not accepted by client.
> Please find the query and explain analyze report from below link
It's hard to say for sure without seeing real query (query on
Hi,
On Thu, Aug 25, 2022 at 10:49:51AM +0200, Jose Osinde wrote:
> select logical_identifier, version_id, lastproduct
>from test_product_ui_partition.product_ui pui
> where pui.mission_id='urn:esa:psa:context:investigation:mission.em16'
> and
> pui.logical_identifier='urn:esa:psa:em
On Wed, Oct 12, 2022 at 10:46:23PM +0530, Sengottaiyan T wrote:
> Thanks, Michael.
>
> Due to reactive nature of the intermittent alerts, Is there any table which
> stores the historical information / periodic snapshots captured from the
> pg_stat_activity view?
No. Unless you will make one, and
On Fri, Oct 14, 2022 at 10:57:00PM +0530, Sengottaiyan T wrote:
> Please suggest: Is there any open-source tool available for capturing such
> information?
pg_cron?
depesz
On Tue, Apr 06, 2021 at 01:22:31PM +0530, aditya desai wrote:
> Hi,
> We have to access data from one schema to another. We have created a view for
> this but performance is not good. We tried
> materialized views as well but Refresh MV is creating problem as it puts and
> access exclusive locks.
On Fri, Oct 01, 2021 at 02:24:11PM +0530, aditya desai wrote:
> Hi Laurenz,
> Please find attached explain query plan and query.
Can you show us \d of the table, and exact query you ran?
Also, please, don't send images. This is text, so you can copy-paste it
directly into mail.
Or, put it on som
