I am Jianhui Lu, a student participating in GSoC 2021, and my project is 'add monitoring to pg_stat_statements to pg_systat'. And following is a summary of the work I have done during the past 10 weeks.
The first part is about adding new features to pg_systat. The first and most important feature is adding monitoring of pg_stat_statement. It enables pg_systat to show statistics about query execution. The second feature is adding monitoring of pg_stat_progress_copy. It's a new feature in pg14. And the third feature is monitoring of pg_buffercache which tracks the data in the shared buffer cache.
The second part is about compatibility. Since pg_stat_progress_copy is a new feature in pg14, we won't show this view when we connect to an older version. And pg_stat_statements added new columns in pg13 and changed some column names, the new columns also won't show in the older version.
The third part of my work is about documentation. I made an asciinema video to show how to use pg_systat. And in the right pane, I have shown the corresponding table in postgreSQL. So users will know the relationship between pg_systat and in the database. Last but not least, I rewrote the readme using rst and added more information including basic introduction and homepage.
Here are links to my commit [1] and asciinema video[2].
It's really a wonderful experience to work with the community!
