Cheatography
https://cheatography.com
Columnsad | 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() |
| | Tablesat | 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 |
Schemasim | ignitemart | is | ignitestaging | agg | aggregations | i | instrumentation |
| | Queriesautoexplain | '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' |
|
Created By
Metadata
Favourited By
Comments
No comments yet. Add yours below!
Add a Comment
Related Cheat Sheets