I connect to my postgres database through pgAdmin and run this query below.
SELECT COUNT(*) FROM PICTURES;
I have about 450k rows in the table and the "tuples out" graph above reflects that.
Why does a single select query result in ~10 transactions as seen by transactions per second graph ? According to what I know it should be a single transaction ?