Découvrez comment nous avons intégré l'Active Session History (ASH), inspiré par Oracle, dans Datasentinel, notre outil de surveillance PostgreSQL.

Session History (fr)

Home - Grafana

DB workload - Grafana

application
application_name
client_host_name
command_type
database
datacenter
environment
ha_cluster
location
pg_instance
pg_version
pid
provider
query_md5_id
server
user_name
wait_event
wait_event_type

08:50
09:00
09:10
09:20
09:30
09:40
09:50
10:00
10:10
10:20
10:30
10:40
10:50
11:00
11:10
11:20
11:30
0
2.5
5.0
7.5
10.0
12.5
Average Active Sessions

application
application_name
client_host_name
command_type
database
datacenter
environment
ha_cluster
location
pg_instance
pg_version
pid
provider
server
user_name
wait_event
wait_event_type

UPDATE pgbench_tellers SET tbalance = tbalance + $1 WHERE tid = $2
   
  Total:
163.293s
Avg:
0.001s
Calls:
800000
Rows:
800000
48%