Postgres Pro
Downloads
Home   >   mailing lists

Comfortably check BackendPID with psql - Mailing list pgsql-hackers

From Naoya Anzai
Subject Comfortably check BackendPID with psql
Date
Msg-id 116262CF971C844FB6E793F8809B51C6E99D48@BPXM02GP.gisp.nec.co.jp
Whole thread Raw
Responses Re: Comfortably check BackendPID with psql  (Marko Tiikkaja <marko@joh.to>)
Re: Comfortably check BackendPID with psql  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
Hi, hackers!

This is a so tiny patch but I think it is very useful for hackers and DBAs.
When we debug with psql, we frequently use "SELECT pg_backend_pid();".
This can change the input of the 24 characters to the only 4 characters!

Image.
----------------------
naoya=# \bid
Backend Process ID
 pid
------
 1716
(1 row)
-----------------------

How do you like it?

Regards,

Naoya

---
Naoya Anzai
Engineering Department
NEC Solution Inovetors, Ltd.
E-Mail: nao-anzai@xc.jp.nec.com
---
Attachment

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Entities created in one query not available in another in extended protocol
Next
From: Marko Tiikkaja
Date:
Subject: Re: Comfortably check BackendPID with psql