Live360
Datasentinel offers a direct connection feature to PostgreSQL instances, enabling real-time retrieval of information.
Last updated
Datasentinel offers a direct connection feature to PostgreSQL instances, enabling real-time retrieval of information.
Last updated
You have the option to select either a specific database or all databases, allowing you to then filter for active sessions and display the associated queries.
From left to right, the above indicators are
Number of active sessions
Number of connected sessions
Database activity graph : Are the sessions on CPU, Waiting, … ?
Number of currently blocked sessions
By simply clicking on a session, you can delve into its details and gain a comprehensive understanding.
The interface displays both blocking and blocked sessions. You can access further session details by clicking on a specific session.
Opt for your desired database, select the schema, then choose the relation type between
Table
Index
Materialized view
Foreign table
View
Extended Statistics
Extension
Function / Proc
Sequence
TOAT table
Example of displayed elements for a table
Columns statistics
Partitions
Indexes
Constraints
Options
Extended statistics
TOAST
Select your database and generate an execution plan from any query.
You can choose the ANALYZE option to execute the query in order to have its overall and step by step execution time statistics.
The execution plan viewer makes it easy and quick to understand each step.
The output can be text or json
Follow the progress of current operations
ALL
VACUUM
>= 12
CREATE INDEX
CLUSTER
VACUUM FULL
>=13
ANALYZE
>=14
COPY
Disk usage lets you explore the space consumed by relations.
You have the option to either observe the space usage for individual databases or for all of them.
Result can be grouped based on:
relations
schemas
tablespaces
Cache usage lets you explore the space consumed by relations in memory (shared_buffers)
You have the option to either observe the space usage for individual databases or for all of them.