Show Menu

psql vars3 Cheat Sheet by

psql

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'

Download the psql vars3 Cheat Sheet

1 Page
//media.cheatography.com/storage/thumb/skoffer_psql-vars3.750.jpg

PDF (recommended)

Alternative Downloads

Share This Cheat Sheet!

 

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