| From: | Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com> |
|---|---|
| To: | ambilalmca <ambilalmca(at)gmail(dot)com> |
| Cc: | PostgreSQL General Discussion Forum <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to know server status variable in postgresql? |
| Date: | 2014-01-11 13:43:25 |
| Message-ID: | CADp-Sm6-O7dWM-BQ-tUL7c5sstK7LVf=Ppf=hi_TgW59pC7wuw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jan 10, 2014 at 2:57 PM, ambilalmca <ambilalmca(at)gmail(dot)com> wrote:
> @ sameer khan,
That's Sameer Kumar :-)
> i got query for all except
> *Number of cached blocks read,
>
check pg_stat_all_tables
> Number of cached index blocks read,
check pg_stat_all_indexes
> Number of cached sequence blocks read*.
>
Why do you need this info?
> can you tell query for these three counters only?
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/How-to-know-server-status-variable-in-postgresql-tp5785677p5786228.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2014-01-11 14:43:16 | Re: pg_upgrade & tablespaces |
| Previous Message | Seref Arikan | 2014-01-11 12:06:40 | Do you have any best practices for managing large file's metadata with postgres? |