如何查询表的死元组？

答：使用pg_stat_all_tables查询死元组。

gaussdb=# SELECT relname,n_live_tup+n_dead_tup all_tup,n_dead_tup,last_autovacuum,last_autoanalyze FROM pg_stat_all_tables WHERE relname='test02';
relname | all_tup   | n_dead_tup |           last_autovacuum   |      last_autoanalyze
---------+---------+------------+-------------------------------+-----------------------------
test02  |  500000 |      10000 | 2023-04-26 14:09:33.933982+08 | 2023-04-26 14:17:34.0364+08