Introduction to Live360° feature

Want to have a complete real-time view of the behavior of your PostgreSQL instances?

Datasentinel introduces a new feature which will be a precious help during your performance analyzes or troubleshooting sessions

This article aims to describe the main elements of Live360° feature.
You will thus have a good overview of the possibilities offered by this new module.

Live360° Functions

Current sessions

---

• View backends by database or globally with the possibility of filtering on active sessions

• For each session, locks and blocking sessions display

• Status of each active session: is it currently consuming CPU, waiting for IOs, writing WAL, waiting on lock, etc …?

• Ability to terminate a backend (requires the read write privilege for the Datasentinel user)

• And of course the query being executed, its start time and duration

Blocking sessions

---

• Immediate visualization of blocking backends as well as blocked backends with time spent waiting and queries

• Ability also to terminate a backend (requires the read write privilege for the Datasentinel user)

Explorer

---

Explore precisely the properties and statistics of relations, by database and schema

• Relations of type Table, Index, Foreign Table, Materialized View, View, Extension, Extended Statistics, Function / Proc, Sequence, TOAST are implemented

• VACUUM informations (live tuples, dead tuples, Frozen xid, last date)

• Table statistics as well as their partitions, indexes, extended statistics, …

• Column statistics : NULL values, distinct values, average width, …

• But also the disk usage, the description of the views, materialized views, …

So much information used by the PostgreSQL planner / optimizer to determine an execution plan

Execution plans

---

Dynamically generate an execution plan for any query

• Finely analyze each step with our integrated viewer

• Also possible to display the plan in text or json format

• ANALYZE option (SELECT query only) ensuring the execution of a query in order to have the overall execution time and of each step

In Progress reporting

---

View the progress of some operations monitored by PostgreSQL since version 9.6

• VACUUM

• CREATE INDEX, CLUSTER, VACUUM FULL since version 12

• ANALYZE since version 13

Disk and memory usage

---

Explore in detail the space used by relations in your databases

• Disk usage of tables, partitions, indexes, TOAST tables organized by database, schema, tablespace or relation name

• Top-down views allowing to visualize in detail the space used

• Ability to analyze the distribution of your data cache thanks to the pg_buffercache extension if present

Documentation et Video

---

View all the documentation Live360° as well as a video available on our channel Youtube

Conclusion

---

The Live360° feature allows a complete real-time view of the behavior of your PostgreSQL instances, through a direct connection, providing precision and additional informations on the context, which will offer you valuable and indispensable help during your performance or troubleshooting analyzes

Datasentinel unique features and the simplexity of its GUI allow a quick start to easily and precisely analyze the workload of your Postgres instances

---

Stay connected!