Many apologies in advance, but I was not able to find this out myself:
What is the difference between live tuples and tuples inserted in postgres statistics?
There's this post, but it doesn't answer the question:
Representing the number of live [...] rows (tuples) in the table. But what means "live"?
The Postgres documentation doesn't provide answers either:
Number of live rows in table
Number of rows inserted into table
Why do my stats show 213,324,422 inserted tuples, but only 124,510,280 live tuples? (3,087,919 dead tuples)
The PG Admin documentation is also unclear about this. It further says that
Tuples Inserted displays the number of tuples inserted into the database within the last week.
I would like to know the total number of existing entries in my database. Is this live rows or inserted rows?
Cache file /home/queryxchang/public_html/apps/frontend/config/../cache/-q-7-192599-postgres-difference-between-tuples-inserted-and-live-tuples- could not be written