Postgresql_extensible plugin Telegraf

1

Postgresql_extensible plugin uses postgre Statistics Collector to get results about the postgredb.

However, I am finding it hard to understand the metrics about my database collected by this.

here have a look,

 postgres=# select tup_inserted, tup_fetched from pg_stat_database;
 tup_inserted | tup_fetched 
--------------+-------------
            0 |           0
            0 |           0
            0 |      425511
            0 |      407918
            0 |           0
         1011 |      413373
          324 |      360500
         1167 |      345411
         1139 |      346655
          787 |      342410
         1049 |      328089
            0 |      204959
         1646 |      231987
          892 |      205624
           41 |       66538
            0 |       41609
          838 |     2591785
(17 rows)

This is a query run on one of the views provided by the Statistics collector of Postgresql.

But these numbers are ridiculous. Even I sum all of my rows in my databases, they will never sum to these, and also I have not used my postgresql in weeks, which directly means it is giving me old data.

please explain these numbers to me.

Also, in what way I can get live data about my database ?
I want the queries/second , clients connected, used memory, database number and other live data necessary. Is there a plugin OR any other tool for this ?

2

@Luv This is a question about Postgres statistics. I think you might have better luck asking that elsewhere.