postgresql查看数据库,索引,表空间大小（PostgreSQL database, index, table space size）.docVIP

postgresql查看数据库,索引,表空间大小（PostgreSQL database, index, table space size） PostgreSQL view database, index, table space size, insert, into, temp, select, generate_series (110000000), generate_series (8000000190000000), 1; Example explanation 1. Check the number of bytes required to store a specified value David=# select pg_column_size (1); Pg_column_size ---- Four (1, row) David=# select pg_column_size (david); Pg_column_size ---- Six (1, row) 2, check the data table field information David=#\d test Table public.test Column Type Modifiers | | -----------+-----------------------+----------- ID inte