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] and asciinema video[2].

It's really a wonderful experience to work with the community!

Best Regards,

Lu

[1] https://gitlab.com/trafalgar_lu/pg_systat/-/commits/main/

[2] https://asciinema.org/a/427202