PostgreSQL 테이블 사이즈: Revision history

From IT Wiki

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

    23 December 2022

    • curprev 13:3613:36, 23 December 2022‎ Dbeaver talk contribs‎ 461 bytes +461‎ 새 문서: '''전체 테이블 사이즈 확인하기''' <blockquote>select spcname, pg_size_pretty(pg_tablespace_size(spcname)) from pg_tablespace;</blockquote>'''테이블별 사이즈 확인하기''' <blockquote>select pg_total_relation_size('테이블이름');</blockquote>'''읽기 좋게 표현하기''' MB, GB같은 단위로 보고싶으면 pg_size_pretty를 사용한다. <blockquote>select pg_size_pretty(pg_total_relation_size('테이블이름'));</blockquote> Tag: Visual edit
Retrieved from "https://itwiki.kr/w/PostgreSQL_테이블_사이즈"