"SELECT t.oid, typarray FROM pg_type t JOIN pg_namespace ns ON typnamespace = ns.oid WHERE typname = 'hstore'; "

[RohitDhankar]

The PSQL log being recorded using own method psql_liveConn_Status() , shows this query multiple times . Needs to be investigated what this is and why it occurs so frequently - how does it impact performance ?

This is linked to #5 , as its creating PSQL connections - not requested by end user.

"SELECT t.oid, typarray
FROM pg_type t JOIN pg_namespace ns
    ON typnamespace = ns.oid
WHERE typname = 'hstore';
"

screenshot of the csv dumped from own method psql_liveConn_Status() , as seen below -

Issue occurs as per information here - https://code.djangoproject.com/ticket/28334 verbatim quote from issue above - "On each newly created database connection django.contrib.postgresql tries to register hstore type for this connection via connection_created signal and register_hstore function."

PostgreSQL creates a new connection and thus - "register hstore type" , which is the core of the issue .

[RohitDhankar]

Status as on 5th JUNE 19. After checking the CSV dump from own method - psql_liveConn_Status() As seen in screencapture's below this 'hstore' related query has not been seen since - 30th May 19 will need further monitoring , keeping issue open.