Details on a specific process

[gleu]

It would be nice to bet able to get a detailed window on a specific process. It would give the same informations that we would already have on the summary window (database name, user name, CPU%, IO%, etc), but it could give more details such as how many workers for the query. If it is a command with a progress view, show the content of the progress view. It could also show the locks it has, and the PID that might be waiting for it to complete.

[blogh]

Hi thanks for the post, I like the idea.

[gleu]

Thank you. It would also allow the display of metrics available in pg_stat_statements if a statement with the same queryid is available on this view. And perhaps in the future, it would allow to show the query plan being executed (Yeah, such a big dream :) ).