Skip to content

Instantly share code, notes, and snippets.

Amit Upadhyay amitu

Block or report user

Report or block amitu

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View postgres_stats.sql
with table_stats as (
select psut.relname,
1.0 * psut.idx_scan / greatest(1, psut.seq_scan + psut.idx_scan) as index_use_ratio
from pg_stat_user_tables psut
order by psut.n_live_tup desc
table_io as (
select psiut.relname,
sum(psiut.heap_blks_read) as table_page_read,
View .gitignore
View Evolution of a Python
#Newbie programmer
def factorial(x):
if x == 0:
return 1
return x * factorial(x - 1)
print factorial(6)
#First year programmer, studied Pascal
You can’t perform that action at this time.