On Mon, Jun 4, 2012 at 5:07 AM, Laura Passigni <laurapassigni at yahoo.it> wrote:
>
> Hi,
> I found in my server the following query, waiting for more than 1 day.
>
> SELECT * FROM "my_table" WHERE ("my_table"."id" = 2626968981)  FOR UPDATE;
>
> It is not coming form my client, in fact it is from the internal server.
> My_table is a table involved in the slony, so I was wondering if this query is launched by slony process.
> Can someone help me in understanding this?

That doesn't seem like a query that Slony would generate.

If you have set up Slony to use its own user, then you could check
pg_stat_activity, and validate that that query isn't being run as that
user.