Advertisement
chrissharp123

Untitled

Sep 9th, 2020
454
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.14 KB | None | 0 0
  1. 2020-09-09 14:42:41 next-db01 postgres[27994]: [1723-1] 2020-09-09 14:42:41.150 EDT [27994] evergreen@evergreen LOG: duration: 21003.982 ms statement: SELECT "aump".id, "aump".create_date, "aump".ausp_set_date, "aump".aum_create_date, "aump".read_date, "aump".org_unit, "aump".ausp_org_unit, "aump".aum_sending_lib, "aump".ausp_id, "aump".aum_id, "aump".deleted, "aump".title, "aump".usr, "aump".ausp_usr, "aump".aum_usr, "aump".message, "aump".pub, "aump".stop_date, "aump".ausp_stop_date, "aump".aum_stop_date, "aump".editor, "aump".edit_date, "aump".staff, "aump".standing_penalty, "aump".ausp_usr_message FROM actor.usr_message_penalty AS "aump" LEFT JOIN actor.usr AS "__au_2" ON ( "__au_2".id = "aump".editor ) LEFT JOIN actor.usr AS "__au_1" ON ( "__au_1".id = "aump".staff ) LEFT JOIN actor.org_unit AS "__aou_1" ON ( "__aou_1".id = "aump".org_unit ) LEFT JOIN config.standing_penalty AS "__csp_1" ON ( "__csp_1".id = "aump".standing_penalty
  2. 2020-09-09 14:42:41 next-db01 postgres[27994]: [1723-2] ) LEFT JOIN actor.usr AS "__au_3" ON ( "__au_3".id = "aump".usr ) WHERE "aump".create_date BETWEEN '2019-09-09' AND 'now' AND "aump".stop_date <= 'now' AND "aump".org_unit IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166,
  3. 2020-09-09 14:42:41 next-db01 postgres[27994]: [1723-3] 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 275, 276, 278, 279, 280, 281, 282, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 326, 328, 329, 330, 331, 333, 335, 336, 337, 340, 342, 343, 344, 345, 346, 347, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358,
  4. 2020-09-09 14:42:41 next-db01 postgres[27994]: [1723-4] 360, 361, 362, 365, 366, 367, 369, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 401, 402, 403, 404, 405) AND "aump".usr = '3673957' ORDER BY "aump".create_date ASC LIMIT 25 OFFSET 0;
  5.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement