Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select relname, indexrelname, idx_scan+idx_tup_read+idx_tup_fetch as somme from pg_stat_user_indexes i where schemaname='public' and (relname,idx_scan+idx_tup_read+idx_tup_fetch)=(select relname, max(idx_scan+idx_tup_read+idx_tup_fetch) from pg_stat_user_indexes j where i.relname=j.relname group by relname limit 1) ;
- fli_newsletter_config | pk_fli_newsletter_config | 0
- fli_newsletter_config | newsletter_config_id | 0
- Je ne veux que la première ligne.
Add Comment
Please, Sign In to add comment