Created
April 3, 2015 17:15
-
-
Save nicpottier/5d9ba18b59d4f27bfc54 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
rapidsms=> \d flows_flowstep; | |
Table "public.flows_flowstep" | |
Column | Type | Modifiers | |
--------------------+--------------------------+------------------------------------------------------------- | |
id | integer | not null default nextval('flows_flowstep_id_seq'::regclass) | |
step_type | character varying(1) | not null | |
step_uuid | character varying(36) | not null | |
arrived_on | timestamp with time zone | not null | |
left_on | timestamp with time zone | | |
rule_uuid | character varying(36) | | |
next_uuid | character varying(36) | | |
rule_category | character varying(36) | | |
rule_decimal_value | numeric(36,8) | | |
run_id | integer | not null | |
rule_value | character varying(640) | | |
contact_id | integer | not null | |
Indexes: | |
"flows_flowstep_pkey" PRIMARY KEY, btree (id) | |
"flows_flowstep_contact_id" btree (contact_id) | |
"flows_flowstep_left_on" btree (left_on) | |
"flows_flowstep_run_id" btree (run_id) | |
"flows_flowstep_step_next_left_null_rule" btree (step_uuid, next_uuid, left_on) WHERE rule_uuid::text = NULL::text | |
"flows_flowstep_step_next_rule_left" btree (step_uuid, next_uuid, rule_uuid, left_on) | |
"flows_flowstep_step_uuid" btree (step_uuid) | |
Foreign-key constraints: | |
"contact_id_refs_id_284700c8" FOREIGN KEY (contact_id) REFERENCES contacts_contact(id) DEFERRABLE INITIALLY DEFERRED | |
"run_id_refs_id_c99fbfd8" FOREIGN KEY (run_id) REFERENCES flows_flowrun(id) DEFERRABLE INITIALLY DEFERRED | |
Referenced by: | |
TABLE "flows_flowstep_messages" CONSTRAINT "flowstep_id_refs_id_a83f5888" FOREIGN KEY (flowstep_id) REFERENCES flows_flowstep(id) DEFERRABLE INITIALLY DEFERRED | |
explain analyze SELECT "flows_flowstep"."id", "flows_flowstep"."run_id", "flows_flowstep"."contact_id", "flows_flowstep"."step_type", "flows_flowstep"."step_uuid", "flows_flowstep"."rule_uuid", "flows_flowstep"."rule_category", "flows_flowstep"."rule_value", "flows_flowstep"."rule_decimal_value", "flows_flowstep"."next_uuid", "flows_flowstep"."arrived_on", "flows_flowstep"."left_on" FROM "flows_flowstep" WHERE ("flows_flowstep"."step_uuid" = '76e71f2a-f15a-405d-b81f-36e847d3f09b' AND "flows_flowstep"."next_uuid" = '9fca130c-eba5-4445-8ab9-88c60f55690b') ORDER BY "flows_flowstep"."left_on" DESC LIMIT 15; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
http://explain.depesz.com/s/BBUC