检索处理实行时间非常慢、查看postgresql.log有下面的内容,内容什么意思?怎么引起的?怎么解决?
2202-05-07 02: 05: 52.300 JST INF0: scanned index“pg_statistic relid_att” to remove 7514 row versions
2022-05-07 02: 05: 52.300 JST DETAIL: CPU 0. 00s/ 0. 00u sec elapsed 0.07 sec.
2022-05-07 02: 05: 52.303 JST INF0: “pg_statistic”: removed 7514 row versions in 1756 pages
2022-05-07 02: 05: 52.303 JST DETAIL: CPU 0. 00s/ 0. 00u sec elapsed 0.00 sec.
2022-05-07 02: 05: 52.303 JST : index “pg_statistic_ relid_att” now contains 10544 row versions in 48 pages
12022-05-07 02: 05: 52.303 JST DETAIL: 260 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0. 00s/ 0. 00u sec el apsed 0.00 sec.
2022-05-07 02: 05: 52.303 JST INF0: “pg-statistic" : found 7622 removable, 10544 nonremovable row versions in 1857 out of 1857 pages
2022-05-07 02 : 05: 52.303 JST DETAIL: 0 dead row versions cannot be removed yet.
There were 17181 unused item pointers.
pages are entirely empty.
CPU 0. 00s/ 0. 02u sec elapsed 0. 18 sec.