I've written the below SQL query that joins pg_stat_statements with pg_stat_activity using "queryid" as the join condition. Yet, the results show that pg_stat_statements and pg_stat_activity are reporting two distinct queries for the identical queryid. Can this occur?
select pgss.queryid as "PGSS_QUERYID", pgss.query as "PGSS_QUERY", pgsa.query_id as "PGSA_QUERYID", substring(pgsa.query, 1, 45) as "PGSA_QUERY" from pg_stat_statements pgss join pg_stat_activity pgsa on pgss.queryid = pgsa.query_id and pgss.queryid = '2397681704071010949'; PGSS_QUERYID | PGSS_QUERY | PGSA_QUERYID | PGSA_QUERY ---------------------+------------+---------------------+----------------------------------------------- 2397681704071010949 | BEGIN | 2397681704071010949 | select projectper0_.ENTITY_PERMISSION_SID as 2397681704071010949 | BEGIN | 2397681704071010949 | select projectper0_.ENTITY_PERMISSION_SID as 2397681704071010949 | BEGIN | 2397681704071010949 | select folderperm0_.ENTITY_PERMISSION_SID as 2397681704071010949 | BEGIN | 2397681704071010949 | select folderperm0_.ENTITY_PERMISSION_SID as 2397681704071010949 | BEGIN | 2397681704071010949 | SELECT item_guid, count(item_guid) count FR 2397681704071010949 | BEGIN | 2397681704071010949 | SELECT item_guid, count(item_guid) count FR 2397681704071010949 | BEGIN | 2397681704071010949 | select folderperm0_.ENTITY_PERMISSION_SID as 2397681704071010949 | BEGIN | 2397681704071010949 | select folderperm0_.ENTITY_PERMISSION_SID as 2397681704071010949 | BEGIN | 2397681704071010949 | SELECT distinct ep.role FROM v_project_permis 2397681704071010949 | BEGIN | 2397681704071010949 | SELECT distinct ep.role FROM v_project_permis 2397681704071010949 | BEGIN | 2397681704071010949 | select this_.CONTACT_SID as CONTACT1_362_1_, 2397681704071010949 | BEGIN | 2397681704071010949 | select this_.CONTACT_SID as CONTACT1_362_1_, 2397681704071010949 | BEGIN | 2397681704071010949 | SELECT item_guid,category,root_guid, count(i 2397681704071010949 | BEGIN | 2397681704071010949 | SELECT item_guid,category,root_guid, count(i 2397681704071010949 | BEGIN | 2397681704071010949 | select folderperm0_.ENTITY_PERMISSION_SID as 2397681704071010949 | BEGIN | 2397681704071010949 | select folderperm0_.ENTITY_PERMISSION_SID as 2397681704071010949 | BEGIN | 2397681704071010949 | select folderperm0_.ENTITY_PERMISSION_SID as 2397681704071010949 | BEGIN | 2397681704071010949 | select folderperm0_.ENTITY_PERMISSION_SID as 2397681704071010949 | BEGIN | 2397681704071010949 | select folderperm0_.ENTITY_PERMISSION_SID as Regards, Satalabha