Skip to content

Instantly share code, notes, and snippets.

@rajivharlalka
Last active May 27, 2024 04:13
Show Gist options
  • Save rajivharlalka/f9a54c95eeafeef58734e2006f957fed to your computer and use it in GitHub Desktop.
Save rajivharlalka/f9a54c95eeafeef58734e2006f957fed to your computer and use it in GitHub Desktop.
GSoC'23 Work Progress - pg_statviz - Rajiv Harlalka
- https://www.depesz.com/2015/02/21/i-have-postgresql-loaded-some-data-and-have-app-using-it-now-what/
https://www.depesz.com/2010/02/26/installing-postgresql/
- https://pgexercises.com/questions/basic/classify.html
- https://www.youtube.com/watch?v=7wuDJxpU7Fo - FDW

Reading

Read

  • Mastering PostgreSQL 15: Build, administer, and maintain database applications efficiently with PostgreSQL 15

    • Hans-Jürgen Schönig
  • PostgreSQL Administration Cookbook - Great Book for simple recepies on different sub-topics.

    • Simon Riggs, Gianni Ciolli
- https://doxygen.postgresql.org/index.html
- https://git.postgresql.org/cgit

Runtime Statistics

Other

Scripts

Partitioning

Proposals made

  • number of concurrent users : pg_stat_activity with backend_type='client backend'

  • Locks Granted per type of lock: pg_stat_activity

  • pg_stat_statements creating temp tables (Doubt on how this should be monitored though)

  • Multiple postgresql.conf settings such as work_mem, max_wal_size etc . would help in understanding things after configs are reloaded.

  • pg_stat_user_tables and pg_stat_user_indexes for sizes , *_hit, *_miss and other stats.

  • version info to tell about version bumps.

  • uptime from select current_timestamp - pg_postmaster_start_time()

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment