Hi Tom Lane, I'm glad that I got a reply from you. And yes you are exactly correct. I am looking for the time that shutdown begins. I fulfilled my requirement by adding a piece of code before the initiation of shutdown in the postgresql service file located in /etc/init.d folder of my ubuntu server. It works perfectly fine and the sample output is shown as below: reported | shutdown_time | startup_time ---------------------------------+--------------------------+---------------------------------- 2018-06-05 12:15:00.63332 | /2018-06-05 12:15:00/ | 2018-06-05 12:09:57.625046+05:30 | | 2018-06-05 12:15:05.28899+05:30 In my view this work meets my requirement. Kindly suggest if it appropriate to do like this. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html