Hi all, is there any provision in Postgresql to know

Question

Hi all, is there any provision in Postgresql to know

the number of transactions in all tables in a database for a particular time. Means can we check how many insert/update/delete/select queries executed in each table in a database for a specific time period?

#programming #russian

0

29.10.2024

8 ответов

3 просмотра

बैरागी Автор вопроса

Kirk
No. For one, deletes can/will be removed by vacuu...

Ok. But there must me something to check the excess load on the database for a particular time period

0

7 дней назад

Stefanie Janine Stölting

बैरागी
Ok. But there must me something to check the exces...

That is called monitoring and should throw alarms. And to observe statistics over a longer period you could use an extension called https://github.com/vyruss/pg_statviz You'd need pg_stat_activity enabled. Also https://github.com/darold/pgbadger is a good tool. Also auto_explain should be used to get explain from slow queries.

0

7 дней назад

बैरागी Автор вопроса

Stefanie Janine Stölting
That is called monitoring and should throw alarms....

Pgbadger as I know logs the query response time. But I want to check the total transaction like insert update select in all tables of a database for a specific period for ex 1 hour.

0

7 дней назад

Stefanie Janine Stölting

बैरागी
Pgbadger as I know logs the query response time. B...

Write your own stuff or give someone money to slow down your database. That's logging every single statement with all availability transaction information.

0

7 дней назад

Milos Eskert

बैरागी
Ok. But there must me something to check the exces...

I would look at this from a different perspective: what do You consider an exess load on Your database? Usually, when We look at the data We can see that something isn’t right, presuming We know how data should look and grow. Just trying to find txcount doesn’t make much practical sense unless something is not behaving as it should. It is very hard for people here to give advice on such a broad topic.

0

7 дней назад

बैरागी Автор вопроса

Milos Eskert
I would look at this from a different perspective:...

I just wanted to know how we can check the number of inserts, update, and select query has been executed in 1 hour in a database?

0

7 дней назад

Stefanie Janine Stölting

बैरागी
I just wanted to know how we can check the number ...

You can do snapshots of pg_stat_statement with a cron job every hour, that thing has a counter for each query.

0

7 дней назад

Kirk · Accepted Answer

No. For one, deletes can/will be removed by vacuum statements. On the other hand, you can turn on the track_commit_timestamp feature (GUC). This will let you associate a timestamp to a specific commit. We use this in development. So that we can review EVERY OBJECT that changed (views, Procs, etc) over a period of time. It won't tell me HOW MANY times I saved that view. Or how many views I dropped (or even about Dropped Views). It's the closest concept I can think of.

169 похожих чатов

Hi all, is there any provision in Postgresql to know

8 ответов

Похожие вопросы