Auteur/autrice : admin
-
[Postgres] Monitor autovacuum_freeze_max_age
This query allows you to monitor the : autovacuum_freeze_max_age SELECT datname, round(age(datfrozenxid)/to_number(current_setting(‘autovacuum_freeze_max_age’),’999999999′)*100,1) as Percent FROM pg_database where datname != ‘template0’;
-
[Postgres] Monitor wait event
tselect wait_event_type, wait_event from pg_stat_activity where pid !=pg_backend_pid();watch 0.5
-
[Postgres] Solve PostgreSQL DataFileRead and buffer_io with Parameter Tuning
Click her to see the next. Solve PostgreSQL DataFileRead and buffer_io with Parameter Tuning | by monika yadav | Medium This is an epic case study to solve DataFileRead and […]
-
[Postgres] Tuto tuning
This site helped to resolve IPC wait event : Postgres checkpoint tuning | Tembo Docs You have to adapt the checkpoint_timeout within the max_wal_size. If the max_wal_size is 8Go then […]
-
[Postgres] Identifier les privilèges
SELECT * FROM information_schema.role_table_grants WHERE grantee = ‘<role_name>’;
-
[Postgres] Identifier les attentes
This query allows you to identify the wait events on which query . How to Find and Stop Running Queries on PostgreSQL Find a query with his pid. This query […]
-
[Postgres] PG_PARTMAN
pg_partman v4 vs pg_partman v5 Une fonction diffère. Conséquence la version 5 va gérer nativement la rotation des partitions et pas la 4 voici la fonction : create function check_partition_type(p_type […]
-
[Postgres] Extensions
Extensions en prd indispensables : shared_preload_libraries = ‘anon,datasentinel,pgaudit,pg_cron,pglogical,pg_store_plans,system_stats,pg_stat_statements,pg_buffercache’
-
[Postgres] Monitor cloud DB (AZURE / IBM)
Quand on n’a pas d’outils pour faire le monitoring des bases PostgreSQL hébergées dans le cloud (IBM ou AZURE…) voici quelques requêtes , vue, fonction SQl utiles pour interroger la […]