query column in pg_stat_statements and pg_stat_activity

[Satalabaha Postgres <satalabaha.postgres@xxxxxxxxx>]

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