PostgreSQL Dependency tree

Hi community! I need to understand the dependency tree in my DB. The order of INSERT into each table based on FKs. I know there is the pg-depend catalog , but I figured before spending some time writting the SQL statement, I would as

Re: Is there any good optimization solution to improve the query efficiency?

I'm happy to help. Looking the explanation the first with on t_res goes in parallel full table scan... this is an issue. Should be present an index on the temporale period (I'm just looking for the same problem) Il giorno mar 6 giu 2023 alle ore 10:33 gzh ha scritto: > I made some slight changes

Re: vacuum to prevent wraparound

On Tue, 2023-06-06 at 11:36 -0300, Marcos Pegoraro wrote: > I have a replica server using Postgres 14.4. > Replica is done using Publication/Subscription and I have triggers for > auditing, > so every record which comes from production is audited. > Some months ago I changed the way I was auditing

Re: No prompt for setting up a master password

On 6/6/23 03:55, Stephanie Goulet wrote: Hi all, Hope you're well. I'm a new user and was trying to set pgAdmin up for the first time. All of the instructions and tutorials and other resources I can find outline how there should be a prompt for setting up a master password when you first open

vacuum to prevent wraparound

I have a replica server using Postgres 14.4. Replica is done using Publication/Subscription and I have triggers for auditing, so every record which comes from production is audited. Some months ago I changed the way I was auditing and replaced that audit table for a new one, but didn't remove the o

Re: Drivers users by connections

> On 06/06/2023 09:18 CEST Hrishikesh (Richie) Rode wrote: > > We are not able to find table which give session connection details about > drivers. In pg_stat_activity details information is not there. Please let us > know where we can find these information. Column pg_stat_activity.application_n

No prompt for setting up a master password

Hi all, Hope you're well. I'm a new user and was trying to set pgAdmin up for the first time. All of the instructions and tutorials and other resources I can find outline how there should be a prompt for setting up a master password when you first open. This did not appear for me. I tried deleting

Drivers users by connections

Hello We are not able to find table which give session connection details about drivers. In pg_stat_activity details information is not there. Please let us know where we can find these information. Please help me to get this information. Thanks Richie- In Oracle and Mysql we use below sql t

Re: Is there any good optimization solution to improve the query efficiency?

I made some slight changes to the SQL you provided, but the optimization approach remained the same. I was surprised that the results were retrieved in less than one second. It's really impressive! Below is the execution plan. Thank you very much for providing the optimization method, I learn