1{ 2 "fs_blocksize": 4096, 3 "new_processes": { 4 "6221": { 5 "application_name": "pgbench", 6 "client": "local", 7 "cpu": null, 8 "database": "pgbench", 9 "duration": -0.002731, 10 "extras": { 11 "cpu_percent": 0.0, 12 "cpu_times": [ 13 0.29, 14 0.04, 15 0, 16 0, 17 0.06 18 ], 19 "io_read": { 20 "bytes": 172032, 21 "chars": 6141498, 22 "count": 830 23 }, 24 "io_time": 1596806345.17328, 25 "io_wait": false, 26 "io_write": { 27 "bytes": 4046848, 28 "chars": 4251702, 29 "count": 388 30 }, 31 "mem_percent": 1.05984334480723, 32 "meminfo": [ 33 65454080, 34 219631616, 35 63139840, 36 4608000, 37 0, 38 2908160, 39 0 40 ], 41 "psutil_proc": null, 42 "read_delta": 0.0, 43 "write_delta": 0.0 44 }, 45 "is_parallel_worker": false, 46 "mem": null, 47 "pid": 6221, 48 "query": "END;", 49 "read": null, 50 "state": "active", 51 "user": "postgres", 52 "wait": false, 53 "write": null 54 }, 55 "6222": { 56 "application_name": "pgbench", 57 "client": "local", 58 "cpu": null, 59 "database": "pgbench", 60 "duration": -0.003539, 61 "extras": { 62 "cpu_percent": 0.0, 63 "cpu_times": [ 64 0.26, 65 0.07, 66 0, 67 0, 68 0.05 69 ], 70 "io_read": { 71 "bytes": 151552, 72 "chars": 6018613, 73 "count": 810 74 }, 75 "io_time": 1596806345.17619, 76 "io_wait": false, 77 "io_write": { 78 "bytes": 5177344, 79 "chars": 5357617, 80 "count": 422 81 }, 82 "mem_percent": 1.06654197921434, 83 "meminfo": [ 84 65867776, 85 219631616, 86 63553536, 87 4608000, 88 0, 89 2908160, 90 0 91 ], 92 "psutil_proc": null, 93 "read_delta": 0.0, 94 "write_delta": 0.0 95 }, 96 "is_parallel_worker": false, 97 "mem": null, 98 "pid": 6222, 99 "query": "SELECT abalance FROM pgbench_accounts WHERE aid = 883793;", 100 "read": null, 101 "state": "active", 102 "user": "postgres", 103 "wait": null, 104 "write": null 105 }, 106 "6223": { 107 "application_name": "pgbench", 108 "client": "local", 109 "cpu": null, 110 "database": "pgbench", 111 "duration": -0.002385, 112 "extras": { 113 "cpu_percent": 0.0, 114 "cpu_times": [ 115 0.27, 116 0.05, 117 0, 118 0, 119 0.03 120 ], 121 "io_read": { 122 "bytes": 131072, 123 "chars": 6043191, 124 "count": 815 125 }, 126 "io_time": 1596806345.17112, 127 "io_wait": false, 128 "io_write": { 129 "bytes": 4186112, 130 "chars": 4399155, 131 "count": 391 132 }, 133 "mem_percent": 1.03470688500235, 134 "meminfo": [ 135 63901696, 136 219631616, 137 61587456, 138 4608000, 139 0, 140 2908160, 141 0 142 ], 143 "psutil_proc": null, 144 "read_delta": 0.0, 145 "write_delta": 0.0 146 }, 147 "is_parallel_worker": false, 148 "mem": null, 149 "pid": 6223, 150 "query": "END;", 151 "read": null, 152 "state": "active", 153 "user": "postgres", 154 "wait": true, 155 "write": null 156 }, 157 "6224": { 158 "application_name": "pgbench", 159 "client": "local", 160 "cpu": null, 161 "database": "pgbench", 162 "duration": -0.00302, 163 "extras": { 164 "cpu_percent": 0.0, 165 "cpu_times": [ 166 0.24, 167 0.08, 168 0, 169 0, 170 0.03 171 ], 172 "io_read": { 173 "bytes": 208896, 174 "chars": 5846582, 175 "count": 790 176 }, 177 "io_time": 1596806345.17362, 178 "io_wait": false, 179 "io_write": { 180 "bytes": 4792320, 181 "chars": 4988978, 182 "count": 405 183 }, 184 "mem_percent": 1.05911379056487, 185 "meminfo": [ 186 65409024, 187 219631616, 188 63094784, 189 4608000, 190 0, 191 2908160, 192 0 193 ], 194 "psutil_proc": null, 195 "read_delta": 0.0, 196 "write_delta": 0.0 197 }, 198 "is_parallel_worker": false, 199 "mem": null, 200 "pid": 6224, 201 "query": "END;", 202 "read": null, 203 "state": "active", 204 "user": "postgres", 205 "wait": true, 206 "write": null 207 }, 208 "6225": { 209 "application_name": "pgbench", 210 "client": "local", 211 "cpu": null, 212 "database": "pgbench", 213 "duration": -0.002305, 214 "extras": { 215 "cpu_percent": 0.0, 216 "cpu_times": [ 217 0.27, 218 0.05, 219 0, 220 0, 221 0.07 222 ], 223 "io_read": { 224 "bytes": 192512, 225 "chars": 5830194, 226 "count": 784 227 }, 228 "io_time": 1596806345.17073, 229 "io_wait": false, 230 "io_write": { 231 "bytes": 5439488, 232 "chars": 5603374, 233 "count": 416 234 }, 235 "mem_percent": 1.04127287318358, 236 "meminfo": [ 237 64307200, 238 219631616, 239 61992960, 240 4608000, 241 0, 242 2908160, 243 0 244 ], 245 "psutil_proc": null, 246 "read_delta": 0.0, 247 "write_delta": 0.0 248 }, 249 "is_parallel_worker": false, 250 "mem": null, 251 "pid": 6225, 252 "query": "END;", 253 "read": null, 254 "state": "active", 255 "user": "postgres", 256 "wait": "ClientRead", 257 "write": null 258 }, 259 "6226": { 260 "application_name": "pgbench", 261 "client": "local", 262 "cpu": null, 263 "database": "pgbench", 264 "duration": -0.002623, 265 "extras": { 266 "cpu_percent": 0.0, 267 "cpu_times": [ 268 0.24, 269 0.07, 270 0, 271 0, 272 0.06 273 ], 274 "io_read": { 275 "bytes": 102400, 276 "chars": 5715499, 277 "count": 763 278 }, 279 "io_time": 1596806345.17196, 280 "io_wait": false, 281 "io_write": { 282 "bytes": 4792320, 283 "chars": 4964391, 284 "count": 390 285 }, 286 "mem_percent": 1.05148663257659, 287 "meminfo": [ 288 64937984, 289 219631616, 290 62623744, 291 4608000, 292 0, 293 2908160, 294 0 295 ], 296 "psutil_proc": null, 297 "read_delta": 0.0, 298 "write_delta": 0.0 299 }, 300 "is_parallel_worker": false, 301 "mem": null, 302 "pid": 6226, 303 "query": "END;", 304 "read": null, 305 "state": "active", 306 "user": "postgres", 307 "wait": "LogicalRepWorkerLock", 308 "write": null 309 }, 310 "6227": { 311 "application_name": "pgbench", 312 "client": "local", 313 "cpu": null, 314 "database": "pgbench", 315 "duration": -0.002693, 316 "extras": { 317 "cpu_percent": 0.0, 318 "cpu_times": [ 319 0.26, 320 0.06, 321 0, 322 0, 323 0.06 324 ], 325 "io_read": { 326 "bytes": 131072, 327 "chars": 5789225, 328 "count": 770 329 }, 330 "io_time": 1596806345.17287, 331 "io_wait": false, 332 "io_write": { 333 "bytes": 5095424, 334 "chars": 5234725, 335 "count": 394 336 }, 337 "mem_percent": 1.04153816563534, 338 "meminfo": [ 339 64323584, 340 219631616, 341 62009344, 342 4608000, 343 0, 344 2908160, 345 0 346 ], 347 "psutil_proc": null, 348 "read_delta": 0.0, 349 "write_delta": 0.0 350 }, 351 "is_parallel_worker": false, 352 "mem": null, 353 "pid": 6227, 354 "query": "UPDATE pgbench_branches SET bbalance = bbalance + -1015 WHERE bid = 77;", 355 "read": null, 356 "state": "active", 357 "user": "postgres", 358 "wait": true, 359 "write": null 360 }, 361 "6228": { 362 "application_name": "pgbench", 363 "client": "local", 364 "cpu": null, 365 "database": "pgbench", 366 "duration": -0.003339, 367 "extras": { 368 "cpu_percent": 0.0, 369 "cpu_times": [ 370 0.26, 371 0.06, 372 0, 373 0, 374 0.03 375 ], 376 "io_read": { 377 "bytes": 98304, 378 "chars": 5781046, 379 "count": 782 380 }, 381 "io_time": 1596806345.17414, 382 "io_wait": false, 383 "io_write": { 384 "bytes": 5259264, 385 "chars": 5496882, 386 "count": 444 387 }, 388 "mem_percent": 1.02475841806111, 389 "meminfo": [ 390 63287296, 391 219631616, 392 60973056, 393 4608000, 394 0, 395 2908160, 396 0 397 ], 398 "psutil_proc": null, 399 "read_delta": 0.0, 400 "write_delta": 0.0 401 }, 402 "is_parallel_worker": false, 403 "mem": null, 404 "pid": 6228, 405 "query": "UPDATE pgbench_accounts SET abalance = abalance + 3062 WHERE aid = 7289374;", 406 "read": null, 407 "state": "active", 408 "user": "postgres", 409 "wait": false, 410 "write": null 411 }, 412 "6229": { 413 "application_name": "pgbench", 414 "client": "local", 415 "cpu": null, 416 "database": "pgbench", 417 "duration": -0.003353, 418 "extras": { 419 "cpu_percent": 0.0, 420 "cpu_times": [ 421 0.25, 422 0.06, 423 0, 424 0, 425 0.04 426 ], 427 "io_read": { 428 "bytes": 184320, 429 "chars": 5928507, 430 "count": 805 431 }, 432 "io_time": 1596806345.17465, 433 "io_wait": false, 434 "io_write": { 435 "bytes": 4702208, 436 "chars": 4866103, 437 "count": 408 438 }, 439 "mem_percent": 1.03052852888703, 440 "meminfo": [ 441 63643648, 442 219631616, 443 61329408, 444 4608000, 445 0, 446 2908160, 447 0 448 ], 449 "psutil_proc": null, 450 "read_delta": 0.0, 451 "write_delta": 0.0 452 }, 453 "is_parallel_worker": false, 454 "mem": null, 455 "pid": 6229, 456 "query": "END;", 457 "read": null, 458 "state": "active", 459 "user": "postgres", 460 "wait": true, 461 "write": null 462 }, 463 "6230": { 464 "application_name": "pgbench", 465 "client": "local", 466 "cpu": null, 467 "database": "pgbench", 468 "duration": -0.003495, 469 "extras": { 470 "cpu_percent": 0.0, 471 "cpu_times": [ 472 0.26, 473 0.05, 474 0, 475 0, 476 0.08 477 ], 478 "io_read": { 479 "bytes": 90112, 480 "chars": 5666362, 481 "count": 772 482 }, 483 "io_time": 1596806345.17591, 484 "io_wait": false, 485 "io_write": { 486 "bytes": 4374528, 487 "chars": 4489270, 488 "count": 376 489 }, 490 "mem_percent": 1.05241515615777, 491 "meminfo": [ 492 64995328, 493 219631616, 494 62681088, 495 4608000, 496 0, 497 2908160, 498 0 499 ], 500 "psutil_proc": null, 501 "read_delta": 0.0, 502 "write_delta": 0.0 503 }, 504 "is_parallel_worker": false, 505 "mem": null, 506 "pid": 6230, 507 "query": "END;", 508 "read": null, 509 "state": "active", 510 "user": "postgres", 511 "wait": true, 512 "write": null 513 }, 514 "6231": { 515 "application_name": "pgbench", 516 "client": "local", 517 "cpu": null, 518 "database": "pgbench", 519 "duration": -0.003384, 520 "extras": { 521 "cpu_percent": 0.0, 522 "cpu_times": [ 523 0.25, 524 0.05, 525 0, 526 0, 527 0.04 528 ], 529 "io_read": { 530 "bytes": 204800, 531 "chars": 5658169, 532 "count": 770 533 }, 534 "io_time": 1596806345.17499, 535 "io_wait": false, 536 "io_write": { 537 "bytes": 4481024, 538 "chars": 4595765, 539 "count": 395 540 }, 541 "mem_percent": 1.03119176001645, 542 "meminfo": [ 543 63684608, 544 219631616, 545 61370368, 546 4608000, 547 0, 548 2908160, 549 0 550 ], 551 "psutil_proc": null, 552 "read_delta": 0.0, 553 "write_delta": 0.0 554 }, 555 "is_parallel_worker": false, 556 "mem": null, 557 "pid": 6231, 558 "query": "UPDATE pgbench_accounts SET abalance = abalance + 157 WHERE aid = 4244124;", 559 "read": null, 560 "state": "active", 561 "user": "postgres", 562 "wait": false, 563 "write": null 564 }, 565 "6232": { 566 "application_name": "pgbench", 567 "client": "local", 568 "cpu": null, 569 "database": "pgbench", 570 "duration": -0.002212, 571 "extras": { 572 "cpu_percent": 0.0, 573 "cpu_times": [ 574 0.27, 575 0.05, 576 0, 577 0, 578 0.04 579 ], 580 "io_read": { 581 "bytes": 114688, 582 "chars": 5838385, 583 "count": 784 584 }, 585 "io_time": 1596806345.16938, 586 "io_wait": false, 587 "io_write": { 588 "bytes": 4718592, 589 "chars": 4890669, 590 "count": 423 591 }, 592 "mem_percent": 1.05493543444955, 593 "meminfo": [ 594 65150976, 595 219631616, 596 62836736, 597 4608000, 598 0, 599 2908160, 600 0 601 ], 602 "psutil_proc": null, 603 "read_delta": 0.0, 604 "write_delta": 0.0 605 }, 606 "is_parallel_worker": false, 607 "mem": null, 608 "pid": 6232, 609 "query": "END;", 610 "read": null, 611 "state": "active", 612 "user": "postgres", 613 "wait": true, 614 "write": null 615 }, 616 "6233": { 617 "application_name": "pgbench", 618 "client": "local", 619 "cpu": null, 620 "database": "pgbench", 621 "duration": -0.002273, 622 "extras": { 623 "cpu_percent": 0.0, 624 "cpu_times": [ 625 0.27, 626 0.05, 627 0, 628 0, 629 0.05 630 ], 631 "io_read": { 632 "bytes": 212992, 633 "chars": 5600824, 634 "count": 762 635 }, 636 "io_time": 1596806345.17035, 637 "io_wait": false, 638 "io_write": { 639 "bytes": 4939776, 640 "chars": 5029940, 641 "count": 403 642 }, 643 "mem_percent": 1.026018557207, 644 "meminfo": [ 645 63365120, 646 219631616, 647 61050880, 648 4608000, 649 0, 650 2908160, 651 0 652 ], 653 "psutil_proc": null, 654 "read_delta": 0.0, 655 "write_delta": 0.0 656 }, 657 "is_parallel_worker": false, 658 "mem": null, 659 "pid": 6233, 660 "query": "END;", 661 "read": null, 662 "state": "active", 663 "user": "postgres", 664 "wait": true, 665 "write": null 666 }, 667 "6234": { 668 "application_name": "pgbench", 669 "client": "local", 670 "cpu": null, 671 "database": "pgbench", 672 "duration": -0.002408, 673 "extras": { 674 "cpu_percent": 0.0, 675 "cpu_times": [ 676 0.24, 677 0.05, 678 0, 679 0, 680 0.03 681 ], 682 "io_read": { 683 "bytes": 131072, 684 "chars": 5649976, 685 "count": 768 686 }, 687 "io_time": 1596806345.17153, 688 "io_wait": false, 689 "io_write": { 690 "bytes": 4177920, 691 "chars": 4358196, 692 "count": 389 693 }, 694 "mem_percent": 1.03702819395531, 695 "meminfo": [ 696 64045056, 697 219631616, 698 61730816, 699 4608000, 700 0, 701 2908160, 702 0 703 ], 704 "psutil_proc": null, 705 "read_delta": 0.0, 706 "write_delta": 0.0 707 }, 708 "is_parallel_worker": false, 709 "mem": null, 710 "pid": 6234, 711 "query": "END;", 712 "read": null, 713 "state": "active", 714 "user": "postgres", 715 "wait": true, 716 "write": null 717 }, 718 "6235": { 719 "application_name": "pgbench", 720 "client": "local", 721 "cpu": null, 722 "database": "pgbench", 723 "duration": -0.002635, 724 "extras": { 725 "cpu_percent": 0.0, 726 "cpu_times": [ 727 0.23, 728 0.07, 729 0, 730 0, 731 0.07 732 ], 733 "io_read": { 734 "bytes": 143360, 735 "chars": 5576246, 736 "count": 757 737 }, 738 "io_time": 1596806345.17238, 739 "io_wait": false, 740 "io_write": { 741 "bytes": 4661248, 742 "chars": 4784178, 743 "count": 422 744 }, 745 "mem_percent": 1.02111064684932, 746 "meminfo": [ 747 63062016, 748 219631616, 749 60747776, 750 4608000, 751 0, 752 2908160, 753 0 754 ], 755 "psutil_proc": null, 756 "read_delta": 0.0, 757 "write_delta": 0.0 758 }, 759 "is_parallel_worker": false, 760 "mem": null, 761 "pid": 6235, 762 "query": "END;", 763 "read": null, 764 "state": "active", 765 "user": "postgres", 766 "wait": true, 767 "write": null 768 }, 769 "6237": { 770 "application_name": "pgbench", 771 "client": "local", 772 "cpu": null, 773 "database": "pgbench", 774 "duration": -0.003559, 775 "extras": { 776 "cpu_percent": 0.0, 777 "cpu_times": [ 778 0.24, 779 0.06, 780 0, 781 0, 782 0.04 783 ], 784 "io_read": { 785 "bytes": 159744, 786 "chars": 5502515, 787 "count": 745 788 }, 789 "io_time": 1596806345.17644, 790 "io_wait": false, 791 "io_write": { 792 "bytes": 4669440, 793 "chars": 4792367, 794 "count": 381 795 }, 796 "mem_percent": 1.00061680495036, 797 "meminfo": [ 798 61796352, 799 219631616, 800 59482112, 801 4608000, 802 0, 803 2908160, 804 0 805 ], 806 "psutil_proc": null, 807 "read_delta": 0.0, 808 "write_delta": 0.0 809 }, 810 "is_parallel_worker": false, 811 "mem": null, 812 "pid": 6237, 813 "query": "UPDATE pgbench_tellers SET tbalance = tbalance + 566 WHERE tid = 733;", 814 "read": null, 815 "state": "active", 816 "user": "postgres", 817 "wait": false, 818 "write": null 819 }, 820 "6238": { 821 "application_name": "pgbench", 822 "client": "local", 823 "cpu": null, 824 "database": "pgbench", 825 "duration": -0.003481, 826 "extras": { 827 "cpu_percent": 0.0, 828 "cpu_times": [ 829 0.25, 830 0.05, 831 0, 832 0, 833 0.06 834 ], 835 "io_read": { 836 "bytes": 110592, 837 "chars": 5625388, 838 "count": 753 839 }, 840 "io_time": 1596806345.17561, 841 "io_wait": false, 842 "io_write": { 843 "bytes": 4923392, 844 "chars": 5103656, 845 "count": 399 846 }, 847 "mem_percent": 1.02741134257878, 848 "meminfo": [ 849 63451136, 850 219631616, 851 61136896, 852 4608000, 853 0, 854 2908160, 855 0 856 ], 857 "psutil_proc": null, 858 "read_delta": 0.0, 859 "write_delta": 0.0 860 }, 861 "is_parallel_worker": false, 862 "mem": null, 863 "pid": 6238, 864 "query": "UPDATE pgbench_accounts SET abalance = abalance + -3113 WHERE aid = 8943851;", 865 "read": null, 866 "state": "active", 867 "user": "postgres", 868 "wait": false, 869 "write": null 870 }, 871 "6239": { 872 "application_name": "pgbench", 873 "client": "local", 874 "cpu": null, 875 "database": "pgbench", 876 "duration": -0.003428, 877 "extras": { 878 "cpu_percent": 0.0, 879 "cpu_times": [ 880 0.24, 881 0.05, 882 0, 883 0, 884 0.06 885 ], 886 "io_read": { 887 "bytes": 86016, 888 "chars": 5461562, 889 "count": 747 890 }, 891 "io_time": 1596806345.1753, 892 "io_wait": false, 893 "io_write": { 894 "bytes": 4382720, 895 "chars": 4546614, 896 "count": 383 897 }, 898 "mem_percent": 0.993254939413836, 899 "meminfo": [ 900 61341696, 901 219631616, 902 59027456, 903 4608000, 904 0, 905 2908160, 906 0 907 ], 908 "psutil_proc": null, 909 "read_delta": 0.0, 910 "write_delta": 0.0 911 }, 912 "is_parallel_worker": false, 913 "mem": null, 914 "pid": 6239, 915 "query": "UPDATE pgbench_accounts SET abalance = abalance + 141 WHERE aid = 1932841;", 916 "read": null, 917 "state": "idle in transaction", 918 "user": "postgres", 919 "wait": false, 920 "write": null 921 }, 922 "6240": { 923 "application_name": "pgbench", 924 "client": "local", 925 "cpu": null, 926 "database": "pgbench", 927 "duration": -0.002256, 928 "extras": { 929 "cpu_percent": 0.0, 930 "cpu_times": [ 931 0.23, 932 0.05, 933 0, 934 0, 935 0.03 936 ], 937 "io_read": { 938 "bytes": 253952, 939 "chars": 5510687, 940 "count": 726 941 }, 942 "io_time": 1596806345.16992, 943 "io_wait": false, 944 "io_write": { 945 "bytes": 3850240, 946 "chars": 4005915, 947 "count": 344 948 }, 949 "mem_percent": 1.02137593930109, 950 "meminfo": [ 951 63078400, 952 219631616, 953 60772352, 954 4608000, 955 0, 956 2908160, 957 0 958 ], 959 "psutil_proc": null, 960 "read_delta": 0.0, 961 "write_delta": 0.0 962 }, 963 "is_parallel_worker": false, 964 "mem": null, 965 "pid": 6240, 966 "query": "END;", 967 "read": null, 968 "state": "active", 969 "user": "postgres", 970 "wait": true, 971 "write": null 972 } 973 }, 974 "processes": { 975 "6221": { 976 "application_name": "pgbench", 977 "client": "local", 978 "cpu": null, 979 "database": "pgbench", 980 "duration": -0.002794, 981 "extras": { 982 "cpu_percent": 0.0, 983 "cpu_times": [ 984 0.29, 985 0.04, 986 0, 987 0, 988 0.06 989 ], 990 "io_read": { 991 "bytes": 163840, 992 "chars": 6035002, 993 "count": 817 994 }, 995 "io_time": 1596806345.13955, 996 "io_wait": false, 997 "io_write": { 998 "bytes": 3915776, 999 "chars": 4112438, 1000 "count": 379 1001 }, 1002 "mem_percent": 1.03444159255059, 1003 "meminfo": [ 1004 63885312, 1005 219631616, 1006 61571072, 1007 4608000, 1008 0, 1009 2908160, 1010 0 1011 ], 1012 "psutil_proc": null, 1013 "read_delta": 0.0, 1014 "write_delta": 0.0 1015 }, 1016 "is_parallel_worker": false, 1017 "mem": null, 1018 "pid": 6221, 1019 "query": "END;", 1020 "read": null, 1021 "state": "active", 1022 "user": "postgres", 1023 "wait": false, 1024 "write": null 1025 }, 1026 "6222": { 1027 "application_name": "pgbench", 1028 "client": "local", 1029 "cpu": null, 1030 "database": "pgbench", 1031 "duration": -0.003188, 1032 "extras": { 1033 "cpu_percent": 0.0, 1034 "cpu_times": [ 1035 0.26, 1036 0.07, 1037 0, 1038 0, 1039 0.05 1040 ], 1041 "io_read": { 1042 "bytes": 151552, 1043 "chars": 5944883, 1044 "count": 799 1045 }, 1046 "io_time": 1596806345.14185, 1047 "io_wait": false, 1048 "io_write": { 1049 "bytes": 5095424, 1050 "chars": 5275695, 1051 "count": 415 1052 }, 1053 "mem_percent": 1.06654197921434, 1054 "meminfo": [ 1055 65867776, 1056 219631616, 1057 63553536, 1058 4608000, 1059 0, 1060 2908160, 1061 0 1062 ], 1063 "psutil_proc": null, 1064 "read_delta": 0.0, 1065 "write_delta": 0.0 1066 }, 1067 "is_parallel_worker": false, 1068 "mem": null, 1069 "pid": 6222, 1070 "query": "UPDATE pgbench_branches SET bbalance = bbalance + 1107 WHERE bid = 84;", 1071 "read": null, 1072 "state": "idle in transaction", 1073 "user": "postgres", 1074 "wait": false, 1075 "write": null 1076 }, 1077 "6223": { 1078 "application_name": "pgbench", 1079 "client": "local", 1080 "cpu": null, 1081 "database": "pgbench", 1082 "duration": -0.00347, 1083 "extras": { 1084 "cpu_percent": 0.0, 1085 "cpu_times": [ 1086 0.27, 1087 0.05, 1088 0, 1089 0, 1090 0.03 1091 ], 1092 "io_read": { 1093 "bytes": 131072, 1094 "chars": 5961271, 1095 "count": 805 1096 }, 1097 "io_time": 1596806345.1446, 1098 "io_wait": false, 1099 "io_write": { 1100 "bytes": 4145152, 1101 "chars": 4358195, 1102 "count": 386 1103 }, 1104 "mem_percent": 1.03470688500235, 1105 "meminfo": [ 1106 63901696, 1107 219631616, 1108 61587456, 1109 4608000, 1110 0, 1111 2908160, 1112 0 1113 ], 1114 "psutil_proc": null, 1115 "read_delta": 0.0, 1116 "write_delta": 0.0 1117 }, 1118 "is_parallel_worker": false, 1119 "mem": null, 1120 "pid": 6223, 1121 "query": "END;", 1122 "read": null, 1123 "state": "active", 1124 "user": "postgres", 1125 "wait": true, 1126 "write": null 1127 }, 1128 "6224": { 1129 "application_name": "pgbench", 1130 "client": "local", 1131 "cpu": null, 1132 "database": "pgbench", 1133 "duration": -0.003245, 1134 "extras": { 1135 "cpu_percent": 0.0, 1136 "cpu_times": [ 1137 0.23, 1138 0.08, 1139 0, 1140 0, 1141 0.03 1142 ], 1143 "io_read": { 1144 "bytes": 208896, 1145 "chars": 5748277, 1146 "count": 777 1147 }, 1148 "io_time": 1596806345.14246, 1149 "io_wait": false, 1150 "io_write": { 1151 "bytes": 4661248, 1152 "chars": 4849713, 1153 "count": 394 1154 }, 1155 "mem_percent": 1.05911379056487, 1156 "meminfo": [ 1157 65409024, 1158 219631616, 1159 63094784, 1160 4608000, 1161 0, 1162 2908160, 1163 0 1164 ], 1165 "psutil_proc": null, 1166 "read_delta": 0.0, 1167 "write_delta": 0.0 1168 }, 1169 "is_parallel_worker": false, 1170 "mem": null, 1171 "pid": 6224, 1172 "query": "UPDATE pgbench_tellers SET tbalance = tbalance + -4335 WHERE tid = 682;", 1173 "read": null, 1174 "state": "idle in transaction", 1175 "user": "postgres", 1176 "wait": false, 1177 "write": null 1178 }, 1179 "6225": { 1180 "application_name": "pgbench", 1181 "client": "local", 1182 "cpu": null, 1183 "database": "pgbench", 1184 "duration": -0.003286, 1185 "extras": { 1186 "cpu_percent": 0.0, 1187 "cpu_times": [ 1188 0.27, 1189 0.04, 1190 0, 1191 0, 1192 0.07 1193 ], 1194 "io_read": { 1195 "bytes": 192512, 1196 "chars": 5748273, 1197 "count": 773 1198 }, 1199 "io_time": 1596806345.14274, 1200 "io_wait": false, 1201 "io_write": { 1202 "bytes": 5365760, 1203 "chars": 5529645, 1204 "count": 408 1205 }, 1206 "mem_percent": 1.04127287318358, 1207 "meminfo": [ 1208 64307200, 1209 219631616, 1210 61992960, 1211 4608000, 1212 0, 1213 2908160, 1214 0 1215 ], 1216 "psutil_proc": null, 1217 "read_delta": 0.0, 1218 "write_delta": 0.0 1219 }, 1220 "is_parallel_worker": false, 1221 "mem": null, 1222 "pid": 6225, 1223 "query": "INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (297, 63, 5970520, -2396, CURRENT_TIMESTAMP);", 1224 "read": null, 1225 "state": "idle in transaction", 1226 "user": "postgres", 1227 "wait": false, 1228 "write": null 1229 }, 1230 "6226": { 1231 "application_name": "pgbench", 1232 "client": "local", 1233 "cpu": null, 1234 "database": "pgbench", 1235 "duration": -0.003431, 1236 "extras": { 1237 "cpu_percent": 0.0, 1238 "cpu_times": [ 1239 0.24, 1240 0.07, 1241 0, 1242 0, 1243 0.06 1244 ], 1245 "io_read": { 1246 "bytes": 102400, 1247 "chars": 5658154, 1248 "count": 755 1249 }, 1250 "io_time": 1596806345.14365, 1251 "io_wait": false, 1252 "io_write": { 1253 "bytes": 4759552, 1254 "chars": 4931622, 1255 "count": 385 1256 }, 1257 "mem_percent": 1.05148663257659, 1258 "meminfo": [ 1259 64937984, 1260 219631616, 1261 62623744, 1262 4608000, 1263 0, 1264 2908160, 1265 0 1266 ], 1267 "psutil_proc": null, 1268 "read_delta": 0.0, 1269 "write_delta": 0.0 1270 }, 1271 "is_parallel_worker": false, 1272 "mem": null, 1273 "pid": 6226, 1274 "query": "SELECT abalance FROM pgbench_accounts WHERE aid = 518562;", 1275 "read": null, 1276 "state": "idle in transaction", 1277 "user": "postgres", 1278 "wait": false, 1279 "write": null 1280 }, 1281 "6227": { 1282 "application_name": "pgbench", 1283 "client": "local", 1284 "cpu": null, 1285 "database": "pgbench", 1286 "duration": -0.002061, 1287 "extras": { 1288 "cpu_percent": 0.0, 1289 "cpu_times": [ 1290 0.25, 1291 0.06, 1292 0, 1293 0, 1294 0.04 1295 ], 1296 "io_read": { 1297 "bytes": 131072, 1298 "chars": 5699111, 1299 "count": 757 1300 }, 1301 "io_time": 1596806345.13715, 1302 "io_wait": false, 1303 "io_write": { 1304 "bytes": 4915200, 1305 "chars": 5054499, 1306 "count": 382 1307 }, 1308 "mem_percent": 1.01441201244222, 1309 "meminfo": [ 1310 62648320, 1311 219631616, 1312 60334080, 1313 4608000, 1314 0, 1315 2908160, 1316 0 1317 ], 1318 "psutil_proc": null, 1319 "read_delta": 0.0, 1320 "write_delta": 0.0 1321 }, 1322 "is_parallel_worker": false, 1323 "mem": null, 1324 "pid": 6227, 1325 "query": "UPDATE pgbench_branches SET bbalance = bbalance + 4427 WHERE bid = 28;", 1326 "read": null, 1327 "state": "idle in transaction", 1328 "user": "postgres", 1329 "wait": false, 1330 "write": null 1331 }, 1332 "6228": { 1333 "application_name": "pgbench", 1334 "client": "local", 1335 "cpu": null, 1336 "database": "pgbench", 1337 "duration": -0.003475, 1338 "extras": { 1339 "cpu_percent": 0.0, 1340 "cpu_times": [ 1341 0.26, 1342 0.05, 1343 0, 1344 0, 1345 0.03 1346 ], 1347 "io_read": { 1348 "bytes": 98304, 1349 "chars": 5723702, 1350 "count": 775 1351 }, 1352 "io_time": 1596806345.14492, 1353 "io_wait": false, 1354 "io_write": { 1355 "bytes": 5210112, 1356 "chars": 5439538, 1357 "count": 438 1358 }, 1359 "mem_percent": 1.02475841806111, 1360 "meminfo": [ 1361 63287296, 1362 219631616, 1363 60973056, 1364 4608000, 1365 0, 1366 2908160, 1367 0 1368 ], 1369 "psutil_proc": null, 1370 "read_delta": 0.0, 1371 "write_delta": 0.0 1372 }, 1373 "is_parallel_worker": false, 1374 "mem": null, 1375 "pid": 6228, 1376 "query": "SELECT abalance FROM pgbench_accounts WHERE aid = 2514784;", 1377 "read": null, 1378 "state": "active", 1379 "user": "postgres", 1380 "wait": false, 1381 "write": null 1382 }, 1383 "6229": { 1384 "application_name": "pgbench", 1385 "client": "local", 1386 "cpu": null, 1387 "database": "pgbench", 1388 "duration": -0.003226, 1389 "extras": { 1390 "cpu_percent": 0.0, 1391 "cpu_times": [ 1392 0.25, 1393 0.06, 1394 0, 1395 0, 1396 0.04 1397 ], 1398 "io_read": { 1399 "bytes": 184320, 1400 "chars": 5822010, 1401 "count": 791 1402 }, 1403 "io_time": 1596806345.14214, 1404 "io_wait": false, 1405 "io_write": { 1406 "bytes": 4653056, 1407 "chars": 4808758, 1408 "count": 400 1409 }, 1410 "mem_percent": 1.03052852888703, 1411 "meminfo": [ 1412 63643648, 1413 219631616, 1414 61329408, 1415 4608000, 1416 0, 1417 2908160, 1418 0 1419 ], 1420 "psutil_proc": null, 1421 "read_delta": 0.0, 1422 "write_delta": 0.0 1423 }, 1424 "is_parallel_worker": false, 1425 "mem": null, 1426 "pid": 6229, 1427 "query": "END;", 1428 "read": null, 1429 "state": "active", 1430 "user": "postgres", 1431 "wait": true, 1432 "write": null 1433 }, 1434 "6230": { 1435 "application_name": "pgbench", 1436 "client": "local", 1437 "cpu": null, 1438 "database": "pgbench", 1439 "duration": -0.002711, 1440 "extras": { 1441 "cpu_percent": 0.0, 1442 "cpu_times": [ 1443 0.25, 1444 0.04, 1445 0, 1446 0, 1447 0.08 1448 ], 1449 "io_read": { 1450 "bytes": 90112, 1451 "chars": 5527095, 1452 "count": 752 1453 }, 1454 "io_time": 1596806345.13785, 1455 "io_wait": false, 1456 "io_write": { 1457 "bytes": 4161536, 1458 "chars": 4276275, 1459 "count": 366 1460 }, 1461 "mem_percent": 1.05241515615777, 1462 "meminfo": [ 1463 64995328, 1464 219631616, 1465 62681088, 1466 4608000, 1467 0, 1468 2908160, 1469 0 1470 ], 1471 "psutil_proc": null, 1472 "read_delta": 0.0, 1473 "write_delta": 0.0 1474 }, 1475 "is_parallel_worker": false, 1476 "mem": null, 1477 "pid": 6230, 1478 "query": "END;", 1479 "read": null, 1480 "state": "active", 1481 "user": "postgres", 1482 "wait": true, 1483 "write": null 1484 }, 1485 "6231": { 1486 "application_name": "pgbench", 1487 "client": "local", 1488 "cpu": null, 1489 "database": "pgbench", 1490 "duration": -0.001462, 1491 "extras": { 1492 "cpu_percent": 0.0, 1493 "cpu_times": [ 1494 0.24, 1495 0.05, 1496 0, 1497 0, 1498 0.04 1499 ], 1500 "io_read": { 1501 "bytes": 204800, 1502 "chars": 5576248, 1503 "count": 759 1504 }, 1505 "io_time": 1596806345.13624, 1506 "io_wait": false, 1507 "io_write": { 1508 "bytes": 4374528, 1509 "chars": 4489268, 1510 "count": 385 1511 }, 1512 "mem_percent": 1.03119176001645, 1513 "meminfo": [ 1514 63684608, 1515 219631616, 1516 61370368, 1517 4608000, 1518 0, 1519 2908160, 1520 0 1521 ], 1522 "psutil_proc": null, 1523 "read_delta": 0.0, 1524 "write_delta": 0.0 1525 }, 1526 "is_parallel_worker": false, 1527 "mem": null, 1528 "pid": 6231, 1529 "query": "UPDATE pgbench_branches SET bbalance = bbalance + 3357 WHERE bid = 6;", 1530 "read": null, 1531 "state": "idle in transaction", 1532 "user": "postgres", 1533 "wait": false, 1534 "write": null 1535 }, 1536 "6232": { 1537 "application_name": "pgbench", 1538 "client": "local", 1539 "cpu": null, 1540 "database": "pgbench", 1541 "duration": -0.003435, 1542 "extras": { 1543 "cpu_percent": 0.0, 1544 "cpu_times": [ 1545 0.26, 1546 0.05, 1547 0, 1548 0, 1549 0.04 1550 ], 1551 "io_read": { 1552 "bytes": 114688, 1553 "chars": 5772849, 1554 "count": 776 1555 }, 1556 "io_time": 1596806345.14397, 1557 "io_wait": false, 1558 "io_write": { 1559 "bytes": 4669440, 1560 "chars": 4841517, 1561 "count": 417 1562 }, 1563 "mem_percent": 1.03782407131061, 1564 "meminfo": [ 1565 64094208, 1566 219631616, 1567 61779968, 1568 4608000, 1569 0, 1570 2908160, 1571 0 1572 ], 1573 "psutil_proc": null, 1574 "read_delta": 0.0, 1575 "write_delta": 0.0 1576 }, 1577 "is_parallel_worker": false, 1578 "mem": null, 1579 "pid": 6232, 1580 "query": "END;", 1581 "read": null, 1582 "state": "active", 1583 "user": "postgres", 1584 "wait": true, 1585 "write": null 1586 }, 1587 "6233": { 1588 "application_name": "pgbench", 1589 "client": "local", 1590 "cpu": null, 1591 "database": "pgbench", 1592 "duration": -0.00339, 1593 "extras": { 1594 "cpu_percent": 0.0, 1595 "cpu_times": [ 1596 0.26, 1597 0.05, 1598 0, 1599 0, 1600 0.05 1601 ], 1602 "io_read": { 1603 "bytes": 212992, 1604 "chars": 5535288, 1605 "count": 754 1606 }, 1607 "io_time": 1596806345.14303, 1608 "io_wait": false, 1609 "io_write": { 1610 "bytes": 4857856, 1611 "chars": 4948020, 1612 "count": 398 1613 }, 1614 "mem_percent": 1.026018557207, 1615 "meminfo": [ 1616 63365120, 1617 219631616, 1618 61050880, 1619 4608000, 1620 0, 1621 2908160, 1622 0 1623 ], 1624 "psutil_proc": null, 1625 "read_delta": 0.0, 1626 "write_delta": 0.0 1627 }, 1628 "is_parallel_worker": false, 1629 "mem": null, 1630 "pid": 6233, 1631 "query": "UPDATE pgbench_accounts SET abalance = abalance + -1917 WHERE aid = 9235835;", 1632 "read": null, 1633 "state": "active", 1634 "user": "postgres", 1635 "wait": false, 1636 "write": null 1637 }, 1638 "6234": { 1639 "application_name": "pgbench", 1640 "client": "local", 1641 "cpu": null, 1642 "database": "pgbench", 1643 "duration": -0.003179, 1644 "extras": { 1645 "cpu_percent": 0.0, 1646 "cpu_times": [ 1647 0.24, 1648 0.05, 1649 0, 1650 0, 1651 0.03 1652 ], 1653 "io_read": { 1654 "bytes": 131072, 1655 "chars": 5584439, 1656 "count": 759 1657 }, 1658 "io_time": 1596806345.14158, 1659 "io_wait": false, 1660 "io_write": { 1661 "bytes": 4046848, 1662 "chars": 4227123, 1663 "count": 382 1664 }, 1665 "mem_percent": 1.0097693945363, 1666 "meminfo": [ 1667 62361600, 1668 219631616, 1669 60047360, 1670 4608000, 1671 0, 1672 2908160, 1673 0 1674 ], 1675 "psutil_proc": null, 1676 "read_delta": 0.0, 1677 "write_delta": 0.0 1678 }, 1679 "is_parallel_worker": false, 1680 "mem": null, 1681 "pid": 6234, 1682 "query": "SELECT abalance FROM pgbench_accounts WHERE aid = 4511601;", 1683 "read": null, 1684 "state": "idle in transaction", 1685 "user": "postgres", 1686 "wait": false, 1687 "write": null 1688 }, 1689 "6235": { 1690 "application_name": "pgbench", 1691 "client": "local", 1692 "cpu": null, 1693 "database": "pgbench", 1694 "duration": -0.003405, 1695 "extras": { 1696 "cpu_percent": 0.0, 1697 "cpu_times": [ 1698 0.23, 1699 0.07, 1700 0, 1701 0, 1702 0.07 1703 ], 1704 "io_read": { 1705 "bytes": 143360, 1706 "chars": 5510708, 1707 "count": 747 1708 }, 1709 "io_time": 1596806345.14336, 1710 "io_wait": false, 1711 "io_write": { 1712 "bytes": 4587520, 1713 "chars": 4710448, 1714 "count": 414 1715 }, 1716 "mem_percent": 1.02111064684932, 1717 "meminfo": [ 1718 63062016, 1719 219631616, 1720 60747776, 1721 4608000, 1722 0, 1723 2908160, 1724 0 1725 ], 1726 "psutil_proc": null, 1727 "read_delta": 0.0, 1728 "write_delta": 0.0 1729 }, 1730 "is_parallel_worker": false, 1731 "mem": null, 1732 "pid": 6235, 1733 "query": "UPDATE pgbench_accounts SET abalance = abalance + -3841 WHERE aid = 1460066;", 1734 "read": null, 1735 "state": "idle in transaction", 1736 "user": "postgres", 1737 "wait": false, 1738 "write": null 1739 }, 1740 "6236": { 1741 "application_name": "pgbench", 1742 "client": "local", 1743 "cpu": null, 1744 "database": "pgbench", 1745 "duration": -0.002822, 1746 "extras": { 1747 "cpu_percent": 0.0, 1748 "cpu_times": [ 1749 0.25, 1750 0.04, 1751 0, 1752 0, 1753 0.05 1754 ], 1755 "io_read": { 1756 "bytes": 147456, 1757 "chars": 5436966, 1758 "count": 724 1759 }, 1760 "io_time": 1596806345.14033, 1761 "io_wait": false, 1762 "io_write": { 1763 "bytes": 4186112, 1764 "chars": 4358178, 1765 "count": 346 1766 }, 1767 "mem_percent": 0.978199592776086, 1768 "meminfo": [ 1769 60411904, 1770 219631616, 1771 58097664, 1772 4608000, 1773 0, 1774 2908160, 1775 0 1776 ], 1777 "psutil_proc": null, 1778 "read_delta": 0.0, 1779 "write_delta": 0.0 1780 }, 1781 "is_parallel_worker": false, 1782 "mem": null, 1783 "pid": 6236, 1784 "query": "UPDATE pgbench_branches SET bbalance = bbalance + -1147 WHERE bid = 26;", 1785 "read": null, 1786 "state": "active", 1787 "user": "postgres", 1788 "wait": true, 1789 "write": null 1790 }, 1791 "6237": { 1792 "application_name": "pgbench", 1793 "client": "local", 1794 "cpu": null, 1795 "database": "pgbench", 1796 "duration": -0.002788, 1797 "extras": { 1798 "cpu_percent": 0.0, 1799 "cpu_times": [ 1800 0.23, 1801 0.06, 1802 0, 1803 0, 1804 0.04 1805 ], 1806 "io_read": { 1807 "bytes": 159744, 1808 "chars": 5387826, 1809 "count": 730 1810 }, 1811 "io_time": 1596806345.13865, 1812 "io_wait": false, 1813 "io_write": { 1814 "bytes": 4505600, 1815 "chars": 4612142, 1816 "count": 367 1817 }, 1818 "mem_percent": 1.00061680495036, 1819 "meminfo": [ 1820 61796352, 1821 219631616, 1822 59482112, 1823 4608000, 1824 0, 1825 2908160, 1826 0 1827 ], 1828 "psutil_proc": null, 1829 "read_delta": 0.0, 1830 "write_delta": 0.0 1831 }, 1832 "is_parallel_worker": false, 1833 "mem": null, 1834 "pid": 6237, 1835 "query": "END;", 1836 "read": null, 1837 "state": "active", 1838 "user": "postgres", 1839 "wait": true, 1840 "write": null 1841 }, 1842 "6238": { 1843 "application_name": "pgbench", 1844 "client": "local", 1845 "cpu": null, 1846 "database": "pgbench", 1847 "duration": -0.003436, 1848 "extras": { 1849 "cpu_percent": 0.0, 1850 "cpu_times": [ 1851 0.25, 1852 0.05, 1853 0, 1854 0, 1855 0.06 1856 ], 1857 "io_read": { 1858 "bytes": 110592, 1859 "chars": 5527083, 1860 "count": 740 1861 }, 1862 "io_time": 1596806345.1443, 1863 "io_wait": false, 1864 "io_write": { 1865 "bytes": 4825088, 1866 "chars": 4988967, 1867 "count": 387 1868 }, 1869 "mem_percent": 1.02741134257878, 1870 "meminfo": [ 1871 63451136, 1872 219631616, 1873 61136896, 1874 4608000, 1875 0, 1876 2908160, 1877 0 1878 ], 1879 "psutil_proc": null, 1880 "read_delta": 0.0, 1881 "write_delta": 0.0 1882 }, 1883 "is_parallel_worker": false, 1884 "mem": null, 1885 "pid": 6238, 1886 "query": "END;", 1887 "read": null, 1888 "state": "active", 1889 "user": "postgres", 1890 "wait": true, 1891 "write": null 1892 }, 1893 "6239": { 1894 "application_name": "pgbench", 1895 "client": "local", 1896 "cpu": null, 1897 "database": "pgbench", 1898 "duration": -0.00305, 1899 "extras": { 1900 "cpu_percent": 0.0, 1901 "cpu_times": [ 1902 0.23, 1903 0.05, 1904 0, 1905 0, 1906 0.06 1907 ], 1908 "io_read": { 1909 "bytes": 86016, 1910 "chars": 5355065, 1911 "count": 733 1912 }, 1913 "io_time": 1596806345.14122, 1914 "io_wait": false, 1915 "io_write": { 1916 "bytes": 4259840, 1917 "chars": 4423733, 1918 "count": 374 1919 }, 1920 "mem_percent": 0.993254939413836, 1921 "meminfo": [ 1922 61341696, 1923 219631616, 1924 59027456, 1925 4608000, 1926 0, 1927 2908160, 1928 0 1929 ], 1930 "psutil_proc": null, 1931 "read_delta": 0.0, 1932 "write_delta": 0.0 1933 }, 1934 "is_parallel_worker": false, 1935 "mem": null, 1936 "pid": 6239, 1937 "query": "END;", 1938 "read": null, 1939 "state": "active", 1940 "user": "postgres", 1941 "wait": true, 1942 "write": null 1943 }, 1944 "6240": { 1945 "application_name": "pgbench", 1946 "client": "local", 1947 "cpu": null, 1948 "database": "pgbench", 1949 "duration": -0.003586, 1950 "extras": { 1951 "cpu_percent": 0.0, 1952 "cpu_times": [ 1953 0.23, 1954 0.05, 1955 0, 1956 0, 1957 0.03 1958 ], 1959 "io_read": { 1960 "bytes": 253952, 1961 "chars": 5436959, 1962 "count": 717 1963 }, 1964 "io_time": 1596806345.14523, 1965 "io_wait": false, 1966 "io_write": { 1967 "bytes": 3809280, 1968 "chars": 3964955, 1969 "count": 339 1970 }, 1971 "mem_percent": 1.02137593930109, 1972 "meminfo": [ 1973 63078400, 1974 219631616, 1975 60772352, 1976 4608000, 1977 0, 1978 2908160, 1979 0 1980 ], 1981 "psutil_proc": null, 1982 "read_delta": 0.0, 1983 "write_delta": 0.0 1984 }, 1985 "is_parallel_worker": false, 1986 "mem": null, 1987 "pid": 6240, 1988 "query": "END;", 1989 "read": null, 1990 "state": "active", 1991 "user": "postgres", 1992 "wait": true, 1993 "write": null 1994 } 1995 } 1996} 1997