Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 07.03.2021 16: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 df9f488d08424df294c459d6c283e9c3
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-03-04 16:07
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.26
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 17506780 kB
MemAvailable 31646268 kB
Buffers 0 kB
Cached 14203268 kB
SwapCached 0 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-03-07 16:27:23
DTS_END                         2021-03-07 16:27:23.4890
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/49090
TRN_ID                          246980
ATT_ID                          621
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: 9420.03 20548 1130404
customer order: creation 182.75 365 21930
customer order: refuse 15.69 381 1883
order to supplier: creation 48.86 1316 5863
order to supplier: removal 3.44 109778 413
invoice (draft): creation 48.33 3312 5799
invoice (draft): removal 51.14 932 6137
invoice accept: apply 43.72 17729 5246
invoice accept: cancel 46.24 829 5549
customer reserve: creation 4091.38 173 490965
customer reserve: removal 4578.00 64 549360
realization accept: apply 88.11 196 10573
realization accept: cancel 85.67 106 10280
payment from customer: creation 63.03 114 7564
payment from customer: removal 6.07 64 728
payment to supplier: creation 50.86 134 6103
payment to supplier: removal 3.67 105 440
service: total inventory turnovers 4.86 1088 583
service: total monetary turnovers 7.12 37 854
service: aggregate perf. data 1.08 14395 130
service: refresh index statistics 0.03 259846 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-03-2021 16:29:15 to 07-03-2021 16:29:17.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3511
TEST_TIME 2 4495
TEST_TIME 3 4472
TEST_TIME 4 4991
TEST_TIME 5 4669
TEST_TIME 6 4499
TEST_TIME 7 4349
TEST_TIME 8 4877
TEST_TIME 9 4876
TEST_TIME 10 5060
TEST_TIME 11 5244
TEST_TIME 12 5704
TEST_TIME 13 5829
TEST_TIME 14 6724
TEST_TIME 15 7090
TEST_TIME 16 7378
TEST_TIME 17 7550
TEST_TIME 18 7781
TEST_TIME 19 8189
TEST_TIME 20 8084
TEST_TIME 21 8279
TEST_TIME 22 8198
TEST_TIME 23 8380
TEST_TIME 24 8486
TEST_TIME 25 8522
TEST_TIME 26 9332
TEST_TIME 27 10066
TEST_TIME 28 10042
TEST_TIME 29 10531
TEST_TIME 30 10892
TEST_TIME 31 11026
TEST_TIME 32 10877
TEST_TIME 33 10795
TEST_TIME 34 10781
TEST_TIME 35 10630
TEST_TIME 36 10824
TEST_TIME 37 10694
TEST_TIME 38 10593
TEST_TIME 39 10516
TEST_TIME 40 10374
TEST_TIME 41 10270
TEST_TIME 42 10059
TEST_TIME 43 10055
TEST_TIME 44 10182
TEST_TIME 45 10019
TEST_TIME 46 9985
TEST_TIME 47 9897
TEST_TIME 48 9821
TEST_TIME 49 9816
TEST_TIME 50 9833
TEST_TIME 51 9867
TEST_TIME 52 9871
TEST_TIME 53 9950
TEST_TIME 54 9802
TEST_TIME 55 9777
TEST_TIME 56 9667
TEST_TIME 57 9567
TEST_TIME 58 9536
TEST_TIME 59 9456
TEST_TIME 60 9414
TEST_TIME 61 9454
TEST_TIME 62 9441
TEST_TIME 63 9522
TEST_TIME 64 9479
TEST_TIME 65 9566
TEST_TIME 66 9695
TEST_TIME 67 9623
TEST_TIME 68 9598
TEST_TIME 69 9639
TEST_TIME 70 9672
TEST_TIME 71 9693
TEST_TIME 72 9791
TEST_TIME 73 9735
TEST_TIME 74 9783
TEST_TIME 75 9694
TEST_TIME 76 9636
TEST_TIME 77 9614
TEST_TIME 78 9579
TEST_TIME 79 9544
TEST_TIME 80 9497
TEST_TIME 81 9464
TEST_TIME 82 9463
TEST_TIME 83 9492
TEST_TIME 84 9489
TEST_TIME 85 9527
TEST_TIME 86 9476
TEST_TIME 87 9538
TEST_TIME 88 9562
TEST_TIME 89 9553
TEST_TIME 90 9587
TEST_TIME 91 9568
TEST_TIME 92 9561
TEST_TIME 93 9659
TEST_TIME 94 9647
TEST_TIME 95 9747
TEST_TIME 96 9664
TEST_TIME 97 9619
TEST_TIME 98 9569
TEST_TIME 99 9588
TEST_TIME 100 9551
TEST_TIME 101 9515
TEST_TIME 102 9466
TEST_TIME 103 9401
TEST_TIME 104 9422
TEST_TIME 105 9457
TEST_TIME 106 9456
TEST_TIME 107 9458
TEST_TIME 108 9490
TEST_TIME 109 9476
TEST_TIME 110 9502
TEST_TIME 111 9493
TEST_TIME 112 9472
TEST_TIME 113 9498
TEST_TIME 114 9509
TEST_TIME 115 9530
TEST_TIME 116 9516
TEST_TIME 117 9551
TEST_TIME 118 9549
TEST_TIME 119 9477
TEST_TIME 120 9422

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-03-2021 16:29:19 to 07-03-2021 16:29:22.

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 1583919 1583919 0 0.00 0 20958 6 0 0
doc_list_biud 1583918 1583918 0 0.00 0 55580 29 0 0
sp_add_invoice_to_stock 5385 5246 139 2.58 34 162841 17729 0 139
sp_cancel_adding_invoice 5549 5549 0 0.00 5 75387 830 0 0
sp_cancel_client_order 1883 1883 0 0.00 4 19017 381 0 0
sp_cancel_customer_reserve 549360 549360 0 0.00 1 55581 65 0 0
sp_cancel_pay_from_customer 728 728 0 0.00 2 4430 65 0 0
sp_cancel_pay_to_supplier 440 440 0 0.00 2 7928 106 0 0
sp_cancel_supplier_invoice 6153 6137 16 0.26 2 20378 932 0 16
sp_cancel_supplier_order 413 413 0 0.00 5 1149853 109779 0 0
sp_cancel_write_off 10280 10280 0 0.00 1 15017 107 0 0
sp_client_order 21930 21930 0 0.00 3 23870 365 0 0
sp_customer_reserve 490965 490965 0 0.00 0 105017 173 0 0
sp_fill_shopping_cart 33587 33587 0 0.00 1 21996 40 0 0
sp_fill_shopping_cart_clo_res 490962 490962 0 0.00 0 16127 13 0 0
sp_get_clo_for_invoice 5243 5243 0 0.00 0 30178 249 0 0
sp_kill_cost_storno 16997 16997 0 0.00 0 7921 58 0 0
sp_kill_qstorno_ret_qs2qd 1115550 1115550 0 0.00 0 55577 35 0 0
sp_kill_qty_storno 589437 589437 0 0.00 0 55579 76 0 0
sp_lock_selected_doc 21962 21962 0 0.00 0 7784 6 0 0
sp_make_cost_storno 29483 29483 0 0.00 0 14742 56 0 0
sp_multiply_rows_for_pdistr 29483 29483 0 0.00 0 9287 28 0 0
sp_multiply_rows_for_qdistr 21930 21930 0 0.00 0 21902 168 0 0
sp_pay_from_customer 7564 7564 0 0.00 4 21710 115 0 0
sp_pay_to_supplier 6103 6103 0 0.00 5 18834 134 0 0
sp_payment_common 13667 13667 0 0.00 1 21702 36 0 0
sp_qd_handle_on_cancel_clo 1883 1883 0 0.00 0 19011 327 0 0
sp_qd_handle_on_invoice_upd_sts 10792 10792 0 0.00 0 30028 356 0 0
sp_qd_handle_on_reserve_upd_sts 10572 10572 0 0.00 0 21976 55 0 0
sp_reserve_write_off 10573 10573 0 0.00 6 21991 197 0 0
sp_supplier_invoice 5799 5799 0 0.00 6 83832 3312 0 0
sp_supplier_order 5863 5863 0 0.00 5 56121 1317 0 0
srv_aggregate_perf_data 131 130 1 0.76 2768 97736 14396 0 1
srv_fill_mon_cache_memory 177 177 0 0.00 955 150735 29894 0 0
srv_find_qd_qs_mism 1079264 1079264 0 0.00 0 20958 5 0 0
srv_make_invnt_saldo 583 583 0 0.00 39 54375 1088 0 0
srv_make_money_saldo 854 854 0 0.00 1 11751 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 57539 419769 259846 0 0
t$perf-abend:sp_add_invoice_to_stock 139 139 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 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 5246 5246 0 0.00 0 15992 141 0 0
t$perf-norm:sp_cancel_adding_invoice 453 453 0 0.00 0 6616 105 0 0
t$perf-norm:sp_cancel_client_order 1883 1883 0 0.00 0 7383 16 0 0
t$perf-norm:sp_cancel_customer_reserve 735 735 0 0.00 0 950 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 728 728 0 0.00 0 266 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 440 440 0 0.00 0 1214 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 429 429 0 0.00 0 912 15 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 25712 1810 0 0
t$perf-norm:sp_cancel_write_off 1068 1068 0 0.00 0 4081 13 0 0
t$perf-norm:sp_client_order 21930 21930 0 0.00 0 15539 15 0 0
t$perf-norm:sp_customer_reserve 1012 1012 0 0.00 0 1410 4 0 0
t$perf-norm:sp_pay_from_customer 7564 7564 0 0.00 0 13289 11 0 0
t$perf-norm:sp_pay_to_supplier 6103 6103 0 0.00 0 5030 8 0 0
t$perf-norm:sp_reserve_write_off 10573 10573 0 0.00 0 11617 13 0 0
t$perf-norm:sp_supplier_invoice 5799 5799 0 0.00 0 3139 13 0 0
t$perf-norm:sp_supplier_order 5863 5863 0 0.00 0 7270 13 0 0
t$perf-norm:srv_aggregate_perf_data 130 130 0 0.00 0 253 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 177 177 0 0.00 0 499 7 0 0
t$perf-norm:srv_make_invnt_saldo 583 583 0 0.00 0 2795 27 0 0
t$perf-norm:srv_make_money_saldo 854 854 0 0.00 0 1370 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10762 10484 278 2.58 0 16451 24 0 278
v_all_customers 40100 40100 0 0.00 0 52 1 0 0
v_all_suppliers 32338 32338 0 0.00 0 24 1 0 0
v_all_wares 43854 43854 0 0.00 0 136 1 0 0
v_cancel_adding_invoice 906 906 0 0.00 0 16326 43 0 0
v_cancel_client_order 3766 3766 0 0.00 0 16188 16 0 0
v_cancel_customer_prepayment 1456 1456 0 0.00 0 3284 7 0 0
v_cancel_customer_reserve 1470 1470 0 0.00 0 2129 5 0 0
v_cancel_payment_to_supplier 880 880 0 0.00 0 5794 20 0 0
v_cancel_supplier_invoice 890 858 32 3.59 0 4313 21 0 32
v_cancel_supplier_order 826 826 0 0.00 0 13492 21 0 0
v_cancel_write_off 2136 2136 0 0.00 0 14806 19 0 0
v_max_id_clo_ord 5863 5863 0 0.00 0 681 2 0 0
v_max_id_clo_res 1012 1012 0 0.00 0 2849 20 0 0
v_max_id_ord_sup 5797 5797 0 0.00 0 3322 4 0 0
v_max_non_paid_invoice 1594 1594 0 0.00 0 539 3 0 0
v_max_non_paid_realizn 3963 3963 0 0.00 0 2251 4 0 0
v_min_id_clo_ord 5863 5863 0 0.00 0 21967 21 0 0
v_min_id_clo_res 1012 1012 0 0.00 0 3893 13 0 0
v_min_id_ord_sup 5797 5797 0 0.00 0 3840 7 0 0
v_min_non_paid_invoice 6103 6103 0 0.00 0 7702 22 0 0
v_min_non_paid_realizn 7564 7564 0 0.00 0 9921 23 0 0
v_our_firm 10956 10956 0 0.00 0 13 1 0 0
v_reserve_write_off 21142 21142 0 0.00 0 16454 15 0 0
x_lock_depdocs_on_canc_invoice 11257 11257 0 0.00 0 26677 134 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 11350 356 0 0
x_make_qstorno_1000_1200 5863 5863 0 0.00 1 56112 1222 0 0
x_make_qstorno_1200_2000 5799 5799 0 0.00 3 81561 3176 0 0
x_make_qstorno_2100_3300 490965 490965 0 0.00 0 105015 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-03-2021 16:29:23 to 07-03-2021 16:29:27.

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
13:57:27 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:33 15841 8192000000 10207983152 10511962112 962263312 10.511 77 62 124 1 987113664 2760480 22089872
13:57:59 31961 8192000000 10304487248 10617303040 1348989824 14.138 100 82 164 1 1381193216 4917728 27285664
13:58:43 24237 8192000000 10353284112 10673438720 1402282352 14.615 100 85 167 2 1435950528 5788704 27879472
13:59:16 22943 8192000000 10385250176 10708164608 1437020352 14.923 100 88 176 1 1472651168 6567584 29063232
13:59:48 29947 8192000000 10415843088 10742706176 1472313840 15.234 100 88 176 1 1507791360 7174256 28303264
14:00:29 20608 8192000000 10427431440 10762010624 1482222992 15.321 100 82 164 1 1516625280 7661776 26740512
14:00:59 17190 8192000000 10448038912 10784800768 1500960464 15.485 100 77 154 0 1533267040 7818032 24488544
14:01:27 20447 8192000000 10490903616 10833100800 1544201984 15.860 100 82 164 0 1578274032 8489632 25582416
14:01:59 19155 8192000000 10521425008 10867257344 1570512112 16.087 100 82 164 1 1605721776 9670016 25539648
14:02:41 13219 8192000000 10555754352 10908631040 1601396912 16.351 100 83 166 1 1637060048 10134592 25528544
14:03:09 18007 8192000000 10575957248 10935087104 1635730160 16.644 100 86 172 1 1673662464 11570528 26361776
14:03:34 13726 8192000000 10591246304 10954231808 1649475200 16.760 100 77 154 0 1684487664 12277392 22735072
14:03:58 10112 8192000000 10612106064 10980216832 1672356320 16.953 100 75 150 1 1707129568 12465888 22307360
14:04:15 9337 8192000000 10654811104 11020689408 1704682848 17.224 100 83 166 0 1741296144 12236016 24377280
14:04:33 12923 8192000000 10668887632 11039113216 1720500976 17.356 100 84 167 1 1757439088 13092592 23845520
14:04:54 10429 8192000000 10680167744 11052879872 1737869024 17.501 100 90 179 1 1777031200 14032528 25129648
14:05:13 6692 8192000000 10691301984 11067060224 1751136416 17.611 100 87 174 0 1789778960 14793104 23849440
14:05:28 5771 8192000000 10690476416 11067195392 1756028592 17.652 100 86 173 0 1795276992 14698688 24549712
14:05:40 5854 8192000000 10708504304 11080863744 1762408496 17.704 100 87 174 1 1802296944 14859712 25028736
14:05:52 4771 8192000000 10703573792 11080744960 1766767600 17.740 100 84 169 1 1803517520 14021600 22728320
14:06:04 3982 8192000000 10716634496 11093053440 1775681248 17.814 100 91 183 0 1816115216 15080416 25353552
14:06:15 5333 8192000000 10720006432 11101589504 1782729616 17.872 100 86 172 0 1820667200 14419856 23517728
14:06:28 4117 8192000000 10725607360 11105140736 1787018624 17.907 100 84 168 0 1824654016 13925360 23710032
14:06:38 5046 8192000000 10737890240 11118247936 1797036352 17.990 100 91 182 1 1836763872 13895408 25832112
14:06:50 3552 8192000000 10731616720 11113836544 1798969376 18.005 100 90 178 2 1838497680 14403328 25124976
14:07:00 4508 8192000000 10740542032 11124871168 1804817792 18.053 100 87 175 3 1843385824 14184528 24383504
14:07:12 5712 8192000000 10748600976 11133976576 1808876624 18.087 100 84 168 2 1845777296 13870912 23029760
14:07:24 4752 8192000000 10759884048 11148537856 1812447776 18.116 100 76 152 0 1847165584 13161712 21556096
14:07:36 3378 8192000000 10769841200 11157078016 1833821600 18.290 100 94 189 2 1873926912 13488352 26616960
14:07:45 2450 8192000000 10785690272 11169796096 1841307680 18.351 100 88 176 3 1880647680 13316656 26023344
14:07:54 3855 8192000000 10789384816 11176046592 1846748016 18.396 100 87 174 2 1884371568 13010096 24613456
14:08:04 3215 8192000000 10791393536 11179847680 1850308240 18.425 100 93 185 2 1889781216 13225216 26247760
14:08:14 2083 8192000000 10791011088 11181699072 1852488736 18.442 100 89 176 1 1890647024 12308320 25849968
14:08:23 1630 8192000000 10794239968 11184766976 1858711152 18.493 100 85 171 0 1895081456 11906704 24463600
14:08:31 2116 8192000000 10796138768 11187761152 1857567248 18.484 100 90 178 0 1896582848 13548000 25467600
14:08:40 2050 8192000000 10803735696 11194056704 1861550480 18.516 100 90 178 2 1900492768 13489776 25452512
14:08:49 1415 8192000000 10808325776 11195523072 1860340768 18.506 100 92 182 1 1900280400 13732560 26207072
14:08:57 1887 8192000000 10809470608 11195736064 1862936704 18.527 100 97 195 1 1904829344 14551456 27341184
14:09:05 2000 8192000000 10807561792 11197427712 1866344352 18.555 100 86 173 1 1903080336 12315504 24420480
14:09:14 1412 8192000000 10817113376 11205664768 1870988688 18.592 100 95 188 0 1909955232 12304960 26661584
14:09:21 1607 8192000000 10815741008 11202691072 1872238688 18.602 100 98 196 0 1914188048 13098704 28850656
14:09:29 1359 8192000000 10821611600 11209781248 1872330032 18.603 100 94 188 3 1912943680 13532688 27080960
14:09:37 1710 8192000000 10816269264 11211366400 1874953232 18.624 100 88 176 0 1914403664 13547632 25902800
14:09:45 1682 8192000000 10814785968 11210289152 1877980400 18.649 100 86 173 0 1914264640 11574544 24709696
14:09:53 27582 8192000000 10800956464 11207737344 1869694512 18.582 100 56 107 3 1893606880 7782320 16130048
14:10:28 6772 8192000000 10799613712 11207180288 1871527296 18.597 100 53 106 1 1896108656 9399712 15181648
14:10:41 2318 8192000000 10812293696 11214839808 1878144544 18.650 100 67 135 1 1907991056 10793712 19052800
14:10:51 3172 8192000000 10814743872 11218300928 1878755632 18.655 100 75 149 1 1911557744 11609904 21192208
14:11:01 3161 8192000000 10805270608 11220316160 1874415200 18.620 100 53 104 0 1904110624 15243200 14452224
14:11:15 9972 8192000000 10783244560 11212324864 1876136752 18.634 100 38 76 4 1894435616 7123872 11174992
14:11:32 10838 8192000000 10790576432 11217846272 1877179152 18.642 100 24 48 1 1890042912 6327552 6536208
14:11:56 12516 8192000000 10789373600 11219865600 1883178352 18.691 100 19 38 2 1894657264 6211888 5267024
14:12:15 11094 8192000000 10788176832 11223654400 1883726448 18.695 100 18 36 0 1895262736 6233472 5302816
14:12:34 13205 8192000000 10796670944 11228938240 1890898640 18.753 100 27 53 0 1904858752 6507824 7452288
14:13:01 9628 8192000000 10799179984 11230416896 1891410512 18.757 100 23 47 1 1903679744 6261344 6007888
14:13:17 22454 8192000000 10793157040 11231039488 1891467168 18.758 100 15 31 2 1901711792 6388560 3856064
14:13:55 65434 8192000000 10820156496 11240402944 1891064480 18.754 100 15 30 0 1901002656 5443328 4494848
14:15:12 22133 8192000000 10820937312 11246596096 1895544432 18.790 100 22 44 0 1908143040 6604848 5993760
14:15:42 1202 8192000000 10849571872 11253071872 1902580192 18.847 100 52 107 1 1923825456 6606800 14638464
14:15:49 4463 8192000000 10825823520 11250409472 1902403568 18.846 100 34 67 0 1918857296 6854416 9599312
14:16:02 2691 8192000000 10842116608 11255963648 1904618688 18.863 100 55 109 0 1932739168 12210784 15909696
14:16:12 4214 8192000000 10826136208 11255394304 1904365968 18.861 100 52 103 0 1928550464 9374112 14810384
14:16:23 8091 8192000000 10802208720 11235590144 1876304128 18.635 99 34 68 0 1892044688 6101360 9639200
14:16:37 3333 8192000000 10838069792 11249963008 1899879632 18.825 100 42 85 2 1916171024 4735792 11555600
14:16:49 6320 8192000000 10811724112 11243323392 1896730800 18.800 100 32 64 0 1912759344 5673296 10355248
14:17:03 7596 8192000000 10783134640 11213905920 1852153488 18.440 98 17 34 0 1862875552 5405232 5316832
14:17:17 7282 8192000000 10797731232 11228962816 1863544160 18.532 99 19 38 0 1874577824 5844816 5188848
14:17:33 6512 8192000000 10793772880 11228590080 1874408800 18.620 99 28 57 0 1888600928 5844448 8347680
14:17:46 11424 8192000000 10763129200 11181768704 1773725616 17.798 95 24 46 2 1786735936 6461104 6549216
14:18:04 8673 8192000000 10755603232 11178242048 1810562448 18.100 98 13 26 0 1820179008 5621056 3995504
14:18:22 10412 8192000000 10778707104 11209834496 1863637552 18.533 100 23 46 1 1875670096 4938112 7094432
14:18:40 58389 8192000000 10784611568 11204571136 1822919584 18.202 97 28 56 0 1836148208 5614144 7614480
14:19:55 22737 8192000000 10739909392 11163365376 1710035184 17.269 91 22 42 0 1720952672 5275616 5641872
14:20:24 3937 8192000000 10717378768 11132506112 1756360656 17.654 96 29 58 0 1770758624 6316128 8081840
14:20:35 6423 8192000000 10714346880 11126849536 1768227232 17.752 98 31 62 4 1783261744 6268576 8765936
14:20:49 5769 8192000000 10713869648 11126484992 1777346224 17.828 99 36 70 1 1794793648 7366624 10080800
14:21:06 8779 8192000000 10693969504 11114369024 1747749248 17.583 97 29 59 0 1761604944 5591888 8263808
14:21:22 3636 8192000000 10728126864 11128287232 1782633520 17.871 99 32 64 0 1797466480 5331056 9501904
14:21:34 7100 8192000000 10716246048 11126530048 1766454896 17.738 98 26 52 1 1778763360 4970640 7337824
14:21:49 5123 8192000000 10705833792 11118186496 1739143952 17.512 97 24 48 0 1751828432 6533360 6151120
14:22:00 6549 8192000000 10694900256 11112878080 1779349600 17.844 100 20 40 1 1792110672 6570368 6190704
14:22:16 7115 8192000000 10685293680 11099611136 1743434496 17.547 98 21 42 2 1754936576 5138560 6363520
14:22:30 8923 8192000000 10679199472 11098750976 1742814528 17.542 98 19 38 1 1754301472 5665792 5821152
14:22:45 5975 8192000000 10706042128 11125841920 1792645456 17.954 100 34 68 3 1807305040 5184304 9475280
14:22:57 6964 8192000000 10714536608 11123150848 1750759728 17.608 97 31 62 2 1765797072 6090944 8946400
14:23:11 10932 8192000000 10721333152 11140988928 1803636448 18.044 100 16 32 0 1814093744 5399888 5057408
14:23:28 9325 8192000000 10718313696 11137855488 1800821920 18.021 100 23 46 2 1812767296 5508208 6437168
14:23:49 80788 8192000000 10733633760 11163017216 1803862384 18.046 99 25 52 0 1817067856 5160224 8045248
14:25:19 7014 8192000000 10761901664 11181494272 1840040992 18.341 100 28 56 0 1856818608 9492080 7285536
14:25:34 7026 8192000000 10761205648 11185561600 1845593440 18.386 100 20 40 1 1857420208 5348976 6477792
14:25:50 6944 8192000000 10759797728 11182854144 1844902144 18.381 100 28 55 0 1859067024 6129520 8035360
14:26:05 5974 8192000000 10759282688 11185668096 1845735104 18.387 100 23 46 0 1858536592 6287520 6513968
14:26:18 5301 8192000000 10763115232 11191070720 1849157696 18.415 100 27 54 1 1862949072 5486224 8305152
14:26:30 10073 8192000000 10767284080 11193708544 1850174688 18.424 100 21 42 3 1862200432 6341040 5684704
14:26:51 9860 8192000000 10777304544 11198320640 1852531760 18.443 100 18 35 2 1866783104 9737392 4513952
14:27:10 15323 8192000000 10796064512 11217735680 1874886480 18.624 100 22 43 2 1885598720 4419616 6292624
14:27:35 12619 8192000000 10821915584 11233705984 1888147424 18.731 100 48 90 1 1908618112 5745872 14724816
14:27:58 34782 8192000000 10823904272 11245748224 1899414208 18.822 100 54 107 1 1923039664 8461760 15163696
14:28:55 18170 8192000000 10847695920 11269472256 1913394128 18.934 100 50 101 0 1943747136 15963008 14390000
14:29:22 13583 8192000000 10850328464 11272781824 1915859888 18.954 100 43 85 2 1940025984 12434992 11731104
14:29:44 17530 8192000000 10867283664 11287367680 1926156992 19.036 100 62 125 2 1958186592 13520832 18508768
14:30:23 67576 8192000000 10864961808 11294937088 1929724416 19.065 100 47 94 2 1956441344 12661232 14055696
14:31:51 30040 8192000000 10870758272 11306229760 1935601872 19.112 100 34 68 0 1958742224 13130560 10009792
14:32:28 20989 8192000000 10882046192 11311792128 1945251936 19.189 100 46 92 3 1971624672 12875264 13497472
14:33:13 12973 8192000000 10886034000 11320324096 1954409504 19.262 100 44 88 2 1983326832 14717872 14199456
14:33:37 16890 8192000000 10894746224 11330981888 1959746912 19.304 100 43 86 2 1991814944 19457312 12610720
14:34:11 21327 8192000000 10908229872 11342610432 1965804432 19.352 100 40 79 2 2001043760 23095616 12143712
14:34:39 20544 8192000000 10910047264 11345395712 1974022240 19.417 100 44 88 1 2007331040 20161728 13147072
14:35:30 5556 8192000000 10920438768 11358060544 1977784512 19.447 100 43 84 3 2012834192 22160368 12889312
14:35:48 5318 8192000000 10925884416 11351097344 1964159936 19.339 99 50 100 0 2003211280 23434352 15616992
14:36:07 7426 8192000000 10935293856 11363094528 1980051664 19.465 100 53 104 3 2022371872 26333120 15987088
14:36:24 7130 8192000000 10945529264 11369054208 1987479632 19.524 100 64 123 3 2029942768 24177872 18285264
14:36:43 8295 8192000000 10946143488 11372093440 1989250768 19.538 100 61 122 0 2034125216 26455328 18419120
14:37:01 9158 8192000000 10937590864 11372232704 1988350976 19.531 100 52 104 0 2028969040 24556224 16061840
14:37:18 5900 8192000000 10949269472 11377131520 1991579136 19.556 100 48 96 1 2032213312 25596960 15037216
14:37:31 11256 8192000000 10938789664 11367641088 1981786528 19.479 100 53 106 0 2026540288 28040800 16712960
14:37:49 6880 8192000000 10939896224 11373494272 1985734704 19.510 100 55 110 2 2032872000 30246832 16890464
14:38:04 8588 8192000000 10937428240 11363733504 1972749216 19.407 99 69 137 2 2024401200 29868656 21783328
14:38:23 2961 8192000000 10946047760 11371401216 1984123040 19.497 100 49 98 1 2029970400 29968880 15878480
14:38:34 1761 8192000000 10947921648 11363540992 1970019152 19.386 99 72 142 1 2023428240 31785856 21623232
14:38:43 12430 8192000000 10940379008 11363999744 1978892688 19.456 100 61 122 2 2030249408 33084528 18272192
14:39:03 4948 8192000000 10938868848 11367579648 1976407984 19.436 100 59 118 0 2027212128 32782528 18021616
14:39:15 2074 8192000000 10936113456 11361218560 1959797696 19.304 99 80 159 1 2018115168 33035696 25281776
14:39:29 4232 8192000000 10951339376 11373002752 1980410592 19.468 100 68 136 0 2037434576 36460128 20563856
14:39:43 12595 8192000000 10957790208 11381624832 1986910112 19.519 100 70 139 0 2039135056 31025616 21199328
14:40:07 3348 8192000000 10965065216 11388067840 1998131616 19.608 100 74 149 2 2053717360 32763184 22822560
14:40:18 5134 8192000000 10973096320 11396894720 2004400256 19.657 100 68 135 0 2058559376 33349808 20809312
14:40:32 6851 8192000000 10976899184 11404197888 2008182016 19.687 100 68 134 0 2064474528 34596784 21695728
14:40:46 7417 8192000000 10975696672 11394883584 1997230688 19.601 100 73 146 2 2056883056 36258032 23394336
14:41:01 2560 8192000000 10982339344 11402522624 2004306288 19.657 100 91 182 2 2068752224 37055120 27390816
14:41:10 1507 8192000000 10993120624 11410124800 2005099664 19.663 100 87 174 2 2069682784 38216832 26366288
14:41:21 3377 8192000000 10974752576 11403055104 2002474688 19.642 100 72 146 2 2061025296 35966544 22584064
14:41:36 2908 8192000000 10958351872 11390316544 1998457328 19.611 100 68 137 1 2050542368 31083856 21001184
14:41:48 2864 8192000000 10953766688 11380875264 1977356736 19.444 99 69 135 4 2027965456 29777824 20830896
14:42:01 5070 8192000000 10947559440 11382038528 1986697424 19.518 100 45 90 3 2029414144 28236784 14479936
14:42:17 3901 8192000000 10968701312 11391856640 2001713728 19.636 100 82 156 1 2054454016 27552848 25187440
14:42:29 2441 8192000000 10954154960 11383681024 1990991168 19.552 100 67 132 3 2040694096 29844272 19858656
14:42:38 3777 8192000000 10960393552 11388551168 1981674608 19.478 99 71 142 2 2033483744 29996992 21812144
14:42:49 2317 8192000000 10952536656 11369414656 1982374688 19.483 100 76 147 1 2032037440 27662064 22000688
14:43:00 1726 8192000000 10973268240 11387527168 1995583072 19.588 100 88 176 1 2051841456 29629632 26628752
14:43:13 2119 8192000000 10955836016 11372847104 1974752352 19.423 99 83 164 0 2030958496 30486208 25719936
14:43:23 2887 8192000000 10933136688 11351769088 1962023776 19.322 100 76 149 2 2016545376 31953936 22567664
14:43:35 2305 8192000000 10940129648 11351810048 1960464160 19.310 100 91 180 4 2021774832 32901456 28409216
14:43:44 1827 8192000000 10947834736 11369717760 1973841856 19.416 100 80 160 0 2031402848 32874928 24686064
14:43:54 4436 8192000000 10943960816 11375280128 1977734880 19.447 100 65 128 1 2028635888 31650720 19250288
14:44:08 1599 8192000000 10941422096 11357315072 1961489936 19.318 99 85 171 0 2020164048 33172912 25501200
14:44:18 3045 8192000000 10964001072 11382198272 1982334608 19.483 100 81 162 1 2040878240 33787344 24756288
14:44:35 1870 8192000000 10941578864 11355828224 1959655328 19.303 99 83 162 0 2016084784 32157280 24272176
14:44:46 4345 8192000000 10921069984 11335958528 1932961088 19.091 98 85 168 2 1994113504 35670032 25482384
14:44:57 2364 8192000000 10950747296 11358523392 1962821792 19.328 100 90 179 0 2029401632 37825040 28754800
14:45:06 2423 8192000000 10939954816 11360116736 1963666192 19.335 100 76 151 1 2024572528 37131952 23774384
14:45:18 954 8192000000 10958955376 11366363136 1957949568 19.290 99 93 184 1 2021838304 35539472 28349264
14:45:25 6283 8192000000 10934610192 11371823104 1971315840 19.396 100 57 114 1 2023909392 35028928 17564624
14:45:48 5788 8192000000 10929270384 11357319168 1951895248 19.242 99 64 128 3 2010985504 39626704 19463552
14:46:02 3670 8192000000 10938215808 11355860992 1942895856 19.170 99 74 143 2 2003294064 37262896 23135312
14:46:15 1583 8192000000 10932902736 11345182720 1939998480 19.147 99 79 157 5 2000581808 35821152 24762176
14:46:26 4861 8192000000 10940674480 11371143168 1969024720 19.378 100 68 135 3 2030313376 39523152 21765504
14:46:38 5365 8192000000 10942660192 11368648704 1971883664 19.400 100 51 102 1 2021700528 33105440 16711424
14:46:53 5393 8192000000 10949853168 11383922688 1978541536 19.453 100 52 104 2 2033310464 38332688 16436240
14:47:05 5464 8192000000 10939071552 11375034368 1965121488 19.347 99 46 91 0 2017563488 37633568 14808432
14:47:18 9822 8192000000 10941211712 11362746368 1954155312 19.260 99 68 134 0 2009923456 34318096 21450048
14:47:36 1013 8192000000 10958673744 11371732992 1975344912 19.428 100 80 159 1 2037616000 35762368 26508720
14:47:44 3686 8192000000 10956119952 11374665728 1974095680 19.418 100 74 147 4 2035096560 38027360 22973520
14:47:54 7881 8192000000 10944805728 11373264896 1957859552 19.289 99 63 126 2 2018056000 39508000 20688448
14:48:12 4467 8192000000 10974623920 11393994752 1986629712 19.517 100 74 148 1 2050951232 40219584 24101936
14:48:24 7324 8192000000 10971690992 11406561280 1996109984 19.592 100 56 112 1 2057365888 42965200 18290704
14:48:48 10631 8192000000 10958962016 11394785280 1974004528 19.417 99 45 88 2 2027796272 39244256 14547488
14:49:08 10361 8192000000 10955814080 11398057984 1988859248 19.535 100 40 80 1 2039858768 37408432 13591088
14:49:24 6875 8192000000 10965402048 11403235328 1993676560 19.573 100 47 94 1 2049071008 38776864 16617584
14:49:37 5191 8192000000 10970546848 11402616832 1995040352 19.584 100 56 111 1 2053332208 39732288 18559568
14:49:50 13977 8192000000 10950952720 11391270912 1966322832 19.356 99 45 90 1 2024225184 42607904 15294448
14:50:15 14132 8192000000 10950504592 11393114112 1981241664 19.475 100 42 84 1 2038135648 42684000 14209984
14:50:35 14640 8192000000 10954772304 11396292608 1980585776 19.469 100 33 66 1 2032522608 40483728 11453104
14:51:03 16279 8192000000 10947992784 11398610944 1978836160 19.455 100 36 72 1 2037850272 46172384 12841728
14:51:33 9456 8192000000 10955034288 11391942656 1967692528 19.367 99 45 90 0 2031027440 47309376 16025536
14:51:53 7682 8192000000 10970997456 11412172800 1984054912 19.497 100 50 98 2 2050973904 50267520 16651472
14:52:25 10588 8192000000 10978677056 11427028992 1980125808 19.466 100 37 74 0 2058507584 64105184 14276592
14:52:44 10330 8192000000 10985838304 11428425728 1984857728 19.503 100 49 98 2 2068110384 65081856 18170800
14:53:05 7840 8192000000 10974641040 11426578432 1978505088 19.453 100 40 80 2 2059845776 65702928 15637760
14:53:19 8283 8192000000 10974389600 11423502336 1977607312 19.446 100 44 88 0 2059412080 65567040 16237728
14:53:51 17166 8192000000 10955044784 11430264832 1978038080 19.449 100 22 44 1 2038937552 52359328 8540144
14:54:15 20887 8192000000 10940311392 11407888384 1965996912 19.354 99 24 48 0 2024059728 49825568 8237248
14:54:53 34901 8192000000 10917409872 11359793152 1925941296 19.034 97 39 78 0 1971463104 33701360 11820448
14:55:51 38019 8192000000 10922773248 11395596288 1959659968 19.303 100 14 28 0 2004007248 39244240 5103040
14:56:36 28725 8192000000 10901832208 11372052480 1939782080 19.145 99 14 28 0 1965094416 21182640 4129696
14:57:13 34828 8192000000 10869412688 11350601728 1891689504 18.759 97 11 23 0 1923599776 28479120 3431152
14:57:54 127880 8192000000 10868010672 11337895936 1768985040 17.759 91 4 8 0 1790486048 20519952 981056
15:00:08 67962 8192000000 10863131872 11321659392 1885031680 18.706 97 14 28 1 1900372800 11471360 3869760
15:01:23 38985 8192000000 10867030464 11324170240 1925509104 19.031 99 28 55 2 1940712160 7365392 7837664
15:02:14 31509 8192000000 10877157696 11329974272 1902690864 18.848 98 24 46 1 1918128192 8267504 7169824
15:02:59 57826 8192000000 10872620512 11348373504 1926142832 19.036 99 12 24 1 1942254448 12889168 3222448
15:04:03 88296 8192000000 10898522032 11341139968 1952566608 19.247 100 22 46 0 1967755824 9234624 5954592
15:05:40 30175 8192000000 10917027424 11355869184 1950691360 19.232 99 49 95 2 1974649248 10275904 13681984
15:06:25 38795 8192000000 10919238240 11364900864 1965841888 19.352 100 20 38 1 1979504544 7983472 5679184
15:07:11 77871 8192000000 10903182320 11356549120 1961837232 19.321 99 42 84 2 1982107152 7887520 12382400
15:08:36 94957 8192000000 10918669040 11389992960 1985514768 19.508 100 23 46 0 2004419696 12256368 6648560
15:10:26 46294 8192000000 10939636272 11391270912 1996783648 19.597 100 31 62 1 2018415072 12069840 9561584
15:11:19 56889 8192000000 10904106256 11364093952 1940545280 19.151 98 27 48 2 1957231344 8837328 7848736
15:12:27 25669 8192000000 10910173856 11374403584 1980368576 19.468 100 33 65 0 1996960816 7675744 8916496
15:13:13 3008 8192000000 10928286672 11382095872 1991472176 19.555 100 41 82 4 2010038688 7232064 11334448
15:14:10 42129 8192000000 10933366640 11389943808 1992675776 19.565 100 33 66 2 2011329296 8842768 9810752
15:15:04 5396 8192000000 10945658592 11395522560 2002772208 19.645 100 65 129 1 2032510464 10332512 19405744
15:15:22 27821 8192000000 10936912528 11384344576 1961281408 19.316 98 51 102 2 1989984656 14179552 14523696
15:15:57 32083 8192000000 10939795984 11396620288 1993402240 19.571 100 46 92 1 2023379184 16473376 13503568
15:16:43 150734 8192000000 10928296896 11412344832 1998517824 19.611 100 25 50 2 2026992000 20584128 7890048
15:19:19 25831 8192000000 10920557424 11415027712 1992745696 19.565 100 11 22 0 2012987872 17092384 3149792
15:19:52 23552 8192000000 10933579344 11408056320 1996620800 19.596 100 28 56 2 2016638368 11876976 8140592
15:20:27 32547 8192000000 10907196064 11393998848 1975091168 19.426 99 11 23 0 1993099440 14739520 3268752
15:21:09 52522 8192000000 10875776416 11350958080 1924484192 19.023 97 19 39 0 1940558192 10784736 5289264
15:22:08 48792 8192000000 10881128944 11369422848 1965134160 19.347 100 7 14 2 1977862784 10064400 2664224
15:23:11 14870 8192000000 10883784608 11373498368 1968091696 19.370 100 9 18 1 1978896336 8433040 2371600
15:23:46 31188 8192000000 10883410704 11357556736 1956641280 19.279 99 13 26 3 1967257488 6734096 3882112
15:24:57 36113 8192000000 10866318000 11349258240 1929005696 19.059 98 13 26 0 1939168688 6597296 3565696
15:25:41 70078 8192000000 10863944848 11352551424 1943191792 19.172 99 5 10 0 1951064704 6785776 1087136
15:26:57 55012 8192000000 10872647552 11352502272 1910992816 18.915 97 10 20 0 1922607024 9363168 2251040
15:28:08 49331 8192000000 10844524832 11319672832 1846972064 18.398 94 15 30 0 1861179760 10059184 4148512
15:29:03 46859 8192000000 10876428752 11357130752 1932543584 19.087 99 16 32 0 1947577488 11015648 4018256
15:29:56 42426 8192000000 10862192336 11344674816 1913189680 18.932 98 18 36 0 1926921168 8777328 4954160
15:30:45 55948 8192000000 10881547536 11358920704 1927566416 19.047 98 20 40 1 1945066064 12120768 5378880
15:31:48 50063 8192000000 10883467696 11361689600 1884339104 18.700 96 21 42 1 1909761184 19379696 6042384
15:32:45 52946 8192000000 10880696960 11342565376 1876562672 18.637 96 17 34 0 1899304656 18236704 4505280
15:33:47 49068 8192000000 10863663104 11303714816 1839612176 18.338 95 17 34 0 1854145744 9693440 4840128
15:34:43 10816 8192000000 10893158352 11330383872 1935344224 19.110 100 56 113 2 1960766256 9416256 16005776
15:35:00 20800 8192000000 10893903696 11333148672 1924521328 19.023 99 57 112 2 1950711296 11547072 14642896
15:35:27 12638 8192000000 10880007072 11331026944 1922176608 19.004 99 56 112 2 1950161984 12467984 15517392
15:35:51 36974 8192000000 10879183344 11332972544 1916118784 18.956 99 41 81 3 1943432880 16343232 10970864
15:36:35 46173 8192000000 10862922016 11332894720 1932046992 19.083 100 34 68 3 1956505344 13912992 10545360
15:38:09 45468 8192000000 10847069520 11310964736 1862507184 18.524 96 25 50 1 1888988416 18693792 7787440
15:39:04 58977 8192000000 10827089408 11287535616 1826895648 18.234 95 11 22 1 1841062976 11151888 3015440
15:40:09 9766 8192000000 10844252832 11291586560 1876658336 18.638 98 57 113 0 1905174000 11692752 16822912
15:40:27 22116 8192000000 10857518416 11304550400 1893793920 18.776 99 49 98 2 1918749360 11293216 13662224
15:40:55 66411 8192000000 10846683360 11308826624 1879151216 18.658 98 32 64 0 1902049296 14131168 8766912
15:42:08 94966 8192000000 10841917536 11307524096 1914879552 18.946 100 26 52 0 1933933888 10961664 8092672
15:43:49 60590 8192000000 10848331520 11310882816 1909904304 18.906 99 28 56 0 1930993312 13448320 7640688
15:44:56 17621 8192000000 10848871216 11326119936 1926256768 19.037 100 25 50 1 1947761904 14625424 6879712
15:45:28 15936 8192000000 10835929648 11320434688 1919966832 18.987 100 7 14 0 1935208784 13088368 2153584
15:45:50 31345 8192000000 10827944624 11304009728 1901686528 18.840 99 4 9 0 1915313008 12875456 751024
15:46:28 29912 8192000000 10811422448 11289407488 1876641568 18.638 98 3 6 0 1884219600 6396992 1181040
15:47:04 32151 8192000000 10827668816 11299823616 1911386752 18.918 100 11 23 1 1920890352 6385248 3118352
15:47:42 37136 8192000000 10815323568 11285016576 1857214112 18.481 97 9 18 0 1866092416 6782464 2095840
15:48:37 66349 8192000000 10851371904 11323625472 1905526960 18.871 99 20 40 1 1922020512 10716320 5777232
15:49:54 70942 8192000000 10844590288 11325935616 1893281328 18.772 98 13 25 1 1904426368 7712496 3432544
15:51:16 46107 8192000000 10864070160 11329859584 1930763888 19.073 100 22 44 1 1950051968 12992848 6295232
15:52:16 49925 8192000000 10859674832 11324170240 1884999856 18.705 97 11 22 1 1896845072 9532352 2312864
15:53:15 46641 8192000000 10874471072 11327135744 1903146352 18.852 98 34 67 1 1921761712 9535552 9079808
15:54:21 23204 8192000000 10855857184 11326062592 1920883808 18.994 99 36 72 0 1941210688 9446944 10879936
15:55:00 78243 8192000000 10880068528 11353026560 1945224368 19.188 100 15 30 0 1958934848 9335328 4375152
15:56:25 69666 8192000000 10885260928 11355906048 1939606112 19.144 99 18 36 1 1955135168 9950560 5578496
15:57:41 49348 8192000000 10890130192 11341725696 1891257440 18.756 96 21 40 1 1904560592 8231136 5072016
15:58:37 78469 8192000000 10894721856 11366162432 1946955952 19.202 99 26 52 1 1966944144 13098288 6889904
16:00:02 78761 8192000000 10901338128 11377152000 1967746912 19.368 100 7 14 1 1986800080 17333760 1719408
16:01:30 30224 8192000000 10915205536 11372081152 1963146368 19.331 99 26 52 0 1980282448 9771808 7364272
16:02:12 89124 8192000000 10887566128 11365457920 1911791376 18.921 97 18 36 1 1928713696 11808128 5114192
16:04:37 87695 8192000000 10870986112 11336253440 1836521440 18.312 93 31 62 0 1857019328 12228720 8269168
16:06:19 38983 8192000000 10852768256 11338260480 1940330960 19.149 100 19 38 0 1955709056 10061248 5316848
16:07:12 59210 8192000000 10867875408 11339079680 1897516352 18.806 97 15 30 1 1907961152 6223072 4221728
16:08:17 103261 8192000000 10886267328 11358171136 1900778752 18.833 97 12 24 0 1912036080 7795872 3461456
16:10:19 99785 8192000000 10880823824 11375251456 1945946048 19.194 99 20 40 2 1968022736 16162352 5914336
16:12:05 35826 8192000000 10883333584 11386580992 1958823184 19.297 100 12 23 0 1978797120 16438560 3535376
16:12:53 68020 8192000000 10883034560 11365666816 1947711488 19.208 99 19 38 2 1961787008 8620912 5454608
16:14:08 39841 8192000000 10878116688 11357581312 1939803008 19.145 99 19 38 2 1952819776 7928640 5088128
16:14:54 27784 8192000000 10894387248 11362611200 1946287936 19.197 99 20 39 0 1960892944 8642960 5962048
16:15:38 41287 8192000000 10903281840 11372793856 1975339888 19.428 100 24 46 2 1988617792 7139600 6138304
16:16:27 43109 8192000000 10861001616 11328155648 1837030608 18.317 93 24 48 2 1852606992 8812336 6764048
16:17:16 79041 8192000000 10863393264 11336982528 1845714304 18.387 95 31 60 1 1866510112 11245344 9550464
16:18:41 24255 8192000000 10869626800 11332296704 1889138368 18.739 97 24 48 0 1903653408 8157952 6357088
16:19:12 81281 8192000000 10852429104 11334791168 1864809056 18.542 96 25 50 1 1883797904 12130160 6858688
16:21:08 34483 8192000000 10873926592 11340136448 1922535648 19.007 99 11 22 0 1932821408 7574016 2711744
16:21:50 32834 8192000000 10867376208 11321057280 1852616800 18.443 95 33 66 1 1872242000 10093824 9531376
16:22:34 93587 8192000000 10849644832 11322900480 1873588016 18.613 97 17 34 0 1888935424 10802320 4545088
16:24:14 106769 8192000000 10840910064 11322945536 1871135040 18.593 97 14 26 1 1885488384 10151520 4201824
16:26:26 88155 8192000000 9235852576 9535754240 376391968 4.392 20 7 11 1 379874384 1942960 1539456

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 07-03-2021 16:29:29 to 07-03-2021 16:30:02.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 139 v_add_invoice_to_stock 335544517
except 16 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-03-2021 16:30:02 to 07-03-2021 16:30:04.

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          246653
MON$OLDEST_ACTIVE               247263
MON$OLDEST_SNAPSHOT             247263
MON$NEXT_TRANSACTION            247263
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                       2032096
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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 ---
:137: 
:138: mscs-test-161.budzdorov.ru    Sun Mar  7 16:27:56 2021
:139:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:140: 
--- end of diff output ---

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

07.03.21 16:30:05. 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-03-07 16:30:08 No severe PSQL-related problems occured
07.03.21 16:30:09. End of report.