public.vwrealtimemonitorqueueobsmedia

Description

Table Definition

CREATE VIEW vwrealtimemonitorqueueobsmedia AS (
 SELECT replace((realtimeadaptermonitordata.keyid)::text, 'QueueObsService:media:'::text, ''::text) AS media,
    realtimeadaptermonitordata.servicename,
    realtimeadaptermonitordata.status,
    realtimeadaptermonitordata.isrunning,
    realtimeadaptermonitordata.eventsprocessed,
    realtimeadaptermonitordata.errorcount,
    realtimeadaptermonitordata.activeconnections,
    realtimeadaptermonitordata.totalwebsockets,
    realtimeadaptermonitordata.activeconversations,
    realtimeadaptermonitordata.staleconversationcount,
    realtimeadaptermonitordata.oldeststaleconversationageseconds,
    ((realtimeadaptermonitordata.oldeststaleconversationageseconds)::numeric / 60.0) AS oldeststaleconversationageminutes,
    realtimeadaptermonitordata.healthpercentage,
    realtimeadaptermonitordata.acwpendingcount,
    realtimeadaptermonitordata.staleacwcount,
    realtimeadaptermonitordata.lastactivityutc,
    realtimeadaptermonitordata.lastconversationnotificationutc,
    realtimeadaptermonitordata.lastconversationhealthcheckutc,
    realtimeadaptermonitordata.lastconversationverifiedactiveutc,
    realtimeadaptermonitordata.updated,
        CASE
            WHEN (realtimeadaptermonitordata.updated IS NULL) THEN NULL::integer
            ELSE GREATEST(0, (floor(EXTRACT(epoch FROM (timezone('utc'::text, now()) - realtimeadaptermonitordata.updated))))::integer)
        END AS monitorrowageseconds,
    (realtimeadaptermonitordata.staleconversationcount > 0) AS hasstaleconversations,
    realtimeadaptermonitordata.notes
   FROM realtimeadaptermonitordata
  WHERE ((realtimeadaptermonitordata.keyid)::text ~~ 'QueueObsService:media:%'::text)
)

Columns

Name	Type	Nullable
media	text	true
servicename	varchar(100)	true
status	varchar(50)	true
isrunning	boolean	true
eventsprocessed	bigint	true
errorcount	bigint	true
activeconnections	integer	true
totalwebsockets	integer	true
activeconversations	integer	true
staleconversationcount	integer	true
oldeststaleconversationageseconds	integer	true
oldeststaleconversationageminutes	numeric	true
healthpercentage	numeric(5,2)	true
acwpendingcount	integer	true
staleacwcount	integer	true
lastactivityutc	timestamp without time zone	true
lastconversationnotificationutc	timestamp without time zone	true
lastconversationhealthcheckutc	timestamp without time zone	true
lastconversationverifiedactiveutc	timestamp without time zone	true
updated	timestamp without time zone	true
monitorrowageseconds	integer	true
hasstaleconversations	boolean	true
notes	varchar(400)	true

Referenced Tables

Name	Columns	Comment	Type
timezone	0
public.realtimeadaptermonitordata	20		BASE TABLE