Show Menu
Cheatography

psql vars3 Cheat Sheet by

Columns

ad
activi­ty_­def­ini­tion_id
adi
activi­ty_­def­ini­tio­n_i­nst­ance_id
at
activi­ty_type
au
activi­ty_uuid
ebi
etl_ba­tch_id
ee
effect­ive_end
ei
entity_id
es
effect­ive­_start
et
entity­_type
iu
identi­ty_uuid
jti
job_ti­cket_id
ou
organi­zat­ion­_uuid
pu
person­_uuid
rei
referr­ing­_en­tity_id
ret
referr­ing­_en­tit­y_type
it
intrac­tio­n_type
minusday
now() - interval '1 day'
minus2days
now() - interval '2 day'
minusweek
now() - interval '1 week'
minusmonth
now() - interval '1 month'
now
now()
 

Tables

at
t_activity
tadd
t_acti­vit­y_d­efi­nit­ion_dim
tasd
t_acti­vit­y_s­ubs­cri­pti­on_­detail
tdi
t_dona­tio­n_i­ntent
tdt
t_dona­tio­n_t­ran­saction
tec
t_etl_­calls
tef
t_email_f
tebd
t_emai­l_b­las­t_dim
tet
t_even­t_t­icket
teta
t_even­t_t­ick­et_­att­endee
ti
t_inte­raction
to
t_orga­niz­ation
tos
t_orga­niz­ati­on_­segment
tosa
t_orga­niz­ati­on_­seg­men­t_a­ssi­gnment
tpa
t_peti­tio­n_a­ctivity
tpc
t_pers­on_­contact
tpd
t_pers­on_dim
tpf
t_p2p_­fun­draiser
ttead
t_tick­ete­d_e­ven­t_a­cti­vit­y_d­etail
ttla
t_targ­ete­d_l­ett­er_­act­ivity

Schemas

im
ignitemart
is
ignite­staging
agg
aggreg­ations
i
instru­men­tation
 

Queries

autoex­plain
'LOAD 'auto_­exp­lain'; SET auto_e­xpl­ain.lo­g_m­in_­dur­ation = 0; SET auto_e­xpl­ain.lo­g_a­nalyze = true; SET auto_e­xpl­ain.lo­g_n­est­ed_­sta­tements = true; select 'EDT:'­||c­urr­ent­_da­tab­ase­()|­|':­'||­cur­ren­t_u­ser­||'­:'|­|pg­_ba­cke­nd_­pid()'
c
count(*)
gb
group by
s
select
f
from
scf
select count(*) from
ob
order by
eab
explain (analyze on , buffers on)
pgsp
pg_siz­e_p­retty
pgrs
pg_rel­ati­on_size
pgs
select pg_siz­e_p­ret­ty(­pg_­rel­ati­on_­siz­e(:­'v'));
martbc
select bc_ide­nti­ty_uuid from t_emai­l_b­las­t_dim where bc_ide­nti­ty_uuid = :'emai­l_b­las­t_uuid'
hqbc
select distinct identi­ty_uuid from email_­bla­st_­content where email_­bla­st_uuid = :'emai­l_b­las­t_uuid'
martadi
select adi_id­ent­ity­_uuid from t_acti­vit­y_d­efi­nit­ion_dim where adi_id­ent­ity­_uuid = :'acti­vit­y_d­efi­nit­ion­_uuid'
hqadi
select distinct identi­ty_uuid from activi­ty_­def­ini­tio­n_i­nstance where activi­ty_­def­ini­tio­n_uuid = :'acti­vit­y_d­efi­nit­ion­_uuid'

Help Us Go Positive!

We offset our carbon usage with Ecologi. Click the link below to help us!

We offset our carbon footprint via Ecologi
 

Comments

No comments yet. Add yours below!

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.

          Related Cheat Sheets

          PostgreSQL interactive terminal commands Cheat Sheet