Rafia Sabih <rafia.sa...@enterprisedb.com> writes: > Approach: > A token for query string is created in the shared memory, this token is > populated with the query string using the global string -- > debug_query_string. Now, for each of the worker when > ExecGetParallelQueryDesc is called, we retrieve the query text from shared > memory and pass it to CreateQueryDesc.
This is simply wrong, because debug_query_string need have nothing to do with what the actual parallel query is. I'm all for sending over the correct query, but if you aren't bothering to accurately reproduce the master's query descriptor, I think you will increase confusion not reduce it. As far as reproducing the pg_stat_activity query goes, you could probably grab that string out of the master backend's pgstat entry and pass it over at parallel query start. But please don't confuse it with either debug_query_string or the string referenced by the QueryDesc; I do not think there's any guarantee that those are the same. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers