Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.11.2020 19: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 17300492 kB
MemAvailable 31426068 kB
Buffers 0 kB
Cached 14368904 kB
SwapCached 2836 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.7
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-11-11 19:27:00
DTS_END                         2020-11-11 19:27:00.1020
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60496
TRN_ID                          232347
ATT_ID                          634
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: 9326.73 22337 1119207
customer order: creation 163.97 372 19676
customer order: refuse 14.33 341 1720
order to supplier: creation 43.68 1315 5242
order to supplier: removal 3.60 94494 432
invoice (draft): creation 44.47 3472 5336
invoice (draft): removal 56.24 705 6749
invoice accept: apply 39.15 18355 4698
invoice accept: cancel 50.59 695 6071
customer reserve: creation 3642.38 180 437086
customer reserve: removal 4973.15 54 596778
realization accept: apply 80.54 163 9665
realization accept: cancel 89.88 92 10785
payment from customer: creation 57.59 106 6911
payment from customer: removal 5.63 76 675
payment to supplier: creation 46.73 106 5607
payment to supplier: removal 3.57 59 428
service: total inventory turnovers 4.63 1013 556
service: total monetary turnovers 5.90 22 708
service: aggregate perf. data 0.67 29002 80
service: refresh index statistics 0.03 296120 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-11-2020 19:28:21 to 11-11-2020 19:28:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6892
TEST_TIME 2 6405
TEST_TIME 3 6730
TEST_TIME 4 6844
TEST_TIME 5 6994
TEST_TIME 6 6637
TEST_TIME 7 6655
TEST_TIME 8 6756
TEST_TIME 9 6811
TEST_TIME 10 7035
TEST_TIME 11 6903
TEST_TIME 12 7390
TEST_TIME 13 7274
TEST_TIME 14 7477
TEST_TIME 15 7355
TEST_TIME 16 7583
TEST_TIME 17 7480
TEST_TIME 18 7989
TEST_TIME 19 7915
TEST_TIME 20 8083
TEST_TIME 21 8563
TEST_TIME 22 8652
TEST_TIME 23 9135
TEST_TIME 24 9629
TEST_TIME 25 9844
TEST_TIME 26 10852
TEST_TIME 27 10823
TEST_TIME 28 10687
TEST_TIME 29 10707
TEST_TIME 30 10362
TEST_TIME 31 10337
TEST_TIME 32 10406
TEST_TIME 33 10401
TEST_TIME 34 10351
TEST_TIME 35 10296
TEST_TIME 36 10150
TEST_TIME 37 10030
TEST_TIME 38 10052
TEST_TIME 39 10156
TEST_TIME 40 10085
TEST_TIME 41 9979
TEST_TIME 42 9800
TEST_TIME 43 9630
TEST_TIME 44 9740
TEST_TIME 45 9731
TEST_TIME 46 9608
TEST_TIME 47 9492
TEST_TIME 48 9511
TEST_TIME 49 9397
TEST_TIME 50 9526
TEST_TIME 51 9792
TEST_TIME 52 9735
TEST_TIME 53 9834
TEST_TIME 54 9855
TEST_TIME 55 9914
TEST_TIME 56 9837
TEST_TIME 57 9814
TEST_TIME 58 9958
TEST_TIME 59 9984
TEST_TIME 60 9977
TEST_TIME 61 10075
TEST_TIME 62 10018
TEST_TIME 63 10093
TEST_TIME 64 9953
TEST_TIME 65 9849
TEST_TIME 66 9773
TEST_TIME 67 9729
TEST_TIME 68 9623
TEST_TIME 69 9580
TEST_TIME 70 9506
TEST_TIME 71 9548
TEST_TIME 72 9490
TEST_TIME 73 9447
TEST_TIME 74 9367
TEST_TIME 75 9371
TEST_TIME 76 9366
TEST_TIME 77 9321
TEST_TIME 78 9327
TEST_TIME 79 9372
TEST_TIME 80 9442
TEST_TIME 81 9441
TEST_TIME 82 9431
TEST_TIME 83 9446
TEST_TIME 84 9492
TEST_TIME 85 9580
TEST_TIME 86 9601
TEST_TIME 87 9589
TEST_TIME 88 9639
TEST_TIME 89 9556
TEST_TIME 90 9460
TEST_TIME 91 9456
TEST_TIME 92 9435
TEST_TIME 93 9402
TEST_TIME 94 9402
TEST_TIME 95 9358
TEST_TIME 96 9394
TEST_TIME 97 9421
TEST_TIME 98 9415
TEST_TIME 99 9439
TEST_TIME 100 9463
TEST_TIME 101 9527
TEST_TIME 102 9531
TEST_TIME 103 9595
TEST_TIME 104 9689
TEST_TIME 105 9646
TEST_TIME 106 9636
TEST_TIME 107 9682
TEST_TIME 108 9643
TEST_TIME 109 9586
TEST_TIME 110 9563
TEST_TIME 111 9504
TEST_TIME 112 9484
TEST_TIME 113 9482
TEST_TIME 114 9459
TEST_TIME 115 9433
TEST_TIME 116 9441
TEST_TIME 117 9390
TEST_TIME 118 9396
TEST_TIME 119 9407
TEST_TIME 120 9329

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 11-11-2020 19:28:24 to 11-11-2020 19:28:28.

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 1523621 1523621 0 0.00 0 19513 5 0 0
doc_list_biud 1523621 1523621 0 0.00 0 31102 27 0 0
sp_add_invoice_to_stock 4759 4698 61 1.28 21 199902 18356 0 61
sp_cancel_adding_invoice 6071 6071 0 0.00 4 48953 696 0 0
sp_cancel_client_order 1720 1720 0 0.00 4 13565 341 0 0
sp_cancel_customer_reserve 596778 596778 0 0.00 1 25526 54 0 0
sp_cancel_pay_from_customer 675 675 0 0.00 2 3655 76 0 0
sp_cancel_pay_to_supplier 428 428 0 0.00 3 1363 60 0 0
sp_cancel_supplier_invoice 6752 6749 3 0.04 1 24982 706 0 3
sp_cancel_supplier_order 432 432 0 0.00 6 960272 94495 0 0
sp_cancel_write_off 10785 10785 0 0.00 1 11520 92 0 0
sp_client_order 19676 19676 0 0.00 3 33637 372 0 0
sp_customer_reserve 437086 437086 0 0.00 0 173201 180 0 0
sp_fill_shopping_cart 30240 30240 0 0.00 1 13475 36 0 0
sp_fill_shopping_cart_clo_res 437076 437076 0 0.00 0 18825 14 0 0
sp_get_clo_for_invoice 4688 4688 0 0.00 0 18902 305 0 0
sp_kill_cost_storno 17959 17959 0 0.00 0 7411 48 0 0
sp_kill_qstorno_ret_qs2qd 1211522 1211522 0 0.00 0 25521 29 0 0
sp_kill_qty_storno 636888 636888 0 0.00 0 31100 63 0 0
sp_lock_selected_doc 19968 19968 0 0.00 0 9265 7 0 0
sp_make_cost_storno 26871 26871 0 0.00 0 10159 46 0 0
sp_multiply_rows_for_pdistr 26871 26871 0 0.00 0 6198 25 0 0
sp_multiply_rows_for_qdistr 19676 19676 0 0.00 0 19538 173 0 0
sp_pay_from_customer 6911 6911 0 0.00 4 18451 106 0 0
sp_pay_to_supplier 5607 5607 0 0.00 4 18864 107 0 0
sp_payment_common 12518 12518 0 0.00 1 11593 23 0 0
sp_qd_handle_on_cancel_clo 1720 1720 0 0.00 0 13552 310 0 0
sp_qd_handle_on_invoice_upd_sts 10759 10759 0 0.00 0 31091 310 0 0
sp_qd_handle_on_reserve_upd_sts 9665 9665 0 0.00 0 19345 60 0 0
sp_reserve_write_off 9665 9665 0 0.00 6 19404 163 0 0
sp_supplier_invoice 5336 5336 0 0.00 6 66287 3473 0 0
sp_supplier_order 5242 5242 0 0.00 5 38027 1315 0 0
srv_aggregate_perf_data 80 80 0 0.00 2528 346064 29002 0 0
srv_fill_mon_cache_memory 155 155 0 0.00 1174 195923 34500 0 0
srv_find_qd_qs_mism 1073451 1073451 0 0.00 0 19511 4 0 0
srv_make_invnt_saldo 556 556 0 0.00 28 37479 1013 0 0
srv_make_money_saldo 708 708 0 0.00 1 772 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 178969 367556 296120 0 0
t$perf-abend:sp_add_invoice_to_stock 61 61 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4698 4698 0 0.00 0 7137 163 0 0
t$perf-norm:sp_cancel_adding_invoice 360 360 0 0.00 1 3423 109 0 0
t$perf-norm:sp_cancel_client_order 1720 1720 0 0.00 0 11938 23 0 0
t$perf-norm:sp_cancel_customer_reserve 649 649 0 0.00 0 2024 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 675 675 0 0.00 0 1677 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 428 428 0 0.00 0 1689 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 389 389 0 0.00 0 5147 28 0 0
t$perf-norm:sp_cancel_supplier_order 432 432 0 0.00 0 23328 1605 0 0
t$perf-norm:sp_cancel_write_off 962 962 0 0.00 0 2157 11 0 0
t$perf-norm:sp_client_order 19677 19677 0 0.00 0 8925 18 0 0
t$perf-norm:sp_customer_reserve 954 954 0 0.00 0 3316 11 0 0
t$perf-norm:sp_pay_from_customer 6911 6911 0 0.00 0 5468 14 0 0
t$perf-norm:sp_pay_to_supplier 5607 5607 0 0.00 0 8860 13 0 0
t$perf-norm:sp_reserve_write_off 9665 9665 0 0.00 0 4280 7 0 0
t$perf-norm:sp_supplier_invoice 5336 5336 0 0.00 0 2933 17 0 0
t$perf-norm:sp_supplier_order 5242 5242 0 0.00 0 9835 21 0 0
t$perf-norm:srv_aggregate_perf_data 80 80 0 0.00 0 50 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 11394 88 0 0
t$perf-norm:srv_make_invnt_saldo 556 556 0 0.00 0 649 19 0 0
t$perf-norm:srv_make_money_saldo 708 708 0 0.00 0 2240 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 5 0 0
v_add_invoice_to_stock 9498 9376 122 1.28 0 7849 18 0 122
v_all_customers 35858 35858 0 0.00 0 14 1 0 0
v_all_suppliers 29276 29276 0 0.00 0 16 1 0 0
v_all_wares 39352 39352 0 0.00 0 194 1 0 0
v_cancel_adding_invoice 720 720 0 0.00 0 5054 15 0 0
v_cancel_client_order 3440 3440 0 0.00 0 5508 7 0 0
v_cancel_customer_prepayment 1350 1350 0 0.00 0 2448 5 0 0
v_cancel_customer_reserve 1298 1298 0 0.00 0 5039 13 0 0
v_cancel_payment_to_supplier 856 856 0 0.00 0 1356 7 0 0
v_cancel_supplier_invoice 784 778 6 0.76 0 563 13 0 6
v_cancel_supplier_order 864 864 0 0.00 0 253 3 0 0
v_cancel_write_off 1924 1924 0 0.00 0 3923 14 0 0
v_max_id_clo_ord 5242 5242 0 0.00 0 375 1 0 0
v_max_id_clo_res 954 954 0 0.00 0 2310 13 0 0
v_max_id_ord_sup 5322 5322 0 0.00 0 8130 7 0 0
v_max_non_paid_invoice 1533 1533 0 0.00 0 2065 4 0 0
v_max_non_paid_realizn 3768 3768 0 0.00 0 2730 4 0 0
v_min_id_clo_ord 5242 5242 0 0.00 0 1283 4 0 0
v_min_id_clo_res 954 954 0 0.00 0 659 2 0 0
v_min_id_ord_sup 5322 5322 0 0.00 0 4676 5 0 0
v_min_non_paid_invoice 5607 5607 0 0.00 0 4600 12 0 0
v_min_non_paid_realizn 6911 6911 0 0.00 0 11276 16 0 0
v_our_firm 9780 9780 0 0.00 0 13 1 0 0
v_reserve_write_off 19330 19330 0 0.00 0 5402 6 0 0
x_lock_depdocs_on_canc_invoice 12431 12431 0 0.00 0 20229 105 0 0
x_lock_depdocs_on_canc_sup_ord 432 432 0 0.00 0 3631 308 0 0
x_make_qstorno_1000_1200 5242 5242 0 0.00 2 37997 1241 0 0
x_make_qstorno_1200_2000 5336 5336 0 0.00 3 66263 3342 0 0
x_make_qstorno_2100_3300 437086 437086 0 0.00 0 173199 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-11-2020 19:28:29 to 11-11-2020 19:28:33.

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
16:57:03 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:10 10250 8192000000 10181662016 10478968832 877656720 9.676 71 53 108 0 898067696 2355056 18055920
16:57:27 25917 8192000000 10285942240 10593898496 1320553184 13.882 100 80 161 0 1351358992 4235888 26569920
16:58:02 24601 8192000000 10338412496 10653712384 1380088656 14.417 100 87 174 0 1414114128 5547728 28477744
16:58:38 30469 8192000000 10384126640 10704408576 1423342368 14.802 100 88 176 0 1458794352 6569088 28882896
16:59:17 20778 8192000000 10408791632 10736513024 1450943360 15.046 100 85 170 0 1485685520 7404160 27338000
16:59:50 20287 8192000000 10424740208 10754248704 1484128000 15.338 100 91 182 0 1521699072 8387552 29183520
17:00:18 12717 8192000000 10439232496 10771820544 1501462048 15.489 100 92 184 1 1539057936 8680960 28914928
17:00:41 20187 8192000000 10469267440 10805186560 1519230416 15.644 100 87 174 0 1555731760 8977776 27523568
17:01:14 14876 8192000000 10485434048 10828345344 1540197776 15.825 100 83 166 1 1575763888 9550288 26015824
17:01:40 14172 8192000000 10515170784 10862575616 1568635104 16.071 100 82 162 1 1603137328 10129328 24372896
17:02:05 10775 8192000000 10528218624 10880086016 1586667184 16.225 100 75 150 1 1619562080 10235040 22659856
17:02:27 14595 8192000000 10566676320 10925416448 1621438496 16.522 100 81 161 0 1656668096 11197264 24032336
17:02:52 9556 8192000000 10585883136 10946748416 1647257408 16.741 100 81 162 1 1683574032 12202016 24114608
17:03:13 15141 8192000000 10613074912 10976321536 1667896432 16.915 100 84 168 3 1705085408 13090336 24098640
17:03:35 9522 8192000000 10630497328 10997084160 1689941408 17.101 100 91 181 2 1729563200 13852800 25768992
17:03:53 9053 8192000000 10649491360 11019407360 1703670576 17.216 100 78 156 1 1739787024 13624576 22491872
17:04:10 6795 8192000000 10660143840 11032539136 1715248848 17.313 100 85 169 1 1753065568 13951440 23865280
17:04:25 9017 8192000000 10653041072 11032760320 1723319360 17.380 100 80 159 1 1759773024 13901744 22551920
17:04:42 6443 8192000000 10680666256 11054497792 1740993936 17.527 100 83 166 1 1778339792 14317696 23028160
17:04:57 5249 8192000000 10686357184 11064397824 1748572464 17.590 100 77 152 0 1783384112 13647328 21164320
17:05:09 3830 8192000000 10698110000 11075584000 1755960928 17.651 100 80 160 3 1791748752 13448944 22338880
17:05:20 6446 8192000000 10701702464 11082551296 1763954784 17.717 100 77 154 1 1798745392 13260592 21530016
17:05:38 8786 8192000000 10697354896 11081519104 1772071488 17.784 100 75 150 1 1806124656 13220320 20832848
17:05:54 4528 8192000000 10722991200 11102810112 1790287808 17.934 100 87 175 0 1827669584 11842752 25539024
17:06:06 2916 8192000000 10734306864 11119476736 1795832672 17.980 100 83 166 2 1831749728 12312640 23604416
17:06:15 2919 8192000000 10745475216 11127128064 1805637008 18.060 100 78 155 1 1839664368 12142784 21884576
17:06:25 3867 8192000000 10750406272 11132911616 1805739744 18.061 100 75 150 2 1839923136 13174992 21008400
17:06:35 2143 8192000000 10758770704 11141263360 1814296688 18.131 100 88 176 2 1853480624 14593072 24590864
17:06:43 2387 8192000000 10762156016 11148398592 1824295552 18.213 100 88 178 1 1861646336 13230704 24120080
17:06:52 2307 8192000000 10771549936 11155271680 1829222816 18.253 100 90 176 1 1868275440 13296704 25755920
17:07:01 2032 8192000000 10779281024 11160559616 1835364160 18.303 100 89 178 1 1873947680 13154672 25428848
17:07:09 1610 8192000000 10785722224 11172651008 1839012000 18.333 100 92 185 0 1882774864 17996832 25766032
17:07:18 2061 8192000000 10787955728 11176583168 1846929888 18.397 100 90 180 0 1885236672 12760848 25545936
17:07:26 2213 8192000000 10785317488 11176153088 1848872320 18.413 100 88 176 1 1886917472 13101104 24944048
17:07:35 1368 8192000000 10795886960 11183439872 1853118512 18.447 100 87 174 1 1889499856 11744928 24636416
17:07:43 1576 8192000000 10794382576 11182092288 1855607984 18.468 100 96 190 2 1894752528 12010864 27133680
17:07:50 2449 8192000000 10799761200 11189698560 1859304816 18.498 100 94 187 2 1898224144 12696128 26223200
17:07:59 2247 8192000000 10810571200 11195797504 1860989664 18.511 100 90 179 1 1899277728 12602720 25685344
17:08:08 1646 8192000000 10816198352 11201851392 1866119552 18.553 100 93 186 0 1905618208 13012096 26486560
17:08:16 1528 8192000000 10811245264 11197120512 1869810752 18.583 100 96 193 4 1909417360 12016288 27590320
17:08:24 21904 8192000000 10798581904 11202711552 1865418352 18.547 100 62 124 3 1893372192 10694528 17259312
17:09:08 1726 8192000000 10816893472 11209261056 1874414000 18.620 100 91 183 1 1913026016 11848880 26763136
17:09:15 4521 8192000000 10806935040 11209805824 1873464176 18.612 100 76 152 1 1907851200 12974288 21412736
17:09:27 2136 8192000000 10796030368 11206209536 1870289504 18.587 100 59 118 2 1898654208 11897088 16467616
17:09:36 4264 8192000000 10790179936 11200970752 1867182544 18.561 100 43 86 3 1888386160 9550368 11653248
17:09:49 4326 8192000000 10780927232 11201400832 1868638080 18.573 100 32 64 1 1885860208 8352016 8870112
17:09:59 3361 8192000000 10780714176 11201605632 1869840656 18.583 100 38 77 0 1888346064 7934080 10571328
17:10:10 6057 8192000000 10773117280 11199201280 1866038704 18.552 100 23 46 2 1879279584 6964768 6276112
17:10:23 6725 8192000000 10778441168 11204005888 1872158912 18.602 100 36 72 1 1890774864 8336432 10279520
17:10:37 6784 8192000000 10774734160 11204378624 1869866304 18.583 100 28 57 0 1884497200 6757136 7873760
17:10:51 6812 8192000000 10783572320 11207454720 1869958896 18.584 100 22 44 1 1881605728 6122304 5524528
17:11:04 15400 8192000000 10789068016 11215347712 1872121008 18.601 100 15 30 0 1882217728 5616432 4480288
17:11:26 6735 8192000000 10793940128 11214974976 1878199904 18.651 100 30 60 0 1894235296 7078992 8956400
17:11:39 12314 8192000000 10783822368 11215650816 1881759408 18.679 100 29 58 0 1897975280 8183136 8032736
17:11:58 13029 8192000000 10800266912 11224530944 1885227440 18.707 100 17 33 1 1895343280 5866720 4249120
17:12:19 7311 8192000000 10797126048 11227140096 1886651792 18.719 100 20 40 0 1898825344 6692688 5480864
17:12:37 14047 8192000000 10796908928 11223719936 1891340368 18.757 100 33 66 2 1906907616 6130944 9436304
17:12:57 66757 8192000000 10835259680 11244732416 1899832592 18.825 100 50 101 2 1920685152 5620256 15232304
17:14:10 6304 8192000000 10808764384 11240882176 1894891600 18.785 100 34 68 1 1913471312 9019840 9559872
17:14:23 4357 8192000000 10823541760 11246911488 1898581456 18.815 100 41 82 1 1917098688 6855872 11661360
17:14:35 7952 8192000000 10816018016 11244711936 1898357472 18.813 100 32 62 3 1913536736 6609088 8570176
17:14:51 7179 8192000000 10810881152 11247685632 1899692096 18.824 100 25 50 0 1912944240 6176864 7075280
17:15:07 7176 8192000000 10827016368 11254054912 1903696112 18.856 100 29 58 2 1917080432 5364160 8020160
17:15:22 5943 8192000000 10814479008 11249360896 1901240816 18.836 100 24 48 1 1915003536 6352272 7410448
17:15:35 5023 8192000000 10824815792 11251474432 1903463920 18.854 100 29 58 0 1918759200 7405520 7889760
17:15:46 4496 8192000000 10807994304 11241783296 1894170736 18.779 100 22 44 2 1905818912 5238848 6409328
17:15:57 6476 8192000000 10809478960 11236564992 1862189216 18.521 98 23 46 0 1874158368 5369760 6599392
17:16:13 10340 8192000000 10804129200 11243892736 1897651488 18.807 100 22 44 1 1909717824 5795776 6270560
17:16:30 9568 8192000000 10790589936 11227684864 1845101056 18.382 97 15 30 1 1854631920 5549712 3981152
17:16:51 63959 8192000000 10779168832 11220905984 1860040272 18.504 98 24 48 1 1871924496 4537568 7346656
17:18:01 7850 8192000000 10792906960 11224334336 1854469280 18.458 98 17 32 3 1864340064 5651680 4219104
17:18:18 10092 8192000000 10792389744 11216760832 1834024736 18.292 97 34 68 0 1850067072 6848848 9193488
17:18:35 4821 8192000000 10784957264 11210424320 1851556464 18.435 99 38 75 1 1874058864 11441296 11061104
17:18:46 5247 8192000000 10759234128 11190140928 1837492176 18.320 99 31 62 1 1851911232 5172800 9246256
17:18:59 6881 8192000000 10720154480 11135963136 1773819568 17.799 98 23 46 2 1786074704 5275328 6979808
17:19:13 6582 8192000000 10703156896 11125329920 1755969904 17.651 97 29 58 1 1771634400 6438912 9225584
17:19:26 8601 8192000000 10705133168 11125178368 1740485200 17.523 96 28 55 1 1754201376 5445952 8270224
17:19:42 7183 8192000000 10709479936 11129782272 1779072768 17.842 99 15 30 0 1788291872 5126544 4092560
17:19:57 7514 8192000000 10691624352 11111104512 1756746848 17.657 98 30 59 3 1771768688 6712192 8309648
17:20:14 10024 8192000000 10668081728 11087765504 1690102032 17.102 95 18 36 3 1700441728 5535088 4804608
17:20:30 11070 8192000000 10664334384 11079483392 1704706320 17.224 96 26 52 0 1718724464 5735824 8282320
17:20:48 10370 8192000000 10676763008 11089809408 1745461952 17.564 98 19 38 0 1756699472 5548400 5689120
17:21:04 5804 8192000000 10690787024 11106099200 1749744800 17.599 98 17 33 1 1760853856 5382272 5726784
17:21:17 12217 8192000000 10719414768 11139158016 1801007168 18.022 100 29 56 2 1815378176 5858224 8512784
17:21:39 54927 8192000000 10686233904 11107487744 1747994736 17.585 97 18 36 0 1757776336 4457376 5324224
17:22:40 13780 8192000000 10724945808 11142819840 1778970816 17.841 98 16 32 1 1788835600 5484256 4380528
17:23:00 6517 8192000000 10749805872 11161071616 1808853760 18.086 99 34 68 1 1825338384 6851072 9633552
17:23:18 7896 8192000000 10747502432 11170934784 1812890736 18.120 99 26 52 1 1830439648 9774720 7774192
17:23:32 5037 8192000000 10753799744 11178831872 1838022864 18.325 100 26 52 1 1851823360 6396144 7404352
17:23:43 6120 8192000000 10753154976 11175100416 1836629024 18.313 100 26 52 0 1849711232 5384112 7698096
17:23:57 10511 8192000000 10753559792 11179261952 1841740960 18.355 100 23 46 1 1853783696 5504704 6538032
17:24:17 10822 8192000000 10756383344 11184984064 1843644784 18.370 100 27 54 1 1857350704 5509840 8196080
17:24:34 17457 8192000000 10760948352 11195072512 1847402816 18.401 100 20 38 0 1858517408 5461952 5652640
17:24:58 8672 8192000000 10785482560 11205455872 1859662816 18.501 100 33 67 1 1875435040 5619232 10152992
17:25:14 6805 8192000000 10763413296 11197538304 1860516672 18.507 100 24 48 1 1873932288 6673088 6742528
17:25:29 7010 8192000000 10773742288 11203072000 1863392480 18.531 100 36 72 2 1880076944 6435776 10248688
17:25:47 7497 8192000000 10776536560 11206942720 1863195280 18.529 100 24 47 2 1875662864 6125472 6342112
17:26:07 12103 8192000000 10783764560 11212378112 1867413728 18.563 100 16 32 0 1877844784 5779536 4651520
17:26:31 96361 8192000000 10836040240 11256000512 1884887472 18.705 100 34 64 2 1899932224 6189056 8855696
17:28:15 18109 8192000000 10838877408 11260379136 1913518576 18.935 100 38 76 3 1931424048 7459712 10445760
17:28:45 3966 8192000000 10851887568 11274391552 1922437552 19.006 100 48 95 1 1944375024 8546944 13390528
17:28:57 1383 8192000000 10871189664 11284656128 1934241904 19.101 100 69 139 1 1963898016 10313888 19342224
17:29:07 18155 8192000000 10864300048 11295424512 1931466304 19.079 100 50 100 0 1956151360 10776320 13908736
17:29:35 7838 8192000000 10872290080 11289567232 1935644368 19.112 100 44 88 0 1957370176 9323072 12402736
17:29:53 14117 8192000000 10877802288 11301093376 1938805216 19.137 100 48 95 0 1961609856 9347392 13457248
17:30:17 15784 8192000000 10883798800 11308351488 1948073968 19.211 100 58 116 1 1976915440 11948784 16892688
17:30:45 12218 8192000000 10880456704 11312140288 1950694080 19.232 100 53 106 0 1978074656 12297360 15083216
17:31:04 34666 8192000000 10880742528 11321278464 1955818896 19.273 100 42 82 1 1979072384 10898016 12355472
17:31:49 15166 8192000000 10896648896 11329572864 1964678304 19.343 100 48 96 0 1990167488 11425040 14064144
17:32:12 7032 8192000000 10912703712 11334053888 1968641680 19.375 100 53 106 1 1997763376 12302224 16819472
17:32:26 20578 8192000000 10908803680 11337814016 1968600304 19.374 100 38 74 2 1989979376 10688592 10690480
17:32:56 8818 8192000000 10902205984 11341406208 1974050560 19.418 100 32 64 0 1994897712 11301392 9545760
17:33:12 16923 8192000000 10903261200 11344195584 1976314656 19.436 100 42 81 1 1998164448 10049840 11799952
17:33:36 42080 8192000000 10906960720 11352637440 1981636736 19.478 100 43 86 1 2010605232 15133648 13834848
17:34:25 14898 8192000000 10919133744 11352449024 1966228368 19.356 99 49 98 1 1994065136 12762848 15073920
17:34:49 15517 8192000000 10931682272 11364487168 1984790448 19.503 100 48 96 4 2012393424 14249120 13353856
17:35:11 9680 8192000000 10943048000 11372826624 1996592272 19.596 100 48 96 0 2030711920 19702848 14416800
17:35:28 7911 8192000000 10957203216 11385778176 2005042304 19.662 100 51 102 0 2037142848 17348528 14752016
17:35:43 9974 8192000000 10948352208 11379351552 2004080704 19.655 100 59 118 1 2039327680 17552800 17694176
17:36:02 4160 8192000000 10968182336 11391541248 2011115360 19.710 100 76 149 1 2054535648 21019072 22401216
17:36:15 8272 8192000000 10957863088 11393736704 2010110368 19.702 100 55 110 2 2048526128 21848960 16566800
17:36:30 10652 8192000000 10971899040 11399020544 2015008400 19.741 100 54 108 1 2053906176 22898576 15999200
17:36:57 6135 8192000000 10977476784 11407368192 2019903376 19.779 100 64 128 3 2064271440 24819856 19548208
17:37:12 4644 8192000000 10978038816 11406151680 2002919504 19.646 99 73 147 0 2050589024 25821408 21848112
17:37:24 15392 8192000000 10973876320 11404902400 2018072240 19.765 100 63 126 2 2061375728 24038256 19265232
17:37:49 3938 8192000000 10968500080 11400802304 2013072944 19.726 100 59 117 0 2055606016 25238000 17295072
17:38:03 7166 8192000000 10975191952 11406557184 2014933648 19.740 100 58 112 1 2057893280 25493792 17465840
17:38:17 2714 8192000000 10972664224 11409965056 2018694432 19.770 100 54 106 1 2059474240 24782896 15996912
17:38:28 3046 8192000000 10972408752 11400249344 1998099168 19.608 99 66 131 0 2043745440 26263280 19382992
17:38:37 18834 8192000000 10975709184 11408793600 2017032704 19.757 100 63 126 0 2064690896 27957920 19700272
17:39:03 5797 8192000000 10971881648 11405295616 2012000960 19.717 100 64 126 0 2059348592 28565296 18782336
17:39:16 8589 8192000000 10966135456 11396775936 2010404320 19.705 100 76 151 1 2061113968 28303632 22406016
17:39:33 4968 8192000000 10973609120 11396898816 2012112960 19.718 100 66 131 2 2060506640 28770704 19622976
17:39:44 1637 8192000000 10975897232 11402043392 2014120480 19.734 100 70 140 0 2061088928 26359792 20608656
17:39:55 19832 8192000000 10981381712 11408244736 2015852288 19.748 100 68 136 0 2062608544 26321936 20434320
17:40:23 13311 8192000000 10973277424 11404038144 1995303776 19.586 99 61 122 3 2040209264 26103168 18802320
17:40:53 7774 8192000000 10941580672 11382140928 1977331152 19.444 99 55 110 1 2022575904 28240768 17003984
17:41:09 1173 8192000000 10972078560 11393921024 2004238784 19.656 100 72 140 1 2052493760 27268352 20986624
17:41:17 2616 8192000000 10937582096 11368476672 1975412064 19.428 99 60 120 3 2023925776 29548304 18965408
17:41:26 1946 8192000000 10945316272 11371077632 1964871104 19.345 99 68 136 1 2014677680 29497456 20309120
17:41:37 4685 8192000000 10942071824 11369730048 1974030944 19.417 100 70 140 2 2026888304 31339424 21517936
17:41:49 7225 8192000000 10939541312 11368865792 1975707408 19.431 100 60 119 0 2025256160 31084416 18464336
17:42:06 11134 8192000000 10937516720 11371954176 1975326816 19.428 100 52 104 2 2021942368 30940320 15675232
17:42:23 2410 8192000000 10947699840 11378937856 1980839344 19.471 100 57 112 1 2029507136 31735648 16932144
17:42:37 3861 8192000000 10954397552 11377680384 1970893584 19.393 99 66 129 0 2023424416 32569232 19961600
17:42:49 6598 8192000000 10930451376 11357138944 1950019296 19.227 98 52 104 1 1999573088 33087488 16466304
17:43:04 6908 8192000000 10941295744 11374264320 1965785040 19.352 99 57 111 1 2013883600 31330112 16768448
17:43:20 7550 8192000000 10949640736 11390595072 1985314480 19.507 100 54 105 2 2032044368 30590912 16138976
17:43:39 5458 8192000000 10957111696 11384852480 1972322480 19.404 99 60 116 0 2022352816 32213232 17817104
17:43:51 2736 8192000000 10943180304 11363999744 1950126688 19.227 98 68 132 4 2004262032 33229584 20905760
17:44:02 7211 8192000000 10938229072 11364167680 1962862000 19.329 100 66 131 1 2018384560 34876672 20645888
17:44:19 8044 8192000000 10942261904 11369766912 1954378928 19.261 99 60 120 1 2011957248 38406176 19172144
17:44:36 2102 8192000000 10958392832 11368448000 1951183280 19.236 99 76 155 2 2017199872 41921872 24094720
17:44:45 6399 8192000000 10962813264 11382882304 1976235632 19.435 100 79 156 3 2043162720 41813056 25114032
17:45:01 2372 8192000000 10955634016 11371409408 1969077824 19.378 100 81 163 1 2037960064 44201168 24681072
17:45:11 3644 8192000000 10948461872 11371474944 1954519728 19.262 99 72 144 1 2019201776 42022384 22659664
17:45:28 14221 8192000000 10898630864 11334443008 1903118224 18.851 97 40 80 0 1954654064 38866064 12669776
17:45:57 10884 8192000000 10911351488 11349430272 1933317040 19.093 99 38 76 1 1984448640 38446240 12685360
17:46:20 3912 8192000000 10924447424 11343212544 1919777600 18.985 98 69 135 2 1981372656 39729632 21865424
17:46:32 1940 8192000000 10955677680 11365736448 1961891184 19.321 100 75 150 2 2027611360 41418368 24301808
17:46:41 2641 8192000000 10950191616 11360538624 1956905600 19.281 99 85 169 1 2027298848 43786912 26606336
17:46:51 1873 8192000000 10947242784 11352915968 1950768688 19.233 99 87 172 0 2020498800 43801120 25928992
17:46:59 2940 8192000000 10947776944 11371302912 1966752240 19.360 100 72 144 1 2034583104 45402160 22428704
17:47:19 9005 8192000000 10935213536 11360022528 1939449232 19.142 99 44 88 1 1997436656 43070032 14917392
17:47:40 6587 8192000000 10921711920 11361763328 1938612832 19.136 99 48 96 0 1999378288 44905552 15859904
17:47:59 8836 8192000000 10921246096 11360907264 1933332256 19.094 99 43 86 1 1998732192 51018432 14381504
17:48:16 12314 8192000000 10918676384 11357286400 1947380880 19.206 100 38 75 0 2005670880 45499152 12790848
17:48:40 11923 8192000000 10928868496 11370868736 1951785568 19.241 100 38 78 0 2014524736 49550384 13188784
17:48:58 10575 8192000000 10912777056 11359166464 1946419536 19.198 100 25 50 3 2000447600 44816832 9211232
17:49:21 5491 8192000000 10936069776 11365539840 1953129472 19.251 100 57 111 2 2018604160 47410880 18063808
17:49:36 4350 8192000000 10946790320 11361120256 1950713776 19.232 100 74 148 2 2022566704 47852368 24000560
17:49:47 3346 8192000000 10943655488 11361259520 1950899248 19.234 100 76 152 0 2024938144 49746640 24292256
17:49:57 4370 8192000000 10927479008 11366359040 1950328416 19.229 100 57 114 1 2019750336 50138464 19283456
17:50:11 11651 8192000000 10884763600 11326578688 1904372896 18.861 98 35 70 1 1960894880 44920480 11601504
17:50:30 8344 8192000000 10896180240 11346395136 1928333824 19.054 100 27 54 0 1983044592 45258000 9452768
17:50:48 21392 8192000000 10898695248 11337711616 1892414432 18.765 98 33 66 1 1948731408 44854736 11462240
17:51:22 6514 8192000000 10895215776 11334574080 1906320320 18.877 99 32 64 1 1963074512 46123600 10630592
17:51:35 18681 8192000000 10883028624 11337297920 1905202960 18.868 99 20 39 2 1956513344 44639984 6670400
17:51:59 29275 8192000000 10866892560 11317407744 1911561664 18.919 100 18 36 0 1952932032 35485520 5884848
17:52:37 29853 8192000000 10868577648 11325931520 1895398032 18.789 99 17 34 0 1938129568 36237920 6493616
17:53:15 28401 8192000000 10847789008 11315568640 1869008544 18.576 98 14 28 1 1910485344 36395200 5081600
17:53:58 79494 8192000000 10851046384 11300126720 1855155552 18.464 97 12 24 1 1872707568 13659552 3892464
17:55:27 108149 8192000000 10823200320 11283533824 1845082352 18.382 96 13 26 0 1866230496 17368464 3779680
17:57:55 75005 8192000000 10861920832 11305435136 1887268944 18.724 98 34 68 0 1907324496 10075440 9980112
17:59:16 86140 8192000000 10872707392 11320627200 1904448128 18.862 98 18 36 0 1919015776 9804592 4763056
18:00:50 30515 8192000000 10900883024 11343478784 1947496864 19.207 100 31 62 0 1965350576 9651568 8202144
18:01:34 195921 8192000000 10909362864 11361570816 1918382016 18.974 97 26 52 2 1939307040 13034944 7890080
18:04:56 43927 8192000000 10886252384 11354443776 1938381776 19.134 99 18 36 1 1957791056 13849904 5559376
18:06:09 33169 8192000000 10881589664 11349118976 1949804240 19.225 100 15 28 1 1967741392 14241328 3695824
18:06:50 46656 8192000000 10889307120 11355369472 1956322800 19.277 100 13 26 0 1974306336 13755072 4228464
18:07:47 94021 8192000000 10897101984 11364343808 1944663888 19.184 99 15 29 1 1959272416 10524528 4084000
18:09:34 89427 8192000000 10911128576 11374481408 1973787440 19.415 100 15 30 1 1990204528 11843232 4573856
18:11:23 88886 8192000000 10887865072 11370823680 1938068240 19.131 98 18 35 2 1961774560 18333488 5372832
18:13:14 47873 8192000000 10925709600 11384889344 1986188576 19.514 100 29 58 2 2006510320 11819584 8502160
18:14:17 21707 8192000000 10936986928 11390545920 1991633696 19.557 100 48 96 1 2027787696 21687904 14466096
18:14:45 85752 8192000000 10923835232 11402584064 1976247632 19.435 99 19 38 0 2003940512 21748432 5944448
18:16:47 71156 8192000000 10914926432 11411574784 1985152048 19.505 100 13 26 0 2022927152 33162656 4612448
18:18:09 25846 8192000000 10905304272 11385139200 1971280000 19.396 100 31 61 0 2007325776 26417008 9628768
18:18:52 26387 8192000000 10892744112 11375665152 1950081728 19.227 99 12 24 1 1969989456 16280496 3627232
18:19:26 92064 8192000000 10906623280 11389546496 1957463792 19.286 99 19 38 1 1974476896 11885040 5128064
18:21:04 116605 8192000000 10913661808 11403128832 1987248416 19.522 100 21 42 1 2010218640 16802832 6167392
18:23:07 66434 8192000000 10918932256 11374940160 1913189984 18.932 96 21 41 1 1933292032 13835776 6266272
18:24:26 21853 8192000000 10920857216 11369140224 1959413296 19.301 99 48 96 3 1985435536 12720800 13301440
18:25:00 13503 8192000000 10896518304 11348746240 1913143296 18.932 97 38 76 1 1935011360 11371136 10496928
18:25:29 77458 8192000000 10888554016 11353161728 1878110800 18.650 96 32 64 0 1903437376 16999376 8327200
18:26:58 125336 8192000000 10860555952 11328180224 1864209120 18.537 95 10 19 3 1878769728 12517504 2043104
18:29:17 35106 8192000000 10881104096 11325874176 1860126416 18.504 95 31 60 1 1877388928 8617568 8644944
18:29:58 14051 8192000000 10857635920 11302047744 1865389312 18.547 96 40 79 2 1886770608 10364592 11016704
18:30:18 46702 8192000000 10876924480 11334316032 1918561616 18.975 99 35 70 0 1939908912 12025104 9322192
18:31:24 83576 8192000000 10885518800 11328487424 1896381040 18.797 97 47 94 3 1917680832 7500400 13799392
18:32:56 35875 8192000000 10863959552 11317354496 1897148016 18.803 98 46 92 2 1919525008 9334912 13042080
18:33:46 67878 8192000000 10827265840 11298041856 1854301584 18.457 96 23 46 2 1871098464 10531216 6265664
18:35:32 80467 8192000000 10822508768 11295150080 1844707008 18.379 96 10 21 1 1858601632 11175536 2719088
18:37:18 94856 8192000000 10850200912 11316817920 1904323520 18.861 99 16 32 0 1927094224 18337152 4433552
18:38:59 39919 8192000000 10861623456 11314692096 1933200864 19.092 100 22 42 0 1946311072 7318608 5791600
18:39:46 38732 8192000000 10822160144 11288834048 1865158400 18.545 96 20 40 0 1879755936 8727056 5870480
18:40:34 86223 8192000000 10844014736 11306024960 1920948608 18.994 100 19 38 1 1936655488 10162144 5544736
18:42:10 67874 8192000000 10841206560 11318001664 1923729904 19.017 100 7 14 0 1933619216 8380976 1508336
18:43:24 41257 8192000000 10871282752 11346640896 1938367184 19.134 100 6 12 1 1948865424 9109440 1388800
18:44:12 30413 8192000000 10885488160 11351056384 1955681568 19.272 100 19 38 3 1973134208 11670896 5781744
18:44:56 39155 8192000000 10873741552 11344322560 1934501632 19.103 99 13 26 1 1950209360 11601136 4106592
18:46:01 32524 8192000000 10863104912 11324510208 1894466224 18.782 97 28 56 0 1916324352 13548880 8309248
18:46:49 80677 8192000000 10836838336 11306573824 1870047088 18.585 97 19 36 1 1889438048 13893248 5497712
18:48:35 33443 8192000000 10867208880 11313348608 1893800960 18.776 98 26 52 1 1910360256 9060384 7498912
18:49:16 72148 8192000000 10871491760 11330822144 1906152848 18.876 98 29 58 1 1931134016 16368976 8612192
18:50:45 69376 8192000000 10869922432 11346616320 1905559552 18.871 98 18 36 0 1929946720 18891664 5495504
18:52:22 86167 8192000000 10861149472 11338878976 1895905168 18.793 98 5 10 0 1921425728 24256480 1264080
18:53:55 29393 8192000000 10861385552 11320512512 1900363216 18.829 98 18 36 2 1915251456 9731264 5156976
18:54:36 54449 8192000000 10871040848 11325292544 1880652608 18.670 97 22 43 1 1897959904 10995344 6311952
18:55:37 55875 8192000000 10872689616 11332890624 1921830848 19.002 99 17 34 1 1937410976 11217072 4363056
18:56:39 92693 8192000000 10882338512 11341320192 1954877712 19.265 100 35 68 1 1973044080 8825264 9341104
18:58:18 45633 8192000000 10879503904 11350601728 1940166976 19.148 99 8 16 0 1947502464 5494000 1841488
19:00:03 54433 8192000000 10879636800 11364130816 1963924496 19.337 100 7 14 0 1974035696 8209120 1902080
19:01:04 23168 8192000000 10879980224 11365199872 1962870240 19.329 100 7 14 1 1973860000 9058880 1930880
19:01:34 65873 8192000000 10884090400 11353743360 1929840528 19.066 98 11 22 0 1940520384 7933616 2746240
19:02:57 94699 8192000000 10904104512 11377704960 1933504560 19.095 98 16 32 0 1953519216 14293632 5721024
19:04:39 85701 8192000000 10896602048 11368304640 1914820960 18.945 97 19 38 1 1934406944 13622656 5963328
19:06:11 62809 8192000000 10906329824 11383541760 1976141888 19.434 100 25 50 0 2000448304 16145808 8160608
19:07:54 59370 8192000000 10906601344 11389022208 1959246624 19.300 99 7 14 2 1980868784 18971936 2650224
19:09:09 43317 8192000000 10928509568 11394953216 1946002064 19.195 98 30 60 0 1971497376 16488880 9006432
19:10:00 36887 8192000000 10924492048 11393409024 1989436736 19.539 100 23 46 0 2013721840 17351552 6933552
19:10:58 44196 8192000000 10923070400 11408961536 1967004576 19.362 99 10 20 1 1994857568 24733440 3119552
19:11:49 76448 8192000000 10932546928 11410026496 1978491040 19.453 100 5 10 0 2007105968 27090800 1524128
19:13:38 26400 8192000000 10950496864 11400863744 2000437632 19.626 100 41 82 0 2024955872 13208896 11309344
19:14:14 45711 8192000000 10924007792 11384942592 1974087552 19.418 99 23 46 0 1992548304 12611264 5849488
19:15:08 68197 8192000000 10933221744 11393376256 1980935696 19.472 99 40 80 2 2002829216 10733920 11159600
19:16:58 86267 8192000000 10930191424 11390095360 1973054192 19.410 99 20 40 2 1986500176 8247584 5198400
19:18:32 35013 8192000000 10898716048 11364450304 1931573056 19.079 97 35 70 0 1953220352 11910976 9736320
19:19:27 55460 8192000000 10884236304 11356545024 1914127200 18.940 97 27 54 0 1932225648 9994192 8104256
19:20:29 49513 8192000000 10864676144 11351474176 1934582240 19.103 99 7 14 0 1948069360 11301904 2185216
19:21:28 31812 8192000000 10861946992 11342995456 1928871568 19.058 99 11 22 0 1940859936 8899600 3088768
19:22:19 112939 8192000000 10881110096 11350335488 1875331568 18.627 96 12 24 0 1888312192 9630464 3350160
19:25:55 69775 8192000000 10287226160 10707169280 1325259568 13.924 68 7 14 0 1339338384 12042736 2036080

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 11-11-2020 19:28:34 to 11-11-2020 19:29:05.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 61 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-11-2020 19:29:06 to 11-11-2020 19:29:08.

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          231308
MON$OLDEST_ACTIVE               232577
MON$OLDEST_SNAPSHOT             232577
MON$NEXT_TRANSACTION            232577
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                       2034976
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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 ---
:271: 
:272: mscs-test-161.budzdorov.ru    Wed Nov 11 19:27:10 2020
:273:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:274: 
:275: 
:276: mscs-test-161.budzdorov.ru    Wed Nov 11 19:27:14 2020
:277:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:278: 
--- end of diff output ---

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

11.11.20 19:29:09. 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-11-11 19:29:12 No severe PSQL-related problems occured
11.11.20 19:29:13. End of report.