Advertisement
Guest User

Untitled

a guest
Apr 16th, 2014
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. Product Load (1.1ms) SELECT "products".* FROM "products" WHERE "products"."vtex_identifier" = '158677' LIMIT 1
  2. (0.2ms) BEGIN
  3. (0.4ms) UPDATE "products" SET "provider_id" = 3, "updated_at" = '2014-02-19 15:14:32.404889' WHERE "products"."id" = 469
  4. (0.5ms) COMMIT
  5. Product Load (5.8ms) SELECT "products".* FROM "products" WHERE "products"."vtex_identifier" = '157683' LIMIT 1
  6.  
  7.  
  8. EXPLAIN (0.5ms) EXPLAIN SELECT "products".* FROM "products" WHERE "products"."vtex_identifier" = '157683' LIMIT 1
  9. EXPLAIN for: SELECT "products".* FROM "products" WHERE "products"."vtex_identifier" = '157683' LIMIT 1
  10. QUERY PLAN
  11. ------------------------------------------------------------------
  12. Limit (cost=0.00..226.53 rows=1 width=267)
  13. -> Seq Scan on products (cost=0.00..226.53 rows=1 width=267)
  14. Filter: ((vtex_identifier)::text = '157683'::text)
  15. (3 rows)
  16.  
  17.  
  18. (0.2ms) BEGIN
  19. (0.4ms) UPDATE "products" SET "provider_id" = 3, "updated_at" = '2014-02-19 15:14:32.920676' WHERE "products"."id" = 470
  20. (0.5ms) COMMIT
  21.  
  22. config.active_record.auto_explain_threshold_in_seconds = 0.5
  23.  
  24. config.active_record.auto_explain_threshold_in_seconds = nil
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement