Site icon Database Tutorials

PostgreSQL up-time

 

There are countless ways of understanding how long PostgreSQL has been turned on.

In this article we will talk about 3 methods.

 

1)Using SQL:

 

2)From Service Definitions:

Firstly, we look at the status of the service with the following query.

 

3) Using PID:

First we take the PID of the PostgreSQL master process.

 

That’s 485. Then we look at when the process begins. There are various ways of doing this. One of these;

Exit mobile version