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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17272276 kB
MemAvailable 31250600 kB
Buffers 0 kB
Cached 14395388 kB
SwapCached 4868 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-01-26 22:27:18
DTS_END                         2021-01-26 22:27:18.0420
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/42482
TRN_ID                          244455
ATT_ID                          638
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: 9237.94 22224 1108553
customer order: creation 177.58 371 21310
customer order: refuse 15.08 320 1810
order to supplier: creation 48.79 1241 5855
order to supplier: removal 3.43 102048 411
invoice (draft): creation 48.61 3108 5833
invoice (draft): removal 52.00 771 6240
invoice accept: apply 42.63 18374 5115
invoice accept: cancel 46.43 800 5571
customer reserve: creation 3943.37 184 473204
customer reserve: removal 4563.44 60 547613
realization accept: apply 86.18 158 10341
realization accept: cancel 77.52 117 9302
payment from customer: creation 61.20 111 7344
payment from customer: removal 6.03 83 723
payment to supplier: creation 50.37 123 6044
payment to supplier: removal 3.15 95 378
service: total inventory turnovers 4.98 1007 598
service: total monetary turnovers 6.36 43 763
service: aggregate perf. data 0.78 22753 94
service: refresh index statistics 0.03 292721 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-01-2021 22:28:37 to 26-01-2021 22:28:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3927
TEST_TIME 2 3571
TEST_TIME 3 3619
TEST_TIME 4 4734
TEST_TIME 5 5074
TEST_TIME 6 4846
TEST_TIME 7 4957
TEST_TIME 8 5852
TEST_TIME 9 5894
TEST_TIME 10 5859
TEST_TIME 11 6108
TEST_TIME 12 6454
TEST_TIME 13 6539
TEST_TIME 14 6918
TEST_TIME 15 7315
TEST_TIME 16 7457
TEST_TIME 17 7733
TEST_TIME 18 7850
TEST_TIME 19 8192
TEST_TIME 20 9022
TEST_TIME 21 9264
TEST_TIME 22 9540
TEST_TIME 23 9639
TEST_TIME 24 9911
TEST_TIME 25 10287
TEST_TIME 26 11214
TEST_TIME 27 10983
TEST_TIME 28 10714
TEST_TIME 29 10667
TEST_TIME 30 10556
TEST_TIME 31 10632
TEST_TIME 32 10535
TEST_TIME 33 10333
TEST_TIME 34 10378
TEST_TIME 35 10284
TEST_TIME 36 10211
TEST_TIME 37 10191
TEST_TIME 38 10426
TEST_TIME 39 10292
TEST_TIME 40 10290
TEST_TIME 41 10277
TEST_TIME 42 10111
TEST_TIME 43 10116
TEST_TIME 44 9981
TEST_TIME 45 9899
TEST_TIME 46 9795
TEST_TIME 47 9772
TEST_TIME 48 9599
TEST_TIME 49 9491
TEST_TIME 50 9576
TEST_TIME 51 9598
TEST_TIME 52 9584
TEST_TIME 53 9575
TEST_TIME 54 9649
TEST_TIME 55 9791
TEST_TIME 56 9753
TEST_TIME 57 9804
TEST_TIME 58 9792
TEST_TIME 59 9818
TEST_TIME 60 9926
TEST_TIME 61 9931
TEST_TIME 62 9858
TEST_TIME 63 9875
TEST_TIME 64 9757
TEST_TIME 65 9685
TEST_TIME 66 9681
TEST_TIME 67 9709
TEST_TIME 68 9614
TEST_TIME 69 9620
TEST_TIME 70 9546
TEST_TIME 71 9577
TEST_TIME 72 9564
TEST_TIME 73 9585
TEST_TIME 74 9647
TEST_TIME 75 9633
TEST_TIME 76 9647
TEST_TIME 77 9622
TEST_TIME 78 9674
TEST_TIME 79 9644
TEST_TIME 80 9716
TEST_TIME 81 9651
TEST_TIME 82 9553
TEST_TIME 83 9550
TEST_TIME 84 9511
TEST_TIME 85 9504
TEST_TIME 86 9502
TEST_TIME 87 9439
TEST_TIME 88 9389
TEST_TIME 89 9360
TEST_TIME 90 9303
TEST_TIME 91 9368
TEST_TIME 92 9354
TEST_TIME 93 9377
TEST_TIME 94 9350
TEST_TIME 95 9362
TEST_TIME 96 9358
TEST_TIME 97 9387
TEST_TIME 98 9405
TEST_TIME 99 9420
TEST_TIME 100 9409
TEST_TIME 101 9394
TEST_TIME 102 9424
TEST_TIME 103 9536
TEST_TIME 104 9551
TEST_TIME 105 9548
TEST_TIME 106 9462
TEST_TIME 107 9438
TEST_TIME 108 9414
TEST_TIME 109 9426
TEST_TIME 110 9380
TEST_TIME 111 9364
TEST_TIME 112 9331
TEST_TIME 113 9295
TEST_TIME 114 9260
TEST_TIME 115 9235
TEST_TIME 116 9251
TEST_TIME 117 9272
TEST_TIME 118 9312
TEST_TIME 119 9288
TEST_TIME 120 9240

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-01-2021 22:28:41 to 26-01-2021 22: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 1546860 1546860 0 0.00 0 28209 6 0 0
doc_list_biud 1546859 1546859 0 0.00 0 30862 27 0 0
sp_add_invoice_to_stock 5226 5115 111 2.12 44 205060 18375 0 111
sp_cancel_adding_invoice 5571 5571 0 0.00 6 73268 800 0 0
sp_cancel_client_order 1810 1810 0 0.00 4 18687 321 0 0
sp_cancel_customer_reserve 547613 547613 0 0.00 1 21016 61 0 0
sp_cancel_pay_from_customer 723 723 0 0.00 3 7043 84 0 0
sp_cancel_pay_to_supplier 378 378 0 0.00 3 3936 96 0 0
sp_cancel_supplier_invoice 6248 6240 8 0.12 2 21411 772 0 8
sp_cancel_supplier_order 411 411 0 0.00 5 1159706 102049 0 0
sp_cancel_write_off 9302 9302 0 0.00 1 10483 117 0 0
sp_client_order 21310 21310 0 0.00 3 18519 371 0 0
sp_customer_reserve 473204 473204 0 0.00 0 166550 184 0 0
sp_fill_shopping_cart 32994 32994 0 0.00 1 15097 40 0 0
sp_fill_shopping_cart_clo_res 473200 473200 0 0.00 0 16443 17 0 0
sp_get_clo_for_invoice 5111 5111 0 0.00 0 37215 326 0 0
sp_kill_cost_storno 15974 15974 0 0.00 0 7039 57 0 0
sp_kill_qstorno_ret_qs2qd 1111179 1111179 0 0.00 0 21907 33 0 0
sp_kill_qty_storno 586399 586399 0 0.00 0 30859 70 0 0
sp_lock_selected_doc 21318 21318 0 0.00 0 9517 5 0 0
sp_make_cost_storno 28840 28840 0 0.00 0 28203 46 0 0
sp_multiply_rows_for_pdistr 28840 28840 0 0.00 0 7346 24 0 0
sp_multiply_rows_for_qdistr 21310 21310 0 0.00 0 18505 184 0 0
sp_pay_from_customer 7344 7344 0 0.00 4 17900 112 0 0
sp_pay_to_supplier 6044 6044 0 0.00 4 13984 123 0 0
sp_payment_common 13388 13388 0 0.00 1 17897 35 0 0
sp_qd_handle_on_cancel_clo 1810 1810 0 0.00 0 18673 288 0 0
sp_qd_handle_on_invoice_upd_sts 10682 10682 0 0.00 0 30856 310 0 0
sp_qd_handle_on_reserve_upd_sts 10341 10341 0 0.00 0 21119 57 0 0
sp_reserve_write_off 10341 10341 0 0.00 6 21138 159 0 0
sp_supplier_invoice 5833 5833 0 0.00 6 101477 3109 0 0
sp_supplier_order 5855 5855 0 0.00 6 33979 1242 0 0
srv_aggregate_perf_data 94 94 0 0.00 3313 193515 22754 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 1298 156658 33529 0 0
srv_find_qd_qs_mism 1059389 1059389 0 0.00 0 18393 5 0 0
srv_make_invnt_saldo 598 598 0 0.00 46 36432 1008 0 0
srv_make_money_saldo 763 763 0 0.00 0 10349 44 0 0
srv_recalc_idx_stat 4 4 0 0.00 85940 461100 292722 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5115 5115 0 0.00 0 12134 154 0 0
t$perf-norm:sp_cancel_adding_invoice 406 406 0 0.00 0 10458 109 0 0
t$perf-norm:sp_cancel_client_order 1810 1810 0 0.00 0 9978 19 0 0
t$perf-norm:sp_cancel_customer_reserve 700 700 0 0.00 0 4430 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 723 723 0 0.00 0 2336 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 378 378 0 0.00 0 567 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 396 396 0 0.00 0 838 14 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 28913 1681 0 0
t$perf-norm:sp_cancel_write_off 1042 1042 0 0.00 0 11722 17 0 0
t$perf-norm:sp_client_order 21310 21310 0 0.00 0 11463 16 0 0
t$perf-norm:sp_customer_reserve 1047 1047 0 0.00 0 4877 18 0 0
t$perf-norm:sp_pay_from_customer 7344 7344 0 0.00 0 9598 13 0 0
t$perf-norm:sp_pay_to_supplier 6044 6044 0 0.00 0 5008 7 0 0
t$perf-norm:sp_reserve_write_off 10341 10341 0 0.00 0 11126 13 0 0
t$perf-norm:sp_supplier_invoice 5833 5833 0 0.00 0 10781 16 0 0
t$perf-norm:sp_supplier_order 5855 5855 0 0.00 0 6308 17 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 425 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 161 5 0 0
t$perf-norm:srv_make_invnt_saldo 598 598 0 0.00 0 928 20 0 0
t$perf-norm:srv_make_money_saldo 763 763 0 0.00 0 2766 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10444 10222 222 2.12 0 5816 19 0 222
v_all_customers 38628 38628 0 0.00 0 86 1 0 0
v_all_suppliers 32366 32366 0 0.00 0 20 1 0 0
v_all_wares 42620 42620 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 812 812 0 0.00 0 2167 9 0 0
v_cancel_client_order 3620 3620 0 0.00 0 1760 3 0 0
v_cancel_customer_prepayment 1446 1446 0 0.00 0 3667 7 0 0
v_cancel_customer_reserve 1400 1400 0 0.00 0 1464 6 0 0
v_cancel_payment_to_supplier 756 756 0 0.00 0 2107 11 0 0
v_cancel_supplier_invoice 808 792 16 1.98 0 2251 20 0 16
v_cancel_supplier_order 822 822 0 0.00 0 626 5 0 0
v_cancel_write_off 2084 2084 0 0.00 0 1759 12 0 0
v_max_id_clo_ord 5854 5854 0 0.00 0 1629 1 0 0
v_max_id_clo_res 1047 1047 0 0.00 0 3515 24 0 0
v_max_id_ord_sup 5830 5830 0 0.00 0 4041 3 0 0
v_max_non_paid_invoice 1545 1545 0 0.00 0 3113 6 0 0
v_max_non_paid_realizn 3967 3967 0 0.00 0 1244 3 0 0
v_min_id_clo_ord 5854 5854 0 0.00 0 11746 9 0 0
v_min_id_clo_res 1047 1047 0 0.00 0 6790 15 0 0
v_min_id_ord_sup 5830 5830 0 0.00 0 7712 9 0 0
v_min_non_paid_invoice 6044 6044 0 0.00 0 9095 18 0 0
v_min_non_paid_realizn 7344 7344 0 0.00 0 17893 24 0 0
v_our_firm 10746 10746 0 0.00 0 17 1 0 0
v_reserve_write_off 20682 20682 0 0.00 0 3758 5 0 0
x_lock_depdocs_on_canc_invoice 11415 11415 0 0.00 0 18204 130 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 12296 359 0 0
x_make_qstorno_1000_1200 5855 5855 0 0.00 2 33969 1158 0 0
x_make_qstorno_1200_2000 5833 5833 0 0.00 3 92161 2973 0 0
x_make_qstorno_2100_3300 473204 473204 0 0.00 0 166547 165 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-01-2021 22:28:45 to 26-01-2021 22: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
19:57:21 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:28 31052 8192000000 10310273392 10619166720 1000425616 10.883 75 58 115 1 1021942688 2967792 18549280
19:58:09 38748 8192000000 10376409824 10695221248 1421817952 14.789 100 91 183 0 1456565200 5336736 29410512
19:59:02 1605 8192000000 10387686384 10710716416 1448262080 15.023 100 89 179 0 1483859024 6613984 28982960
19:59:14 21033 8192000000 10418594752 10745290752 1472965008 15.240 100 87 175 1 1508186688 7196064 28025616
19:59:45 31961 8192000000 10447854496 10779316224 1495358512 15.436 100 89 178 0 1532175472 8132032 28684928
20:00:25 10916 8192000000 10457152096 10790219776 1510637088 15.569 100 89 178 1 1547120208 8680672 27802448
20:00:47 8824 8192000000 10459611072 10797535232 1522690544 15.674 100 84 168 0 1557855456 9244656 25920256
20:01:10 14650 8192000000 10477440864 10816720896 1537324480 15.800 100 87 174 0 1574234512 9828736 27081296
20:01:37 16330 8192000000 10492993696 10838810624 1550103088 15.911 100 85 170 2 1586451344 10326448 26021808
20:02:02 17544 8192000000 10519804224 10870050816 1573513504 16.112 100 78 156 1 1607075104 10214944 23346656
20:02:28 18420 8192000000 10562082816 10913644544 1614630624 16.464 100 86 171 1 1650894016 11152032 25111360
20:02:54 10379 8192000000 10575307904 10930651136 1635825744 16.644 100 85 170 0 1673490416 12347840 25316832
20:03:12 14587 8192000000 10597490528 10953682944 1650265360 16.767 100 80 158 4 1685865248 12782128 22817760
20:03:34 9643 8192000000 10610173648 10969563136 1667229200 16.910 100 85 170 2 1705192240 13383920 24579120
20:03:51 6750 8192000000 10618563120 10982998016 1682521072 17.039 100 83 165 2 1719541696 13208160 23812464
20:04:08 8810 8192000000 10635212688 11002834944 1695488416 17.147 100 81 158 1 1731226864 12733920 23004528
20:04:29 8813 8192000000 10658255456 11031531520 1716245232 17.321 100 83 166 3 1753164960 12467344 24452384
20:04:47 7769 8192000000 10657974608 11039444992 1730943296 17.443 100 76 148 1 1764767440 12684032 21140112
20:05:02 5586 8192000000 10680325104 11056730112 1744399968 17.555 100 80 160 0 1779199024 12161216 22637840
20:05:15 4794 8192000000 10696017744 11071279104 1761639376 17.698 100 84 167 2 1797854448 12570640 23644432
20:05:27 4064 8192000000 10703865328 11082444800 1767231424 17.744 100 81 163 0 1807382192 16930384 23220384
20:05:38 4642 8192000000 10712665344 11091173376 1773504784 17.796 100 83 165 1 1809677408 13358048 22814576
20:05:50 3302 8192000000 10721120352 11098808320 1780610848 17.855 100 86 173 2 1819160576 14488864 24060864
20:06:01 3840 8192000000 10735335232 11112357888 1790179584 17.933 100 91 182 3 1830304240 14654368 25470288
20:06:12 2561 8192000000 10734111232 11112161280 1790712224 17.938 100 90 178 3 1830328112 14780976 24834912
20:06:21 4712 8192000000 10744931904 11123716096 1798380288 18.001 100 91 183 0 1839359088 15771744 25207056
20:06:33 2817 8192000000 10739656480 11120582656 1797810336 17.996 100 90 178 0 1836210000 13517792 24881872
20:06:42 8532 8192000000 10754191760 11138596864 1811993712 18.112 100 89 177 3 1849115232 13085376 24036144
20:06:57 6948 8192000000 10750703104 11141177344 1820319488 18.180 100 79 158 2 1855138256 13172512 21646256
20:07:11 1937 8192000000 10783590560 11166707712 1836659376 18.314 100 92 183 0 1875629376 13513216 25456784
20:07:19 3096 8192000000 10781901616 11172024320 1845433504 18.385 100 88 176 0 1885098368 14285376 25379488
20:07:28 2337 8192000000 10782850576 11170885632 1848405904 18.409 100 93 183 6 1886227072 12842288 24978880
20:07:37 2479 8192000000 10789691520 11177406464 1851170176 18.432 100 89 178 0 1888908240 12475984 25262080
20:07:46 1504 8192000000 10798863408 11188322304 1857127216 18.480 100 90 179 3 1894415872 12494832 24793824
20:07:54 1820 8192000000 10804038448 11188305920 1857426032 18.482 100 93 181 5 1895772944 12851296 25495616
20:08:02 1316 8192000000 10807486320 11194056704 1864969024 18.544 100 95 190 0 1906465280 13814368 27681888
20:08:10 1271 8192000000 10816737568 11204702208 1871350816 18.595 100 93 184 2 1910361504 12620416 26390272
20:08:17 1882 8192000000 10818474576 11208323072 1872192160 18.602 100 93 183 4 1911686880 13203216 26291504
20:08:25 1055 8192000000 10823614224 11209805824 1875738240 18.631 100 97 191 4 1916158640 13313456 27106944
20:08:33 1105 8192000000 10829382624 11220381696 1884981552 18.705 100 92 183 2 1924057360 13084928 25990880
20:08:40 1176 8192000000 10825240048 11216465920 1880863536 18.672 100 95 189 1 1921014912 13423152 26728224
20:08:48 1912 8192000000 10816625584 11216494592 1879393152 18.660 100 89 176 2 1917435600 13179520 24862928
20:08:56 2413 8192000000 10814534688 11212902400 1878876192 18.656 100 77 155 2 1911654576 10663648 22114736
20:09:04 6291 8192000000 10789855696 11208933376 1873728992 18.614 100 43 86 0 1895332592 9338816 12264784
20:09:19 33819 8192000000 10818897424 11222163456 1880458224 18.669 100 48 94 1 1901021456 5459376 15103856
20:10:23 1284 8192000000 10840002912 11235123200 1895450768 18.790 100 95 194 0 1932375264 9671264 27253232
20:10:30 40770 8192000000 10793311376 11225944064 1883650048 18.695 100 25 50 0 1896348512 6134416 6564048
20:11:18 13771 8192000000 10789653744 11225370624 1884943712 18.705 100 16 32 1 1895548464 6278608 4326144
20:11:38 9981 8192000000 10807329936 11231895552 1888305520 18.732 100 19 38 3 1899064736 5985472 4773744
20:11:55 7342 8192000000 10808337056 11239133184 1891479024 18.758 100 27 53 1 1905725536 5953456 8293056
20:12:13 10209 8192000000 10805033808 11235565568 1893752464 18.776 100 16 31 1 1903212864 4930592 4529808
20:12:31 10170 8192000000 10802176704 11239665664 1896681696 18.800 100 15 28 2 1906045936 5648720 3715520
20:12:51 11140 8192000000 10802914672 11237744640 1898171936 18.812 100 14 28 1 1912328448 10444928 3711584
20:13:09 9016 8192000000 10822559536 11255693312 1901827456 18.841 100 18 35 3 1917674704 10978288 4868960
20:13:29 7342 8192000000 10820996832 11252908032 1903627472 18.855 100 20 41 1 1915367760 6322032 5418256
20:13:46 16889 8192000000 10800156448 11239514112 1882611888 18.686 99 13 26 1 1892128128 5984736 3531504
20:14:10 9948 8192000000 10807428720 11244638208 1900036224 18.827 100 12 24 1 1909311808 5750768 3524816
20:14:26 10822 8192000000 10811970768 11247452160 1903367280 18.853 100 17 31 1 1913942304 5626512 4948512
20:14:43 14334 8192000000 10804456432 11245613056 1885051008 18.706 99 17 33 1 1895592800 6120032 4421760
20:15:04 17867 8192000000 10807274016 11242684416 1884520336 18.702 99 20 40 0 1895663584 5644448 5498800
20:15:28 63293 8192000000 10832919088 11260547072 1892363728 18.765 99 51 103 2 1913771792 5250752 16157312
20:16:42 15760 8192000000 10810526240 11248074752 1883060288 18.690 99 23 46 0 1895573872 6454768 6058816
20:17:04 8773 8192000000 10793273952 11225661440 1841231312 18.351 97 27 54 0 1854219072 5783488 7204272
20:17:19 5821 8192000000 10791386208 11216736256 1857658736 18.484 99 27 54 1 1871232608 5994016 7579856
20:17:39 5141 8192000000 10774186656 11210514432 1838536656 18.329 98 23 46 1 1851986912 6139984 7310272
20:17:51 8729 8192000000 10786913216 11223244800 1878906320 18.656 100 23 46 1 1890912128 5491392 6514416
20:18:10 4670 8192000000 10779622432 11210166272 1864760064 18.542 99 31 61 2 1879844224 6373088 8711072
20:18:25 7993 8192000000 10770971600 11204317184 1831977904 18.275 97 26 52 5 1844474480 5081248 7415328
20:18:42 6565 8192000000 10744310928 11170197504 1785609216 17.896 96 30 60 0 1799818016 4619648 9589152
20:18:57 9761 8192000000 10687193872 11101216768 1648582928 16.752 90 13 26 0 1657336640 5063040 3690672
20:19:14 6346 8192000000 10678429648 11095584768 1751187312 17.611 98 32 64 2 1767444608 6819056 9438240
20:19:26 13591 8192000000 10719857488 11125284864 1736077360 17.486 96 34 67 6 1751573776 6150928 9345488
20:19:49 10189 8192000000 10707216720 11127214080 1769034640 17.759 98 18 35 1 1779930288 6043072 4852576
20:20:06 57549 8192000000 10695563632 11100278784 1713917888 17.301 95 31 62 0 1727644752 4780624 8946240
20:21:11 18372 8192000000 10689141408 11105120256 1704880736 17.226 95 17 34 1 1715262016 5635712 4745568
20:21:37 4360 8192000000 10691436352 11105984512 1771863984 17.782 99 31 64 0 1787156048 6578496 8713568
20:21:48 5405 8192000000 10737974752 11136557056 1803448272 18.042 100 46 92 0 1823150560 7342192 12360096
20:22:00 3785 8192000000 10719296032 11135717376 1792439200 17.952 99 34 68 1 1809496752 7770784 9286768
20:22:12 5558 8192000000 10731707328 11150868480 1815249184 18.139 100 32 64 3 1831132512 6809152 9074176
20:22:26 9467 8192000000 10730747504 11145179136 1808818320 18.086 100 27 54 1 1825932064 9086976 8026768
20:22:41 8249 8192000000 10725108560 11144888320 1794438560 17.968 99 19 38 0 1805970192 5306768 6224864
20:22:56 7969 8192000000 10737187584 11161608192 1806795728 18.070 99 27 55 0 1820932464 5713504 8423232
20:23:13 10253 8192000000 10750632976 11169923072 1830707008 18.265 100 19 38 1 1841993952 5987904 5299040
20:23:33 8022 8192000000 10755346448 11182673920 1840481520 18.345 100 27 54 1 1859044096 9948720 8613856
20:23:48 13890 8192000000 10769788944 11189850112 1840798384 18.347 100 17 34 1 1850548576 5034096 4716096
20:24:14 13132 8192000000 10755916592 11184734208 1849202048 18.416 100 24 48 2 1865834784 9526832 7105904
20:24:34 10278 8192000000 10768778384 11194515456 1854569696 18.459 100 20 40 3 1866517040 5632128 6315216
20:24:53 59451 8192000000 10817294800 11211087872 1868708976 18.574 100 67 136 3 1894448464 6148416 19591072
20:25:58 9634 8192000000 10781557776 11201728512 1862473872 18.523 100 36 72 5 1880763200 8230208 10059120
20:26:14 7250 8192000000 10777414448 11205312512 1862152432 18.521 100 22 44 0 1874692736 6836224 5704080
20:26:29 8694 8192000000 10782611680 11206774784 1864843920 18.543 100 32 64 0 1880152512 6669760 8638832
20:26:44 6164 8192000000 10779401648 11204091904 1863408752 18.531 100 24 48 1 1875782448 5594704 6778992
20:26:57 6596 8192000000 10806907568 11222392832 1870138640 18.585 100 32 65 0 1885746960 6663744 8944576
20:27:10 10318 8192000000 10802734400 11228332032 1885537504 18.710 100 27 53 0 1898414704 4885600 7991600
20:27:27 8121 8192000000 10822513040 11241594880 1898561520 18.815 100 43 86 2 1916714576 5516256 12636800
20:27:46 9060 8192000000 10839194048 11254747136 1907519536 18.887 100 57 113 4 1929999248 6737024 15742688
20:28:05 27592 8192000000 10849125104 11263819776 1911021392 18.915 100 47 94 1 1931747712 7469872 13256448
20:28:43 18289 8192000000 10862264432 11275939840 1921856560 19.002 100 54 106 3 1950817904 14219472 14741872
20:29:13 45882 8192000000 10871605696 11285745664 1912217776 18.924 99 60 120 2 1944976912 15796304 16962832
20:30:08 94182 8192000000 10865679680 11304062976 1935390880 19.110 100 47 94 0 1968770032 19119184 14259968
20:31:50 26719 8192000000 10879801472 11307589632 1937451936 19.126 100 30 60 1 1964919248 17824128 9643184
20:32:25 15748 8192000000 10886026832 11315384320 1945907216 19.194 100 36 70 0 1974082896 17959072 10216608
20:32:48 2622 8192000000 10889749472 11318644736 1948721968 19.216 100 43 81 1 1980085536 18000384 13363184
20:32:59 2658 8192000000 10902755616 11322327040 1955448832 19.270 100 61 117 1 1989899760 18166496 16284432
20:33:23 16713 8192000000 10911600208 11340218368 1962025856 19.322 100 55 110 0 1998432016 20494400 15911760
20:33:56 12216 8192000000 10921037472 11345924096 1968545856 19.374 100 53 106 1 2008361056 24174304 15640896
20:34:21 22563 8192000000 10925005776 11358212096 1974767664 19.423 100 60 119 0 2017424352 24398432 18258256
20:35:01 6096 8192000000 10936163296 11368796160 1982478656 19.484 100 46 92 2 2023710032 26691856 14539520
20:35:14 5877 8192000000 10944470048 11375792128 1987438528 19.524 100 51 101 0 2026957536 23641072 15877936
20:35:28 7846 8192000000 10933294320 11363229696 1981973568 19.480 100 48 96 0 2020239296 23390496 14875232
20:35:58 7896 8192000000 10946618464 11370127360 1988776208 19.534 100 64 128 2 2031930192 23755168 19398816
20:36:13 6509 8192000000 10952833072 11378462720 1995950064 19.591 100 73 146 1 2042979104 25123808 21905232
20:36:27 22829 8192000000 10943021440 11376377856 1977614256 19.446 99 61 123 2 2022245472 26877232 17753984
20:36:56 7242 8192000000 10963207936 11390935040 1997124736 19.600 100 54 107 0 2043827104 30666432 16035936
20:37:15 4013 8192000000 10946840528 11374206976 1983072704 19.489 99 60 120 2 2032633168 31152400 18408064
20:37:26 7492 8192000000 10949953696 11374874624 1961234944 19.316 98 68 131 0 2013777568 32433824 20108800
20:37:44 5988 8192000000 10938699040 11364114432 1967974576 19.369 99 64 128 2 2021522192 34096176 19451440
20:38:01 2278 8192000000 10952896208 11378708480 1975176336 19.426 99 74 148 0 2032437760 34994400 22267024
20:38:12 6175 8192000000 10968258832 11393024000 1998034736 19.607 100 75 149 0 2056460912 35704368 22721808
20:38:28 9178 8192000000 10952356976 11375431680 1983215552 19.490 99 65 129 0 2036916512 34310128 19390832
20:38:50 2303 8192000000 10973763504 11394744320 1983903376 19.496 99 82 162 1 2045008608 36153008 24952224
20:39:00 1970 8192000000 10973672384 11389751296 1995260704 19.585 100 75 151 1 2057448080 38911984 23275392
20:39:10 7787 8192000000 10976726240 11401056256 1998829200 19.613 100 72 144 0 2061549616 40303664 22416752
20:39:25 4645 8192000000 10943100384 11359113216 1956971600 19.282 98 67 132 0 2017967184 40544896 20450688
20:39:36 3798 8192000000 10956094016 11380740096 1984739792 19.502 100 73 143 1 2042132160 35552784 21839584
20:39:52 6469 8192000000 10953168832 11387052032 1990266768 19.546 100 53 105 4 2043604096 36585792 16751536
20:40:07 9996 8192000000 10958623552 11393687552 1990234912 19.546 100 54 108 1 2045121872 37861568 17025392
20:40:26 1345 8192000000 10971446656 11388968960 1989189104 19.537 100 71 142 1 2046243488 35523424 21530960
20:40:34 2016 8192000000 10963135120 11386970112 1988543184 19.532 100 76 153 2 2047656208 36443040 22669984
20:40:44 8330 8192000000 10966317792 11393048576 1991962384 19.559 100 72 144 0 2052424192 38305984 22155824
20:41:03 2017 8192000000 10978183936 11405246464 1995861648 19.590 100 71 142 1 2057958080 39928768 22167664
20:41:13 7734 8192000000 10973126640 11403948032 1988479856 19.532 99 71 141 1 2049327904 38492096 22355952
20:41:34 4905 8192000000 10978175056 11411349504 2008071184 19.686 100 61 122 3 2067054368 39621152 19362032
20:41:46 1608 8192000000 11001781168 11423547392 2017417808 19.760 100 76 150 0 2080817072 39775648 23623616
20:41:54 3185 8192000000 10968212720 11390828544 1983532672 19.493 99 79 157 0 2046990880 38118736 25339472
20:42:05 4560 8192000000 10992889424 11410710528 2005638960 19.667 100 75 150 3 2067413120 38916256 22857904
20:42:19 4668 8192000000 10978604192 11398406144 1996740480 19.597 100 80 160 1 2064609568 42908896 24960192
20:42:30 2989 8192000000 10986483648 11409149952 2002344608 19.641 100 83 165 2 2070176912 43090272 24742032
20:42:41 3132 8192000000 10958005824 11369734144 1973186960 19.411 99 82 163 1 2035842064 37647184 25007920
20:42:50 1807 8192000000 10961567760 11369033728 1966566384 19.358 99 90 181 1 2031247648 37460992 27220272
20:43:06 3618 8192000000 10960363984 11378483200 1978992112 19.457 100 77 153 2 2041926848 38502160 24432576
20:43:16 2551 8192000000 10968846112 11382763520 1981337664 19.475 100 87 174 0 2048855392 41044848 26472880
20:43:25 4037 8192000000 10963878672 11371728896 1961658416 19.319 99 88 176 1 2030905280 42632384 26614480
20:43:37 1668 8192000000 10955243584 11367075840 1961868656 19.321 99 82 165 1 2030023312 43289616 24865040
20:43:47 1947 8192000000 10964834176 11377070080 1976644240 19.438 100 91 182 0 2048922144 43929328 28348576
20:43:56 2341 8192000000 10960846432 11373830144 1975101424 19.426 100 81 161 0 2041990288 42230432 24658432
20:44:05 1298 8192000000 10976946240 11381821440 1972374256 19.404 99 93 187 2 2042283856 41687136 28222464
20:44:13 4070 8192000000 10940498192 11358511104 1963614896 19.335 100 65 130 0 2025659776 41661024 20383856
20:44:26 6069 8192000000 10955030544 11371352064 1970620448 19.390 100 75 149 5 2034092128 41158464 22313216
20:44:41 4068 8192000000 10948976000 11376562176 1968596256 19.374 100 56 112 0 2032901104 46558784 17746064
20:45:00 5077 8192000000 10935528864 11363696640 1946688368 19.200 99 56 112 0 2009693152 44756736 18248048
20:45:15 11204 8192000000 10928531376 11361779712 1938078848 19.131 99 44 88 0 1997958512 44002672 15876992
20:45:33 6557 8192000000 10940945648 11359629312 1951698768 19.240 100 65 128 1 2019188496 46368128 21121600
20:45:47 4909 8192000000 10951834816 11375681536 1967511904 19.366 100 70 139 1 2040281024 49915440 22853680
20:46:15 23534 8192000000 10927345520 11376418816 1929725888 19.065 98 46 92 1 1998470208 52464144 16280176
20:46:48 4181 8192000000 10966246832 11386073088 1972433728 19.405 100 65 130 2 2041762128 48710752 20617648
20:47:00 2934 8192000000 10974329232 11392606208 1976223904 19.435 100 79 156 2 2053149968 51651040 25275024
20:47:09 7845 8192000000 10956498064 11391967232 1971155040 19.395 100 54 108 0 2042645600 53542000 17948560
20:47:35 8329 8192000000 10937508016 11379384320 1933396464 19.094 98 41 82 5 1994773888 47464912 13912512
20:47:54 10080 8192000000 10916475504 11364921344 1947888944 19.210 100 33 66 1 2007037312 47989136 11159232
20:48:16 6495 8192000000 10924523040 11363422208 1940453616 19.150 99 50 100 2 1999465168 42883936 16127616
20:48:32 13139 8192000000 10915600368 11356942336 1951246416 19.236 100 33 66 1 2006864080 44742160 10875504
20:48:53 14230 8192000000 10913677824 11357483008 1947637360 19.208 100 29 56 4 1994069312 36380336 10051616
20:49:20 29699 8192000000 10883238000 11328991232 1886063872 18.714 97 36 72 5 1935349904 37793024 11493008
20:49:56 16718 8192000000 10889265888 11344703488 1921780432 19.001 99 30 60 0 1971272832 39551984 9940416
20:50:28 6407 8192000000 10903356688 11354189824 1937903328 19.130 100 24 49 2 1981831952 35711424 8217200
20:50:58 18371 8192000000 10883753616 11332874240 1897744176 18.808 98 25 50 2 1945883792 39305776 8833840
20:51:23 23816 8192000000 10860248656 11311702016 1881650672 18.678 98 24 48 2 1937219072 46618448 8949952
20:51:54 33503 8192000000 10877811520 11328925696 1907054432 18.883 100 22 44 1 1950783648 35725680 8003536
20:52:35 42866 8192000000 10883396688 11339366400 1898536144 18.815 99 12 24 0 1939653136 36429296 4687696
20:53:29 29770 8192000000 10839269376 11294617600 1881087712 18.674 98 17 32 1 1905259936 19707392 4464832
20:54:15 97177 8192000000 10862766144 11309686784 1905982640 18.874 99 24 48 1 1921419088 8722112 6714336
20:56:16 105222 8192000000 10895913888 11337940992 1889043968 18.738 97 28 56 1 1907010688 10675728 7290992
20:58:07 38547 8192000000 10899398096 11351699456 1949029040 19.219 99 39 79 2 1968788016 8823808 10935168
20:58:53 122821 8192000000 10874078912 11322773504 1883042192 18.690 96 21 42 3 1899579040 10253280 6283568
21:01:02 79384 8192000000 10878447680 11326070784 1895466352 18.790 96 30 60 2 1920546896 16533872 8546672
21:02:30 17825 8192000000 10911151632 11353587712 1968566080 19.374 100 38 76 0 1991499264 11572384 11360800
21:03:00 4620 8192000000 10927453888 11360182272 1960295232 19.308 99 56 113 1 1989477952 12209824 16972896
21:03:13 10085 8192000000 10922577808 11369447424 1981086432 19.473 100 44 82 1 2009495664 16627328 11781904
21:03:37 17021 8192000000 10919541040 11350478848 1959986528 19.306 99 58 111 0 1990639360 14589632 16063200
21:04:02 45731 8192000000 10916786368 11370762240 1979443120 19.460 100 51 102 3 2015553024 20487888 15622016
21:04:54 156656 8192000000 10889635104 11356729344 1946084240 19.195 99 10 20 1 1967194048 17765824 3343984
21:08:11 70742 8192000000 10899370400 11367567360 1977022560 19.441 100 7 14 1 1999012096 20082352 1907184
21:09:28 43850 8192000000 10904091456 11372261376 1979713360 19.462 100 19 38 1 2000364544 15170176 5481008
21:10:19 40019 8192000000 10909867088 11385290752 1985035024 19.505 100 13 26 1 2005599056 17248192 3315840
21:11:20 92869 8192000000 10891404368 11352977408 1920514288 18.991 97 11 22 0 1930181904 6657472 3010144
21:13:07 46382 8192000000 10906896368 11361841152 1953676096 19.256 99 33 66 4 1969015008 7006448 8332464
21:13:59 38785 8192000000 10877078608 11344633856 1951318048 19.237 99 13 26 0 1966877552 11911808 3647696
21:14:56 78005 8192000000 10898612960 11372589056 1956778928 19.280 99 18 36 1 1973411136 11752656 4879552
21:18:15 55819 8192000000 10892068608 11351810048 1935089920 19.108 98 16 32 0 1953252640 13392816 4769904
21:19:17 55092 8192000000 10918863136 11382833152 1979703504 19.462 100 20 38 3 2000140896 14440800 5996592
21:21:02 56064 8192000000 10913670128 11378335744 1964707344 19.343 99 17 34 0 1979535504 10231120 4597040
21:22:18 100193 8192000000 10908706880 11374387200 1909417536 18.902 96 25 50 2 1939050320 22678096 6954688
21:25:22 64286 8192000000 10914737952 11380912128 1922186496 19.004 97 15 30 0 1942186256 15397808 4601952
21:26:55 86493 8192000000 10850598816 11315900416 1756969728 17.659 90 10 20 0 1773302048 13834704 2497616
21:28:28 63477 8192000000 10854887632 11304333312 1796748480 17.987 93 22 45 1 1813889088 11840704 5299904
21:29:40 23159 8192000000 10853214960 11301978112 1864261136 18.538 97 31 61 0 1885035968 12493840 8280992
21:30:11 130940 8192000000 10872100128 11330052096 1886942128 18.721 98 38 76 0 1908353008 11147136 10263744
21:32:37 35841 8192000000 10865836080 11342508032 1942867328 19.170 100 19 38 1 1962352992 13977792 5507872
21:33:29 81966 8192000000 10862781024 11346460672 1909155408 18.900 98 11 22 0 1926670224 14655584 2859232
21:35:00 27785 8192000000 10845549328 11315494912 1880325776 18.668 97 8 16 0 1893391456 10956240 2109440
21:35:34 76302 8192000000 10868218992 11346567168 1918146096 18.972 99 19 38 0 1935285376 12083616 5055664
21:36:57 33636 8192000000 10871229488 11319226368 1878208624 18.651 96 41 83 2 1901918464 11393040 12316800
21:37:39 60546 8192000000 10874205712 11341725696 1886340736 18.716 97 29 58 1 1908689232 13499648 8848848
21:39:14 113486 8192000000 10855581616 11335303168 1899182304 18.820 98 9 18 2 1920301664 18037552 3081808
21:42:23 36576 8192000000 10910390576 11345551360 1930445040 19.070 99 29 58 2 1945590864 7065040 8080784
21:43:21 53278 8192000000 10870921872 11336966144 1900651776 18.832 97 26 52 0 1918317936 10460048 7206112
21:44:24 27605 8192000000 10891363008 11334062080 1910538720 18.911 98 40 79 1 1930357888 8672224 11146944
21:45:01 24667 8192000000 10886239696 11340386304 1926679264 19.040 99 41 82 0 1949483616 10598064 12206288
21:45:34 30685 8192000000 10864144320 11327885312 1903019424 18.851 98 29 58 1 1928076032 17203344 7853264
21:46:13 77516 8192000000 10883176560 11343806464 1862601216 18.524 96 13 26 0 1879283920 13157088 3525616
21:47:40 52294 8192000000 10875716976 11322171392 1885900528 18.713 97 28 56 0 1902456688 8832400 7723760
21:48:42 132026 8192000000 10865714768 11327090688 1901858256 18.841 98 27 54 2 1917373824 7769328 7746240
21:51:02 32010 8192000000 10881929088 11329159168 1925437104 19.030 99 51 100 1 1947954032 7076288 15440640
21:51:41 40029 8192000000 10883287952 11342540800 1947126736 19.204 100 37 74 0 1967646848 10755504 9764608
21:52:47 51973 8192000000 10862249984 11342950400 1953082240 19.251 100 14 28 1 1965261904 8065040 4114624
21:53:46 35540 8192000000 10880540752 11354431488 1954438448 19.262 100 8 16 0 1968794912 12296000 2060464
21:54:27 58562 8192000000 10872549856 11346886656 1925994080 19.035 98 14 28 3 1942981520 13005040 3982400
21:55:35 87957 8192000000 10882089248 11359830016 1963932816 19.337 100 13 26 1 1978600640 10679344 3988480
21:57:26 60622 8192000000 10884516800 11363586048 1948100480 19.211 99 15 30 0 1964393024 11407312 4885232
21:58:33 50403 8192000000 10866582128 11330093056 1906961344 18.882 97 15 29 1 1916913712 5826080 4126288
21:59:30 36551 8192000000 10880791824 11354734592 1931267440 19.077 98 19 38 1 1943324192 6888944 5167808
22:00:16 45502 8192000000 10885306880 11359260672 1964041696 19.338 100 11 22 1 1973937040 7038752 2856592
22:01:08 27454 8192000000 10894556704 11353489408 1934638464 19.104 98 25 50 1 1948549120 7095504 6815152
22:01:42 83939 8192000000 10916489216 11364732928 1926509216 19.039 98 23 45 0 1941066752 8056768 6500768
22:03:12 24393 8192000000 10923038752 11359809536 1970960320 19.393 100 48 94 2 1992602160 8477120 13164720
22:03:47 33290 8192000000 10901224160 11364163584 1945753616 19.193 99 17 33 0 1959266736 8805248 4707872
22:04:34 29497 8192000000 10890595440 11346710528 1912514992 18.927 97 35 70 0 1933594240 11342560 9736688
22:05:27 42949 8192000000 10851309648 11321896960 1881915424 18.681 97 21 42 0 1902771424 14448784 6407216
22:06:19 51268 8192000000 10856654448 11320451072 1876788944 18.639 97 24 48 2 1895184944 11715312 6680688
22:07:22 52588 8192000000 10860231312 11291893760 1816513872 18.149 94 30 60 0 1835022608 10249200 8259536
22:08:21 44157 8192000000 10885434096 11330031616 1910244400 18.909 99 45 89 0 1936914432 13847312 12822720
22:09:36 57316 8192000000 10845281744 11329359872 1878812640 18.656 97 14 28 0 1901249632 18326752 4110240
22:10:55 68240 8192000000 10874598336 11349700608 1913815760 18.937 99 14 28 0 1934298336 16623728 3858848
22:12:12 71506 8192000000 10855328256 11312480256 1883222800 18.691 97 13 26 0 1897634000 10874688 3536512
22:13:52 70613 8192000000 10823547472 11286413312 1833658176 18.289 95 23 46 0 1848022432 7888400 6475856
22:15:49 49309 8192000000 10848623072 11301519360 1891336528 18.757 99 12 24 1 1904911872 9910288 3665056
22:18:24 74754 8192000000 10839363296 11303796736 1869312144 18.579 97 15 30 1 1885101936 11532016 4257776
22:19:52 70805 8192000000 10846206768 11320176640 1907203712 18.884 99 19 38 2 1924205712 11140672 5861328
22:21:22 58374 8192000000 10886875344 11342016512 1932481808 19.087 100 14 28 1 1947780688 11438576 3860304
22:22:27 40192 8192000000 10851656176 11327389696 1897974672 18.810 98 21 42 0 1916018912 12004528 6039712
22:23:18 49036 8192000000 10879580912 11339485184 1923492768 19.015 99 18 36 0 1941217440 12450400 5274272
22:24:35 64481 8192000000 10870858272 11350503424 1923923616 19.018 99 19 38 2 1943448512 13774912 5749984
22:26:01 33942 8192000000 10853433136 11304058880 1839241168 18.335 95 25 50 1 1853986416 7782016 6963232
22:26:48 44881 8192000000 9265698208 9535295488 407352720 4.737 21 2 4 0 413015040 5224608 437712

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 26-01-2021 22:28:51 to 26-01-2021 22:29:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 111 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-01-2021 22:29:22 to 26-01-2021 22:29:24.

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          246682
MON$OLDEST_ACTIVE               246683
MON$OLDEST_SNAPSHOT             246683
MON$NEXT_TRANSACTION            246683
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                       2016320
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.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 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 ---
:32: 
:33: mscs-test-161.budzdorov.ru    Tue Jan 26 22:27:45 2021
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
--- end of diff output ---

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

26.01.21 22:29:25. 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-01-26 22:29:28 No severe PSQL-related problems occured
26.01.21 22:29:29. End of report.