Re: pg_stat_activity

Ron <ronljohnsonjr@xxxxxxxxx> · Mon, 11 Jun 2018 11:12:28 -0500



    On 06/11/2018 10:21 AM, David G. Johnston wrote:

    
        On Mon, Jun 11, 2018 at
            8:07 AM, Ron <ronljohnsonjr@xxxxxxxxx> wrote:

        
               That won't work,
                because that would catch any query on a table which
                happens to have the string "select" in a table, index or
                column name.
            
            
            I don't
              believe what you are asking is possible using only
              pg_stat_activity.  One thought that comes to mind is to
              identify, via pg_locks, sessions that hold non-read-only
              locks and then exclude the rows in pg_stat_activity that
              match up with those sessions.
            

            David J.
            
          
    Thanks.  I'll try that.

    
    -- 

      Angular momentum makes the world go 'round.