Re: Stadisticas - Mailing list pgsql-www
| From | Enrique Escobar |
|---|---|
| Subject | Re: Stadisticas |
| Date | |
| Msg-id | SNT153-DS96514B1C066F3DE12ADFF8D710@phx.gbl Whole thread Raw |
| In response to | Re: Stadisticas ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Responses |
Re: Stadisticas
("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Stadisticas (Justin Clift <justin@postgresql.org>) |
| List | pgsql-www |
Sorry.. (Language Error)....
Hello
I am seeking a way to measure the load by day of my bases. What I need is. (Sum of total requests to the server)
Example
1. insertion request and not inserted because x reason example duplicate record. ( 1 )
2. Consultation registration. ( 2 ).
3. Request insertion and inserts to the base (3)
4. Deleting registration (4)
Total would 4 requests. I was reading the following link.
http://www.postgresql.org/docs/current/interactive/monitoring-stats.html
http://www.postgresql.org/docs/current/interactive/runtime-config-statistics.html
and I have not managed to find a way to have a stadistica of requests to the server, someone else to do?
Gracias
Enrique Escobar
De: pgsql-www-owner@postgresql.org [mailto:pgsql-www-owner@postgresql.org] En nombre de David G. Johnston
Enviado el: lunes, 09 de mayo de 2016 20:30
Para: Enrique Escobar
CC: Josh berkus; PostgreSQL www
Asunto: Re: [pgsql-www] Stadisticas
2016-05-09 18:20 GMT-07:00 Enrique Escobar <ekurth@live.com.mx>:
Hola Lista.
Ando buscando una forma para medir por dia la carga de mis bases. Lo que deseo hacer es lo siguiente. (suma de peticiones, al server)
Ejemplo
1.- Peticion de inserción y no inserta porque x motivo ejemplo registro duplicado. (seria 1 movimiento)
2.- Consulta de registro. (Seria 2 movimientos).
3.- Peticion de inserción y lo inserta ala base (Seria 3 movimientos)
4.- Borrado de registro (seria 4 movimientos)
En total serian 4 registros, aunque si me voy a los registros solo veria 2 la inserción y el borrado. Estuve leyendo los siguientes link.
http://www.postgresql.org/docs/current/interactive/monitoring-stats.html
http://www.postgresql.org/docs/current/interactive/runtime-config-statistics.html
y no he logrado encontrar una forma para tener una stadistica de cómo hcaerlo, alguien lo a hecho?
Yeah...doing a reply-to-all on an unrelated thread
on an inappropriate list doesn't really endear you to people.
I speak zero Spanish and what Google Translate gives me isn't something I can reliably help with.
You should try the regional list(s).
What I can read says you need to learn how to output data to the log file and process it. For the most part you will need to use external to PostgreSQL tools to do so.
Some of these things seem application oriented and should be generated explicitly via events and not gleaned from transaction logs.
David J.