Re: How to know transaction count in hour basic
mallikarjun t <[email protected]> Wed, 30 Oct 2019 20:40:10 +0530
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <CAOA8XiVe+oaNcZaFLngbqzq61sVjb=HPTO+xEAbrmmyBSDE=Yg@mail.gmail.com> |
Dear Team, Begin; select version(); commit; This is one transaction committed. In this one query type is select query, I want how many update and insert and delete queries are committed in one hour? That's the concept I want. Kindly help me? Regards, Mallikarjunarao, +91-8142923383. On Wed, Oct 30, 2019 at 8:31 PM Alex Balashov <[email protected]> wrote: > It’s not really a concept one can explain. It’s just a mathematical > operation to determine a rate of change over time. > > — > Sent from mobile, with due apologies for brevity and errors. > > On Oct 30, 2019, at 11:00 AM, mallikarjun t <[email protected]> wrote: > > > Dear Team, > > I can't understand how to accumulate time series gauge? > > Kindly explain. > > Regards, > Mallikarjunarao, > +91-8142923383. > > On Wed, Oct 30, 2019 at 8:20 PM Alex Balashov <[email protected]> > wrote: > >> You would just have to accumulate these values in a time-series gauge, >> right? >> >> — >> Sent from mobile, with due apologies for brevity and errors. >> >> On Oct 30, 2019, at 10:13 AM, mallikarjun t <[email protected]> wrote: >> >> >> Dear Team, >> >> How to check, how many transactions are committed in one hour? >> >> In database level pg_stat_database xact_commit column is there,this is >> giving only count. >> >> How to get count for hour basis and minutes and seconds basis, how many >> transactions are committed? >> >> *How to check?* >> >> *Regards,* >> *Mallikarjunarao,* >> >> *+91-8142923383.* >> >>