WITH stat_index_uses AS (
                    SELECT distinct
                        i.indexname,
                        i.tablename,
                        i.schemaname,
                        i.indexdef,
                        SUM(pg_relation_size(indexrelid)) OVER (PARTITION BY indexname) as index_size,
                        split_part(i.indexdef, 'USING ', 2) as indexdef_part ,
                        s.idx_scan,
                        -- статистика чтения индекса
                        SUM(s.idx_scan) OVER (PARTITION BY i.tablename) AS tdx_scan -- если статистика по таблице в целом равна 0 значит статистика не создавалась, такие индексы не удаляем
                    FROM
                        pg_indexes i
                        LEFT JOIN pg_stat_user_indexes s ON s.indexrelname = i.indexname
                    WHERE
                        i.tablename = 'TABLICAAA'
                        AND i.schemaname = 'public'
                ) SELECT
                      tdx_scan as tab_scan,
                      index_size as ind_size,
                      pg_relation_size(schemaname||'.'||tablename) as tab_size,
                      pg_total_relation_size(schemaname||'.'||tablename) as tab_total_size_befor,
                      0 as tab_total_size_after,
                      current_date as dt,
                      'drop' as action,
                      schemaname as schemaname,
                      tablename as tablename,
                      indexname as indexname,
                      '201702220900_drop_index__TABLICAA' as changelog,
                      'изменение индекса' as descr,
                      indexdef as def,
                      indexdef_part as def_part
                  FROM
                      stat_index_uses i
                  WHERE
                      split_part(i.indexdef, 'USING ', 2) = 'btree (is_system) WHERE (is_system = false)'
                      --AND i.idx_scan < 10
                      --AND i.tdx_scan > 10000