Short version: When I execute one transaction in IntelliJ, the "transactions per second" graph increases by 10 tx/sec - I only expect it to increase by 1.
So, it seems that my understanding of the "transactions per second" graph in PgAdmin is wrong or that PgAdmin is doing something unexpected.
Here is a detailed description of my test and my expectations:
I start PgAdmin, then wait a while to see how many "transactions per second" we have when only PgAdmin is connected (up to max. 3), and then execute a simple test-query 4 times.
This is what I can see in PgAdmin:
- (in the Server Sessions chart) is when I start to execute the test-query. We can see that a new server session is created. This is expected, since IntelliJ will connect to the database.
- (in the "Transactions per second" chart) is the time when I execute my test-query (4 times)
- before I start, we can see that about 3 transactions per second happen sometimes (since only PgAdmin is connected, I guess these are the queries to show the chart-data)
- but when I execute my simple test-query the transactions per second spike up to 14/15 transactions per second: Why is this so high? I'd only expect 1 transaction more than before: so max. 4 in total
Any idea why this is happening?
- Does IntelliJ maybe keep some transactions open while it is connected?
- I can also see this happen when other apps disconnect. Some even have extreme spikes up to 1000 tx/sec.
- maybe it is related to the database? I use postgres-13 with timescale-db 2.7