API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 17th, 2020
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.76 KB | None | 0 0
raw download clone embed print report
  1. -[ RECORD 1 ]-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  2. query | +
  3. | SELECT DISTINCT uid +
  4. | FROM ( +
  5. | -- users_followers user_id +
  6. | SELECT s.user_id as uid +
  7. | FROM users_followers s +
  8. | INNER JOIN users u ON u.id=s.follower_id AND u.active=? +
  9. | WHERE s.follower_id=? AND s.is_expired=? AND s.is_muted=? +
  10. | -- users_followers follower_id +
  11. | UNION ALL +
  12. | SELECT s.follower_id as uid +
  13. | FROM users_followers s +
  14. | INNER JOIN users u ON u.id=s.user_id AND u.active=? +
  15. | WHERE s.user_id=? AND s.is_expired=? AND s.is_muted=? +
  16. | ) sub +
  17. | LEFT JOIN public.users_blocks ub1 ON (ub1.user_id = ? AND ub1.blocked_user_id = sub.uid) +
  18. | LEFT JOIN public.users_blocks ub2 ON (ub2.user_id = sub.uid AND ub2.blocked_user_id = ?) +
  19. | WHERE ub1.id IS NULL AND ub2.id IS NULL +
  20. |
  21. calls | 113643
  22. total_time | 48641960.806
  23. rows | 646634923
  24. hit_percent | 99.9999999646179235
  25. -[ RECORD 2 ]-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  26. query | SELECT "users_posts".* +
  27. | FROM users_posts, to_tsquery(?, ?) query +
  28. | WHERE users_posts.active =? +
  29. | AND users_posts.is_media_ready =? +
  30. | AND "users_posts"."publish_date" <= ? +
  31. | AND "users_posts"."media_type" = ? +
  32. | AND (users_posts.user_id NOT IN (SELECT id FROM users WHERE users_posts.is_free=? AND users.subscribe_price>?)) +
  33. | AND (users_posts.user_id NOT IN (SELECT id FROM users WHERE active=? OR is_private=?)) +
  34. | AND (users_posts.user_id NOT IN (SELECT user_id FROM users_blocks WHERE blocked_user_id=? )) +
  35. | AND ((tsvector @@ query) OR users_posts.text ILIKE ?) +
  36. | ORDER BY ts_rank_cd(tsvector, query) DESC +
  37. | LIMIT ? OFFSET ?
  38. calls | 531
  39. total_time | 16125399.067
  40. rows | 101655
  41. hit_percent | 99.9999801320076967
  42. -[ RECORD 3 ]-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  43. query | SELECT "users_posts".* +
  44. | FROM users_posts, to_tsquery(?, ?) query +
  45. | WHERE users_posts.active =? +
  46. | AND users_posts.is_media_ready =? +
  47. | AND "users_posts"."publish_date" <= ? +
  48. | AND (users_posts.user_id NOT IN (SELECT id FROM users WHERE users_posts.is_free=? AND users.subscribe_price>?)) +
  49. | AND (users_posts.user_id NOT IN (SELECT id FROM users WHERE active=? OR is_private=?)) +
  50. | AND (users_posts.user_id NOT IN (SELECT user_id FROM users_blocks WHERE blocked_user_id=? )) +
  51. | AND ((tsvector @@ query) OR users_posts.text ILIKE ?) +
  52. | ORDER BY ts_rank_cd(tsvector, query) DESC +
  53. | LIMIT ? OFFSET ?
  54. calls | 247
  55. total_time | 14005323.794
  56. rows | 48981
  57. hit_percent | 99.9999956809228496
  58. -[ RECORD 4 ]-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  59. query | SELECT COUNT(*) AS "records_found" +
  60. | FROM users_favorites +
  61. | JOIN "users_posts" ON ("users_posts"."id" = "users_favorites"."post_id") +
  62. | JOIN "users" ON ("users"."id" = "users_favorites"."owner_id") +
  63. | LEFT OUTER JOIN "users_blocks" ON ("users_blocks"."user_id" = "users_posts"."user_id" AND "users_blocks"."blocked_user_id" = ?) +
  64. | LEFT OUTER JOIN "users_subscribers" ON ("users_subscribers"."user_id" = "users_favorites"."owner_id" AND "users_subscribers"."subscriber_id" = "users_favorites"."user_id") +
  65. | LEFT OUTER JOIN "users_followers" ON ("users_followers"."user_id" = "users_favorites"."owner_id" AND "users_followers"."follower_id" = "users_favorites"."user_id") +
  66. | WHERE "users_favorites"."user_id" = ? +
  67. | AND users_posts.active =? +
  68. | AND users.active =? +
  69. | AND users_blocks.id IS NULL +
  70. | AND ((users_favorites.owner_id = ?) OR (users.is_private=?) OR (users.is_performer=? AND users_subscribers.is_expired=?) OR (users.is_performer=? AND users_followers.is_expired=?))
  71. calls | 216894
  72. total_time | 10121849.0879883
  73. rows | 216894
  74. hit_percent | 99.9998773254431884
  75. -[ RECORD 5 ]-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  76. query | SELECT COUNT(*) AS "records_found" +
  77. | FROM users_followers +
  78. | JOIN "users" ON ("users"."id" = "users_followers"."user_id") +
  79. | LEFT OUTER JOIN "users_blocks" ON ("users_blocks"."user_id" = "users_followers"."user_id" AND "users_blocks"."blocked_user_id" = ?) +
  80. | WHERE users_followers.is_expired =? +
  81. | AND "users_followers"."follower_id" = ? +
  82. | AND users_blocks.id IS NULL +
  83. | AND users.active =?
  84. calls | 216894
  85. total_time | 9962275.84500026
  86. rows | 216894
  87. hit_percent | 99.9995264772639060
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!