postgresql 查看数据库,表,索引,表空间以及大小

1,查看数据库

查看复制打印?

1. playboy=>l//加上字母l,相当于mysql的，mysql>showdatabases;
2. Listofdatabases
3. Name|Owner|Encoding
4. -----------+----------+----------
5. playboy|postgres|UTF8
6. postgres|postgres|UTF8
7. template0|postgres|UTF8
8. template1|postgres|UTF8
10. playboy=>selectpg_database_size('playboy');//查看playboy数据库的大小
11. pg_database_size
12. ------------------
13. 3637896
14. (1row)
16. playboy=>selectpg_database.datname,pg_database_size(pg_database.datname)ASsizefrompg_database;//查看所有数据库的大小
17. datname|size
18. -----------+---------
19. postgres|3621512
20. playboy|3637896
21. template1|3563524
22. template0|3563524
23. (4rows)
25. playboy=>selectpg_size_pretty(pg_database_size('playboy'));//以KB，MB，GB的方式来查看数据库大小
26. pg_size_pretty
27. ----------------
28. 3553kB
29. (1row)

2，查看多表

查看复制打印?

1. playboy=>dt//相当于mysql的，mysql>showtables;
2. Listofrelations
3. Schema|Name|Type|Owner
4. --------+------+-------+---------
5. public|test|table|playboy
6. (1row)

3，查看单表

查看复制打印?

1. playboy=>dtest;//相当于mysql的，mysql>desctest;
2. Table"public.test"
3. Column|Type|Modifiers
4. --------+-----------------------+-----------
5. id|integer|notnull
6. name|charactervarying(32)|
7. Indexes:"playboy_id_pk"PRIMARYKEY,btree(id)
9. playboy=>selectpg_relation_size('test');//查看表大小
10. pg_relation_size
11. ------------------
12. 0
13. (1row)
15. playboy=>selectpg_size_pretty(pg_relation_size('test'));//以KB，MB，GB的方式来查看表大小
16. pg_size_pretty
17. ----------------
18. 0bytes
19. (1row)
21. playboy=>selectpg_size_pretty(pg_total_relation_size('test'));//查看表的总大小，包括索引大小
22. pg_size_pretty
23. ----------------
24. 8192bytes
25. (1row)

4，查看索引

查看复制打印?

1. playboy=>di//相当于mysql的，mysql>showindexfromtest;
2. Listofrelations
3. Schema|Name|Type|Owner|Table
4. --------+---------------+-------+---------+-------
5. public|playboy_id_pk|index|playboy|test
6. (1row)
8. playboy=>selectpg_size_pretty(pg_relation_size('playboy_id_pk'));//查看索大小
9. pg_size_pretty
10. ----------------
11. 8192bytes
12. (1row)

5，查看表空间，以及大小

查看复制打印?

1. playboy=>selectspcnamefrompg_tablespace;//查看所有表空间
2. spcname
3. ------------
4. pg_default
5. pg_global
6. (2rows)
8. playboy=>selectpg_size_pretty(pg_tablespace_size('pg_default'));//查看表空间大小
9. pg_size_pretty
10. ----------------
11. 14MB
12. (1row)

23

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!