gistfile1.sql

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"."rule_uuid" IS NULL AND 
           "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;


       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

http://explain.depesz.com/s/CkuB