Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.12.2020 22:28
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17685124 kB
MemAvailable 31630496 kB
Buffers 0 kB
Cached 14051896 kB
SwapCached 1968 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-04 22:27:06
DTS_END                         2020-12-04 22:27:06.8600
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35314
TRN_ID                          231520
ATT_ID                          677
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9150.50 19158 1098060
customer order: creation 166.83 395 20020
customer order: refuse 14.32 356 1718
order to supplier: creation 43.60 1352 5232
order to supplier: removal 3.47 104367 416
invoice (draft): creation 43.78 3467 5253
invoice (draft): removal 53.25 787 6390
invoice accept: apply 39.82 19089 4778
invoice accept: cancel 48.61 858 5833
customer reserve: creation 3724.48 187 446938
customer reserve: removal 4718.58 61 566229
realization accept: apply 80.63 200 9675
realization accept: cancel 88.13 109 10575
payment from customer: creation 57.15 121 6858
payment from customer: removal 5.56 75 667
payment to supplier: creation 47.00 133 5640
payment to supplier: removal 3.27 87 392
service: total inventory turnovers 4.40 1126 528
service: total monetary turnovers 6.80 41 816
service: aggregate perf. data 0.82 16993 98
service: refresh index statistics 0.03 233353 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-12-2020 22:28:33 to 04-12-2020 22:28:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8067
TEST_TIME 2 8004
TEST_TIME 3 7068
TEST_TIME 4 6051
TEST_TIME 5 5899
TEST_TIME 6 5844
TEST_TIME 7 6045
TEST_TIME 8 6144
TEST_TIME 9 6199
TEST_TIME 10 6713
TEST_TIME 11 7443
TEST_TIME 12 7442
TEST_TIME 13 7976
TEST_TIME 14 7918
TEST_TIME 15 8029
TEST_TIME 16 8113
TEST_TIME 17 8677
TEST_TIME 18 8504
TEST_TIME 19 9164
TEST_TIME 20 9206
TEST_TIME 21 9373
TEST_TIME 22 9585
TEST_TIME 23 9462
TEST_TIME 24 9710
TEST_TIME 25 10128
TEST_TIME 26 10347
TEST_TIME 27 10994
TEST_TIME 28 11557
TEST_TIME 29 11265
TEST_TIME 30 11037
TEST_TIME 31 10943
TEST_TIME 32 10784
TEST_TIME 33 10765
TEST_TIME 34 10728
TEST_TIME 35 10593
TEST_TIME 36 10389
TEST_TIME 37 10345
TEST_TIME 38 10296
TEST_TIME 39 10173
TEST_TIME 40 10210
TEST_TIME 41 10078
TEST_TIME 42 9905
TEST_TIME 43 9845
TEST_TIME 44 9730
TEST_TIME 45 9588
TEST_TIME 46 9518
TEST_TIME 47 9638
TEST_TIME 48 9579
TEST_TIME 49 9564
TEST_TIME 50 9523
TEST_TIME 51 9526
TEST_TIME 52 9657
TEST_TIME 53 9704
TEST_TIME 54 9662
TEST_TIME 55 9618
TEST_TIME 56 9708
TEST_TIME 57 9666
TEST_TIME 58 9729
TEST_TIME 59 9804
TEST_TIME 60 9810
TEST_TIME 61 9794
TEST_TIME 62 9803
TEST_TIME 63 9798
TEST_TIME 64 9754
TEST_TIME 65 9652
TEST_TIME 66 9566
TEST_TIME 67 9496
TEST_TIME 68 9478
TEST_TIME 69 9460
TEST_TIME 70 9470
TEST_TIME 71 9395
TEST_TIME 72 9434
TEST_TIME 73 9438
TEST_TIME 74 9387
TEST_TIME 75 9433
TEST_TIME 76 9389
TEST_TIME 77 9402
TEST_TIME 78 9457
TEST_TIME 79 9426
TEST_TIME 80 9509
TEST_TIME 81 9547
TEST_TIME 82 9514
TEST_TIME 83 9492
TEST_TIME 84 9577
TEST_TIME 85 9632
TEST_TIME 86 9570
TEST_TIME 87 9500
TEST_TIME 88 9449
TEST_TIME 89 9477
TEST_TIME 90 9433
TEST_TIME 91 9408
TEST_TIME 92 9357
TEST_TIME 93 9374
TEST_TIME 94 9368
TEST_TIME 95 9409
TEST_TIME 96 9377
TEST_TIME 97 9359
TEST_TIME 98 9364
TEST_TIME 99 9419
TEST_TIME 100 9375
TEST_TIME 101 9381
TEST_TIME 102 9408
TEST_TIME 103 9478
TEST_TIME 104 9477
TEST_TIME 105 9485
TEST_TIME 106 9566
TEST_TIME 107 9522
TEST_TIME 108 9502
TEST_TIME 109 9433
TEST_TIME 110 9430
TEST_TIME 111 9395
TEST_TIME 112 9389
TEST_TIME 113 9341
TEST_TIME 114 9343
TEST_TIME 115 9336
TEST_TIME 116 9305
TEST_TIME 117 9268
TEST_TIME 118 9254
TEST_TIME 119 9229
TEST_TIME 120 9156

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-12-2020 22:28:36 to 04-12-2020 22:28:40.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1510851 1510851 0 0.00 0 24297 7 0 0
doc_list_biud 1510848 1510848 0 0.00 0 36592 29 0 0
sp_add_invoice_to_stock 4939 4778 161 3.25 29 198169 19090 0 161
sp_cancel_adding_invoice 5833 5833 0 0.00 5 97774 858 0 0
sp_cancel_client_order 1718 1718 0 0.00 4 12671 356 0 0
sp_cancel_customer_reserve 566229 566229 0 0.00 1 36595 61 0 0
sp_cancel_pay_from_customer 667 667 0 0.00 3 3145 76 0 0
sp_cancel_pay_to_supplier 392 392 0 0.00 3 3759 88 0 0
sp_cancel_supplier_invoice 6404 6390 14 0.21 1 25895 788 0 14
sp_cancel_supplier_order 416 416 0 0.00 6 1035744 104367 0 0
sp_cancel_write_off 10575 10575 0 0.00 1 12445 110 0 0
sp_client_order 20020 20020 0 0.00 3 40835 395 0 0
sp_customer_reserve 446938 446938 0 0.00 0 55639 187 0 0
sp_fill_shopping_cart 30497 30497 0 0.00 1 27263 39 0 0
sp_fill_shopping_cart_clo_res 446925 446925 0 0.00 0 36579 15 0 0
sp_get_clo_for_invoice 4764 4764 0 0.00 0 22153 295 0 0
sp_kill_cost_storno 17467 17467 0 0.00 0 6864 58 0 0
sp_kill_qstorno_ret_qs2qd 1149839 1149839 0 0.00 0 36588 33 0 0
sp_kill_qty_storno 605600 605600 0 0.00 0 36592 71 0 0
sp_lock_selected_doc 20128 20128 0 0.00 0 9701 7 0 0
sp_make_cost_storno 26937 26937 0 0.00 0 11187 57 0 0
sp_multiply_rows_for_pdistr 26937 26937 0 0.00 0 9424 31 0 0
sp_multiply_rows_for_qdistr 20019 20019 0 0.00 0 35989 170 0 0
sp_pay_from_customer 6858 6858 0 0.00 4 20823 122 0 0
sp_pay_to_supplier 5640 5640 0 0.00 4 21038 133 0 0
sp_payment_common 12498 12498 0 0.00 1 7459 29 0 0
sp_qd_handle_on_cancel_clo 1718 1718 0 0.00 0 12664 327 0 0
sp_qd_handle_on_invoice_upd_sts 10597 10597 0 0.00 0 34154 344 0 0
sp_qd_handle_on_reserve_upd_sts 9675 9675 0 0.00 0 24288 67 0 0
sp_reserve_write_off 9675 9675 0 0.00 6 24300 200 0 0
sp_supplier_invoice 5253 5253 0 0.00 6 93676 3468 0 0
sp_supplier_order 5232 5232 0 0.00 6 59607 1352 0 0
srv_aggregate_perf_data 98 98 0 0.00 2622 134229 16993 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1091 160248 31983 0 0
srv_find_qd_qs_mism 1051453 1051453 0 0.00 0 24293 6 0 0
srv_make_invnt_saldo 528 528 0 0.00 49 76228 1126 0 0
srv_make_money_saldo 816 816 0 0.00 0 8253 41 0 0
srv_recalc_idx_stat 4 4 0 0.00 118814 395925 233354 0 0
t$perf-abend:sp_add_invoice_to_stock 161 161 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4778 4778 0 0.00 0 7985 150 0 0
t$perf-norm:sp_cancel_adding_invoice 414 414 0 0.00 0 16437 154 0 0
t$perf-norm:sp_cancel_client_order 1718 1718 0 0.00 0 4263 12 0 0
t$perf-norm:sp_cancel_customer_reserve 697 697 0 0.00 0 5338 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 667 667 0 0.00 0 2409 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 392 392 0 0.00 0 469 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 398 398 0 0.00 0 1784 17 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 29808 1598 0 0
t$perf-norm:sp_cancel_write_off 987 987 0 0.00 0 2597 11 0 0
t$perf-norm:sp_client_order 20020 20020 0 0.00 0 17243 17 0 0
t$perf-norm:sp_customer_reserve 954 954 0 0.00 0 4268 10 0 0
t$perf-norm:sp_pay_from_customer 6858 6858 0 0.00 0 5467 9 0 0
t$perf-norm:sp_pay_to_supplier 5640 5640 0 0.00 0 18535 13 0 0
t$perf-norm:sp_reserve_write_off 9675 9675 0 0.00 0 7100 10 0 0
t$perf-norm:sp_supplier_invoice 5253 5253 0 0.00 0 16233 21 0 0
t$perf-norm:sp_supplier_order 5232 5232 0 0.00 0 5010 19 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 607 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 1884 18 0 0
t$perf-norm:srv_make_invnt_saldo 528 528 0 0.00 0 2722 32 0 0
t$perf-norm:srv_make_money_saldo 816 816 0 0.00 0 2632 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 9850 9528 322 3.26 0 7094 20 0 322
v_all_customers 36602 36602 0 0.00 0 27 1 0 0
v_all_suppliers 29037 29037 0 0.00 0 25 1 0 0
v_all_wares 40038 40038 0 0.00 0 43 1 0 0
v_cancel_adding_invoice 828 828 0 0.00 0 78 5 0 0
v_cancel_client_order 3436 3436 0 0.00 0 4288 6 0 0
v_cancel_customer_prepayment 1334 1334 0 0.00 0 370 3 0 0
v_cancel_customer_reserve 1394 1394 0 0.00 0 3167 5 0 0
v_cancel_payment_to_supplier 784 784 0 0.00 0 3371 15 0 0
v_cancel_supplier_invoice 824 796 28 3.39 0 3996 27 0 28
v_cancel_supplier_order 832 832 0 0.00 0 3007 10 0 0
v_cancel_write_off 1974 1974 0 0.00 0 2819 13 0 0
v_max_id_clo_ord 5230 5230 0 0.00 0 192 1 0 0
v_max_id_clo_res 954 954 0 0.00 0 3868 24 0 0
v_max_id_ord_sup 5248 5248 0 0.00 0 7289 4 0 0
v_max_non_paid_invoice 1598 1598 0 0.00 0 1632 5 0 0
v_max_non_paid_realizn 3580 3580 0 0.00 0 803 3 0 0
v_min_id_clo_ord 5229 5229 0 0.00 0 3085 9 0 0
v_min_id_clo_res 954 954 0 0.00 0 6119 13 0 0
v_min_id_ord_sup 5248 5248 0 0.00 0 4874 6 0 0
v_min_non_paid_invoice 5639 5639 0 0.00 0 6737 21 0 0
v_min_non_paid_realizn 6858 6858 0 0.00 0 4609 18 0 0
v_our_firm 9992 9992 0 0.00 0 16 1 0 0
v_reserve_write_off 19350 19350 0 0.00 0 8303 8 0 0
x_lock_depdocs_on_canc_invoice 11825 11825 0 0.00 0 12500 108 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 20444 386 0 0
x_make_qstorno_1000_1200 5232 5232 0 0.00 2 59592 1279 0 0
x_make_qstorno_1200_2000 5253 5253 0 0.00 2 85383 3322 0 0
x_make_qstorno_2100_3300 446938 446938 0 0.00 0 55638 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-12-2020 22:28:41 to 04-12-2020 22:28:45.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:10 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:16 25404 8192000000 10285654544 10596782080 883690208 9.736 69 53 104 1 903273536 2374080 17209248
19:57:50 31085 8192000000 10342695392 10663677952 1398156528 14.579 100 88 176 0 1431375776 5277184 27942064
19:58:29 20038 8192000000 10379246080 10699235328 1429880384 14.860 100 89 178 0 1465902416 6980512 29041520
19:59:03 16291 8192000000 10392928592 10720792576 1452986336 15.064 100 87 174 1 1489272272 7753424 28532512
19:59:30 12813 8192000000 10410130256 10740088832 1465457200 15.174 100 91 181 0 1503881712 8418400 30006112
19:59:51 23807 8192000000 10430977072 10764197888 1481195584 15.312 100 88 176 2 1519106896 9008608 28902704
20:00:25 14227 8192000000 10443028208 10779553792 1500049440 15.477 100 92 184 1 1539906272 9620192 30236640
20:00:53 17071 8192000000 10469386080 10812157952 1519021184 15.642 100 83 166 2 1555136688 9745200 26370304
20:01:36 16496 8192000000 10500131440 10849734656 1551839744 15.926 100 85 171 0 1588918224 10416416 26662064
20:02:00 14981 8192000000 10521631168 10875101184 1578167312 16.152 100 77 154 0 1612394368 10458816 23768240
20:02:24 10919 8192000000 10554917136 10911256576 1613215488 16.452 100 78 156 0 1647543600 10484576 23843536
20:02:43 11204 8192000000 10573178416 10936487936 1634503200 16.633 100 80 160 0 1669846864 11273440 24070224
20:03:03 13332 8192000000 10604210272 10966171648 1654921600 16.806 100 86 173 0 1692496432 11900736 25674096
20:03:24 9375 8192000000 10618125536 10984620032 1675953296 16.983 100 85 168 2 1712851904 12257136 24641472
20:03:46 10381 8192000000 10642021376 11009257472 1689831264 17.100 100 79 158 1 1725543632 12687168 23025200
20:04:08 8721 8192000000 10645329568 11015389184 1709424832 17.264 100 84 166 1 1745820464 13260400 23135232
20:04:24 6887 8192000000 10660335520 11031744512 1722596032 17.374 100 75 150 1 1757106080 13102032 21408016
20:04:38 7360 8192000000 10680287328 11057119232 1738384800 17.505 100 80 160 2 1774151184 13172576 22593808
20:04:57 4488 8192000000 10690011616 11065131008 1757437440 17.663 100 91 182 2 1796750480 13564160 25748880
20:05:09 4678 8192000000 10699650688 11074248704 1757206848 17.661 100 89 176 1 1795702512 14407888 24087776
20:05:20 5485 8192000000 10707389376 11085336576 1764932544 17.725 100 85 169 2 1802660432 14707952 23019936
20:05:32 4245 8192000000 10718550704 11095261184 1770127872 17.768 100 86 173 1 1809406096 14950448 24327776
20:05:43 4329 8192000000 10713195040 11092103168 1779963056 17.849 100 84 169 0 1818275744 15154624 23158064
20:05:54 3960 8192000000 10721638992 11101245440 1785031728 17.891 100 89 176 0 1822940224 13947312 23961184
20:06:04 3975 8192000000 10732703408 11114995712 1794573424 17.969 100 90 180 2 1833233840 13547568 25112848
20:06:15 2991 8192000000 10732257296 11119570944 1797728240 17.995 100 86 170 0 1834766352 12689648 24348464
20:06:24 4224 8192000000 10749503264 11134427136 1810564032 18.100 100 85 170 0 1847404208 13326352 23513824
20:06:35 9740 8192000000 10754282976 11144060928 1814750720 18.135 100 83 167 2 1851695168 13250864 23693584
20:06:52 3806 8192000000 10756873456 11146514432 1817460352 18.157 100 79 158 1 1852607040 13329312 21817376
20:07:02 2173 8192000000 10778416416 11163664384 1835199216 18.302 100 88 178 1 1871926384 12087904 24639264
20:07:11 2551 8192000000 10779182832 11165839360 1837663488 18.322 100 85 171 0 1874614256 13445872 23504896
20:07:20 2074 8192000000 10779448208 11167981568 1840077120 18.341 100 86 170 1 1876811376 12779536 23954720
20:07:28 1603 8192000000 10796832336 11183443968 1851811232 18.437 100 89 178 2 1890127040 13627728 24688080
20:07:36 1934 8192000000 10789100016 11178205184 1849686192 18.420 100 94 188 1 1891771664 15337408 26748064
20:07:45 1674 8192000000 10799189504 11187642368 1855272272 18.465 100 87 170 2 1892601392 13388352 23940768
20:07:53 2066 8192000000 10800690096 11192496128 1860270528 18.505 100 94 186 3 1901166496 13915872 26980096
20:08:02 2218 8192000000 10809607600 11198013440 1862966432 18.527 100 92 186 2 1902743856 13705136 26072288
20:08:10 1292 8192000000 10809921008 11200057344 1866162880 18.553 100 95 190 2 1905802960 12828352 26811728
20:08:17 1352 8192000000 10814585024 11204358144 1867566992 18.565 100 90 180 0 1906713520 13831472 25315056
20:08:25 1309 8192000000 10819250032 11207254016 1871083120 18.593 100 91 183 3 1910702080 14244176 25374784
20:08:33 41879 8192000000 10807815760 11210047488 1868716640 18.574 100 67 133 2 1897274864 9387664 19170560
20:09:21 1340 8192000000 10826580672 11219488768 1879302720 18.659 100 97 194 4 1919048720 12229632 27516368
20:09:29 2095 8192000000 10824135840 11218288640 1878400496 18.652 100 85 169 1 1915463744 13125696 23937552
20:09:38 2903 8192000000 10812356576 11216908288 1878147072 18.650 100 71 139 4 1908649264 10994928 19507264
20:09:47 4400 8192000000 10798950960 11217633280 1879737312 18.663 100 49 98 1 1901652304 8940128 12974864
20:09:58 3780 8192000000 10803781680 11217338368 1877209504 18.643 100 45 90 1 1899041216 8986096 12845616
20:10:09 4303 8192000000 10808858976 11223048192 1878814352 18.656 100 42 83 1 1897957376 7900432 11242592
20:10:24 45999 8192000000 10784708832 11218288640 1878382096 18.652 100 23 46 0 1891016832 5955440 6679296
20:11:18 8540 8192000000 10793589776 11222323200 1883841936 18.696 100 31 62 2 1899396368 7004080 8550352
20:11:33 4353 8192000000 10794146688 11222515712 1884372656 18.700 100 33 66 1 1901110320 7382224 9355440
20:11:45 7487 8192000000 10802208976 11230777344 1886280256 18.716 100 30 60 3 1900951056 6452000 8218800
20:11:59 8621 8192000000 10796663488 11230228480 1886403216 18.717 100 21 42 1 1899537088 7270528 5863344
20:12:18 8426 8192000000 10796689376 11230081024 1887972896 18.729 100 24 46 1 1900850320 5957520 6919904
20:12:33 9857 8192000000 10801234304 11241598976 1893893504 18.777 100 17 34 3 1904058928 5617088 4548336
20:12:50 9525 8192000000 10813680672 11245920256 1903004736 18.850 100 24 48 0 1920159632 9689872 7465024
20:13:07 10157 8192000000 10814088624 11247329280 1902353648 18.845 100 24 48 1 1915636384 6767920 6514816
20:13:24 6718 8192000000 10810862176 11245400064 1902422624 18.846 100 18 35 2 1912988992 5739296 4827072
20:13:37 8577 8192000000 10816020176 11251666944 1907756592 18.889 100 23 45 3 1922184960 6825888 7602480
20:13:51 41418 8192000000 10827142224 11262644224 1911377152 18.918 100 17 35 1 1921260992 5114208 4769632
20:14:42 33122 8192000000 10875732416 11278258176 1925722064 19.033 100 81 165 5 1955650720 7339376 22589280
20:15:22 3618 8192000000 10843073120 11273281536 1918535296 18.975 100 49 98 0 1942633888 10655856 13442736
20:15:36 7839 8192000000 10828795280 11266056192 1915712704 18.952 100 23 46 1 1927762576 5675824 6374048
20:15:50 6426 8192000000 10826911856 11267100672 1917680432 18.968 100 25 49 1 1931087872 5806992 7600448
20:16:04 6619 8192000000 10843052368 11271909376 1919929616 18.986 100 38 76 2 1938251872 6752608 11569648
20:16:18 3680 8192000000 10819501024 11255742464 1907060608 18.883 100 37 73 0 1924982240 8061712 9859920
20:16:32 6918 8192000000 10810983248 11251523584 1905539760 18.871 100 28 56 1 1919617216 6200256 7877200
20:16:48 46502 8192000000 10775832880 11219881984 1814178416 18.130 95 23 46 1 1826154176 5471312 6504448
20:17:47 8777 8192000000 10793673648 11218169856 1863865472 18.535 99 30 60 3 1878841232 6536224 8439536
20:18:03 4719 8192000000 10796350272 11221250048 1865267728 18.546 99 44 87 1 1884166304 6539168 12359408
20:18:15 6016 8192000000 10786308400 11216695296 1876382352 18.636 100 35 68 1 1893606048 7069008 10154688
20:18:27 5321 8192000000 10776638368 11200626688 1857070912 18.480 99 33 64 3 1872816560 5870752 9874896
20:18:39 3438 8192000000 10769082112 11188891648 1845969856 18.389 100 39 76 0 1864976512 7777104 11229552
20:18:49 7735 8192000000 10779666368 11200782336 1858789344 18.493 100 24 48 3 1870674048 5256128 6628576
20:19:04 6232 8192000000 10785480352 11209969664 1865535008 18.548 100 33 66 3 1880929472 5898736 9495728
20:19:17 7865 8192000000 10727495168 11146432512 1778141776 17.834 96 26 52 3 1792281056 6520800 7618480
20:19:37 6015 8192000000 10747591744 11168542720 1814935488 18.136 99 31 62 2 1834017680 10861200 8220992
20:19:52 8231 8192000000 10722214896 11144601600 1784077328 17.883 98 24 48 1 1796830304 5864896 6888080
20:20:07 9826 8192000000 10727678784 11139100672 1735987744 17.485 95 20 40 1 1746903216 5402880 5512592
20:20:24 12167 8192000000 10712593008 11135426560 1768059408 17.751 97 19 38 0 1779244064 5179808 6004848
20:20:44 53564 8192000000 10690318000 11092791296 1711033408 17.277 94 23 44 1 1723031056 4920448 7077200
20:21:44 17522 8192000000 10669874240 11088195584 1668771616 16.923 93 14 28 2 1678014672 5225008 4018048
20:22:09 7076 8192000000 10690262224 11097722880 1718141408 17.337 96 28 57 1 1731829344 5518288 8169648
20:22:26 7060 8192000000 10707732832 11122987008 1765231744 17.728 98 37 73 0 1782610368 7707312 9671312
20:22:42 6141 8192000000 10704292432 11115552768 1781545392 17.862 99 28 56 0 1796468976 7160160 7763424
20:22:54 6223 8192000000 10727913264 11146076160 1796779936 17.987 99 27 54 0 1811071472 6295792 7995744
20:23:09 7749 8192000000 10724960336 11147345920 1815355216 18.140 100 23 46 1 1827058736 5615264 6088256
20:23:23 9840 8192000000 10736426528 11156066304 1804518432 18.051 99 20 41 1 1815524000 5930416 5075152
20:23:39 9194 8192000000 10756833968 11168223232 1830925648 18.267 100 21 42 0 1842544864 5003856 6615360
20:23:56 3765 8192000000 10754617744 11174502400 1835122640 18.301 100 22 44 0 1846683120 5978048 5582432
20:24:07 7590 8192000000 10753151760 11175878656 1840826928 18.348 100 25 48 2 1854084816 6023056 7234832
20:24:21 9821 8192000000 10761244032 11180826624 1827175728 18.236 99 18 37 0 1838633424 4962496 6495200
20:24:39 6147 8192000000 10749412608 11178254336 1843630448 18.370 100 25 49 1 1855794992 5414256 6750288
20:24:51 9834 8192000000 10757725712 11186589696 1851281392 18.433 100 19 38 1 1861765664 5321936 5162336
20:25:07 13270 8192000000 10765890224 11190165504 1848965024 18.414 100 13 26 1 1857537472 5180544 3391904
20:25:32 58703 8192000000 10793572832 11202912256 1861169120 18.513 100 25 47 2 1875109936 5622160 8318656
20:26:50 6140 8192000000 10775697008 11206995968 1863350928 18.530 100 34 69 1 1881059040 8585424 9122688
20:27:07 37280 8192000000 10820551840 11235450880 1880206608 18.667 100 47 92 5 1899816384 6116592 13493184
20:27:54 7462 8192000000 10835848816 11250376704 1902472304 18.846 100 54 107 1 1928225808 10617104 15136400
20:28:09 20456 8192000000 10840001472 11259088896 1908188064 18.892 100 46 92 0 1932669840 11879776 12602000
20:28:36 1746 8192000000 10871505792 11279175680 1922784736 19.009 100 79 155 3 1957047872 11906960 22356176
20:28:46 17017 8192000000 10866822864 11285127168 1930188688 19.068 100 62 123 0 1965052144 17311152 17552304
20:29:10 3311 8192000000 10870323952 11284189184 1932493840 19.087 100 65 131 0 1964948368 12520112 19934416
20:29:21 6178 8192000000 10875658176 11292721152 1936475328 19.119 100 68 136 2 1969744160 13647648 19621184
20:29:36 15388 8192000000 10865273408 11290472448 1936485232 19.119 100 50 99 1 1963381136 12853568 14042336
20:30:03 38544 8192000000 10874336352 11307581440 1945120208 19.188 100 39 78 1 1970482208 13920432 11441568
20:30:56 47457 8192000000 10884313248 11314544640 1948496688 19.215 100 40 80 1 1974009248 13914064 11598496
20:32:10 22872 8192000000 10884251680 11319844864 1958286224 19.292 100 35 70 1 1983176960 14540640 10350096
20:32:49 11009 8192000000 10900251024 11327893504 1966046544 19.354 100 48 96 1 1994254400 14091264 14116592
20:33:06 11322 8192000000 10908103152 11335131136 1970194400 19.387 100 53 105 2 2002795424 16342880 16258144
20:33:29 22233 8192000000 10906429264 11339644928 1970724544 19.391 100 46 90 3 2000498912 16006368 13768000
20:34:02 5375 8192000000 10925091424 11350171648 1977281328 19.443 100 57 113 2 2015128768 21181968 16665472
20:34:15 2530 8192000000 10924945920 11349942272 1978014864 19.449 100 52 104 2 2011117408 17460784 15641760
20:34:27 6801 8192000000 10920655408 11347521536 1975733504 19.431 100 58 116 0 2012416672 19294832 17388336
20:34:49 3819 8192000000 10926466368 11350044672 1979710576 19.462 100 60 120 0 2015522544 18636832 17175136
20:35:02 12919 8192000000 10927958320 11357081600 1984195328 19.498 100 64 128 0 2023912704 20225680 19491696
20:35:26 5028 8192000000 10943822464 11366350848 1991694112 19.557 100 60 120 0 2028669136 19456320 17518704
20:35:41 6486 8192000000 10949679104 11373568000 1998095968 19.608 100 67 131 0 2042219312 24641776 19481568
20:35:55 9451 8192000000 10948949968 11377385472 2001139040 19.632 100 73 144 1 2044672624 21379968 22153616
20:36:13 7002 8192000000 10961618720 11388628992 2004651424 19.659 100 68 136 0 2050951088 25964160 20335504
20:36:27 4723 8192000000 10959129440 11390988288 2004967472 19.662 100 64 128 0 2050570080 25712160 19890448
20:36:41 5447 8192000000 10950573040 11380146176 1983503488 19.492 99 60 120 1 2028350768 26524864 18322416
20:36:59 19554 8192000000 10957728384 11394355200 1999766928 19.621 100 53 105 0 2045981488 29350560 16864000
20:37:26 9802 8192000000 10960998208 11396317184 2007561600 19.682 100 54 105 1 2050595904 27306624 15727680
20:37:44 10788 8192000000 10955103424 11389906944 1985443120 19.508 99 54 108 1 2028794224 26995136 16355968
20:38:04 16995 8192000000 10945476960 11383803904 1994795968 19.582 100 52 103 0 2038973024 27965456 16211600
20:38:32 7113 8192000000 10951564384 11389853696 2001045312 19.631 100 46 92 2 2041321600 25667504 14608784
20:38:46 8671 8192000000 10934635024 11371679744 1984707328 19.502 99 53 104 0 2026293712 24625952 16960432
20:39:03 6208 8192000000 10959299248 11387232256 1995243488 19.585 100 65 130 2 2040256640 25894032 19119120
20:39:16 1251 8192000000 10958063392 11378249728 1991782544 19.558 100 77 154 1 2046239168 31059184 23397440
20:39:25 4981 8192000000 10957181744 11385171968 2000102080 19.624 100 74 147 0 2050231312 27628400 22500832
20:39:37 2783 8192000000 10961463632 11391877120 2002971904 19.646 100 75 150 2 2053191040 27617136 22602000
20:39:49 7980 8192000000 10955615056 11384745984 1985958512 19.512 99 69 136 1 2034400128 28033888 20407728
20:40:11 5497 8192000000 10967292032 11396857856 1989866608 19.543 99 66 131 1 2039759616 29658592 20234416
20:40:24 1500 8192000000 10995371664 11407917056 2014643792 19.738 100 89 177 2 2071832240 30812080 26376368
20:40:32 6387 8192000000 10978693984 11410612224 2015922608 19.748 100 64 128 0 2066033680 29814176 20296896
20:40:46 2998 8192000000 10975467760 11400237056 1990447680 19.547 99 70 137 1 2044832576 33653104 20731792
20:40:57 3100 8192000000 10984079984 11407151104 2015880272 19.748 100 71 143 2 2068783072 29804864 23097936
20:41:07 2767 8192000000 10983751296 11415764992 2017591616 19.761 100 62 124 0 2067754640 30859344 19303680
20:41:17 3713 8192000000 10984278720 11420663808 2019971680 19.780 100 61 121 1 2069815984 30784768 19059536
20:41:30 3993 8192000000 10989235104 11421880320 2022996176 19.804 100 63 123 2 2073120816 30599824 19524816
20:41:43 3174 8192000000 10987471968 11413852160 2014961152 19.741 100 74 147 2 2074151840 36624784 22565904
20:41:53 5312 8192000000 10992410672 11421650944 2015741360 19.747 100 68 133 1 2069535504 33084288 20709856
20:42:08 2593 8192000000 10976391408 11394101248 1997016576 19.599 99 86 173 3 2055503040 32054624 26431840
20:42:18 4003 8192000000 10954416352 11376566272 1982249984 19.483 100 69 137 0 2035955472 33025280 20680208
20:42:29 3767 8192000000 10963825728 11380051968 1980510144 19.469 99 84 168 2 2037801904 31046272 26245488
20:42:40 2295 8192000000 10971235648 11392135168 1997069376 19.600 100 70 138 1 2051181632 32283904 21828352
20:42:49 4583 8192000000 10981228992 11396120576 2001600192 19.635 100 90 180 1 2063059648 33960640 27498816
20:43:02 1086 8192000000 10974354528 11386646528 1982094880 19.481 99 83 166 1 2043563728 35460896 26007952
20:43:10 1638 8192000000 10952539568 11367247872 1972978080 19.409 99 82 162 4 2033291904 34885680 25428144
20:43:20 1321 8192000000 10978081856 11389407232 1993824176 19.574 100 91 180 2 2057147088 35447296 27875616
20:43:29 5811 8192000000 10969208752 11398270976 1996181552 19.593 100 59 116 3 2050109728 34803456 19124720
20:43:42 4569 8192000000 10973513520 11397222400 1982720368 19.486 99 77 151 2 2042601296 35773760 24107168
20:43:54 4288 8192000000 10979138352 11402727424 1999860128 19.622 100 77 151 0 2061570576 37562368 24148080
20:44:10 1513 8192000000 10984357040 11402022912 1987527504 19.524 99 81 155 2 2050763344 38739024 24496816
20:44:19 2318 8192000000 10991758704 11408224256 2012370544 19.720 100 90 180 2 2079694784 39149888 28174352
20:44:28 2567 8192000000 11003427376 11423801344 2016524864 19.753 100 88 176 0 2084514256 40825488 27163904
20:44:39 2198 8192000000 10981252944 11397922816 1995470096 19.587 100 81 162 2 2059647712 38697088 25480528
20:44:49 4306 8192000000 10951104864 11383713792 1969157856 19.379 99 60 120 0 2025189616 37314000 18717760
20:45:01 7167 8192000000 10940393680 11381899264 1983822672 19.495 100 50 100 0 2036238544 36346288 16069584
20:45:16 10880 8192000000 10944421088 11374764032 1942572528 19.167 98 46 94 2 1999752112 41887344 15292240
20:45:36 2992 8192000000 10945852288 11368517632 1964448112 19.341 99 75 146 2 2027235360 39532544 23254704
20:45:47 4185 8192000000 10977872032 11394453504 1986437648 19.516 100 77 155 1 2054392416 42495600 25459168
20:45:58 5165 8192000000 10965537360 11386642432 1980823536 19.471 100 73 142 0 2048099600 44619952 22656112
20:46:11 6176 8192000000 10957017376 11396214784 1983291520 19.491 100 58 116 1 2048853744 46571328 18990896
20:46:25 10793 8192000000 10935979280 11379281920 1944361584 19.182 98 40 79 0 1994444528 36642192 13440752
20:46:46 5596 8192000000 10935130544 11369992192 1968237296 19.371 100 42 85 0 2015772304 33667232 13867776
20:47:03 4801 8192000000 10969615136 11388755968 1982036960 19.481 100 79 156 1 2042222736 35818448 24367328
20:47:17 2073 8192000000 10960566496 11371200512 1969164000 19.379 99 89 175 0 2034850528 37656928 28029600
20:47:26 1460 8192000000 10957705808 11380531200 1976489488 19.437 100 79 158 0 2041803712 40079088 25235136
20:47:37 8944 8192000000 10944308496 11386867712 1980767264 19.471 100 51 102 3 2036790656 39512064 16511328
20:47:57 5371 8192000000 10933070416 11365584896 1941916320 19.162 98 43 84 2 1996086640 38424752 15745568
20:48:09 16383 8192000000 10927852032 11370500096 1950485072 19.230 99 38 74 2 2001372720 38005152 12882496
20:48:44 4799 8192000000 10934145632 11355795456 1947473712 19.206 99 48 96 1 2001262224 37691712 16096800
20:48:57 4074 8192000000 10940306912 11378204672 1968545280 19.374 100 43 86 0 2026269632 43088176 14636176
20:49:10 17210 8192000000 10928541040 11376828416 1965139984 19.347 100 35 70 1 2015051680 38351888 11559808
20:49:34 15475 8192000000 10944968624 11389595648 1978312672 19.451 100 34 66 7 2029102432 39662912 11126848
20:49:55 12907 8192000000 10944056368 11386540032 1941005008 19.155 98 39 77 0 1997739824 43534112 13200704
20:50:22 9533 8192000000 10926779808 11365838848 1923961888 19.019 98 44 88 1 1986075152 47266320 14846944
20:50:39 10922 8192000000 10929442128 11370291200 1945792384 19.193 100 37 74 1 2011215280 51380880 14042016
20:51:00 8960 8192000000 10930982000 11376422912 1951641296 19.240 100 33 66 2 2017601312 53297824 12662192
20:51:15 7359 8192000000 10924782848 11360108544 1909173408 18.900 98 44 88 1 1979937600 53685840 17078352
20:51:30 12446 8192000000 10936971024 11380883456 1943682464 19.176 100 43 86 1 2018305472 59085600 15537408
20:51:50 15574 8192000000 10941739216 11388571648 1953039344 19.251 100 36 73 2 2021047632 54947360 13060928
20:52:28 19207 8192000000 10934243200 11381809152 1934205824 19.100 99 34 68 2 2010247568 64029296 12012448
20:53:15 20811 8192000000 10903559248 11356446720 1921543776 18.999 99 25 50 1 1975575712 44863616 9168320
20:54:43 23577 8192000000 10873916336 11337555968 1910651136 18.912 99 19 38 0 1944208896 27125296 6432464
20:55:25 39690 8192000000 10877134176 11322781696 1928083648 19.052 100 8 16 0 1955474208 24744432 2646128
20:56:12 77719 8192000000 10869002944 11308048384 1870491904 18.588 96 49 97 1 1892030432 8020144 13518384
20:57:37 79035 8192000000 10871800496 11305799680 1856941920 18.478 96 17 34 0 1868548992 7568272 4038800
20:59:05 37476 8192000000 10845167536 11296407552 1860886000 18.510 96 38 77 0 1883682144 12460800 10335344
20:59:48 49120 8192000000 10853057840 11313864704 1914485888 18.943 99 30 60 2 1937146464 14196688 8463888
21:00:51 160248 8192000000 10855884752 11308105728 1833012672 18.284 94 7 14 0 1846717760 11735904 1969184
21:03:38 21148 8192000000 10880219584 11322355712 1946243584 19.197 100 35 71 0 1963990864 7363696 10383584
21:04:06 60841 8192000000 10889403888 11336892416 1951926448 19.242 100 50 99 0 1975382976 9354704 14101824
21:05:25 40167 8192000000 10861510576 11323682816 1925789840 19.033 99 17 34 0 1940430064 10014016 4626208
21:06:36 29421 8192000000 10869493840 11323240448 1924915952 19.026 99 37 74 1 1943871296 8370464 10584880
21:07:12 52886 8192000000 10847140816 11314040832 1899722832 18.824 98 8 16 2 1911428752 8943040 2762880
21:08:18 85193 8192000000 10876227728 11332689920 1945657440 19.192 100 9 18 0 1956668720 8534112 2477168
21:09:50 34630 8192000000 10879197184 11350147072 1959368032 19.301 100 10 20 1 1978960304 16147120 3445152
21:10:46 158500 8192000000 10900391376 11355779072 1934410304 19.102 98 24 48 1 1954624720 13144400 7070016
21:13:59 59011 8192000000 10894217920 11377061888 1960931136 19.313 100 22 44 2 1987771264 19842816 6997312
21:15:05 64410 8192000000 10903155456 11374387200 1979160928 19.458 100 30 60 2 2004651216 16611968 8878320
21:16:17 69315 8192000000 10892185296 11367202816 1956880752 19.281 99 17 34 1 1978566176 16458368 5227056
21:17:34 61985 8192000000 10912294352 11392143360 1976532560 19.437 100 17 34 0 1997118704 15637072 4949072
21:18:52 87874 8192000000 10918264560 11390058496 1966743056 19.360 99 22 41 1 1992071776 19796256 5532464
21:21:46 42994 8192000000 10941965440 11396521984 1967550784 19.366 98 33 67 2 1987759952 10050640 10158528
21:22:47 56294 8192000000 10921931872 11398840320 1956670560 19.280 98 11 22 0 1971888944 12332352 2886032
21:23:57 55816 8192000000 10937014688 11384188928 1959409312 19.301 98 34 68 3 1980153920 11669504 9075104
21:25:01 47670 8192000000 10895537488 11377512448 1949701104 19.224 98 26 52 1 1972250608 15151168 7398336
21:26:54 90317 8192000000 10914413904 11376054272 1921131296 18.996 96 28 56 1 1948258624 20329872 6797456
21:28:39 57845 8192000000 10909555568 11369693184 1932137296 19.084 97 29 58 1 1954541952 14347312 8057344
21:29:52 14047 8192000000 10923314416 11369566208 1970205664 19.387 100 35 69 1 1987740624 8388000 9146960
21:30:12 39430 8192000000 10914911760 11372531712 1951943968 19.242 98 43 86 1 1975673872 12502880 11227024
21:30:59 35945 8192000000 10909494672 11359330304 1917771168 18.969 97 41 82 1 1939656768 10297232 11588368
21:31:45 107629 8192000000 10894330992 11341492224 1871812032 18.599 95 31 62 0 1889605152 9139232 8653888
21:33:44 57898 8192000000 10866558256 11325722624 1890590528 18.751 97 28 56 2 1910415824 12266000 7559296
21:34:48 35876 8192000000 10866283488 11337625600 1906794624 18.881 98 14 28 2 1931813808 21322640 3696544
21:35:36 51084 8192000000 10856686208 11337187328 1901432960 18.838 98 15 30 1 1928513840 22823840 4257040
21:36:52 47526 8192000000 10850886160 11335237632 1927826048 19.049 99 6 12 0 1942520112 12864864 1829200
21:37:46 67388 8192000000 10855128352 11323228160 1911682416 18.920 98 12 24 1 1926745248 11456784 3606048
21:39:00 65936 8192000000 10874132896 11341848576 1927000176 19.043 99 10 19 2 1942290432 12292784 2997472
21:40:14 111010 8192000000 10845418096 11316785152 1841515488 18.353 95 16 32 3 1859527696 13820384 4191824
21:42:40 74151 8192000000 10859267936 11322953728 1867900464 18.567 96 20 40 1 1884093888 11069584 5123840
21:44:05 69094 8192000000 10864021664 11320397824 1877445552 18.644 97 24 49 0 1902143472 17748368 6949552
21:45:26 35689 8192000000 10860906080 11326038016 1927962720 19.051 100 24 48 1 1948311936 14019120 6330096
21:46:08 39737 8192000000 10879176768 11330170880 1911170656 18.916 98 35 70 2 1933928912 13162624 9595632
21:46:59 54075 8192000000 10844362496 11319439360 1879825776 18.664 97 14 28 0 1903296688 19752960 3717952
21:47:59 102562 8192000000 10877082144 11337916416 1888861648 18.737 97 20 37 2 1910119392 15723632 5534112
21:49:49 65809 8192000000 10865288288 11325960192 1850447184 18.426 95 37 74 1 1871233408 10946768 9839456
21:51:07 99881 8192000000 10882596688 11366719488 1925517120 19.031 99 19 38 2 1947297872 16521408 5259344
21:52:53 51689 8192000000 10875748016 11329241088 1889258176 18.740 97 29 58 2 1912758896 15006784 8493936
21:53:54 124494 8192000000 10876542944 11340742656 1945002576 19.187 100 27 54 2 1968901168 16004112 7894480
21:56:18 52275 8192000000 10873358560 11356270592 1931892720 19.082 99 12 23 0 1955905376 20782256 3230400
21:57:19 57358 8192000000 10864214416 11335901184 1907030816 18.883 98 8 16 0 1920065376 11236976 1797584
21:59:03 47562 8192000000 10862446976 11338858496 1918241856 18.973 98 8 15 0 1933713792 13596176 1875760
21:59:57 35343 8192000000 10873101840 11361775616 1950417872 19.230 100 8 15 1 1965765280 13338416 2008992
22:01:10 40650 8192000000 10888085760 11360931840 1955043296 19.267 99 19 38 1 1967083088 6966976 5072816
22:01:58 53208 8192000000 10873553616 11342798848 1912784240 18.929 97 16 32 1 1926759504 9367632 4607632
22:02:58 82342 8192000000 10917575872 11360092160 1913391056 18.934 97 30 60 1 1932705024 10148336 9165632
22:04:33 39154 8192000000 10911328880 11369148416 1974337984 19.420 100 26 52 0 1991812832 9888800 7586048
22:05:21 57906 8192000000 10891631616 11362185216 1932577008 19.087 98 16 32 0 1949569024 12178304 4813712
22:06:26 75082 8192000000 10918367888 11362058240 1913662432 18.936 97 26 52 1 1934341728 12959056 7720240
22:07:49 31093 8192000000 10903188672 11360862208 1948598192 19.215 99 47 94 2 1971850352 9951056 13301104
22:08:27 81425 8192000000 10905655808 11383898112 1947137712 19.204 98 17 34 0 1970825104 18592464 5094928
22:10:45 83169 8192000000 10917875536 11383881728 1942058752 19.163 98 17 34 0 1956435056 9931072 4445232
22:12:14 15427 8192000000 10932228672 11393638400 1990081952 19.544 100 29 58 1 2012575328 14459920 8033456
22:12:38 94662 8192000000 10925386320 11414425600 1987364912 19.523 100 16 32 0 2014681472 22824368 4492192
22:15:03 42451 8192000000 10925263920 11380449280 1965431360 19.349 99 34 68 0 1984797488 9571120 9795008
22:16:13 153444 8192000000 10907583696 11396456448 1989023200 19.536 100 18 36 1 2004719328 10611728 5084400
22:18:53 35586 8192000000 10903465984 11384492032 1971543216 19.398 99 14 28 1 1990027648 14443024 4041408
22:19:37 47139 8192000000 10908950800 11396927488 1990477312 19.548 100 8 16 0 2004425328 12075184 1872832
22:20:31 33450 8192000000 10922847296 11402989568 1993285456 19.570 100 11 22 0 2006538976 10563296 2690224
22:21:18 54262 8192000000 10919298032 11397091328 1993245232 19.569 100 14 28 1 2006407712 9188224 3974256
22:23:33 67587 8192000000 10851817696 11326550016 1851898720 18.438 94 8 16 1 1861966672 7658512 2409440
22:24:47 47050 8192000000 10871214512 11353649152 1954821712 19.265 100 12 23 3 1966175488 7634752 3719024
22:25:41 48642 8192000000 10861194240 11329921024 1899308432 18.821 97 9 19 0 1909558288 7898368 2351488
22:27:04 12048 8192000000 9011752272 9208963072 186750752 2.228 10 4 6 0 188924512 1122864 1050896

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 04-12-2020 22:28:47 to 04-12-2020 22:29:18.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 161 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-12-2020 22:29:19 to 04-12-2020 22:29:21.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          231461
MON$OLDEST_ACTIVE               231917
MON$OLDEST_SNAPSHOT             231917
MON$NEXT_TRANSACTION            231917
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2013376
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33396 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33396 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33396 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33396 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:48: 
:49: mscs-test-161.budzdorov.ru    Fri Dec  4 22:27:19 2020
:50:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:51: 
:52: 
:53: mscs-test-161.budzdorov.ru    Fri Dec  4 22:27:19 2020
:54:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:55: 
:56: 
:57: mscs-test-161.budzdorov.ru    Fri Dec  4 22:27:21 2020
:58:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:59: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

04.12.20 22:29:22. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2020-12-04 22:29:24 No severe PSQL-related problems occured
04.12.20 22:29:25. End of report.