Jobin Augustine

Unfortunately, PostgreSQL 17 removed the functions like `pg_stat_get_buf_written_backend()` This makes the task more difficult. A commit https://github.com/jobinau/pg_gather/commit/c750d2955e411c400f10f2316361976da711d6c1 could be temporary fix for data collection and importing. However, analysis and report...

`pg_stat_get_checkpointer_buffers_written()` returns the number of buffers written by the **checkpointer**. (It is already part of commit https://github.com/jobinau/pg_gather/commit/c750d2955e411c400f10f2316361976da711d6c1) `pg_stat_get_buf_written_backend()` is different. It is the buffers written by individual **client backends**, which...

The analysis / Report part is modified to have PG 17 compatibility https://github.com/jobinau/pg_gather/commit/9b7fc52c2ff9f437b4930bef497b2acc3624c926 If everything goes well, this will be part of release 27

Thank you @psvampa for this feature request. Since we already capture OID in pg_gather its a matter of placing it in the report.

This is becoming a pressing need for those multi-database environments

Table OID is now part of the pop window on mouseover on the table name. part of commit: https://github.com/jobinau/pg_gather/commit/d035733f64d5a0dd2daddb951f58707367f1c908 Testing so far is good. Planning to include this in Release...

One feasible solution is to hold the rendering until the DOM is fully ready with all modifications to highlight the analysis. Wait for all jquery action on the elements.

The delayed rendering patches are pushed to dev templates commit : 5cca672105ba1b015c79c064e9f32888b2e7c386 Currently under testing. Showing considerable performance gains and much less CPU utilization. Planning to merge with the main...

Hi @fernandorb10 and @lelutin, Thank you for reporting this. Even though the data collection from PostgreSQL 10 onwards is supported, The analysis and report generation from the collected (which generally...

Thank you @lelutin for the valuable suggestion. The README is updated. https://github.com/jobinau/pg_gather/commit/eaf34c45b78958c630c0bdeb912c411095180609