|
ad
|
activity_definition_id
|
|
adi
|
activity_definition_instance_id
|
|
at
|
activity_type
|
|
au
|
activity_uuid
|
|
ebi
|
etl_batch_id
|
|
ee
|
effective_end
|
|
ei
|
entity_id
|
|
es
|
effective_start
|
|
et
|
entity_type
|
|
iu
|
identity_uuid
|
|
jti
|
job_ticket_id
|
|
ou
|
organization_uuid
|
|
pu
|
person_uuid
|
|
rei
|
referring_entity_id
|
|
ret
|
referring_entity_type
|
|
it
|
intraction_type
|
|
minusday
|
now() - interval '1 day'
|
|
minus2days
|
now() - interval '2 day'
|
|
minusweek
|
now() - interval '1 week'
|
|
minusmonth
|
now() - interval '1 month'
|
|
now
|
now()
|
|
at
|
t_activity
|
|
tadd
|
t_activity_definition_dim
|
|
tasd
|
t_activity_subscription_detail
|
|
tdi
|
t_donation_intent
|
|
tdt
|
t_donation_transaction
|
|
tec
|
t_etl_calls
|
|
tef
|
t_email_f
|
|
tebd
|
t_email_blast_dim
|
|
tet
|
t_event_ticket
|
|
teta
|
t_event_ticket_attendee
|
|
ti
|
t_interaction
|
|
to
|
t_organization
|
|
tos
|
t_organization_segment
|
|
tosa
|
t_organization_segment_assignment
|
|
tpa
|
t_petition_activity
|
|
tpc
|
t_person_contact
|
|
tpd
|
t_person_dim
|
|
tpf
|
t_p2p_fundraiser
|
|
ttead
|
t_ticketed_event_activity_detail
|
|
ttla
|
t_targeted_letter_activity
|
|
im
|
ignitemart
|
|
is
|
ignitestaging
|
|
agg
|
aggregations
|
|
i
|
instrumentation
|
|
autoexplain
|
'LOAD 'auto_explain'; SET auto_explain.log_min_duration = 0; SET auto_explain.log_analyze = true; SET auto_explain.log_nested_statements = true; select 'EDT:'||current_database()||':'||current_user||':'||pg_backend_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_size_pretty
|
|
pgrs
|
pg_relation_size
|
|
pgs
|
select pg_size_pretty(pg_relation_size(:'v'));
|
|
martbc
|
select bc_identity_uuid from t_email_blast_dim where bc_identity_uuid = :'email_blast_uuid'
|
|
hqbc
|
select distinct identity_uuid from email_blast_content where email_blast_uuid = :'email_blast_uuid'
|
|
martadi
|
select adi_identity_uuid from t_activity_definition_dim where adi_identity_uuid = :'activity_definition_uuid'
|
|
hqadi
|
select distinct identity_uuid from activity_definition_instance where activity_definition_uuid = :'activity_definition_uuid'
|
No comments yet.
Cheatography n. The art of mapping complex subjects into clear, instantly navigable reference guides.
