Summary of GSoC 2021
Hi Everyone,
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]https://gitlab.com/trafalgar_lu/pg_systat/-/commits/main/ and asciinema video[2]https://asciinema.org/a/427202.
It's really a wonderful experience to work with the community!
Best Regards,
Lu
[1]: https://gitlab.com/trafalgar_lu/pg_systat/-/commits/main/