Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.06.2021 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 58e1ddde69c44dad93d327777e5becec
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 2021-05-09 08:45
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 4793.92
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 17390604 kB
MemAvailable 31399008 kB
Buffers 0 kB
Cached 14255912 kB
SwapCached 40 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 2021-06-11 19:27:39
DTS_END                         2021-06-11 19:27:39.6750
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55674
TRN_ID                          229277
ATT_ID                          657
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: 8913.06 19603 1069567
customer order: creation 166.17 387 19940
customer order: refuse 14.03 449 1684
order to supplier: creation 42.44 1394 5093
order to supplier: removal 3.43 111815 412
invoice (draft): creation 44.55 3941 5346
invoice (draft): removal 50.91 875 6109
invoice accept: apply 40.28 19699 4834
invoice accept: cancel 45.28 917 5434
customer reserve: creation 3700.15 194 444018
customer reserve: removal 4522.94 67 542753
realization accept: apply 80.69 199 9683
realization accept: cancel 76.84 128 9221
payment from customer: creation 58.53 115 7024
payment from customer: removal 5.35 81 642
payment to supplier: creation 46.76 118 5611
payment to supplier: removal 3.33 73 400
service: total inventory turnovers 4.33 1624 519
service: total monetary turnovers 6.21 30 745
service: aggregate perf. data 0.79 22361 95
service: refresh index statistics 0.03 227598 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 11-06-2021 19:28:37 to 11-06-2021 19:28:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2074
TEST_TIME 2 3487
TEST_TIME 3 3410
TEST_TIME 4 3366
TEST_TIME 5 3825
TEST_TIME 6 4163
TEST_TIME 7 4609
TEST_TIME 8 4869
TEST_TIME 9 4961
TEST_TIME 10 4992
TEST_TIME 11 5081
TEST_TIME 12 5248
TEST_TIME 13 5484
TEST_TIME 14 5704
TEST_TIME 15 5752
TEST_TIME 16 5832
TEST_TIME 17 6049
TEST_TIME 18 6315
TEST_TIME 19 6522
TEST_TIME 20 6842
TEST_TIME 21 6929
TEST_TIME 22 6983
TEST_TIME 23 7097
TEST_TIME 24 7319
TEST_TIME 25 7253
TEST_TIME 26 7215
TEST_TIME 27 7434
TEST_TIME 28 7808
TEST_TIME 29 7685
TEST_TIME 30 7875
TEST_TIME 31 8163
TEST_TIME 32 8523
TEST_TIME 33 9331
TEST_TIME 34 9537
TEST_TIME 35 9362
TEST_TIME 36 9262
TEST_TIME 37 9418
TEST_TIME 38 9319
TEST_TIME 39 9285
TEST_TIME 40 9173
TEST_TIME 41 9126
TEST_TIME 42 9075
TEST_TIME 43 9067
TEST_TIME 44 9033
TEST_TIME 45 8921
TEST_TIME 46 8927
TEST_TIME 47 8957
TEST_TIME 48 8776
TEST_TIME 49 8850
TEST_TIME 50 8723
TEST_TIME 51 8630
TEST_TIME 52 8577
TEST_TIME 53 8690
TEST_TIME 54 8613
TEST_TIME 55 8637
TEST_TIME 56 8540
TEST_TIME 57 8497
TEST_TIME 58 8555
TEST_TIME 59 8481
TEST_TIME 60 8390
TEST_TIME 61 8487
TEST_TIME 62 8438
TEST_TIME 63 8429
TEST_TIME 64 8631
TEST_TIME 65 8601
TEST_TIME 66 8574
TEST_TIME 67 8643
TEST_TIME 68 8657
TEST_TIME 69 8699
TEST_TIME 70 8768
TEST_TIME 71 8782
TEST_TIME 72 8892
TEST_TIME 73 8834
TEST_TIME 74 8834
TEST_TIME 75 8918
TEST_TIME 76 8916
TEST_TIME 77 8833
TEST_TIME 78 8847
TEST_TIME 79 8780
TEST_TIME 80 8804
TEST_TIME 81 8798
TEST_TIME 82 8741
TEST_TIME 83 8694
TEST_TIME 84 8685
TEST_TIME 85 8602
TEST_TIME 86 8580
TEST_TIME 87 8637
TEST_TIME 88 8604
TEST_TIME 89 8596
TEST_TIME 90 8676
TEST_TIME 91 8679
TEST_TIME 92 8719
TEST_TIME 93 8764
TEST_TIME 94 8783
TEST_TIME 95 8778
TEST_TIME 96 8745
TEST_TIME 97 8897
TEST_TIME 98 8883
TEST_TIME 99 8880
TEST_TIME 100 8928
TEST_TIME 101 8952
TEST_TIME 102 8918
TEST_TIME 103 8852
TEST_TIME 104 8859
TEST_TIME 105 8809
TEST_TIME 106 8789
TEST_TIME 107 8775
TEST_TIME 108 8811
TEST_TIME 109 8778
TEST_TIME 110 8753
TEST_TIME 111 8735
TEST_TIME 112 8771
TEST_TIME 113 8790
TEST_TIME 114 8777
TEST_TIME 115 8764
TEST_TIME 116 8755
TEST_TIME 117 8773
TEST_TIME 118 8870
TEST_TIME 119 8926
TEST_TIME 120 8914

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-06-2021 19:28:41 to 11-06-2021 19:28:44.

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 1480402 1480402 0 0.00 0 20136 6 0 0
doc_list_biud 1480401 1480401 0 0.00 0 32944 31 0 0
sp_add_invoice_to_stock 4951 4834 117 2.36 32 217147 19700 0 117
sp_cancel_adding_invoice 5434 5434 0 0.00 5 57328 918 0 0
sp_cancel_client_order 1684 1684 0 0.00 4 12653 449 0 0
sp_cancel_customer_reserve 542753 542753 0 0.00 1 23401 68 0 0
sp_cancel_pay_from_customer 642 642 0 0.00 3 3118 81 0 0
sp_cancel_pay_to_supplier 400 400 0 0.00 3 2021 74 0 0
sp_cancel_supplier_invoice 6113 6109 4 0.06 2 24101 876 0 4
sp_cancel_supplier_order 412 412 0 0.00 9 1052890 111815 0 0
sp_cancel_write_off 9221 9221 0 0.00 1 9951 129 0 0
sp_client_order 19940 19940 0 0.00 3 32879 387 0 0
sp_customer_reserve 444018 444018 0 0.00 0 56693 195 0 0
sp_fill_shopping_cart 30375 30375 0 0.00 1 24114 46 0 0
sp_fill_shopping_cart_clo_res 444016 444016 0 0.00 0 19428 16 0 0
sp_get_clo_for_invoice 4832 4832 0 0.00 0 31491 405 0 0
sp_kill_cost_storno 15697 15697 0 0.00 0 6242 62 0 0
sp_kill_qstorno_ret_qs2qd 1101248 1101248 0 0.00 0 24089 36 0 0
sp_kill_qty_storno 580127 580127 0 0.00 0 32942 79 0 0
sp_lock_selected_doc 20013 20013 0 0.00 0 8116 5 0 0
sp_make_cost_storno 27150 27150 0 0.00 0 16532 56 0 0
sp_multiply_rows_for_pdistr 27149 27149 0 0.00 0 10999 32 0 0
sp_multiply_rows_for_qdistr 19940 19940 0 0.00 0 30521 169 0 0
sp_pay_from_customer 7024 7024 0 0.00 4 16538 115 0 0
sp_pay_to_supplier 5611 5611 0 0.00 5 17834 118 0 0
sp_payment_common 12635 12635 0 0.00 1 12962 31 0 0
sp_qd_handle_on_cancel_clo 1684 1684 0 0.00 0 12646 408 0 0
sp_qd_handle_on_invoice_upd_sts 10265 10265 0 0.00 0 32940 378 0 0
sp_qd_handle_on_reserve_upd_sts 9683 9683 0 0.00 0 26649 76 0 0
sp_reserve_write_off 9683 9683 0 0.00 6 26792 200 0 0
sp_supplier_invoice 5346 5346 0 0.00 7 111538 3942 0 0
sp_supplier_order 5093 5093 0 0.00 5 31103 1395 0 0
srv_aggregate_perf_data 96 95 1 1.04 2722 235553 22361 0 1
srv_fill_mon_cache_memory 170 170 0 0.00 1226 158838 30733 0 0
srv_find_qd_qs_mism 1023428 1023428 0 0.00 0 20134 5 0 0
srv_make_invnt_saldo 519 519 0 0.00 33 199254 1625 0 0
srv_make_money_saldo 745 745 0 0.00 1 2208 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 107209 305233 227599 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4834 4834 0 0.00 0 17892 195 0 0
t$perf-norm:sp_cancel_adding_invoice 377 377 0 0.00 1 4803 122 0 0
t$perf-norm:sp_cancel_client_order 1684 1684 0 0.00 0 4855 19 0 0
t$perf-norm:sp_cancel_customer_reserve 670 670 0 0.00 0 887 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 642 642 0 0.00 0 1110 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 400 400 0 0.00 0 1532 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 914 13 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 26039 1740 0 0
t$perf-norm:sp_cancel_write_off 918 918 0 0.00 0 3086 7 0 0
t$perf-norm:sp_client_order 19940 19940 0 0.00 0 8599 22 0 0
t$perf-norm:sp_customer_reserve 966 966 0 0.00 0 4368 8 0 0
t$perf-norm:sp_pay_from_customer 7024 7024 0 0.00 0 10094 11 0 0
t$perf-norm:sp_pay_to_supplier 5611 5611 0 0.00 0 17947 13 0 0
t$perf-norm:sp_reserve_write_off 9683 9683 0 0.00 0 5107 12 0 0
t$perf-norm:sp_supplier_invoice 5346 5346 0 0.00 0 3829 19 0 0
t$perf-norm:sp_supplier_order 5093 5093 0 0.00 0 7157 19 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 4396 71 0 0
t$perf-norm:srv_fill_mon_cache_memory 170 170 0 0.00 0 964 16 0 0
t$perf-norm:srv_make_invnt_saldo 519 519 0 0.00 0 2526 35 0 0
t$perf-norm:srv_make_money_saldo 745 745 0 0.00 0 4827 29 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 16 6 0 0
v_add_invoice_to_stock 9885 9652 233 2.35 0 4966 16 0 233
v_all_customers 36748 36748 0 0.00 0 91 1 0 0
v_all_suppliers 29160 29160 0 0.00 0 91 1 0 0
v_all_wares 39880 39880 0 0.00 0 173 1 0 0
v_cancel_adding_invoice 754 754 0 0.00 0 1232 8 0 0
v_cancel_client_order 3368 3368 0 0.00 0 2684 5 0 0
v_cancel_customer_prepayment 1284 1284 0 0.00 0 2874 9 0 0
v_cancel_customer_reserve 1340 1340 0 0.00 0 1641 5 0 0
v_cancel_payment_to_supplier 800 800 0 0.00 0 684 5 0 0
v_cancel_supplier_invoice 806 798 8 0.99 0 3408 21 0 8
v_cancel_supplier_order 824 824 0 0.00 0 2188 9 0 0
v_cancel_write_off 1836 1836 0 0.00 0 4966 17 0 0
v_max_id_clo_ord 5090 5090 0 0.00 0 831 1 0 0
v_max_id_clo_res 966 966 0 0.00 0 2380 8 0 0
v_max_id_ord_sup 5343 5343 0 0.00 0 4755 3 0 0
v_max_non_paid_invoice 1464 1464 0 0.00 0 2299 5 0 0
v_max_non_paid_realizn 3627 3627 0 0.00 0 2819 4 0 0
v_min_id_clo_ord 5090 5090 0 0.00 0 6104 13 0 0
v_min_id_clo_res 966 966 0 0.00 0 3534 7 0 0
v_min_id_ord_sup 5343 5343 0 0.00 0 4046 8 0 0
v_min_non_paid_invoice 5611 5611 0 0.00 0 6122 18 0 0
v_min_non_paid_realizn 7024 7024 0 0.00 0 10561 18 0 0
v_our_firm 9926 9926 0 0.00 0 31 1 0 0
v_reserve_write_off 19366 19366 0 0.00 0 6051 6 0 0
x_lock_depdocs_on_canc_invoice 11144 11144 0 0.00 0 18889 141 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 3385 350 0 0
x_make_qstorno_1000_1200 5093 5093 0 0.00 2 31003 1299 0 0
x_make_qstorno_1200_2000 5346 5346 0 0.00 3 106966 3770 0 0
x_make_qstorno_2100_3300 444018 444018 0 0.00 0 56692 176 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-06-2021 19:28:45 to 11-06-2021 19:28:49.

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:43 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:49 16890 8192000000 10255321904 10563526656 946160960 10.353 73 53 106 0 965692816 2450784 17081072
16:58:14 13232 8192000000 10320975040 10637897728 1382894480 14.442 100 78 157 0 1412844272 4476176 25473616
16:58:38 29175 8192000000 10383066336 10705240064 1429472240 14.857 100 86 172 0 1463254144 5674704 28107200
16:59:15 30377 8192000000 10423396640 10748649472 1463926800 15.160 100 83 166 1 1497830672 7004304 26899568
16:59:55 21508 8192000000 10445896512 10776006656 1494030912 15.424 100 88 176 0 1529913632 7865280 28017440
17:00:27 16484 8192000000 10453337344 10785566720 1510414128 15.567 100 93 186 0 1548862592 8767680 29680784
17:00:58 20771 8192000000 10457674608 10794250240 1509948960 15.563 100 82 164 0 1545227248 9201952 26076336
17:01:33 14272 8192000000 10468614592 10808872960 1528504800 15.724 100 84 168 0 1564503952 9737760 26261392
17:02:01 11958 8192000000 10486945600 10832318464 1545476128 15.871 100 87 174 0 1582769104 10388560 26904416
17:02:35 9982 8192000000 10520346496 10866282496 1572440976 16.103 100 83 167 0 1608790624 10536128 25813520
17:02:55 10252 8192000000 10540247056 10891993088 1598337248 16.325 100 85 170 0 1635713056 11498576 25877232
17:03:14 15014 8192000000 10556649104 10911035392 1609865952 16.424 100 85 170 0 1647847552 12027536 25954064
17:03:36 13723 8192000000 10574766736 10931257344 1629963568 16.595 100 80 160 3 1665940128 11931232 24045328
17:03:58 8811 8192000000 10579833232 10939973632 1644625824 16.719 100 81 162 1 1680847264 12270208 23951232
17:04:15 13025 8192000000 10603106576 10965905408 1654649088 16.804 100 76 152 1 1689034720 11958400 22427232
17:04:35 11475 8192000000 10612927024 10984579072 1675127744 16.976 100 70 140 0 1707459184 11175696 21155744
17:04:54 7029 8192000000 10619528176 10989223936 1686247616 17.070 100 71 142 1 1718514432 11724656 20542160
17:05:09 8118 8192000000 10646319200 11013705728 1706056208 17.236 100 82 164 0 1742672640 12450608 24165824
17:05:26 9327 8192000000 10667414480 11039596544 1723466192 17.381 100 75 150 0 1757583792 12725120 21392480
17:05:44 4903 8192000000 10672924944 11047751680 1737201040 17.495 100 83 167 1 1773909184 13139152 23568992
17:05:55 5975 8192000000 10686861296 11060133888 1747195840 17.578 100 79 155 1 1781638000 12953104 21489056
17:06:08 3934 8192000000 10693074656 11069399040 1757272016 17.662 100 89 178 2 1795717312 13431200 25014096
17:06:20 4268 8192000000 10696844544 11076579328 1763259600 17.711 100 79 159 2 1798996080 12396624 23339856
17:06:30 4417 8192000000 10711179920 11086344192 1769530080 17.763 100 84 168 0 1806531232 13537664 23463488
17:06:42 5024 8192000000 10720867424 11098488832 1777205408 17.826 100 87 173 1 1815599632 13687984 24706240
17:06:53 3397 8192000000 10722968064 11105120256 1785599216 17.896 100 83 165 0 1822201024 13590960 23010848
17:07:03 3718 8192000000 10728821520 11111010304 1786388400 17.902 100 87 172 0 1824593936 13445328 24760208
17:07:13 9127 8192000000 10727653632 11112849408 1795642848 17.978 100 77 152 3 1828863968 12985392 20235728
17:07:29 4469 8192000000 10737956272 11124396032 1803514528 18.043 100 78 154 0 1838084352 14032432 20537392
17:07:42 3621 8192000000 10769888304 11151978496 1823873664 18.209 100 89 174 1 1863645616 14634080 25137872
17:07:53 2637 8192000000 10763717824 11145179136 1828676864 18.249 100 90 181 1 1868234160 13632144 25925152
17:08:02 2532 8192000000 10763519024 11148222464 1826507808 18.231 100 84 166 4 1864379632 13835088 24036736
17:08:12 2823 8192000000 10772039328 11156656128 1833694944 18.289 100 92 180 1 1872084784 12755200 25634640
17:08:21 2905 8192000000 10781807120 11165540352 1835237808 18.302 100 85 170 0 1872867072 13519488 24109776
17:08:31 1874 8192000000 10792114912 11173490688 1843102832 18.366 100 91 183 0 1883029216 14064240 25862144
17:08:39 2345 8192000000 10793994448 11177738240 1847609424 18.403 100 90 181 3 1885397488 12728704 25059360
17:08:48 2832 8192000000 10799224736 11183837184 1856174016 18.472 100 87 175 2 1894458000 14056576 24227408
17:08:57 1955 8192000000 10804343424 11190398976 1859537008 18.500 100 93 185 2 1900677472 14898288 26242176
17:09:06 2359 8192000000 10804158640 11191070720 1861361536 18.514 100 93 186 1 1901154368 13617488 26175344
17:09:19 2016 8192000000 10803690960 11194155008 1866658240 18.557 100 87 174 0 1903822080 12387312 24776528
17:09:27 1734 8192000000 10814079120 11202101248 1869953488 18.584 100 98 194 2 1911810736 14060016 27797232
17:09:35 1607 8192000000 10823236464 11210645504 1873165536 18.610 100 95 190 0 1914999344 14143504 27690304
17:09:43 1963 8192000000 10820091904 11209981952 1877600864 18.646 100 91 181 1 1915640672 12671392 25368416
17:09:51 41976 8192000000 10802129328 11213950976 1876418576 18.636 100 66 127 1 1905761456 11155312 18187568
17:10:40 1418 8192000000 10825718752 11218362368 1884170912 18.699 100 78 157 3 1916536432 8396592 23968928
17:10:48 1994 8192000000 10821854384 11220918272 1886450896 18.717 100 78 156 1 1918862304 9626256 22785152
17:10:56 11566 8192000000 10804454816 11214983168 1876991520 18.641 100 37 75 1 1895386912 8487632 9907760
17:11:15 8829 8192000000 10803184752 11218055168 1878605152 18.654 100 44 87 1 1899703584 8481152 12617280
17:11:32 6771 8192000000 10789201280 11214127104 1878806016 18.655 100 34 68 0 1896366720 8127760 9432944
17:11:48 4951 8192000000 10802097904 11221102592 1881625072 18.678 100 30 60 1 1897392752 7674752 8092928
17:12:03 7766 8192000000 10794676768 11220377600 1881537232 18.678 100 27 56 0 1896087904 7369872 7180800
17:12:18 6654 8192000000 10793779968 11220660224 1882209616 18.683 100 20 40 0 1895645248 7316896 6118736
17:12:31 7080 8192000000 10793755376 11219447808 1885100704 18.706 100 25 50 0 1899165664 5591552 8473408
17:12:46 5564 8192000000 10808546992 11228917760 1892040816 18.762 100 36 72 1 1909701408 7987120 9673472
17:13:02 4872 8192000000 10804914144 11228672000 1891676192 18.759 100 26 52 0 1905191008 6293472 7221344
17:13:16 7550 8192000000 10794775120 11227209728 1890546960 18.750 100 16 32 1 1900396512 5150944 4698608
17:13:30 10199 8192000000 10797542224 11231100928 1892310448 18.764 100 24 48 0 1906189952 7226496 6653008
17:13:47 8110 8192000000 10799177232 11232677888 1893952528 18.778 100 25 50 0 1907547552 6043360 7551664
17:14:06 3753 8192000000 10811397840 11240603648 1897131296 18.803 100 30 60 3 1911592432 6180096 8281040
17:14:19 8092 8192000000 10806268400 11238866944 1896706848 18.800 100 13 26 1 1905698400 5449952 3541600
17:14:34 53962 8192000000 10831921328 11255455744 1904957792 18.866 100 35 69 1 1920971568 4957744 11056032
17:15:36 20141 8192000000 10855279824 11264688128 1914878080 18.946 100 68 137 2 1940382656 6313296 19191280
17:16:03 6135 8192000000 10823363648 11259285504 1913821504 18.937 100 42 84 0 1935488320 10294336 11372480
17:16:20 5982 8192000000 10816726320 11256524800 1913708384 18.936 100 33 66 2 1929339552 5855760 9775408
17:16:32 5277 8192000000 10829540720 11259985920 1914890176 18.946 100 33 66 0 1931887376 6667904 10329296
17:16:46 3427 8192000000 10841133392 11270115328 1915330656 18.949 100 36 73 2 1933378592 7968976 10078960
17:16:56 3430 8192000000 10841868528 11272577024 1915687600 18.952 100 40 78 1 1942495920 16294752 10513568
17:17:06 3253 8192000000 10827118512 11259187200 1913152160 18.932 100 30 61 0 1928165760 5769856 9243744
17:17:16 7389 8192000000 10814228256 11243909120 1885352320 18.708 99 20 40 3 1896458464 5386400 5719744
17:17:32 6628 8192000000 10815382656 11255201792 1908263024 18.893 100 21 42 0 1919924960 5790608 5871328
17:17:46 13791 8192000000 10811852320 11243548672 1872360400 18.603 98 23 46 1 1889148208 10124336 6663472
17:18:06 7890 8192000000 10820307936 11258863616 1905976144 18.874 100 16 31 0 1915286224 5558688 3751392
17:18:20 8928 8192000000 10799500720 11232456704 1848368752 18.409 97 19 38 1 1859120752 5689936 5062064
17:18:37 64353 8192000000 10783917872 11217805312 1783533952 17.879 94 30 58 2 1801515696 9126800 8854944
17:19:48 12828 8192000000 10776328352 11207929856 1852340288 18.441 98 18 36 1 1863341680 5609392 5392000
17:20:09 7554 8192000000 10784669104 11201548288 1829828896 18.258 98 41 84 2 1849771904 8082848 11860160
17:20:23 5015 8192000000 10769208480 11183132672 1843981424 18.373 99 40 78 0 1863859376 7607216 12270736
17:20:35 5115 8192000000 10747198480 11158147072 1809717280 18.094 99 39 78 0 1829288624 8479280 11092064
17:20:47 6512 8192000000 10755201024 11173429248 1791234688 17.942 97 27 54 0 1805346144 5451440 8660016
17:21:02 8459 8192000000 10704951360 11129135104 1768712992 17.756 97 28 55 1 1783296560 6300320 8283248
17:21:19 11528 8192000000 10721981104 11140587520 1761973584 17.701 97 17 33 1 1772231888 5482304 4776000
17:21:37 12783 8192000000 10746556848 11164807168 1805053360 18.055 99 24 48 1 1818063984 5357744 7652880
17:21:56 10017 8192000000 10728476720 11148976128 1776159936 17.818 97 29 58 1 1790905312 6855968 7889408
17:22:12 13182 8192000000 10723200944 11141738496 1766281344 17.736 97 15 30 0 1775866320 5603936 3981040
17:22:36 11332 8192000000 10716635648 11126009856 1689730160 17.099 93 33 66 1 1710318480 10051488 10536832
17:22:54 20528 8192000000 10698429648 11107491840 1682961312 17.042 94 28 55 1 1695902848 5212192 7729344
17:23:22 61357 8192000000 10693745744 11117981696 1748023328 17.585 97 26 53 1 1760552624 4980144 7549152
17:24:32 12380 8192000000 10722164272 11141767168 1797911200 17.997 100 23 46 1 1810235808 6180992 6143616
17:24:53 6231 8192000000 10715305584 11134189568 1798769600 18.004 100 16 32 1 1808274016 5099344 4405072
17:25:05 7491 8192000000 10730942800 11144728576 1810925248 18.103 100 33 64 3 1830953664 11203408 8825008
17:25:20 7800 8192000000 10734748480 11150925824 1815780688 18.143 100 17 34 2 1826063280 5261776 5020816
17:25:35 7219 8192000000 10743101440 11161165824 1825517616 18.223 100 36 72 3 1842047216 6960112 9569488
17:25:50 7152 8192000000 10736652656 11159089152 1830860224 18.266 100 32 64 1 1845769920 4858784 10050912
17:26:03 7123 8192000000 10748561680 11169124352 1832071952 18.276 100 29 58 4 1847115808 6439296 8604560
17:26:17 11301 8192000000 10742394400 11173888000 1837077536 18.317 100 21 42 2 1848438560 5379952 5981072
17:26:35 10961 8192000000 10754260576 11180290048 1839494832 18.337 100 15 30 0 1853838000 10048672 4294496
17:26:53 7478 8192000000 10752979680 11180380160 1845004448 18.382 100 20 40 1 1856472672 5583696 5884528
17:27:07 12744 8192000000 10769685552 11197603840 1860803968 18.510 100 16 31 2 1869753072 4836736 4112368
17:27:27 12534 8192000000 10772765984 11205308416 1871487856 18.596 100 21 39 1 1881907728 4757888 5661984
17:27:46 9462 8192000000 10833059760 11237351424 1888720288 18.735 100 67 133 2 1919049680 10867680 19461712
17:28:05 44947 8192000000 10820224320 11236909056 1891925280 18.761 100 51 102 2 1914331248 8492368 13913600
17:29:02 10305 8192000000 10842673072 11254513664 1902265328 18.845 100 51 103 0 1930770240 14131248 14373664
17:29:23 15689 8192000000 10833343536 11257835520 1904992688 18.866 100 43 85 2 1929915632 13127312 11795632
17:29:53 102521 8192000000 10835856320 11271958528 1912403104 18.926 100 43 85 1 1934295744 8982976 12909664
17:31:44 29462 8192000000 10853758880 11272146944 1917229600 18.965 100 36 72 1 1936848880 8969392 10649888
17:32:21 7782 8192000000 10881845264 11291107328 1928047200 19.051 100 70 138 2 1960096560 11963264 20086096
17:32:41 5758 8192000000 10873289712 11291824128 1930850528 19.074 100 69 138 0 1962425360 12141984 19432848
17:32:59 19711 8192000000 10887614944 11311996928 1934426944 19.102 100 57 114 3 1974356608 24322608 15607056
17:33:32 13782 8192000000 10883945136 11303821312 1941603168 19.160 100 61 122 3 1976891744 17240480 18048096
17:33:54 12569 8192000000 10888094960 11310460928 1943403696 19.174 100 50 100 1 1969355056 11699120 14252240
17:34:14 11597 8192000000 10887671728 11311149056 1950077120 19.227 100 55 110 3 1977064848 11256624 15731104
17:34:34 8657 8192000000 10889299904 11315875840 1951937280 19.242 100 65 129 6 1982078032 11821056 18319696
17:35:16 13604 8192000000 10888178688 11316428800 1938678160 19.136 99 54 106 2 1966388560 12405136 15305264
17:35:38 14904 8192000000 10897795328 11323564032 1955385296 19.269 100 45 90 0 1982407488 13539520 13482672
17:36:03 7828 8192000000 10891188688 11322359808 1960235952 19.308 100 56 112 2 1988929280 11885440 16807888
17:36:18 6963 8192000000 10910350464 11333980160 1965683264 19.351 100 59 115 3 1994570576 11739136 17148176
17:36:38 21110 8192000000 10902690176 11340132352 1969453696 19.381 100 50 100 2 1999859616 15482944 14922976
17:37:09 9757 8192000000 10919423136 11348905984 1973802800 19.416 100 44 88 0 2001682384 14530608 13348976
17:37:27 10351 8192000000 10920932784 11351142400 1978987568 19.457 100 41 80 0 2004670592 14355056 11327968
17:37:45 7085 8192000000 10922940896 11353628672 1980164608 19.466 100 63 125 2 2014025216 15537680 18322928
17:38:05 4742 8192000000 10929373600 11355209728 1982035120 19.481 100 51 102 1 2014510128 17478032 14996976
17:38:17 20564 8192000000 10925579152 11362041856 1985958704 19.512 100 57 112 1 2021182928 18657312 16566912
17:38:47 2644 8192000000 10933757952 11363459072 1988178416 19.529 100 59 117 1 2027358640 21059776 18120448
17:38:59 4004 8192000000 10931688128 11362717696 1990018416 19.544 100 59 118 0 2025425968 17814144 17593408
17:39:14 9999 8192000000 10925708560 11365273600 1988674224 19.533 100 52 104 1 2020448368 16257856 15516288
17:39:31 15087 8192000000 10922910672 11364741120 1987612432 19.525 100 40 80 0 2015566096 16020496 11933168
17:39:55 6246 8192000000 10930540224 11361796096 1984570544 19.501 100 54 107 1 2017702704 17097856 16034304
17:40:09 10773 8192000000 10929923296 11362119680 1971668016 19.399 99 59 116 0 2010047696 20366352 18013328
17:40:30 8807 8192000000 10930362272 11365994496 1991187024 19.553 100 62 124 1 2029036944 18280864 19569056
17:40:51 8556 8192000000 10923703280 11357462528 1977068672 19.441 99 57 110 2 2012940944 18709440 17162832
17:41:11 3598 8192000000 10933926160 11370950656 1992124656 19.561 100 61 122 0 2029707744 17908016 19675072
17:41:24 11176 8192000000 10935142080 11371917312 1992254240 19.562 100 55 109 1 2026613280 17686256 16672784
17:41:44 8895 8192000000 10953618096 11385245696 2001060864 19.631 100 56 110 0 2038701056 20485040 17155152
17:42:06 4631 8192000000 10963483536 11395567616 2013703488 19.731 100 63 127 2 2052315728 19534784 19077456
17:42:21 2233 8192000000 10970535936 11397787648 2016186688 19.750 100 72 144 1 2059739568 21538592 22014288
17:42:37 8639 8192000000 10977481168 11405291520 2014200048 19.735 100 63 125 1 2054850032 21705008 18944976
17:42:54 3747 8192000000 10987562368 11410845696 2023039808 19.804 100 68 135 1 2065678304 21914896 20723600
17:43:08 4034 8192000000 10982698064 11404148736 2016470304 19.752 100 71 142 2 2061478272 22651088 22356880
17:43:19 6162 8192000000 10970135920 11397337088 1999618768 19.620 99 80 160 0 2045402064 21489552 24293744
17:43:35 16749 8192000000 10977151088 11408470016 2016671184 19.754 100 61 123 0 2061307040 26297664 18338192
17:43:59 4949 8192000000 10978949488 11413753856 2019630528 19.777 100 67 133 0 2067665536 27588736 20446272
17:44:14 7560 8192000000 10966465072 11399434240 2008868912 19.693 100 60 120 1 2054497632 26973184 18655536
17:44:29 3515 8192000000 10972802928 11399938048 2010847104 19.708 100 68 136 1 2059257168 27122912 21287152
17:44:41 2751 8192000000 10992260000 11416313856 2020550512 19.784 100 86 171 3 2074976128 28185104 26240512
17:44:50 2074 8192000000 10987486240 11405152256 2007596992 19.683 100 83 165 0 2061977024 29158144 25221888
17:44:59 3113 8192000000 10978614208 11407749120 2012380656 19.720 100 74 148 0 2064020048 29456048 22183344
17:45:09 2210 8192000000 10986074624 11407110144 2019830944 19.779 100 85 170 2 2069562304 25302880 24428480
17:45:21 1585 8192000000 10994544608 11412185088 2021302720 19.790 100 80 153 3 2070911312 26608608 22999984
17:45:31 6090 8192000000 11006266384 11424301056 2028153888 19.844 100 87 172 1 2083817024 29915264 25747872
17:45:44 1493 8192000000 10985529600 11403247616 2005797264 19.668 99 86 173 0 2062386512 31069184 25520064
17:45:53 2641 8192000000 11001597440 11421773824 2025046256 19.820 100 87 172 0 2082767184 32827440 24893488
17:46:03 7071 8192000000 10980866176 11406659584 2011471616 19.713 100 74 148 2 2066315168 33092528 21751024
17:46:18 7048 8192000000 10957767280 11389132800 1995299200 19.586 99 72 142 3 2047697328 30176496 22221632
17:46:38 1227 8192000000 10969913648 11394813952 1994958864 19.583 99 74 149 3 2049299920 31342592 22998464
17:46:48 4983 8192000000 10939091968 11367055360 1959255360 19.300 99 62 123 1 2009494096 31685952 18552784
17:47:00 4415 8192000000 10955725520 11384311808 1989024192 19.536 100 71 143 1 2043591888 32540240 22027456
17:47:15 12073 8192000000 10938804944 11367583744 1948629392 19.216 98 58 117 1 1999350160 32795088 17925680
17:47:34 2191 8192000000 10962875392 11381997568 1985790384 19.511 100 82 164 0 2045300768 34299728 25210656
17:47:45 3371 8192000000 10958008448 11391700992 1992085136 19.560 100 69 138 0 2045277648 31826864 21365648
17:47:57 4890 8192000000 10950726640 11383578624 1987140960 19.521 100 60 120 1 2034857216 30003168 17713088
17:48:11 4995 8192000000 10911026480 11316912128 1907849360 18.889 96 77 154 2 1959744560 29446896 22448304
17:48:23 1940 8192000000 10898827632 11311591424 1925841088 19.034 99 77 152 1 1978049696 29554016 22654592
17:48:36 4336 8192000000 10907866800 11340152832 1950267680 19.229 100 53 108 0 1995863296 28702944 16892672
17:48:50 4368 8192000000 10920971376 11347480576 1960048320 19.306 100 70 137 2 2010338800 28848752 21441728
17:49:07 1226 8192000000 10946060544 11361792000 1976197152 19.435 100 84 168 0 2033826352 30643488 26985712
17:49:15 4743 8192000000 10919943520 11340615680 1950702192 19.232 100 71 140 3 2004735616 32414432 21618992
17:49:35 3244 8192000000 10919640144 11335106560 1933999344 19.099 99 83 163 0 1992745632 33291344 25454944
17:49:46 2611 8192000000 10931926096 11350917120 1962128432 19.323 100 68 136 2 2017672784 34427568 21116784
17:49:56 3867 8192000000 10942609968 11356012544 1962794736 19.328 100 78 157 1 2022710560 35820416 24095408
17:50:08 4233 8192000000 10933101792 11348344832 1945874144 19.194 99 83 166 1 2006812800 34778560 26160096
17:50:19 3333 8192000000 10927839520 11334762496 1942980304 19.171 100 87 171 0 2005934784 35785936 27168544
17:50:28 6385 8192000000 10899945504 11322580992 1926144304 19.036 99 63 126 0 1985995760 39828816 20022640
17:50:47 9691 8192000000 10921941008 11342503936 1948672480 19.216 100 60 118 1 2005144384 37419376 19052528
17:51:08 5552 8192000000 10930773552 11341512704 1946760416 19.201 100 76 151 1 2009958576 39504752 23693408
17:51:21 2919 8192000000 10921945568 11342303232 1944655872 19.184 100 59 119 0 2003667184 39968288 19043024
17:51:33 12308 8192000000 10927798848 11360587776 1955383248 19.269 100 41 81 1 2012428080 43966480 13078352
17:51:53 7616 8192000000 10929303328 11364745216 1959163728 19.299 100 42 82 1 2012726896 39710880 13852288
17:52:10 7621 8192000000 10934089952 11360731136 1960966560 19.314 100 50 98 1 2015883824 38924336 15992928
17:52:25 4494 8192000000 10941695152 11361476608 1963880400 19.337 100 74 148 0 2027921632 40061232 23980000
17:52:37 3428 8192000000 10956666288 11364061184 1966515968 19.358 100 90 178 1 2037773968 42486336 28771664
17:52:50 5275 8192000000 10947414320 11373051904 1971120416 19.394 100 64 128 2 2034863856 43672976 20070464
17:53:05 7371 8192000000 10935616688 11368628224 1950190128 19.228 99 49 96 1 2010317488 43970608 16156752
17:53:19 10470 8192000000 10948202048 11371278336 1951893200 19.242 99 55 107 1 2015147168 44695984 18557984
17:53:37 5599 8192000000 10948117136 11371540480 1952368352 19.245 99 59 118 1 2020073248 47791280 19913616
17:53:57 13953 8192000000 10941964896 11374575616 1945224176 19.188 99 49 98 1 2011215040 49240848 16750016
17:54:20 10878 8192000000 10942369152 11378749440 1962552032 19.326 100 46 92 1 2025995808 47581680 15862096
17:54:44 17148 8192000000 10944790336 11385298944 1952309600 19.245 99 45 85 1 2017830768 50700432 14820736
17:55:15 6357 8192000000 10948289376 11382063104 1970881664 19.392 100 49 95 2 2028845680 42435376 15528640
17:55:29 6997 8192000000 10963269232 11391721472 1984596480 19.501 100 63 126 3 2047790992 42487712 20706800
17:55:43 11554 8192000000 10947562016 11390324736 1982520272 19.485 100 39 78 1 2037717344 41587760 13609312
17:56:05 13777 8192000000 10950242208 11385217024 1967458160 19.365 99 46 92 1 2022847440 41404560 13984720
17:56:32 7954 8192000000 10962539040 11391291392 1967248928 19.364 99 50 100 1 2027719984 44295120 16175936
17:56:55 18763 8192000000 10955086880 11402960896 1983024496 19.489 100 38 76 1 2043665696 48155792 12485408
17:57:21 16406 8192000000 10949174848 11391877120 1975633152 19.430 100 34 68 2 2035983616 48913968 11436496
17:57:46 9170 8192000000 10950243760 11394371584 1971428720 19.397 100 36 72 1 2034862864 50602128 12832016
17:58:03 10778 8192000000 10939031680 11387609088 1963370960 19.333 100 30 60 2 2023047392 49083920 10592512
17:58:21 20577 8192000000 10916388304 11371159552 1955009232 19.266 100 25 50 2 2012934896 48735312 9190352
17:58:48 16476 8192000000 10906629072 11361554432 1926705312 19.041 99 25 50 0 1987084544 50632816 9746416
17:59:11 30538 8192000000 10924942064 11381059584 1943917664 19.178 100 26 52 2 2011535248 57588864 10028720
17:59:57 25615 8192000000 10917180736 11363074048 1940007104 19.147 100 19 38 0 1989858352 43316704 6534544
18:00:30 13999 8192000000 10917909360 11359866880 1934156112 19.100 99 54 106 1 1985934016 35573072 16204832
18:00:50 24758 8192000000 10878207280 11337007104 1913249792 18.933 98 17 35 1 1932969744 14192576 5527376
18:01:22 32473 8192000000 10887983200 11341377536 1945899120 19.194 100 18 36 1 1965099424 13331632 5868672
18:02:06 66698 8192000000 10923611904 11362942976 1972506656 19.405 100 31 61 2 1997061632 14262144 10292832
18:03:19 53948 8192000000 10906507552 11372253184 1954535520 19.263 99 15 28 1 1977342352 18610128 4196704
18:04:24 38257 8192000000 10879618368 11332661248 1931727600 19.081 98 24 48 3 1957038096 18594320 6716176
18:05:11 35025 8192000000 10893802000 11345178624 1943974592 19.178 99 30 60 1 1961778032 9247488 8555952
18:07:11 42857 8192000000 10875122400 11325923328 1902028608 18.843 97 25 50 0 1918832528 10123840 6680080
18:08:12 91772 8192000000 10881815104 11351613440 1957107792 19.283 100 17 34 0 1973698384 12137840 4452752
18:09:54 95070 8192000000 10890967200 11366191104 1951501680 19.238 99 17 34 0 1972306544 16037184 4767680
18:11:36 74853 8192000000 10900269696 11364343808 1960285632 19.308 99 25 49 2 1978725344 11987552 6452160
18:12:57 106827 8192000000 10891505920 11368505344 1955331568 19.269 99 12 23 0 1977798896 19285392 3181936
18:14:51 73797 8192000000 10913749856 11371110400 1976314304 19.436 100 19 38 2 1997458752 15161920 5982528
18:16:12 119481 8192000000 10917319264 11402801152 1990193104 19.545 100 18 36 2 2017485360 22260736 5031520
18:18:54 32712 8192000000 10924876064 11395846144 2003509408 19.650 100 26 52 2 2026923120 15941840 7471872
18:19:39 50712 8192000000 10928412176 11401093120 1999347728 19.618 100 31 62 1 2026542496 18578016 8616752
18:20:47 44388 8192000000 10917347040 11396005888 1992364880 19.562 100 10 21 0 2012398704 16665360 3368464
18:21:41 41401 8192000000 10920153728 11401637888 1995416400 19.587 100 11 21 0 2015712832 18015968 2280464
18:22:29 43836 8192000000 10909359264 11388063744 1992871360 19.566 100 13 26 0 2007906496 11278048 3757088
18:23:20 33963 8192000000 10904865312 11374071808 1976308688 19.435 99 15 30 0 1993482656 12559568 4614400
18:24:03 105229 8192000000 10907180528 11385860096 1974482816 19.421 99 22 45 1 1991255936 10350368 6422752
18:25:56 48847 8192000000 10918024368 11391086592 1976934096 19.440 99 15 30 0 1991830144 10232384 4663664
18:27:16 88768 8192000000 10908359744 11394957312 1979850128 19.464 99 20 40 2 2003341488 17637648 5853712
18:28:56 34966 8192000000 10909709792 11375702016 1975585472 19.430 99 13 24 1 1989232784 10068880 3578432
18:29:43 41776 8192000000 10919368832 11397160960 1963023232 19.330 98 24 48 2 1980956064 11424624 6508208
18:30:35 120511 8192000000 10935174544 11404980224 1961761824 19.320 98 11 22 0 1977935424 13124352 3049248
18:32:47 25321 8192000000 10918762320 11377238016 1950744848 19.232 98 32 64 2 1970559552 11129792 8684912
18:33:23 78259 8192000000 10873760080 11348942848 1882555152 18.686 95 43 85 4 1908235504 13875712 11804640
18:34:52 15666 8192000000 10914223872 11362074624 1956111424 19.275 99 40 79 0 1976208432 8796624 11300384
18:35:18 66739 8192000000 10907397264 11370143744 1955680784 19.272 99 24 48 1 1975598848 12809888 7108176
18:36:40 74941 8192000000 10863624704 11340800000 1911730592 18.921 98 14 28 1 1931224592 15566656 3927344
18:38:02 45910 8192000000 10894460784 11341332480 1926765488 19.041 98 42 84 3 1947331792 7965712 12600592
18:38:54 43862 8192000000 10891823024 11361103872 1938679840 19.136 99 37 73 1 1959750976 10643136 10428000
18:40:46 37200 8192000000 10904740800 11366821888 1938225136 19.133 98 19 39 0 1957870288 14425504 5219648
18:41:35 78116 8192000000 10906245280 11381309440 1907359664 18.885 97 20 40 0 1929840480 16616112 5864704
18:43:08 106697 8192000000 10887690944 11345833984 1920651664 18.992 98 26 52 0 1946814128 18859120 7303344
18:45:01 77352 8192000000 10808720880 11265462272 1821274400 18.188 93 17 34 0 1835476400 9502832 4699168
18:46:40 25438 8192000000 10836027776 11277754368 1892028688 18.762 98 47 94 1 1914123568 9140480 12954400
18:47:13 21542 8192000000 10854963520 11317747712 1912692464 18.928 99 32 64 1 1932070896 10466000 8912432
18:47:45 51681 8192000000 10841406272 11323572224 1911103216 18.916 99 12 24 0 1924461264 8655536 4702512
18:48:46 34143 8192000000 10855884752 11324276736 1914607856 18.944 99 6 12 0 1924009632 7965808 1435968
18:49:26 58150 8192000000 10832321600 11306688512 1861825040 18.518 96 9 18 0 1873643488 8953360 2865088
18:50:44 72775 8192000000 10860734752 11333959680 1942709344 19.168 100 9 18 1 1953469808 7939632 2820832
18:52:08 72565 8192000000 10867796704 11342077952 1927682160 19.048 99 10 20 1 1939847728 9043504 3122064
18:54:55 84142 8192000000 10894009168 11365154816 1959135280 19.299 100 21 42 1 1978760896 13611584 6014032
18:56:27 63197 8192000000 10876020304 11344908288 1909398496 18.902 97 21 43 1 1927348880 11307792 6642592
18:57:40 84644 8192000000 10870975648 11329503232 1830554528 18.264 94 13 26 0 1842383616 8296768 3532320
18:59:10 53141 8192000000 10886237856 11351318528 1936542112 19.119 99 32 64 1 1956552448 11249328 8761008
19:00:10 80651 8192000000 10842938048 11313319936 1788847648 17.922 92 12 25 0 1801677312 9998880 2830784
19:01:37 60035 8192000000 10855941952 11312193536 1877283232 18.643 97 19 37 0 1890697120 8330848 5083040
19:02:52 36476 8192000000 10903793568 11349397504 1928028688 19.051 99 30 60 0 1956013616 19332032 8652896
19:03:36 55485 8192000000 10881415696 11358658560 1950661632 19.232 100 29 58 1 1975283136 16574944 8046560
19:04:52 76228 8192000000 10876928944 11349524480 1912269936 18.925 98 10 20 0 1930563632 16054464 2239232
19:06:18 158838 8192000000 10892943552 11371245568 1906546176 18.879 97 25 50 1 1934973440 21610272 6816992
19:09:05 29782 8192000000 10917421360 11363958784 1966643136 19.359 100 28 56 0 1981643552 7745552 7254864
19:09:42 39743 8192000000 10903700784 11365826560 1973163680 19.411 100 40 80 0 1992738528 8188144 11386704
19:10:52 65663 8192000000 10901207328 11369549824 1975084768 19.426 100 16 32 1 1986661104 7361536 4214800
19:12:05 53159 8192000000 10898143984 11362476032 1946929248 19.202 98 26 52 1 1962007472 7424800 7653424
19:13:06 67875 8192000000 10895731776 11376422912 1960957904 19.314 99 22 42 2 1979587264 11755216 6874144
19:14:21 65672 8192000000 10901667664 11387682816 1980395424 19.468 100 5 10 0 1997115328 15129280 1590624
19:15:54 38879 8192000000 10895131520 11380064256 1970247744 19.387 100 11 22 1 1987687792 14169472 3270576
19:16:40 64425 8192000000 10869392080 11341217792 1922197792 19.004 97 14 28 1 1938392080 11865600 4328688
19:17:50 70350 8192000000 10845243856 11315752960 1884637872 18.703 96 17 33 1 1899842944 10473824 4731248
19:19:19 99011 8192000000 10891376208 11365666816 1941201216 19.156 99 12 24 0 1956648928 12584064 2863648
19:21:05 41530 8192000000 10879285312 11347410944 1910254288 18.909 97 21 42 2 1923920112 7830896 5834928
19:22:13 45209 8192000000 10904359760 11366645760 1929871296 19.066 98 18 36 0 1947525136 11913584 5740256
19:23:06 61167 8192000000 10875026112 11341271040 1886354640 18.716 96 25 50 1 1910203904 16283664 7565600
19:24:30 145070 8192000000 10868617376 11353489408 1867360192 18.563 96 16 32 1 1893028512 20703744 4964576
19:27:01 45700 8192000000 9122493664 9355538432 285788848 3.371 15 1 2 0 286722368 789712 143808

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 11-06-2021 19:28:51 to 11-06-2021 19:29:24.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 117 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 11-06-2021 19:29:25 to 11-06-2021 19:29:26.

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          229595
MON$OLDEST_ACTIVE               229596
MON$OLDEST_SNAPSHOT             229596
MON$NEXT_TRANSACTION            229596
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                       2014080
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.33472 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33472 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33472 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33472 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 ---
--- end of diff output ---

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

11.06.21 19:29:27. 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
2021-06-11 19:29:30 No severe PSQL-related problems occured
11.06.21 19:29:31. End of report.