On Mon, Jun 20, 2005 at 04:18:03PM -0400, Tom Lane wrote: > However, all you could get from ProcArray would be the database in > which the backend is running, and maybe the owning user's ID if we > cared to expend the extra space to store it there. We're certainly > not going to add current_query or any such thing into that array.
You could show the current transaction Id, which is also useful. (Presently there's no way to know even a backend's own TransactionId, and people is suggested to use hacks like insert a row in a table and check its xmin.) Maybe we could add an adittional view, with all the info from ProcArray, which is useful sometimes. Then you could join that to pg_locks, and it would work even if the statistic collector is disabled. -- Alvaro Herrera (<alvherre[a]surnet.cl>) "La felicidad no es maƱana. La felicidad es ahora" ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings