2017.02.22 17:15

postgres 스키마 크기 출력

query
SELECT schema_name,
    pg_size_pretty(sum(table_size)::bigint) as "disk space",
    (sum(table_size) / pg_database_size(current_database())) * 100
        as "percent"
FROM (
     SELECT pg_catalog.pg_namespace.nspname as schema_name,
         pg_relation_size(pg_catalog.pg_class.oid) as table_size
     FROM   pg_catalog.pg_class
         JOIN pg_catalog.pg_namespace 
             ON relnamespace = pg_catalog.pg_namespace.oid
) t
GROUP BY schema_name
ORDER BY schema_name;

출력 결과



Trackback 0 Comment 0
2016.12.21 15:23

IntelliJ Process finished with exit code 0 when spring-boot run

Deleting provided scope of spring-boot-starter-tomcat dependency helps me.

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-tomcat</artifactId>
</dependency>


[출처] IntelliJ Process finished with exit code 0 when spring-boot run

Trackback 0 Comment 0
2016.12.21 14:41

IntelliJ svn ignore pattern

Settings - Version Control - Ignored Files

Trackback 0 Comment 0
2016.12.21 09:18

IntelliJ 메이븐 deploy with source

Run à Edit Configurations à Add New Configurations à Maven

이름 입력 à Working Directory 지정 (모듈) à Command Line 입력 (clean source:jar deploy)

Trackback 0 Comment 0
2016.12.20 17:32

IntelliJ의 Search Everywhere에서 class 파일 제외시키기

Search Everywhere에서 파일을 검색하면 class 파일까지 같이 검색되어 불편함

 

해결 방법

Project Structure (Ctrl + Alt + Shift + S) - Module에서 target을 exclude

Trackback 0 Comment 0