psql vars3 Cheat Sheet by skoffer

ad

activi­ty_­def­ini­tion_id

at

activi­ty_type

ebi

etl_ba­tch_id

ei

entity_id

et

entity­_type

jti

job_ti­cket_id

pu

person­_uuid

ret

referr­ing­_en­tit­y_type

minusday

now() - interval '1 day'

minusweek

now() - interval '1 week'

now

now()

at

t_activity

tasd

t_acti­vit­y_s­ubs­cri­pti­on_­detail

tdt

t_dona­tio­n_t­ran­saction

tef

t_email_f

tet

t_even­t_t­icket

ti

t_inte­raction

tos

t_orga­niz­ati­on_­segment

tpa

t_peti­tio­n_a­ctivity

tpd

t_pers­on_dim

ttead

t_tick­ete­d_e­ven­t_a­cti­vit­y_d­etail

im

ignitemart

agg

aggreg­ations

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()'

gb

group by

f

from

ob

order by

pgsp

pg_siz­e_p­retty

pgs

select pg_siz­e_p­ret­ty(­pg_­rel­ati­on_­siz­e(:­'v'));

hqbc

select distinct identi­ty_uuid from email_­bla­st_­content where email_­bla­st_uuid = :'emai­l_b­las­t_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'