On Thu, Feb 01, 2024 at 07:37:32AM +0000, ma lz wrote: > session 1: > create temp table ttt ( a int ); > insert into ttt values(3); -- query_id is XXX from > pg_stat_activity > > session 2: > create temp table ttt ( a int ); > insert into ttt values(3); -- query_id is YYY from > pg_stat_activity > > I know temp table has different oid, so query_id is different, is > there a way to use table name for temp table instead of oid?
The CREATE TABLE statements have indeed the same query ID (in 16~), and the inserts have a different one as they touch different schemas and relations. That's quite an old problem, that depends on the RangeVar attached to an InsertStmt. I don't quite see a way to directly handle that except by using a custom implementation in query jumbling for this node and its RangeVar, so there is no "easy" way to tackle that :/ -- Michael
signature.asc
Description: PGP signature
