Recent Releases of https://github.com/awslabs/pg-collector
https://github.com/awslabs/pg-collector - pg collector V1 for PostgreSQL 17
1- V1 version created from pg-collector-for-postgresQL-16 branch.
2- Change the supported postgresql version from 16 to 17
3- Fix "ERROR: column p.max_dead_tuples does not exist" and "ERROR: column p.num_dead_tuples does not exist" by changing the columns "max_dead_tuples" and "num_dead_tuples" to the newly introduced columns "max_dead_tuple_bytes" and "dead_tuple_bytes" : https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=667e65aac354975c6f8090c6146fceb8d7b762d6
4- Added new columns "total_indexes_to_vacuum" and "total_indexes_processed" to "vacuum progress process" table.
5- Added new columns to "Top SQL order by shared blocks read (physical reads)" table
"shared_blocks_hits"
"shared_blocks_read_time_sec"
- HTML
Published by mmohali over 1 year ago
https://github.com/awslabs/pg-collector - pg collector V1.2 for PostgreSQL 16
1- Add a new section for Amazon Aurora Limitless Database. 2- Starting from this version, the pg collector will not include Amazon Aurora PostgreSQL or Amazon Aurora Limitless Database sections automatically in the pg collector report if the instance is not an Amazon Aurora.
- HTML
Published by mmohali over 1 year ago
https://github.com/awslabs/pg-collector - pg collector V1.1 for PostgreSQL 16
1- The script should display the message "Report Generated Successfully" upon successful completion and relocate the report file name and location information to the end of the script..
2- Add a new section for Amazon Aurora PostgreSQL.
3- Add a new section for Invalid databases.
4- Implement a check for the pg_stat_statements extension. If the extension is not installed, the script should print the message "pg_stat_statements extension is not installed" in the report, instead of displaying the errors "ERROR: relation "pg_stat_statements_info" does not exist" or "ERROR: relation "pg_stat_statements" does not exist".
5- Add a new section "List of role grants" under "Users & Roles Info".
- HTML
Published by mmohali over 1 year ago
https://github.com/awslabs/pg-collector - pg collector V1.1 for PostgreSQL 15
1- The script should display the message "Report Generated Successfully" upon successful completion and relocate the report file name and location information to the end of the script..
2- Add a new section for Amazon Aurora PostgreSQL.
3- Add a new section for Invalid databases.
4- Implement a check for the pg_stat_statements extension. If the extension is not installed, the script should print the message "pg_stat_statements extension is not installed" in the report, instead of displaying the errors "ERROR: relation "pg_stat_statements_info" does not exist" or "ERROR: relation "pg_stat_statements" does not exist".
- HTML
Published by mmohali over 1 year ago
https://github.com/awslabs/pg-collector - pg collector V1.3 for PostgreSQL 14
1- The script should display the message "Report Generated Successfully" upon successful completion and relocate the report file name and location information to the end of the script..
2- Add a new section for Amazon Aurora PostgreSQL.
3- Add a new section for Invalid databases.
4- Implement a check for the pg_stat_statements extension. If the extension is not installed, the script should print the message "pg_stat_statements extension is not installed" in the report, instead of displaying the errors "ERROR: relation "pg_stat_statements_info" does not exist" or "ERROR: relation "pg_stat_statements" does not exist".
- HTML
Published by mmohali over 1 year ago
https://github.com/awslabs/pg-collector - pg collector V1.3 for PostgreSQL 13
1- The script should display the message "Report Generated Successfully" upon successful completion and relocate the report file name and location information to the end of the script..
2- Add a new section for Amazon Aurora PostgreSQL.
3- Add a new section for Invalid databases.
4- Implement a check for the pg_stat_statements extension. If the extension is not installed, the script should print the message "pg_stat_statements extension is not installed" in the report, instead of displaying the errors "ERROR: relation "pg_stat_statements_info" does not exist" or "ERROR: relation "pg_stat_statements" does not exist".
- HTML
Published by mmohali over 1 year ago
https://github.com/awslabs/pg-collector - PG Collector v3.1 for PostgreSQL 12 and older versions
``` 1- The script should display the message "Report Generated Successfully" upon successful completion and relocate the report file name and location information to the end of the script.. 2- Add a new section for Amazon Aurora PostgreSQL. 3- Add a new section for Invalid databases. 4- Implement a check for the pgstatstatements extension. If the extension is not installed, the script should print the message "pgstatstatements extension is not installed" in the report, instead of displaying the errors "ERROR: relation "pgstatstatementsinfo" does not exist" or "ERROR: relation "pgstat_statements" does not exist".
```
- HTML
Published by mmohali over 1 year ago
https://github.com/awslabs/pg-collector - pg collector V1 for PostgreSQL 16
1- V1 version Created from pg-collector-for-postgresQL-15 branch.
2- Change the supported postgresql version from 15 to 16.
3- Add reserved_connections parameter to Reserved connections settings.
- HTML
Published by mmohali almost 2 years ago
https://github.com/awslabs/pg-collector - pg collector V1 for PostgreSQL 15
1- V1 version Created from pg-collector-for-postgresQL-14 branch
2- Change the supported postgresql version from 14 to 15
3- Fix "104: ERROR: column "datlastsysoid" does not exist " by doing "select * from pg_database;" to show all columns in pg_database view without showing specific columns
- HTML
Published by mmohali almost 2 years ago
https://github.com/awslabs/pg-collector - pg collector V1.2 for PostgreSQL 14
1- Enhance the where condition in the following sections “current running vacuum process“and ”current running autovacuum process“.
2- Fix typos, Thanks to Vikas Gupta for highlighting them .
3- Upade percent_towards_wraparound's query with 2^31-3000000 as in 14 the wraparound safety margin increased from 1 million to 3 million.
4- Add reserved connections parameters info to the Connections Info section .
5- Add DB/username/status/Connections count to the Connections Info section .
6- Add objects list and count in each schema to the schema info section .
7- Update the Toast Tables Mapping's sql to order the toast by the size and add note about toast OID wraparound
- HTML
Published by mmohali almost 2 years ago
https://github.com/awslabs/pg-collector - pg collector V1.2 for PostgreSQL 13
1- Enhance the where condition in the following sections “current running vacuum process“and ”current running autovacuum process“.
2- Fix typos, Thanks to Vikas Gupta for highlighting them .
3- Upade percent_towards_wraparound's query with 2^31-1000000 .
4- Add reserved connections parameters info to the Connections Info section .
5- Add DB/username/status/Connections count to the Connections Info section .
6- Add objects list and count in each schema to the schema info section .
7- Update the Toast Tables Mapping's sql to order the toast by the size and add note about toast OID wraparound
- HTML
Published by mmohali almost 2 years ago
https://github.com/awslabs/pg-collector - PG Collector v3 for PostgreSQL 12 and older versions
1- Enhance the where condition in the following sections “current running vacuum process“and ”current running autovacuum process“.
2- Fix typos, Thanks to Vikas Gupta for highlighting them .
3- Upade percent_towards_wraparound's query with 2^31-1000000 .
4- Add reserved connections parameters info to the Connections Info section .
5- Add DB/username/status/Connections count to the Connections Info section .
6- Add objects list and count in each schema to the schema info section .
7- Update the Toast Tables Mapping's sql to order the toast by the size and add note about toast OID wraparound.
- HTML
Published by mmohali almost 2 years ago
https://github.com/awslabs/pg-collector - pg collector V1.1 for PostgreSQL 14
1- Add new section for COPY command progress 2- Add pgstatstatementsinfo View to pgstatstatementsextension section 3- Add vacuumfailsafeage and vacuummultixactfailsafeage parameters to vacuum and Statistics section 4- Add pgstatwal veiw to DB load section inder pgstat* views 5- Add pgstatreplicationslots View to Replication section 6- Add logicaldecodingworkmem parameter to Replication Parameters 7- Add ninssincevacuum and ntupins columns to pgstatalltables's queries in vacuum and Statistics section 8- Add Sessions statistics ( sessiontime,activetime,idleintransactiontime,sessions,sessionsabandoned,sessionsfatal,sessions_killed ) to Sessions/Connections Info section 9- Add Replication Slot wal status to Replication section
- HTML
Published by mmohali almost 4 years ago
https://github.com/awslabs/pg-collector - pg collector V1.1 for PostgreSQL 13
1- Add logicaldecodingwork_mem parameter to Replication Parameters 2- Add Replication Slot wal status to Replication section
- HTML
Published by mmohali almost 4 years ago
https://github.com/awslabs/pg-collector - pg collector V1 for PostgreSQL 14
1- V1 version Created from pg-collector-for-postgresQL-13 branch 2- Change the supported postgresql version from 13 to 14
- HTML
Published by mmohali almost 4 years ago
https://github.com/awslabs/pg-collector - pg collector V1 for PostgreSQL 13
1- V1 version Created from the main branch 2- fix for https://github.com/awslabs/pg-collector/issues/2 and https://github.com/awslabs/pg-collector/issues/4
following pgstatstatements columns renamed: totaltime → totalexectime mintime → minexectime maxtime → maxexectime meantime → meanexectime stddevtime →s tddevexec_time
- HTML
Published by mmohali almost 4 years ago
https://github.com/awslabs/pg-collector - PG Collector v2.9 for PostgreSQL 12 and older versions
1- Add HTML <details> Tag to each section so the user can open and close it on demand, it is closed by By default , this will help make the report more readable and Easy to navigate when the DB have a lot of objects.
2- Add new section for Functions statistics .
3- Change active session monitor section name to session/connection info and add more information .
4- Fix link issue (FKwithoutindex) .
5- Add logtempfiles to Temp tables section .
6- Add tempbuffers to Memory setting section .
7- Enhance the following sections (tables without auto vacuum , tables without auto analyze , tables without auto analyze, auto vacuum, vacuum and analyze) .
8- Change Replicationslot section name to Replication and add Replication slot lag and Replication Parameters .
9- PG collector will be able to detect and report the PG server type and the database Role .
Note: Thanks to Jeremy Schneider as he the author of this part of the code .
PG server type :
RDS PG = RDS- < PGVersion >
Aurora PG = Aurora- < PGVersion > - < AuroraVersion >
PostgreSQL Community = PG- < PGVersion >
Database Role : Primary/writer DB (Read write) Standby/Reader DB (Read Only) 10- Add new section for DB Load (wait events stats,Locks ,pgstat* views) 11- Add new section for Triggers . 12- Add new section for pg_config . 13- Enhancement suggestions for pg-collector https://github.com/awslabs/pg-collector/issues/1 requested by thottr@
13-1. Add queryid to the pg_stat_statements's queries ( pg_stat_statements extension section)
13-2. Add Top SQL order by shared blocks read (physical reads) ( pg_stat_statements extension section)
13-3. Add Top 50 Tables by total physical reads and total physical reads percent to Table Access Profile section
13-4. Add Top 50 indexes by physical reads and physical reads percent to Index Access Profile section
- HTML
Published by mmohali almost 5 years ago
https://github.com/awslabs/pg-collector -
Add new section for ssl and Background processes
- HTML
Published by mmohali over 5 years ago