Search Postgresql Archives

RE: Restore of a reference database kills the auto analyze processing.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux