Re: On a subscriber, why is last_msg_send_time in pg_stat_subscription sometimes null?

On 8/23/24 12:31, Koen De Groote wrote: Adrian, Thanks for pointing me at the source code. Digging a bit, the view seems to eventually get its data on last msg send time from here: https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/replication/logical/launcher.c;h=c566d5

Re: On a subscriber, why is last_msg_send_time in pg_stat_subscription sometimes null?

Adrian, Thanks for pointing me at the source code. Digging a bit, the view seems to eventually get its data on last msg send time from here: https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/replication/logical/launcher.c;h=c566d50a072b92bd07f4179100275d0d0b1f4c7c;hb=HEAD#l

Re: dead tuple difference between pgstattuple and pg_stat_user_tables

On 8/23/24 09:51, Adrian Klaver wrote: On 8/23/24 09:33, Matthew Tice wrote: On Fri, Aug 23, 2024 at 10:26 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote:     https://www.postgresql.org/docs/current/pgstattuple.html    

Re: dead tuple difference between pgstattuple and pg_stat_user_tables

On 8/23/24 09:33, Matthew Tice wrote: On Fri, Aug 23, 2024 at 10:26 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: https://www.postgresql.org/docs/current/pgstattuple.html pgstattuple_approx(regclass) return

Re: dead tuple difference between pgstattuple and pg_stat_user_tables

On Fri, Aug 23, 2024 at 10:26 AM Adrian Klaver wrote: > On 8/23/24 09:14, Matthew Tice wrote: > > Hi All, > > > > I'm trying to understand why there's a difference between what > > pgstattuple reports and pg_stat_user_tables reports (for the number of > > dead tuples). > > > > As I understand, pg

Re: dead tuple difference between pgstattuple and pg_stat_user_tables

On 8/23/24 09:14, Matthew Tice wrote: Hi All, I'm trying to understand why there's a difference between what pgstattuple reports and pg_stat_user_tables reports (for the number of dead tuples). As I understand, pgstattuple and pgstattuple_approx return the exact number of dead tuples (as no

dead tuple difference between pgstattuple and pg_stat_user_tables

Hi All, I'm trying to understand why there's a difference between what pgstattuple reports and pg_stat_user_tables reports (for the number of dead tuples). As I understand, pgstattuple and pgstattuple_approx return the exact number of dead tuples (as noted in the documentation) and based on an ol

Re: On a subscriber, why is last_msg_send_time in pg_stat_subscription sometimes null?

On 8/23/24 07:33, Koen De Groote wrote: I'm running this query: SELECT subname, received_lsn, latest_end_lsn, last_msg_send_time, last_msg_receipt_time FROM pg_catalog.pg_stat_subscription; And "last_msg_send_time" will sometimes be null. All I can find in the documentation is that this value

Re: Is there a way to translate pg_amop.amopstrategy into a description?

Thanks for the confirmation. And, I'd say that this feature would go under "nice to have" rather than anything more important. Although, it *would *be nice. On Thu, Aug 22, 2024 at 5:42 PM Tom Lane wrote: > Morris de Oryx writes: > > What I'm hoping for is a function like > > get_opt_class_stra

On a subscriber, why is last_msg_send_time in pg_stat_subscription sometimes null?

I'm running this query: SELECT subname, received_lsn, latest_end_lsn, last_msg_send_time, last_msg_receipt_time FROM pg_catalog.pg_stat_subscription; And "last_msg_send_time" will sometimes be null. All I can find in the documentation is that this value represents: "Send time of last message rece

Re: Where is my app installed?

Thanks everyone, the issue was resolved. -- */ArbolOne.ca/* Using Fire Fox and Thunderbird. ArbolOne is composed of students and volunteers dedicated to providing free services to charitable organizations. ArbolOne on Java Development is in progress [ í ]

Re: How to validate restore of backup?

On 2024-08-23 08:13:40 +0200, Peter J. Holzer wrote: > On 2024-08-22 16:09:47 +0500, Muhammad Usman Khan wrote: > > For validation of databases, you can use the following approach > > > > /usr/pgsql-16/bin/pg_dump -d postgres -h localhost -p 5428 | md5sum > > > /var/lib/ > > pgsql/db1.txt > > /us