Skip to content

Instantly share code, notes, and snippets.

@qpfiffer
Created March 19, 2013 08:53
Show Gist options
  • Save qpfiffer/5194613 to your computer and use it in GitHub Desktop.
Save qpfiffer/5194613 to your computer and use it in GitHub Desktop.
waiting_locktype | waiting_table | waiting_query | waiting_mode | waiting_pid | other_locktype | other_table | other_query | other_mode | other_pid | other_granted
------------------+-----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+-------------+----------------+-----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+-----------+---------------
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | f
relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | f
relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 8113 | t
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 8113 | t
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 8113 | t
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 8113 | t
relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 8113 | t
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 8113 | t
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 8113 | t
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | f
relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | f
relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 3369 | t
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 3369 | t
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 3369 | t
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 3369 | t
relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 3369 | t
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 3369 | t
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 3369 | t
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | f
relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 7571 | t
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 7571 | t
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 7571 | t
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 7571 | t
relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 7571 | t
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 7571 | t
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 7571 | t
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 32087 | t
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 32087 | t
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 32087 | t
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 32087 | t
relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 32087 | t
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 32087 | t
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | relation | drops_droppoint | <IDLE> in transaction | AccessShareLock | 32087 | t
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24707 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26416 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26765 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | f
relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" | AccessShareLock | 25595 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | f
relation | drops_droppoint | ALTER TABLE drops_droppoint ADD COLUMN test_column INTEGER; | AccessExclusiveLock | 22712 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | f
relation | drops_droppoint | SELECT "drops_droppoint"."id", "drops_droppoint"."created_at", "drops_droppoint"."created_by", "drops_droppoint"."updated_at", "drops_droppoint"."updated_by", "drops_droppoint"."_aggregate_searchable_field", "drops_droppoint"."country_id", "drops_droppoint"."province_id", "drops_droppoint"."state_id", "drops_droppoint"."address_1", "drops_droppoint"."address_2", "drops_droppoint"."city", "drops_droppoint"."postal_code", "drops_droppoint"."contact_name", "drops_droppoint"."phone", "drops_droppoint"."fax", "drops_droppoint"."note", "drops_droppoint"."primary_contact_id", "drops_droppoint"."directions", "drops_droppoint"."active", "drops_droppoint"."exclusivity", "drops_droppoint"."_preferences_id", "drops_droppoint"."min_order_adjustment" FROM "drops_droppoint" WHERE "drops_droppoint"."primary_contact_id" = 391464 ORDER BY "drops_droppoint"."contact_name" ASC | AccessShareLock | 26346 | relation | drops_droppoint | SELECT COUNT(*) FROM "drops_droppoint" WHERE "drops_droppoint"."active" = true | AccessShareLock | 24742 | f
(70 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment