All public logs

Combined display of all available logs of IT Wiki. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

• 13:20, 2 September 2022 Dbeaver talk contribs created page 테이블 인덱스 - DBMS별 확인 방법 (새 문서: * 상위 문서: 테이블 인덱스 == PostgreSQL == === 인덱스 확인 === pg_indexes 테이블 활용<blockquote>SELECT * FROM pg_indexes WHERE tablename = 'mytable';</blockquote> === 인덱스 통계 확인 === pg_stat_user_indexes 테이블 활용<syntaxhighlight lang="sql" line="1"> SELECT schemaname AS schema_name, relname AS table_name, indexrelname AS index_name, pg_size_pretty(pg_relation_size(indexrelid::regclass)) AS index_size, idx_scan...) Tag: Visual edit