Classified as: {OPEN}
> Assuming clean shutdowns the statistics will survive restarts. They would be
> wiped when you drop a database and start over, have an unclean shutdown or
> you use one of the reset functions...
Yes, stats are permanent, but are not being updated.
We don't use any of the pg_stat_reset functions.
-------------------------------------
I've left the system alone over the weekend.
Here's the timeline:
14th May:
Postgres working ok, 1767 log entries for "automatic analyze", mostly in
database postgres.
03:30 Jenkins deployed an update, resulting in reload of lfm database.
15th May:
Postgres working ok, with 257 logged "automatic analyze" events, up until 03:30
03:30 Jenkins deployed an update, resulting in reload of lfm database.
Log of the auto analyse around that update is attached.
No further auto analyse logged after 03.30
16th May:
03:30 Jenkins deployed an update, resulting in reload of lfm database.
Only 3 logged "automatic analyze" in the whole file, timed at 03:30, for
lfm.public and lfm.pg_catalog tables.
Test data feed restarts at 2024-05-16 14:54
Daily partitions are created for this data, and each partition from here is
showing no vacuum or analyze timestamps
17th May:
03:30 Jenkins deployed an update, resulting in reload of lfm database.
Only the reloaded database shows log entries for "automatic analyze", at 03:30,
then nothing more.
18th - 21st may:
As per 17th
Stats output for a sample of tables is attached.
You can see that the partitions were auto analysed on the day they were
created, and not since.
And that new partitions haven’t been analysed at all.
(accp does get a manual analyze occasionally, from an SQL function somewhere,
but not enough to stop auto analyze from running as well)
Summary: since the reload of lfm database on 15th May, the only "automatic
analyze" events logged have been for the lfm database, at the point of reload.
No other stats analyze seems to have taken place, on any database on the server
since that point, even partitions with over a million rows.
Apart from that, Postgres appears to be working normally.
I'm sure that another restart of Postgres will restore the auto analyze, until
the next pg_restore of lfm.
So what's going on? How is it that we're breaking this important function that
we shouldn't be able to have any effect on?
Thanks for looking,
Phil Horder
Database Mechanic
Thales
Land & Air Systems
{OPEN}
The information contained in this e-mail is confidential. It is intended only
for the stated addressee(s) and access to it by any other person is
unauthorised. If you are not an addressee, you must not disclose, copy,
circulate or in any other way use or rely on the information contained in this
e-mail. Such unauthorised use may be unlawful. If you have received this e-mail
in error, please inform the originator immediately and delete it and all copies
from your system.
Thales UK Limited. A company registered in England and Wales. Registered
Office: 350 Longwater Avenue, Green Park, Reading, Berks RG2 6GF. Registered
Number: 868273
Please consider the environment before printing a hard copy of this e-mail.
2024-05-15 03:25:16.008 GMT [5200]: [3-1] db=,user=,app=,client= LOG:
automatic analyze of table "postgres.a.accp"
avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s
buffer usage: 177 hits, 0 misses, 0 dirtied
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-05-15 03:25:57.715 GMT [6356]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=11.22.33.44 LOG: connection
received: host=11.22.33.44 port=61679
2024-05-15 03:25:57.723 GMT [6356]: [2-1]
db=postgres,user=a_a,app=[unknown],client=11.22.33.44 LOG: connection
authenticated: identity="a_a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:25:57.723 GMT [6356]: [3-1]
db=postgres,user=a_a,app=[unknown],client=11.22.33.44 LOG: connection
authorized: user=a_a database=postgres
2024-05-15 03:26:44.945 GMT [5236]: [1-1] db=,user=,app=,client= LOG:
automatic vacuum of table "lfm.fs.ij": index scans: 0
pages: 0 removed, 1 remain, 1 scanned (100.00% of total)
tuples: 4 removed, 2 remain, 0 are dead but not yet removable
removable cutoff: 597463556, which was 0 XIDs old when operation ended
index scan not needed: 0 pages from table (0.00% of total) had 0 dead
item identifiers removed
avg read rate: 0.000 MB/s, avg write rate: 44.473 MB/s
buffer usage: 39 hits, 0 misses, 3 dirtied
WAL usage: 3 records, 0 full page images, 313 bytes
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-05-15 03:26:44.947 GMT [5236]: [2-1] db=,user=,app=,client= LOG:
automatic analyze of table "lfm.fs.ij"
avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s
buffer usage: 327 hits, 0 misses, 0 dirtied
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-05-15 03:26:58.997 GMT [6444]: [1-1] db=,user=,app=,client= LOG:
automatic analyze of table "luciad_fusion_met.fs.ij"
avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s
buffer usage: 356 hits, 0 misses, 0 dirtied
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-05-15 03:28:00.385 GMT [3852]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=11.22.33.44 LOG: connection
received: host=11.22.33.44 port=61793
2024-05-15 03:28:00.391 GMT [3852]: [2-1]
db=postgres,user=a_a,app=[unknown],client=11.22.33.44 LOG: connection
authenticated: identity="a_a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:28:00.391 GMT [3852]: [3-1]
db=postgres,user=a_a,app=[unknown],client=11.22.33.44 LOG: connection
authorized: user=a_a database=postgres
2024-05-15 03:28:45.181 GMT [4820]: [1-1] db=,user=,app=,client= LOG:
automatic analyze of table "lfm.fs.ij"
avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s
buffer usage: 356 hits, 0 misses, 0 dirtied
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-05-15 03:28:59.132 GMT [5960]: [1-1] db=,user=,app=,client= LOG:
automatic vacuum of table "luciad_fusion_met.fs.ij": index scans: 0
pages: 0 removed, 2 remain, 2 scanned (100.00% of total)
tuples: 3 removed, 2 remain, 0 are dead but not yet removable
removable cutoff: 597463771, which was 0 XIDs old when operation ended
new relfrozenxid: 597463769, which is 606 XIDs ahead of previous value
index scan not needed: 0 pages from table (0.00% of total) had 0 dead
item identifiers removed
avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s
buffer usage: 41 hits, 0 misses, 0 dirtied
WAL usage: 3 records, 0 full page images, 311 bytes
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-05-15 03:28:59.134 GMT [5960]: [2-1] db=,user=,app=,client= LOG:
automatic analyze of table "luciad_fusion_met.fs.ij"
avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s
buffer usage: 328 hits, 0 misses, 0 dirtied
system usage: CPU: user: 0.00 s, system: 0.01 s, elapsed: 0.00 s
2024-05-15 03:30:21.362 GMT [1072]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=11.22.33.44 LOG: connection
received: host=11.22.33.44 port=61816
2024-05-15 03:30:21.375 GMT [1072]: [2-1]
db=luciad_fusion_met,user=fsa,app=[unknown],client=11.22.33.44 LOG: connection
authenticated: identity="fsa" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:30:21.375 GMT [1072]: [3-1]
db=luciad_fusion_met,user=fsa,app=[unknown],client=11.22.33.44 LOG: connection
authorized: user=fsa database=luciad_fusion_met
2024-05-15 03:30:34.212 GMT [7028]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=::1 LOG: connection received:
host=::1 port=64617
2024-05-15 03:30:34.217 GMT [7028]: [2-1]
db=postgres,user=superuser,app=[unknown],client=::1 LOG: connection
authenticated: identity="superuser" method=md5
(E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:30:34.217 GMT [7028]: [3-1]
db=postgres,user=superuser,app=[unknown],client=::1 LOG: connection
authorized: user=superuser database=postgres application_name=psql
2024-05-15 03:30:34.680 GMT [5744]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=::1 LOG: connection received:
host=::1 port=64618
2024-05-15 03:30:34.686 GMT [5744]: [2-1]
db=postgres,user=a,app=[unknown],client=::1 LOG: connection authenticated:
identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:30:34.686 GMT [5744]: [3-1]
db=postgres,user=a,app=[unknown],client=::1 LOG: connection authorized: user=a
database=postgres application_name=psql
2024-05-15 03:30:42.201 GMT [5256]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64620
2024-05-15 03:30:42.749 GMT [5256]: [2-1]
db=postgres,user=superuser,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="superuser" method=md5
(E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:30:42.749 GMT [5256]: [3-1]
db=postgres,user=superuser,app=[unknown],client=127.0.0.1 LOG: connection
authorized: user=superuser database=postgres
2024-05-15 03:30:45.288 GMT [1668]: [1-1] db=,user=,app=,client= LOG:
automatic analyze of table "lfm.fs.ij"
avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s
buffer usage: 355 hits, 0 misses, 0 dirtied
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-05-15 03:30:49.420 GMT [6948]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64622
2024-05-15 03:30:49.452 GMT [6948]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:30:49.452 GMT [6948]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:30:51.235 GMT [4064]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64623
2024-05-15 03:30:51.277 GMT [4064]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:30:51.277 GMT [4064]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:30:52.624 GMT [6188]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64624
2024-05-15 03:30:52.647 GMT [6188]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:30:52.647 GMT [6188]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:30:54.136 GMT [4160]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64625
2024-05-15 03:30:54.157 GMT [4160]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:30:54.157 GMT [4160]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:30:56.082 GMT [7036]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64626
2024-05-15 03:30:56.115 GMT [7036]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:30:56.115 GMT [7036]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:30:57.420 GMT [4276]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64627
2024-05-15 03:30:57.437 GMT [4276]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:30:57.437 GMT [4276]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:30:58.597 GMT [1084]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64628
2024-05-15 03:30:58.619 GMT [1084]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:30:58.619 GMT [1084]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:30:59.143 GMT [4000]: [1-1] db=,user=,app=,client= LOG:
automatic analyze of table "luciad_fusion_met.fs.ij"
avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s
buffer usage: 357 hits, 0 misses, 0 dirtied
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-05-15 03:30:59.732 GMT [5196]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64629
2024-05-15 03:30:59.747 GMT [5196]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:30:59.747 GMT [5196]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:00.965 GMT [5932]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64630
2024-05-15 03:31:00.995 GMT [5932]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:00.995 GMT [5932]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:02.320 GMT [2408]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64631
2024-05-15 03:31:02.338 GMT [2408]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:02.338 GMT [2408]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:03.151 GMT [2604]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64632
2024-05-15 03:31:03.168 GMT [2604]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:03.168 GMT [2604]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:04.509 GMT [5012]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64633
2024-05-15 03:31:04.528 GMT [5012]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:04.528 GMT [5012]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:05.560 GMT [6428]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64635
2024-05-15 03:31:05.579 GMT [6428]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:05.579 GMT [6428]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:06.671 GMT [6328]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64637
2024-05-15 03:31:06.692 GMT [6328]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:06.693 GMT [6328]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:07.548 GMT [6564]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64639
2024-05-15 03:31:07.565 GMT [6564]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:07.565 GMT [6564]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:08.632 GMT [1292]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64640
2024-05-15 03:31:08.647 GMT [1292]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:08.647 GMT [1292]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:09.611 GMT [2396]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64641
2024-05-15 03:31:09.633 GMT [2396]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:09.633 GMT [2396]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:10.540 GMT [6808]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64642
2024-05-15 03:31:10.554 GMT [6808]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:10.554 GMT [6808]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:11.767 GMT [5576]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64643
2024-05-15 03:31:11.785 GMT [5576]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:11.785 GMT [5576]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:12.683 GMT [6184]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64644
2024-05-15 03:31:12.709 GMT [6184]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:12.709 GMT [6184]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:13.959 GMT [6960]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64645
2024-05-15 03:31:13.981 GMT [6960]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:13.981 GMT [6960]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:14.944 GMT [6076]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64646
2024-05-15 03:31:14.971 GMT [6076]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:14.972 GMT [6076]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:16.220 GMT [7080]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64647
2024-05-15 03:31:16.257 GMT [7080]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:16.257 GMT [7080]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:17.312 GMT [2708]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64648
2024-05-15 03:31:17.330 GMT [2708]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:17.330 GMT [2708]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:18.503 GMT [3092]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64649
2024-05-15 03:31:18.529 GMT [3092]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:18.529 GMT [3092]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:19.718 GMT [1472]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64650
2024-05-15 03:31:19.741 GMT [1472]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:19.741 GMT [1472]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:21.441 GMT [1940]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64651
2024-05-15 03:31:21.468 GMT [1940]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:21.468 GMT [1940]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:22.781 GMT [6788]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=127.0.0.1 LOG: connection
received: host=127.0.0.1 port=64652
2024-05-15 03:31:22.798 GMT [6788]: [2-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection
authenticated: identity="a" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:22.798 GMT [6788]: [3-1]
db=postgres,user=a,app=[unknown],client=127.0.0.1 LOG: connection authorized:
user=a database=postgres
2024-05-15 03:31:23.799 GMT [1004]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=::1 LOG: connection received:
host=::1 port=64653
2024-05-15 03:31:23.807 GMT [1004]: [2-1]
db=postgres,user=superuser,app=[unknown],client=::1 LOG: connection
authenticated: identity="superuser" method=md5
(E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:23.807 GMT [1004]: [3-1]
db=postgres,user=superuser,app=[unknown],client=::1 LOG: connection
authorized: user=superuser database=postgres application_name=psql
2024-05-15 03:31:24.030 GMT [5616]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=::1 LOG: connection received:
host=::1 port=64654
2024-05-15 03:31:24.035 GMT [5616]: [2-1]
db=postgres,user=superuser,app=[unknown],client=::1 LOG: connection
authenticated: identity="superuser" method=md5
(E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:24.035 GMT [5616]: [3-1]
db=postgres,user=superuser,app=[unknown],client=::1 LOG: connection
authorized: user=superuser database=postgres application_name=psql
2024-05-15 03:31:24.043 GMT [768]: [4-1] db=lfm,user=fsa,app=PostgreSQL JDBC
Driver,client=11.22.33.44 FATAL: terminating connection due to administrator
command
2024-05-15 03:31:24.043 GMT [6200]: [4-1] db=lfm,user=fsa,app=PostgreSQL JDBC
Driver,client=11.22.33.44 FATAL: terminating connection due to administrator
command
2024-05-15 03:31:24.043 GMT [4312]: [4-1] db=lfm,user=fsa,app=PostgreSQL JDBC
Driver,client=11.22.33.44 FATAL: terminating connection due to administrator
command
2024-05-15 03:31:24.045 GMT [5436]: [4-1] db=lfm,user=fsa,app=PostgreSQL JDBC
Driver,client=11.22.33.44 FATAL: terminating connection due to administrator
command
2024-05-15 03:31:24.045 GMT [1064]: [4-1] db=lfm,user=fsa,app=PostgreSQL JDBC
Driver,client=11.22.33.44 FATAL: terminating connection due to administrator
command
2024-05-15 03:31:24.046 GMT [6752]: [4-1] db=lfm,user=fsa,app=PostgreSQL JDBC
Driver,client=11.22.33.44 FATAL: terminating connection due to administrator
command
2024-05-15 03:31:24.046 GMT [1744]: [4-1] db=lfm,user=fsa,app=PostgreSQL JDBC
Driver,client=11.22.33.44 FATAL: terminating connection due to administrator
command
2024-05-15 03:31:24.047 GMT [1688]: [4-1] db=lfm,user=fsa,app=PostgreSQL JDBC
Driver,client=11.22.33.44 FATAL: terminating connection due to administrator
command
2024-05-15 03:31:24.047 GMT [4304]: [4-1] db=lfm,user=fsa,app=PostgreSQL JDBC
Driver,client=11.22.33.44 FATAL: terminating connection due to administrator
command
2024-05-15 03:31:24.047 GMT [7140]: [4-1] db=lfm,user=fsa,app=PostgreSQL JDBC
Driver,client=11.22.33.44 FATAL: terminating connection due to administrator
command
2024-05-15 03:31:24.166 GMT [6640]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=::1 LOG: connection received:
host=::1 port=64655
2024-05-15 03:31:24.173 GMT [6640]: [2-1]
db=postgres,user=superuser,app=[unknown],client=::1 LOG: connection
authenticated: identity="superuser" method=md5
(E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:24.173 GMT [6640]: [3-1]
db=postgres,user=superuser,app=[unknown],client=::1 LOG: connection
authorized: user=superuser database=postgres application_name=dropdb
2024-05-15 03:31:24.196 GMT [4848]: [111-1] db=,user=,app=,client= LOG:
checkpoint starting: immediate force wait
2024-05-15 03:31:24.603 GMT [3416]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=11.22.33.44 LOG: connection
received: host=11.22.33.44 port=61825
2024-05-15 03:31:24.607 GMT [3416]: [2-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 LOG: connection
authenticated: identity="fsa" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:24.607 GMT [3416]: [3-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 LOG: connection authorized:
user=fsa database=lfm
2024-05-15 03:31:27.757 GMT [4848]: [112-1] db=,user=,app=,client= LOG:
checkpoint complete: wrote 38 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0
recycled; write=0.020 s, sync=3.004 s, total=3.562 s; sync files=16,
longest=0.936 s, average=0.188 s; distance=650 kB, estimate=8459 kB
2024-05-15 03:31:28.987 GMT [3416]: [4-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 FATAL: database "lfm" does
not exist
2024-05-15 03:31:28.987 GMT [3416]: [5-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 DETAIL: It seems to have just
been dropped or renamed.
2024-05-15 03:31:29.146 GMT [1120]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=::1 LOG: connection received:
host=::1 port=64658
2024-05-15 03:31:29.151 GMT [1120]: [2-1]
db=postgres,user=superuser,app=[unknown],client=::1 LOG: connection
authenticated: identity="superuser" method=md5
(E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:29.152 GMT [1120]: [3-1]
db=postgres,user=superuser,app=[unknown],client=::1 LOG: connection
authorized: user=superuser database=postgres application_name=pg_restore
2024-05-15 03:31:29.385 GMT [4108]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=11.22.33.44 LOG: connection
received: host=11.22.33.44 port=61826
2024-05-15 03:31:29.400 GMT [4108]: [2-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 LOG: connection
authenticated: identity="fsa" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:29.400 GMT [4108]: [3-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 LOG: connection authorized:
user=fsa database=lfm
2024-05-15 03:31:29.400 GMT [4108]: [4-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 FATAL: database "lfm" does
not exist
2024-05-15 03:31:29.830 GMT [7072]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=11.22.33.44 LOG: connection
received: host=11.22.33.44 port=61827
2024-05-15 03:31:29.840 GMT [7072]: [2-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 LOG: connection
authenticated: identity="fsa" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:29.840 GMT [7072]: [3-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 LOG: connection authorized:
user=fsa database=lfm
2024-05-15 03:31:29.841 GMT [7072]: [4-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 FATAL: database "lfm" does
not exist
2024-05-15 03:31:30.525 GMT [6364]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=11.22.33.44 LOG: connection
received: host=11.22.33.44 port=61828
2024-05-15 03:31:30.531 GMT [6364]: [2-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 LOG: connection
authenticated: identity="fsa" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:30.531 GMT [6364]: [3-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 LOG: connection authorized:
user=fsa database=lfm
2024-05-15 03:31:30.531 GMT [6364]: [4-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 FATAL: database "lfm" does
not exist
2024-05-15 03:31:31.287 GMT [4556]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=::1 LOG: connection received:
host=::1 port=64659
2024-05-15 03:31:31.290 GMT [4556]: [2-1]
db=lfm,user=superuser,app=[unknown],client=::1 LOG: connection authenticated:
identity="superuser" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:31.290 GMT [4556]: [3-1]
db=lfm,user=superuser,app=[unknown],client=::1 LOG: connection authorized:
user=superuser database=lfm application_name=pg_restore
2024-05-15 03:31:31.555 GMT [3268]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=11.22.33.44 LOG: connection
received: host=11.22.33.44 port=61829
2024-05-15 03:31:31.576 GMT [3268]: [2-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 LOG: connection
authenticated: identity="fsa" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:31.576 GMT [3268]: [3-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 LOG: connection authorized:
user=fsa database=lfm
2024-05-15 03:31:31.705 GMT [3268]: [4-1] db=lfm,user=fsa,app=PostgreSQL JDBC
Driver,client=11.22.33.44 ERROR: permission denied for schema fs at character
530
2024-05-15 03:31:31.705 GMT [3268]: [5-1] db=lfm,user=fsa,app=PostgreSQL JDBC
Driver,client=11.22.33.44 STATEMENT: select ij.id, ij_created_by.id,
ij_created_by.username, ij_created_by.email, ij_created_by.creation_time,
ij_created_by.user_tour_completed, ij_updated_by.id, ij_updated_by.username,
ij_updated_by.email, ij_updated_by.creation_time,
ij_updated_by.user_tour_completed, ij.creation_time, ij.update_time, ij.status,
ij.last_execution_time, ij.last_execution_status, ij.job_schedule, ij.ij_type
from fs.ij ij left join fs.app_user ij_created_by on ij.created_by_app_user_id
= ij_created_by.id left join fs.app_user ij_updated_by on
ij.updated_by_app_user_id = ij_updated_by.id where ij.id = $1 limit $2
2024-05-15 03:31:31.750 GMT [2220]: [1-1]
db=[unknown],user=[unknown],app=[unknown],client=11.22.33.44 LOG: connection
received: host=11.22.33.44 port=61830
2024-05-15 03:31:31.755 GMT [2220]: [2-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 LOG: connection
authenticated: identity="fsa" method=md5 (E:/PostgreSQL/15/data/pg_hba.conf:108)
2024-05-15 03:31:31.755 GMT [2220]: [3-1]
db=lfm,user=fsa,app=[unknown],client=11.22.33.44 LOG: connection authorized:
user=fsa database=lfm
postgres=# \x
postgres=# select * from pg_stat_all_tables where relname in
('accp','pg_shdepend')
postgres-# or relname like 'cr_pt_e_202405%' order by relname;
-[ RECORD 1 ]-------+--------------------------------------------------
relid | 811486381
schemaname | a
relname | accp
seq_scan | 1661787
seq_tup_read | 905357338
idx_scan | 248533779
idx_tup_fetch | 655158328
n_tup_ins | 3655469
n_tup_upd | 0
n_tup_del | 3220871
n_tup_hot_upd | 0
n_live_tup | 490
n_dead_tup | 1673487
n_mod_since_analyze | 392
n_ins_since_vacuum | 1673683
last_vacuum |
last_autovacuum | 2024-05-15 03:25:16.007386+00
last_analyze | 2024-05-21 12:51:09.114787+00
last_autoanalyze | 2024-05-15 03:25:16.008873+00
vacuum_count | 0
autovacuum_count | 1888
analyze_count | 26856
autoanalyze_count | 1715
-[ RECORD 2 ]-------+--------------------------------------------------
relid | 922801367
schemaname | a
relname | cr_pt_e_202405010000_202405020000
seq_scan | 47
seq_tup_read | 20302955
idx_scan | 241500
idx_tup_fetch | 64456
n_tup_ins | 0
n_tup_upd | 0
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 1450324
n_dead_tup | 0
n_mod_since_analyze | 0
n_ins_since_vacuum | 0
last_vacuum |
last_autovacuum |
last_analyze | 2024-05-09 08:59:41.62695+00
last_autoanalyze |
vacuum_count | 0
autovacuum_count | 0
analyze_count | 1
autoanalyze_count | 0
-[ RECORD 3 ]-------+--------------------------------------------------
relid | 923130055
schemaname | a
relname | cr_pt_e_202405020000_202405030000
seq_scan | 1264
seq_tup_read | 8800722491
idx_scan | 4601405
idx_tup_fetch | 4415621
n_tup_ins | 3851400
n_tup_upd | 15790
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 7166325
n_dead_tup | 0
n_mod_since_analyze | 0
n_ins_since_vacuum | 0
last_vacuum |
last_autovacuum | 2024-05-03 09:03:44.810654+00
last_analyze | 2024-05-09 08:44:37.725674+00
last_autoanalyze | 2024-05-03 09:03:58.838664+00
vacuum_count | 0
autovacuum_count | 1
analyze_count | 1
autoanalyze_count | 1
-[ RECORD 4 ]-------+--------------------------------------------------
relid | 923492271
schemaname | a
relname | cr_pt_e_202405030000_202405040000
seq_scan | 49
seq_tup_read | 17146395
idx_scan | 2516428
idx_tup_fetch | 263394464
n_tup_ins | 1221170
n_tup_upd | 28186
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 1221081
n_dead_tup | 0
n_mod_since_analyze | 0
n_ins_since_vacuum | 97850
last_vacuum |
last_autovacuum | 2024-05-03 22:23:52.923897+00
last_analyze | 2024-05-09 08:34:56.67582+00
last_autoanalyze | 2024-05-03 23:40:05.055661+00
vacuum_count | 0
autovacuum_count | 7
analyze_count | 1
autoanalyze_count | 19
-[ RECORD 5 ]-------+--------------------------------------------------
relid | 923703041
schemaname | a
relname | cr_pt_e_202405040000_202405050000
seq_scan | 49
seq_tup_read | 20317780
idx_scan | 2404969
idx_tup_fetch | 23974762973
n_tup_ins | 1451270
n_tup_upd | 42958
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 1451368
n_dead_tup | 0
n_mod_since_analyze | 0
n_ins_since_vacuum | 0
last_vacuum |
last_autovacuum | 2024-05-09 07:37:07.984628+00
last_analyze | 2024-05-09 08:45:49.581849+00
last_autoanalyze | 2024-05-09 07:37:15.986243+00
vacuum_count | 0
autovacuum_count | 19
analyze_count | 1
autoanalyze_count | 5
-[ RECORD 6 ]-------+--------------------------------------------------
relid | 924013058
schemaname | a
relname | cr_pt_e_202405050000_202405060000
seq_scan | 46
seq_tup_read | 20346620
idx_scan | 1677570
idx_tup_fetch | 62821556003
n_tup_ins | 1453330
n_tup_upd | 43044
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 1453377
n_dead_tup | 0
n_mod_since_analyze | 0
n_ins_since_vacuum | 0
last_vacuum |
last_autovacuum | 2024-05-09 07:38:29.862644+00
last_analyze | 2024-05-09 09:06:45.596016+00
last_autoanalyze | 2024-05-09 07:38:46.638095+00
vacuum_count | 0
autovacuum_count | 1
analyze_count | 1
autoanalyze_count | 1
-[ RECORD 7 ]-------+--------------------------------------------------
relid | 924322992
schemaname | a
relname | cr_pt_e_202405060000_202405070000
seq_scan | 46
seq_tup_read | 20317780
idx_scan | 1547942
idx_tup_fetch | 42808203048
n_tup_ins | 1451270
n_tup_upd | 43099
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 1451352
n_dead_tup | 0
n_mod_since_analyze | 0
n_ins_since_vacuum | 0
last_vacuum |
last_autovacuum | 2024-05-09 07:38:38.204882+00
last_analyze | 2024-05-09 09:17:08.164641+00
last_autoanalyze | 2024-05-09 07:38:54.664434+00
vacuum_count | 0
autovacuum_count | 1
analyze_count | 1
autoanalyze_count | 1
-[ RECORD 8 ]-------+--------------------------------------------------
relid | 924633049
schemaname | a
relname | cr_pt_e_202405070000_202405080000
seq_scan | 46
seq_tup_read | 3972817
idx_scan | 302373
idx_tup_fetch | 1196443546
n_tup_ins | 281190
n_tup_upd | 8790
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 281190
n_dead_tup | 0
n_mod_since_analyze | 0
n_ins_since_vacuum | 0
last_vacuum |
last_autovacuum | 2024-05-09 07:37:40.345145+00
last_analyze | 2024-05-09 09:21:34.794247+00
last_autoanalyze | 2024-05-09 07:37:43.220323+00
vacuum_count | 0
autovacuum_count | 1
analyze_count | 1
autoanalyze_count | 1
-[ RECORD 9 ]-------+--------------------------------------------------
relid | 924849317
schemaname | a
relname | cr_pt_e_202405160000_202405170000
seq_scan | 11
seq_tup_read | 551050
idx_scan | 625876
idx_tup_fetch | 23425556147
n_tup_ins | 551050
n_tup_upd | 16050
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 551050
n_dead_tup | 16050
n_mod_since_analyze | 567100
n_ins_since_vacuum | 551050
last_vacuum |
last_autovacuum |
last_analyze |
last_autoanalyze |
vacuum_count | 0
autovacuum_count | 0
analyze_count | 0
autoanalyze_count | 0
-[ RECORD 10 ]------+--------------------------------------------------
relid | 924961379
schemaname | a
relname | cr_pt_e_202405170000_202405180000
seq_scan | 8
seq_tup_read | 0
idx_scan | 1576550
idx_tup_fetch | 62495118422
n_tup_ins | 1445090
n_tup_upd | 42104
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 1445090
n_dead_tup | 42104
n_mod_since_analyze | 1487194
n_ins_since_vacuum | 1445090
last_vacuum |
last_autovacuum |
last_analyze |
last_autoanalyze |
vacuum_count | 0
autovacuum_count | 0
analyze_count | 0
autoanalyze_count | 0
-[ RECORD 11 ]------+--------------------------------------------------
relid | 925266104
schemaname | a
relname | cr_pt_e_202405180000_202405190000
seq_scan | 8
seq_tup_read | 0
idx_scan | 1575404
idx_tup_fetch | 62723304826
n_tup_ins | 1445090
n_tup_upd | 42107
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 1445090
n_dead_tup | 42107
n_mod_since_analyze | 1487197
n_ins_since_vacuum | 1445090
last_vacuum |
last_autovacuum |
last_analyze |
last_autoanalyze |
vacuum_count | 0
autovacuum_count | 0
analyze_count | 0
autoanalyze_count | 0
-[ RECORD 12 ]------+--------------------------------------------------
relid | 925574480
schemaname | a
relname | cr_pt_e_202405190000_202405200000
seq_scan | 8
seq_tup_read | 0
idx_scan | 1576466
idx_tup_fetch | 62756475943
n_tup_ins | 1446120
n_tup_upd | 42140
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 1446120
n_dead_tup | 42140
n_mod_since_analyze | 1488260
n_ins_since_vacuum | 1446120
last_vacuum |
last_autovacuum |
last_analyze |
last_autoanalyze |
vacuum_count | 0
autovacuum_count | 0
analyze_count | 0
autoanalyze_count | 0
-[ RECORD 13 ]------+--------------------------------------------------
relid | 925883070
schemaname | a
relname | cr_pt_e_202405200000_202405210000
seq_scan | 8
seq_tup_read | 0
idx_scan | 1554745
idx_tup_fetch | 55383014348
n_tup_ins | 1445090
n_tup_upd | 42103
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 1445090
n_dead_tup | 42103
n_mod_since_analyze | 1487193
n_ins_since_vacuum | 1445090
last_vacuum |
last_autovacuum |
last_analyze |
last_autoanalyze |
vacuum_count | 0
autovacuum_count | 0
analyze_count | 0
autoanalyze_count | 0
-[ RECORD 14 ]------+--------------------------------------------------
relid | 926191516
schemaname | a
relname | cr_pt_e_202405210000_202405220000
seq_scan | 8
seq_tup_read | 0
idx_scan | 792634
idx_tup_fetch | 8375236568
n_tup_ins | 747780
n_tup_upd | 21758
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 747780
n_dead_tup | 21758
n_mod_since_analyze | 769538
n_ins_since_vacuum | 747780
last_vacuum |
last_autovacuum |
last_analyze |
last_autoanalyze |
vacuum_count | 0
autovacuum_count | 0
analyze_count | 0
autoanalyze_count | 0
-[ RECORD 15 ]------+--------------------------------------------------
relid | 1214
schemaname | pg_catalog
relname | pg_shdepend
seq_scan | 17
seq_tup_read | 95718
idx_scan | 15059199
idx_tup_fetch | 2170231
n_tup_ins | 2148565
n_tup_upd | 0
n_tup_del | 2148602
n_tup_hot_upd | 0
n_live_tup | 6991
n_dead_tup | 16171
n_mod_since_analyze | 32342
n_ins_since_vacuum | 16171
last_vacuum |
last_autovacuum | 2024-05-21 03:28:39.846993+00
last_analyze | 2024-05-09 08:27:39.663855+00
last_autoanalyze | 2024-05-21 03:28:39.856801+00
vacuum_count | 0
autovacuum_count | 584
analyze_count | 1
autoanalyze_count | 749
