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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17469116 kB
MemAvailable 31510688 kB
Buffers 0 kB
Cached 14235740 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-31 19:27:24
DTS_END                         2021-03-31 19:27:24.6420
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56574
TRN_ID                          231002
ATT_ID                          652
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: 9169.21 18674 1100305
customer order: creation 163.78 374 19654
customer order: refuse 13.71 403 1645
order to supplier: creation 43.13 1322 5176
order to supplier: removal 3.38 115367 405
invoice (draft): creation 45.45 3427 5454
invoice (draft): removal 54.55 920 6546
invoice accept: apply 39.29 19583 4715
invoice accept: cancel 49.14 884 5897
customer reserve: creation 3651.81 194 438217
customer reserve: removal 4812.58 63 577509
realization accept: apply 81.56 177 9787
realization accept: cancel 86.48 107 10378
payment from customer: creation 56.33 140 6759
payment from customer: removal 5.47 84 656
payment to supplier: creation 47.43 128 5692
payment to supplier: removal 3.42 58 410
service: total inventory turnovers 4.70 1122 564
service: total monetary turnovers 6.28 24 754
service: aggregate perf. data 0.69 23905 83
service: refresh index statistics 0.03 205197 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 31-03-2021 19:29:20 to 31-03-2021 19:29:22.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7203
TEST_TIME 2 6383
TEST_TIME 3 6559
TEST_TIME 4 6270
TEST_TIME 5 6300
TEST_TIME 6 5866
TEST_TIME 7 5882
TEST_TIME 8 5966
TEST_TIME 9 6320
TEST_TIME 10 6247
TEST_TIME 11 6406
TEST_TIME 12 6786
TEST_TIME 13 6892
TEST_TIME 14 6809
TEST_TIME 15 7056
TEST_TIME 16 7290
TEST_TIME 17 7239
TEST_TIME 18 7387
TEST_TIME 19 7447
TEST_TIME 20 7750
TEST_TIME 21 7983
TEST_TIME 22 8177
TEST_TIME 23 8452
TEST_TIME 24 8361
TEST_TIME 25 8555
TEST_TIME 26 8663
TEST_TIME 27 8642
TEST_TIME 28 9645
TEST_TIME 29 10948
TEST_TIME 30 10958
TEST_TIME 31 10737
TEST_TIME 32 10617
TEST_TIME 33 10563
TEST_TIME 34 10620
TEST_TIME 35 10384
TEST_TIME 36 10393
TEST_TIME 37 10187
TEST_TIME 38 10044
TEST_TIME 39 9879
TEST_TIME 40 9927
TEST_TIME 41 10152
TEST_TIME 42 10088
TEST_TIME 43 9921
TEST_TIME 44 9913
TEST_TIME 45 9902
TEST_TIME 46 9766
TEST_TIME 47 9675
TEST_TIME 48 9561
TEST_TIME 49 9537
TEST_TIME 50 9527
TEST_TIME 51 9419
TEST_TIME 52 9488
TEST_TIME 53 9433
TEST_TIME 54 9451
TEST_TIME 55 9410
TEST_TIME 56 9392
TEST_TIME 57 9498
TEST_TIME 58 9447
TEST_TIME 59 9530
TEST_TIME 60 9563
TEST_TIME 61 9539
TEST_TIME 62 9641
TEST_TIME 63 9636
TEST_TIME 64 9604
TEST_TIME 65 9706
TEST_TIME 66 9772
TEST_TIME 67 9747
TEST_TIME 68 9698
TEST_TIME 69 9679
TEST_TIME 70 9609
TEST_TIME 71 9596
TEST_TIME 72 9476
TEST_TIME 73 9478
TEST_TIME 74 9459
TEST_TIME 75 9421
TEST_TIME 76 9380
TEST_TIME 77 9366
TEST_TIME 78 9373
TEST_TIME 79 9296
TEST_TIME 80 9308
TEST_TIME 81 9304
TEST_TIME 82 9287
TEST_TIME 83 9320
TEST_TIME 84 9327
TEST_TIME 85 9300
TEST_TIME 86 9450
TEST_TIME 87 9399
TEST_TIME 88 9389
TEST_TIME 89 9375
TEST_TIME 90 9394
TEST_TIME 91 9399
TEST_TIME 92 9437
TEST_TIME 93 9446
TEST_TIME 94 9485
TEST_TIME 95 9476
TEST_TIME 96 9413
TEST_TIME 97 9327
TEST_TIME 98 9350
TEST_TIME 99 9295
TEST_TIME 100 9236
TEST_TIME 101 9251
TEST_TIME 102 9220
TEST_TIME 103 9186
TEST_TIME 104 9138
TEST_TIME 105 9116
TEST_TIME 106 9053
TEST_TIME 107 9024
TEST_TIME 108 9039
TEST_TIME 109 9024
TEST_TIME 110 9059
TEST_TIME 111 9027
TEST_TIME 112 9042
TEST_TIME 113 9056
TEST_TIME 114 9170
TEST_TIME 115 9165
TEST_TIME 116 9181
TEST_TIME 117 9178
TEST_TIME 118 9190
TEST_TIME 119 9205
TEST_TIME 120 9175

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 31-03-2021 19:29:23 to 31-03-2021 19:29:27.

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 1508430 1508430 0 0.00 0 18665 6 0 0
doc_list_biud 1508422 1508422 0 0.00 0 33805 31 0 0
sp_add_invoice_to_stock 4851 4715 136 2.80 38 222142 19583 0 136
sp_cancel_adding_invoice 5897 5897 0 0.00 4 71048 885 0 0
sp_cancel_client_order 1645 1645 0 0.00 5 27088 403 0 0
sp_cancel_customer_reserve 577509 577509 0 0.00 1 33807 63 0 0
sp_cancel_pay_from_customer 656 656 0 0.00 3 6903 84 0 0
sp_cancel_pay_to_supplier 410 410 0 0.00 3 2213 59 0 0
sp_cancel_supplier_invoice 6555 6546 9 0.13 2 14998 921 0 9
sp_cancel_supplier_order 405 405 0 0.00 10 1112101 115367 0 0
sp_cancel_write_off 10378 10378 0 0.00 1 9971 107 0 0
sp_client_order 19654 19654 0 0.00 3 38454 375 0 0
sp_customer_reserve 438217 438217 0 0.00 0 46789 194 0 0
sp_fill_shopping_cart 30271 30271 0 0.00 1 13058 39 0 0
sp_fill_shopping_cart_clo_res 438210 438210 0 0.00 0 11866 13 0 0
sp_get_clo_for_invoice 4705 4705 0 0.00 0 24956 274 0 0
sp_kill_cost_storno 17341 17341 0 0.00 0 17011 56 0 0
sp_kill_qstorno_ret_qs2qd 1172347 1172347 0 0.00 0 29641 35 0 0
sp_kill_qty_storno 616871 616871 0 0.00 0 33803 74 0 0
sp_lock_selected_doc 19985 19985 0 0.00 0 8388 6 0 0
sp_make_cost_storno 26943 26943 0 0.00 0 12199 54 0 0
sp_multiply_rows_for_pdistr 26943 26943 0 0.00 0 8298 28 0 0
sp_multiply_rows_for_qdistr 19654 19654 0 0.00 0 11053 160 0 0
sp_pay_from_customer 6759 6759 0 0.00 4 12989 140 0 0
sp_pay_to_supplier 5692 5692 0 0.00 5 12224 129 0 0
sp_payment_common 12450 12450 0 0.00 1 11685 34 0 0
sp_qd_handle_on_cancel_clo 1645 1645 0 0.00 0 27083 368 0 0
sp_qd_handle_on_invoice_upd_sts 10602 10602 0 0.00 0 19561 345 0 0
sp_qd_handle_on_reserve_upd_sts 9786 9786 0 0.00 0 29040 64 0 0
sp_reserve_write_off 9787 9787 0 0.00 7 29121 177 0 0
sp_supplier_invoice 5454 5454 0 0.00 7 109097 3428 0 0
sp_supplier_order 5176 5176 0 0.00 5 48066 1322 0 0
srv_aggregate_perf_data 84 83 1 1.19 2729 151800 23906 0 1
srv_fill_mon_cache_memory 160 160 0 0.00 1614 151231 31145 0 0
srv_find_qd_qs_mism 1055899 1055899 0 0.00 0 18662 5 0 0
srv_make_invnt_saldo 564 564 0 0.00 48 28461 1123 0 0
srv_make_money_saldo 754 754 0 0.00 1 999 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 65430 425478 205197 0 0
t$perf-abend:sp_add_invoice_to_stock 136 136 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 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 4715 4715 0 0.00 0 14717 188 0 0
t$perf-norm:sp_cancel_adding_invoice 400 400 0 0.00 0 6229 158 0 0
t$perf-norm:sp_cancel_client_order 1645 1645 0 0.00 0 6267 18 0 0
t$perf-norm:sp_cancel_customer_reserve 669 669 0 0.00 0 633 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 656 656 0 0.00 0 4047 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 410 410 0 0.00 0 142 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 386 386 0 0.00 0 1308 16 0 0
t$perf-norm:sp_cancel_supplier_order 405 405 0 0.00 0 23297 1850 0 0
t$perf-norm:sp_cancel_write_off 925 925 0 0.00 0 1600 6 0 0
t$perf-norm:sp_client_order 19655 19655 0 0.00 0 11313 24 0 0
t$perf-norm:sp_customer_reserve 960 960 0 0.00 0 4725 14 0 0
t$perf-norm:sp_pay_from_customer 6759 6759 0 0.00 0 8413 16 0 0
t$perf-norm:sp_pay_to_supplier 5692 5692 0 0.00 0 6441 14 0 0
t$perf-norm:sp_reserve_write_off 9787 9787 0 0.00 0 4998 13 0 0
t$perf-norm:sp_supplier_invoice 5454 5454 0 0.00 0 12930 31 0 0
t$perf-norm:sp_supplier_order 5176 5176 0 0.00 0 8984 21 0 0
t$perf-norm:srv_aggregate_perf_data 83 83 0 0.00 0 3664 48 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 685 10 0 0
t$perf-norm:srv_make_invnt_saldo 564 564 0 0.00 0 1300 30 0 0
t$perf-norm:srv_make_money_saldo 754 754 0 0.00 0 4231 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 9680 9408 272 2.80 0 6725 21 0 272
v_all_customers 35620 35620 0 0.00 0 178 1 0 0
v_all_suppliers 29508 29508 0 0.00 0 17 1 0 0
v_all_wares 39306 39306 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 800 800 0 0.00 0 299 5 0 0
v_cancel_client_order 3290 3290 0 0.00 0 4446 8 0 0
v_cancel_customer_prepayment 1312 1312 0 0.00 0 4564 8 0 0
v_cancel_customer_reserve 1338 1338 0 0.00 0 5023 8 0 0
v_cancel_payment_to_supplier 820 820 0 0.00 0 263 3 0 0
v_cancel_supplier_invoice 790 772 18 2.27 0 2058 17 0 18
v_cancel_supplier_order 810 810 0 0.00 0 3929 10 0 0
v_cancel_write_off 1850 1850 0 0.00 0 2092 13 0 0
v_max_id_clo_ord 5173 5173 0 0.00 0 3363 2 0 0
v_max_id_clo_res 960 960 0 0.00 0 13635 25 0 0
v_max_id_ord_sup 5445 5445 0 0.00 0 5019 4 0 0
v_max_non_paid_invoice 1555 1555 0 0.00 0 1831 4 0 0
v_max_non_paid_realizn 3697 3697 0 0.00 0 6348 6 0 0
v_min_id_clo_ord 5173 5173 0 0.00 0 6199 10 0 0
v_min_id_clo_res 960 960 0 0.00 0 6300 17 0 0
v_min_id_ord_sup 5445 5445 0 0.00 0 4165 8 0 0
v_min_non_paid_invoice 5691 5691 0 0.00 0 9587 20 0 0
v_min_non_paid_realizn 6759 6759 0 0.00 0 6641 22 0 0
v_our_firm 9810 9810 0 0.00 0 14 1 0 0
v_reserve_write_off 19570 19570 0 0.00 0 2804 4 0 0
x_lock_depdocs_on_canc_invoice 12057 12057 0 0.00 0 16049 114 0 0
x_lock_depdocs_on_canc_sup_ord 405 405 0 0.00 0 6113 365 0 0
x_make_qstorno_1000_1200 5176 5176 0 0.00 1 48059 1239 0 0
x_make_qstorno_1200_2000 5454 5454 0 0.00 3 100191 3291 0 0
x_make_qstorno_2100_3300 438217 438217 0 0.00 0 46788 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 31-03-2021 19:29:28 to 31-03-2021 19:29:32.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:28 8 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:35 14851 8192000000 10238097008 10543144960 890886320 9.808 70 53 107 0 911793088 2543712 18363056
16:57:58 29397 8192000000 10350799776 10671828992 1409205600 14.677 100 87 174 1 1441850624 4920176 27724848
16:58:36 28727 8192000000 10405578592 10728755200 1452111168 15.056 100 89 178 1 1488019376 6866704 29041504
16:59:17 33856 8192000000 10444317968 10775158784 1495440848 15.436 100 91 182 1 1532865776 8484192 28940736
17:00:00 30012 8192000000 10468451600 10803503104 1517522528 15.629 100 96 193 0 1556957200 9463984 29970688
17:00:50 24387 8192000000 10479839584 10822258688 1536007296 15.789 100 85 170 0 1573246816 10399696 26839824
17:01:26 17059 8192000000 10500294624 10843615232 1554330896 15.947 100 86 172 2 1592135520 11015120 26789504
17:01:53 17983 8192000000 10512065952 10858278912 1570832000 16.089 100 89 178 0 1610062224 11607104 27623120
17:02:20 17653 8192000000 10521691248 10874834944 1582098240 16.186 100 85 170 1 1619516608 11415984 26002384
17:02:46 20008 8192000000 10546554384 10909556736 1603274304 16.367 100 72 141 1 1635306576 10685824 21346448
17:03:14 10440 8192000000 10587649792 10950410240 1642429536 16.700 100 70 140 0 1673962032 10951792 20580704
17:03:33 8367 8192000000 10606506048 10971889664 1668585056 16.921 100 77 153 2 1702345808 11354224 22406528
17:03:49 10543 8192000000 10630878032 10996531200 1688054176 17.085 100 78 157 0 1722648928 11846224 22748528
17:04:09 8948 8192000000 10641372304 11014467584 1703037312 17.211 100 68 136 2 1734299344 11981920 19280112
17:04:25 9544 8192000000 10656092448 11034398720 1716755728 17.325 100 78 156 4 1752343568 12827088 22760752
17:04:45 7038 8192000000 10677146688 11050958848 1735111664 17.478 100 74 148 1 1768309888 12500576 20697648
17:04:58 5546 8192000000 10692485120 11065479168 1751949440 17.618 100 84 168 0 1788943504 13292288 23701776
17:05:11 6272 8192000000 10700047824 11080728576 1758094240 17.669 100 79 158 2 1793742224 13111920 22536064
17:05:26 5771 8192000000 10708154288 11093655552 1772260672 17.786 100 79 159 0 1807747088 13435600 22050816
17:05:42 9376 8192000000 10717160256 11102945280 1782509328 17.870 100 73 146 2 1814672400 12717808 19445264
17:05:58 3841 8192000000 10736186992 11121233920 1795302784 17.975 100 89 174 2 1833365456 13471888 24590784
17:06:10 3871 8192000000 10743325616 11129548800 1807924688 18.079 100 81 161 2 1843347040 12928464 22493888
17:06:22 3147 8192000000 10752635216 11141926912 1815604464 18.142 100 83 167 1 1851872512 13001424 23266624
17:06:31 3497 8192000000 10760742608 11145674752 1823968192 18.210 100 89 178 0 1862946576 13835712 25142672
17:06:42 4327 8192000000 10764161264 11153305600 1825572544 18.223 100 83 164 0 1863182784 13940320 23669920
17:06:53 2847 8192000000 10777666240 11161395200 1829592464 18.256 100 82 164 2 1866048688 13383200 23073024
17:07:02 2440 8192000000 10774272896 11161751552 1835976976 18.308 100 83 166 1 1872604464 13480352 23147136
17:07:12 3082 8192000000 10779700704 11165069312 1836688768 18.314 100 87 175 1 1873783056 12401008 24693280
17:07:22 2870 8192000000 10791666848 11177443328 1843562336 18.370 100 89 178 2 1881797328 13180256 25054736
17:07:31 2133 8192000000 10785120688 11174375424 1844994064 18.381 100 84 169 1 1882245312 13402912 23848336
17:07:42 2198 8192000000 10788083264 11183415296 1848057136 18.406 100 83 166 2 1885188848 13928896 23202816
17:07:50 2109 8192000000 10787152928 11181752320 1847587520 18.403 100 75 151 0 1881188400 13162224 20438656
17:07:59 4034 8192000000 10795522192 11182583808 1852074432 18.439 100 87 173 1 1888863456 12951584 23837440
17:08:10 2205 8192000000 10789810016 11184717824 1856124064 18.472 100 90 181 1 1894651232 13233104 25294064
17:08:19 1904 8192000000 10802890128 11191947264 1859606576 18.500 100 88 177 0 1897231664 12738320 24886768
17:08:27 2502 8192000000 10803464048 11190358016 1858188080 18.489 100 87 174 2 1896090272 13324192 24578000
17:08:36 2193 8192000000 10809037936 11196755968 1863100944 18.528 100 91 180 2 1902181808 14112832 24968032
17:08:45 2048 8192000000 10802126752 11197530112 1862120560 18.520 100 86 172 0 1900427920 13925664 24381696
17:08:54 19112 8192000000 10801150192 11193679872 1861590640 18.516 100 63 127 2 1889497664 9238832 18668192
17:09:20 8272 8192000000 10814927984 11205292032 1871357088 18.595 100 92 184 1 1910841024 11459328 28024608
17:09:35 2039 8192000000 10819137200 11209482240 1872986480 18.608 100 91 183 1 1910601968 11625008 25990480
17:09:43 3422 8192000000 10787379696 11203174400 1870057872 18.585 100 50 100 2 1894871968 10966432 13847664
17:09:54 3509 8192000000 10797834336 11210539008 1880355584 18.668 100 71 140 2 1911088640 10817936 19915120
17:10:05 2031 8192000000 10791548512 11206950912 1874460896 18.620 100 46 92 0 1897755440 10297248 12997296
17:10:17 6214 8192000000 10781317504 11205746688 1874128256 18.618 100 29 58 0 1889430288 6595024 8707008
17:10:31 6013 8192000000 10795847536 11208998912 1876660864 18.638 100 36 72 1 1893024640 6590528 9773248
17:10:45 5198 8192000000 10799164640 11222327296 1877312960 18.643 100 27 55 2 1895837792 11250960 7273872
17:11:02 5427 8192000000 10814180800 11223556096 1888436096 18.733 100 46 92 1 1911801376 9990688 13374592
17:11:13 7851 8192000000 10799869552 11227451392 1892914224 18.769 100 36 72 4 1911250256 8039184 10296848
17:11:29 50482 8192000000 10820424128 11239071744 1895469392 18.790 100 46 92 1 1913686128 5866544 12350192
17:12:31 8427 8192000000 10815462048 11240906752 1891213344 18.756 100 21 42 1 1902676512 5797600 5665568
17:12:47 4369 8192000000 10807553808 11242774528 1895519840 18.790 100 37 72 3 1917226912 11491360 10215712
17:13:00 7785 8192000000 10810114880 11243954176 1902053104 18.843 100 24 48 0 1916061568 7039600 6968864
17:13:14 6073 8192000000 10818953728 11250307072 1906345008 18.877 100 34 67 4 1921574688 6369888 8859792
17:13:27 4049 8192000000 10834432592 11252363264 1906129440 18.876 100 37 72 1 1922372832 5956656 10286736
17:13:37 4772 8192000000 10829402464 11253391360 1910131232 18.908 100 48 96 1 1933143264 10008416 13003616
17:13:48 3711 8192000000 10823938736 11252285440 1909721456 18.904 100 46 92 0 1931015280 7886672 13407152
17:13:59 7171 8192000000 10818115888 11251642368 1905854944 18.873 100 26 50 2 1920057376 7094544 7107888
17:14:13 4943 8192000000 10823374544 11247620096 1891703280 18.760 99 41 83 0 1909212880 5057216 12452384
17:14:24 8961 8192000000 10822017648 11255828480 1906234704 18.876 100 32 64 0 1926162864 10676784 9251376
17:14:40 10505 8192000000 10824256432 11252678656 1910428560 18.910 100 29 58 2 1925257472 5393680 9435232
17:14:57 6357 8192000000 10815488112 11257626624 1908899504 18.898 100 32 64 0 1928939536 9965968 10074064
17:15:11 21659 8192000000 10824244736 11257561088 1910180784 18.908 100 17 34 0 1920959504 5904528 4874192
17:15:41 4826 8192000000 10830108416 11262795776 1918023968 18.971 100 22 44 0 1929689632 5688512 5977152
17:15:52 57522 8192000000 10868245328 11269197824 1904011760 18.859 99 55 110 4 1927408224 5512272 17884192
17:16:56 13871 8192000000 10829052736 11263979520 1912671728 18.928 100 13 26 1 1921694400 5332320 3690352
17:17:17 6501 8192000000 10803195584 11241594880 1894735408 18.784 99 27 54 0 1909325696 7141104 7449184
17:17:30 7253 8192000000 10801480320 11225735168 1861095168 18.512 98 32 64 0 1876974624 5679088 10200368
17:17:46 5004 8192000000 10819407376 11237519360 1892720272 18.768 100 34 67 3 1908659744 7169184 8770288
17:17:59 6441 8192000000 10799314064 11230662656 1876558912 18.637 99 24 47 4 1889500496 6196336 6745248
17:18:13 5140 8192000000 10805115904 11233734656 1876639184 18.638 99 34 70 1 1892978784 6751824 9587776
17:18:24 4492 8192000000 10769119200 11190996992 1841752816 18.355 98 33 65 1 1857881040 7118448 9009776
17:18:35 12315 8192000000 10784530944 11205607424 1817764848 18.159 97 24 48 1 1830640976 6174384 6701744
17:18:54 4395 8192000000 10770414592 11199143936 1845262800 18.384 99 28 56 1 1860503696 7159072 8081824
17:19:08 5511 8192000000 10779723248 11197833216 1821370176 18.189 97 28 56 2 1835772224 5594240 8807808
17:19:24 6754 8192000000 10762898128 11190194176 1820262000 18.180 98 16 32 0 1830292672 5805664 4225008
17:19:38 9122 8192000000 10753818592 11184484352 1788395840 17.919 96 17 34 0 1799484176 6507280 4581056
17:19:53 10514 8192000000 10725018800 11143262208 1688453680 17.088 92 11 20 0 1700702896 9260304 2988912
17:20:10 13039 8192000000 10727473920 11145379840 1764842976 17.724 97 24 48 2 1776588240 5057936 6687328
17:21:06 24918 8192000000 10678190288 11097284608 1641365888 16.691 91 12 24 1 1653191616 8620720 3205008
17:21:40 11163 8192000000 10690301168 11099115520 1729653760 17.433 96 27 54 0 1747545280 9530288 8361232
17:21:57 5985 8192000000 10690648096 11093417984 1738229824 17.504 98 47 94 0 1759851920 8614608 13007488
17:22:10 6142 8192000000 10694839344 11110842368 1767962768 17.750 99 36 72 2 1785706752 6167072 11576912
17:22:25 10801 8192000000 10708874528 11119562752 1758095024 17.669 98 26 52 3 1775803984 9561792 8147168
17:22:42 4171 8192000000 10724619280 11131621376 1795538224 17.977 100 23 46 4 1812700176 10817040 6344912
17:22:53 9437 8192000000 10738311360 11152453632 1815809008 18.143 100 31 62 2 1831075808 5161264 10105536
17:23:09 9949 8192000000 10749311408 11160023040 1821509744 18.190 100 23 45 0 1834599712 5562928 7527040
17:23:25 8095 8192000000 10739736784 11165483008 1830565328 18.264 100 25 50 2 1843845728 5504736 7775664
17:23:42 8690 8192000000 10742295040 11175071744 1837885728 18.324 100 23 46 2 1849964976 5188768 6890480
17:23:57 8493 8192000000 10758156640 11186069504 1847840272 18.405 100 34 68 2 1863893248 5089872 10963104
17:24:12 11665 8192000000 10762451168 11198832640 1856462304 18.475 100 31 62 0 1876238000 10229856 9545840
17:24:30 7077 8192000000 10743079376 11171684352 1835493232 18.304 99 19 38 1 1847199920 6044224 5662464
17:24:45 78451 8192000000 10763283648 11196940288 1862361680 18.522 100 28 57 1 1875245280 4762864 8120736
17:26:10 12410 8192000000 10792959632 11211653120 1865903664 18.551 100 39 78 2 1887802176 10731104 11167408
17:26:30 13986 8192000000 10775255568 11208409088 1867226816 18.562 100 30 60 0 1882092016 6299856 8565344
17:26:52 6756 8192000000 10787454480 11212197888 1867287472 18.562 100 31 62 3 1887022160 11136880 8597808
17:27:08 3970 8192000000 10809692896 11223826432 1882640784 18.686 100 38 78 0 1903593200 9395504 11556912
17:27:20 13351 8192000000 10813021920 11231707136 1890696672 18.751 100 29 58 0 1904054976 5413840 7944464
17:27:43 26065 8192000000 10835581792 11254161408 1903591680 18.855 100 52 101 2 1929658944 12334400 13732864
17:28:16 15186 8192000000 10839900128 11259879424 1909743152 18.905 100 60 119 0 1935849744 9409520 16697072
17:28:40 5099 8192000000 10857174896 11273154560 1918663008 18.976 100 57 112 2 1944115120 9603056 15849056
17:28:52 4374 8192000000 10861139072 11275558912 1922064128 19.003 100 60 120 0 1949245552 10706112 16475312
17:29:04 11338 8192000000 10859225200 11275911168 1927051904 19.043 100 66 131 0 1956888736 11570000 18266832
17:29:27 3035 8192000000 10874549120 11284017152 1927270800 19.045 100 58 116 0 1955144448 10744576 17129072
17:29:36 59718 8192000000 10861021232 11288371200 1932005360 19.083 100 46 93 0 1958545168 14292528 12247280
17:30:52 61135 8192000000 10863671488 11304144896 1933463616 19.095 100 33 66 1 1952738192 9978400 9296176
17:32:06 22064 8192000000 10885490624 11320995840 1951678672 19.240 100 43 86 2 1976593488 12754256 12160560
17:32:38 12067 8192000000 10885052400 11314970624 1951124672 19.235 100 41 78 0 1974772976 12720928 10927376
17:33:01 6390 8192000000 10904591264 11321667584 1961767488 19.320 100 58 112 2 1990093472 12316736 16009248
17:33:26 31542 8192000000 10895387104 11333537792 1962597200 19.327 100 40 78 0 1987001024 13311360 11092464
17:34:04 4918 8192000000 10915981984 11341422592 1972661648 19.407 100 53 107 1 2003392640 15627424 15103568
17:34:26 12132 8192000000 10929089744 11357429760 1977771904 19.447 100 46 92 1 2013314368 20749936 14792528
17:34:47 6069 8192000000 10921529536 11357028352 1988149760 19.529 100 53 106 0 2020254688 16929216 15175712
17:35:02 5141 8192000000 10935483104 11367583744 1990336080 19.546 100 56 113 0 2029452432 22713552 16402800
17:35:17 4299 8192000000 10942941840 11366993920 1991554960 19.556 100 74 146 3 2033225408 18885680 22784768
17:35:28 22892 8192000000 10932315456 11360854016 1991111600 19.553 100 57 114 3 2028021600 19501808 17408192
17:36:01 15067 8192000000 10922572192 11367518208 1988744624 19.534 100 45 90 0 2022525920 20487536 13293760
17:36:25 13014 8192000000 10913123264 11357388800 1970558912 19.390 99 42 84 1 1998160112 14656656 12944544
17:36:50 18793 8192000000 10938277024 11371978752 1989919072 19.543 100 52 104 2 2021468720 16817072 14732576
17:37:17 6246 8192000000 10940459792 11374080000 1997461680 19.603 100 50 100 1 2032172704 20491792 14219232
17:37:32 4745 8192000000 10960426960 11386441728 2003167872 19.648 100 63 125 3 2042726944 20720544 18838528
17:37:47 2051 8192000000 10982015344 11396124672 2016163280 19.750 100 83 163 1 2062835584 22749760 23922544
17:37:57 2516 8192000000 10973371456 11399135232 2015723344 19.747 100 76 153 0 2061912672 24535312 21654016
17:38:06 4622 8192000000 10971922032 11393728512 2009308528 19.696 100 77 152 2 2056298720 24158144 22832048
17:38:19 4336 8192000000 10975329024 11395026944 2010986992 19.709 100 75 148 1 2057868928 24836688 22045248
17:38:31 17762 8192000000 10950178976 11383717888 1965974160 19.353 98 57 114 0 2012110240 29049072 17087008
17:38:56 7915 8192000000 10948858432 11379236864 1994580560 19.580 100 60 120 2 2038281328 26023040 17677728
17:39:15 4509 8192000000 10948645776 11378675712 1992159328 19.561 100 62 124 2 2038517312 27550816 18807168
17:39:27 9201 8192000000 10925938592 11356606464 1958063168 19.291 99 60 120 3 2005345984 28514352 18768464
17:39:44 3874 8192000000 10954070080 11377963008 1991249392 19.554 100 74 150 2 2043335376 29516240 22569744
17:40:04 11968 8192000000 10945159520 11375550464 1988170992 19.529 100 66 127 2 2037142112 29283248 19687872
17:40:24 5325 8192000000 10953250576 11385487360 1997239616 19.601 100 61 114 5 2044603536 29399552 17964368
17:40:43 8766 8192000000 10960125984 11385745408 1999913776 19.622 100 61 121 2 2047910544 29579568 18417200
17:41:01 2910 8192000000 10965423104 11391324160 2002809200 19.645 100 76 151 2 2056788576 30252816 23726560
17:41:11 5736 8192000000 10964950384 11394224128 2002249600 19.640 100 64 128 1 2053675408 30921408 20504400
17:41:27 7056 8192000000 10973742896 11405475840 2006778096 19.676 100 59 116 2 2057394032 31743024 18872912
17:41:45 13301 8192000000 10962077984 11399438336 1990521024 19.548 99 53 106 1 2041077488 33359728 17196736
17:42:10 5089 8192000000 10971581200 11405582336 1991311408 19.554 99 64 123 2 2046095712 33873392 20910912
17:42:25 3151 8192000000 10986779008 11413073920 2012035120 19.718 100 79 157 1 2071571760 33945568 25591072
17:42:36 1713 8192000000 10974511920 11396169728 1987738816 19.526 99 81 162 2 2048424336 35044688 25640832
17:42:45 3758 8192000000 10963441952 11383578624 1979570784 19.461 99 80 158 1 2038509600 34993424 23945392
17:42:57 1930 8192000000 10979111296 11395047424 1997234736 19.601 100 76 153 1 2056280384 36025920 23019728
17:43:06 7700 8192000000 10971435728 11394494464 1983132752 19.489 99 79 158 0 2045019200 38332432 23554016
17:43:21 3777 8192000000 10986589952 11402936320 1998746624 19.613 100 79 158 2 2061567648 39107760 23713264
17:43:33 3625 8192000000 10978025936 11393929216 1998729584 19.613 100 84 166 0 2060494416 36878688 24886144
17:43:44 4075 8192000000 10969512000 11383115776 1985094288 19.505 100 84 168 1 2047313840 36774336 25445216
17:43:58 7541 8192000000 10969724400 11381116928 1985466496 19.508 100 80 156 0 2046557728 38164672 22926560
17:44:13 2667 8192000000 10965180976 11383382016 1982194832 19.482 100 80 159 0 2045582128 39135728 24251568
17:44:22 3511 8192000000 10973852848 11387228160 1983924032 19.496 100 84 164 0 2050957248 42034672 24998544
17:44:33 8435 8192000000 10967180800 11389526016 1983783616 19.495 100 78 156 3 2051313808 43182976 24347216
17:44:51 2610 8192000000 10973302512 11393372160 1984609488 19.501 100 76 149 0 2053475792 44716928 24149376
17:45:05 3505 8192000000 10982334192 11399778304 1992084432 19.560 100 83 166 1 2064399504 46085696 26229376
17:45:16 3230 8192000000 10962431792 11379412992 1977697424 19.446 99 81 161 2 2045762544 42301200 25763920
17:45:28 3264 8192000000 10975526944 11396096000 1991104400 19.553 100 76 151 0 2058012528 43247248 23660880
17:45:41 2679 8192000000 10968583440 11383500800 1969100048 19.378 99 87 174 0 2039875776 43886368 26889360
17:45:51 2279 8192000000 10973721984 11382632448 1967679824 19.367 99 92 182 1 2039880768 44260768 27940176
17:46:00 3553 8192000000 10968408816 11380146176 1963076848 19.330 99 84 165 0 2035790768 46327952 26385968
17:46:14 4913 8192000000 10974143264 11388764160 1983118400 19.489 100 86 171 0 2056681568 46919472 26643696
17:46:25 2956 8192000000 10988642032 11396112384 1990572592 19.548 100 92 183 1 2067046080 48249728 28223760
17:46:35 4212 8192000000 10975122240 11392024576 1986966672 19.520 100 83 166 1 2061801216 47981936 26852608
17:46:48 1613 8192000000 10991157648 11400364032 1996401264 19.594 100 96 191 0 2075051536 48442928 30207344
17:46:56 3849 8192000000 10977771728 11391651840 1968101664 19.370 99 80 157 0 2042946080 49525584 25318832
17:47:08 7526 8192000000 10976801232 11392098304 1980064976 19.465 100 81 162 0 2055926480 49915504 25946000
17:47:23 3451 8192000000 11002877360 11414605824 1998561184 19.611 100 89 178 0 2079254784 52347360 28346240
17:47:33 3375 8192000000 11001014400 11417210880 2000440256 19.626 100 88 176 0 2087489344 59532192 27516896
17:47:44 1672 8192000000 11006720192 11424579584 2007926096 19.685 100 89 178 1 2089441984 53692208 27823680
17:47:52 1801 8192000000 11012051312 11423682560 2011277952 19.712 100 88 173 0 2090499216 52087568 27133696
17:48:02 7790 8192000000 10953771136 11395436544 1983831744 19.495 99 54 108 1 2047864080 46776128 17256208
17:48:17 3483 8192000000 10966975888 11396698112 1972790096 19.408 99 59 117 0 2036268144 44190400 19287648
17:48:29 18612 8192000000 10957714720 11395792896 1975544304 19.429 99 57 114 2 2043511040 48811984 19154752
17:49:06 10709 8192000000 10964991536 11407134720 1989334112 19.539 100 43 86 1 2051060016 47068224 14657680
17:49:25 5588 8192000000 10967505072 11408457728 1993426400 19.571 100 43 86 2 2053647376 45268224 14952752
17:49:41 2314 8192000000 10981503392 11415191552 1997153792 19.600 100 50 103 1 2061709664 47444320 17111552
17:49:56 7882 8192000000 10985889616 11422502912 1995878048 19.590 100 48 96 0 2061491712 50057312 15556352
17:50:11 6097 8192000000 10977501440 11416862720 1998855184 19.614 100 47 92 3 2063543840 49490320 15198336
17:50:30 3142 8192000000 10971404256 11424911360 2001728432 19.636 100 40 80 2 2059329296 43887936 13712928
17:50:49 18214 8192000000 10984814560 11425464320 2007638720 19.683 100 43 86 1 2068714144 46496512 14578912
17:51:22 13882 8192000000 10991163584 11432550400 2005499840 19.666 100 44 88 2 2070493376 49878352 15115184
17:52:01 15372 8192000000 10966318592 11415547904 1981438816 19.476 100 38 76 0 2050401728 55020640 13942272
17:52:27 31328 8192000000 10960341856 11412377600 1960207072 19.308 99 35 70 2 2021961376 49664880 12089424
17:53:32 16765 8192000000 10941482288 11395543040 1940768880 19.153 99 30 60 1 2008756656 56471696 11516080
17:54:24 24240 8192000000 10936658320 11388583936 1930701904 19.072 99 29 58 2 2006345184 64238352 11404928
17:54:54 12082 8192000000 10940143648 11387146240 1929992864 19.067 99 31 62 1 2013605168 71285040 12327264
17:56:01 29786 8192000000 10886260528 11350376448 1901127920 18.835 99 10 20 1 1943782448 39141232 3513296
17:57:36 82660 8192000000 10863138592 11315175424 1852271600 18.441 96 10 20 3 1870849440 15566048 3011792
17:59:05 70490 8192000000 10881703936 11327148032 1933502000 19.095 100 24 47 2 1961075200 21085136 6488064
18:00:31 92410 8192000000 10873409904 11336544256 1924055376 19.019 99 36 72 1 1948940608 15412144 9473088
18:02:46 126776 8192000000 10885108176 11349315584 1936491232 19.119 99 29 58 0 1958980384 13604160 8884992
18:04:59 20077 8192000000 10874031088 11331588096 1937018256 19.123 99 22 43 1 1954757696 11067792 6671648
18:05:27 83830 8192000000 10911588960 11361169408 1961300048 19.316 100 26 51 3 1982690352 13765648 7624656
18:06:58 42369 8192000000 10919605488 11365765120 1962336528 19.325 100 50 99 2 1995708720 18061776 15310416
18:07:47 36625 8192000000 10906438992 11376439296 1971223888 19.395 100 22 44 0 1995766256 17304176 7238192
18:08:35 40414 8192000000 10885432720 11356516352 1935660240 19.112 98 11 21 1 1948985296 10474656 2850400
18:09:42 66766 8192000000 10872116624 11343384576 1927683040 19.048 98 11 22 0 1942548304 11918080 2947184
18:11:03 50596 8192000000 10887783264 11363856384 1967008464 19.362 100 19 38 2 1986223168 13327248 5887456
18:12:02 55492 8192000000 10880645552 11360206848 1950290880 19.229 99 8 16 0 1964516672 11834400 2391392
18:13:36 76872 8192000000 10894677056 11370782720 1966140576 19.355 100 11 22 0 1977834336 8398336 3295424
18:15:09 50820 8192000000 10908495888 11379847168 1977961472 19.449 100 20 40 0 1999587792 15675248 5951072
18:16:07 13683 8192000000 10906324960 11377459200 1976020336 19.433 100 21 41 0 1994359744 12752912 5586496
18:16:30 37683 8192000000 10899669344 11372011520 1963122192 19.331 99 22 44 0 1984820160 15574624 6123344
18:17:18 75226 8192000000 10902002288 11394560000 1973156624 19.410 100 13 26 0 1993581120 16757408 3667088
18:18:49 51930 8192000000 10895541664 11400892416 1974483968 19.421 100 7 14 0 1994164448 18005712 1674768
18:19:54 50562 8192000000 10891132800 11372199936 1960047120 19.306 99 16 32 0 1972665904 8264736 4354048
18:20:56 55475 8192000000 10889514176 11365584896 1939588400 19.143 98 23 46 0 1953318592 7644672 6085520
18:23:00 71394 8192000000 10925627472 11389014016 1961662016 19.319 99 16 32 0 1980391984 13535168 5194800
18:24:26 41661 8192000000 10917237472 11392122880 1970064320 19.386 99 17 34 1 1990584256 15315328 5204608
18:25:21 51130 8192000000 10913628560 11385806848 1967201280 19.363 99 14 28 1 1983762752 12107840 4453632
18:26:21 145890 8192000000 10911303024 11390185472 1888139488 18.731 95 12 23 0 1904490064 13532320 2818256
18:29:55 66801 8192000000 10917112048 11368427520 1929950480 19.066 97 22 45 2 1951459504 15260048 6248976
18:31:08 13565 8192000000 10938496080 11389513728 1992844784 19.566 100 46 92 1 2016639248 10982336 12812128
18:31:31 19077 8192000000 10942066480 11395993600 1971453632 19.397 99 38 76 3 2002288096 20260080 10574384
18:31:58 59547 8192000000 10904050736 11386732544 1923435040 19.014 97 31 62 0 1950719184 18882000 8402144
18:33:43 76693 8192000000 10887589280 11365941248 1909528352 18.903 97 13 26 1 1925184560 12160800 3495408
18:35:10 74972 8192000000 10904101808 11369742336 1949284224 19.221 99 16 32 2 1969591792 15841232 4466336
18:37:22 89582 8192000000 10904830272 11338072064 1876556336 18.637 95 36 68 1 1894865120 8114048 10194736
18:38:59 61548 8192000000 10892771376 11342274560 1934277024 19.101 99 46 92 2 1959346624 12507984 12561616
18:40:07 50427 8192000000 10891443392 11344490496 1945384224 19.190 100 32 64 1 1965579072 10976496 9218352
18:41:13 17555 8192000000 10873888288 11335315456 1914928576 18.946 98 39 80 2 1932463664 6633424 10901664
18:41:38 37543 8192000000 10836403248 11311349760 1879540416 18.661 97 16 32 0 1892271648 8254720 4476512
18:42:22 66789 8192000000 10852071568 11312132096 1899669920 18.824 98 14 28 1 1913860896 10153008 4037968
18:43:41 49345 8192000000 10850728720 11315191808 1879726096 18.663 97 24 48 0 1902343088 15964128 6652864
18:44:51 55550 8192000000 10858982272 11337596928 1930354096 19.070 100 11 22 0 1948810864 15630736 2826032
18:45:53 81017 8192000000 10870050192 11336372224 1906936208 18.882 98 11 22 0 1922437312 12147360 3353744
18:47:20 65748 8192000000 10847594656 11321225216 1870484176 18.588 97 17 34 1 1891607248 16104096 5018976
18:48:35 70949 8192000000 10826720192 11307139072 1820430016 18.181 95 7 14 1 1842432848 20089632 1913200
18:49:52 50860 8192000000 10816111280 11286536192 1807085824 18.072 95 17 33 1 1824663056 12526384 5050848
18:50:59 69007 8192000000 10828319824 11272425472 1782170400 17.867 94 23 46 1 1797755152 8954432 6630320
18:52:15 55022 8192000000 10829591088 11289337856 1855931104 18.470 98 28 56 1 1881710048 16899264 8879680
18:53:19 73931 8192000000 10824998432 11284643840 1857852848 18.486 98 19 38 2 1879460048 15736064 5871136
18:54:39 42076 8192000000 10854263792 11310108672 1911521792 18.919 100 33 66 2 1930586752 9961056 9103904
18:55:28 34792 8192000000 10855287504 11318448128 1904279104 18.861 99 24 48 0 1923381504 12408848 6693552
18:57:04 49701 8192000000 10889365072 11340984320 1941011584 19.155 100 22 44 0 1963407744 15870544 6525616
18:58:02 32224 8192000000 10883386160 11336028160 1914123984 18.940 98 33 66 1 1934225904 11452464 8649456
18:58:40 26105 8192000000 10879791344 11337031680 1929267024 19.061 99 38 76 0 1954390256 14111728 11011504
18:59:18 44948 8192000000 10871165376 11333259264 1905937760 18.874 98 19 38 1 1922439680 11658512 4843408
19:00:09 70471 8192000000 10875154240 11343941632 1908458608 18.894 98 18 36 1 1922277456 9298160 4520688
19:01:27 151226 8192000000 10892036608 11372257280 1936938080 19.122 99 15 30 0 1952565824 11335184 4292560
19:04:04 50871 8192000000 10904011728 11344121856 1932696288 19.088 98 40 80 1 1953921792 9731744 11493760
19:05:06 76987 8192000000 10878253216 11358347264 1945984976 19.194 99 16 32 1 1961890240 11579680 4325584
19:06:33 26782 8192000000 10881765168 11363053568 1963142336 19.331 100 4 8 0 1976027024 11674112 1210576
19:07:39 51488 8192000000 10901277040 11380523008 1966719296 19.359 100 9 18 0 1982277072 13140720 2417056
19:08:36 22747 8192000000 10888540976 11376467968 1950262544 19.229 99 8 16 1 1967553632 15082416 2208672
19:10:02 77100 8192000000 10908550320 11379695616 1980997616 19.473 100 19 37 1 1993355424 7572224 4785584
19:11:31 20515 8192000000 10913368544 11366105088 1944798304 19.185 98 44 75 5 1961522016 5477232 11246480
19:11:58 29687 8192000000 10900038112 11367768064 1961369792 19.317 99 26 52 1 1976896336 8430368 7096176
19:12:40 75486 8192000000 10892945632 11373064192 1975138272 19.426 100 18 36 0 1988779744 8361392 5280080
19:14:57 76444 8192000000 10906343552 11393052672 1967899504 19.369 99 20 40 0 1987399952 13258512 6241936
19:16:20 46170 8192000000 10911046880 11395883008 1986801744 19.519 100 21 43 0 2003920480 11523920 5594816
19:17:56 48819 8192000000 10920907472 11392344064 1980957824 19.472 100 25 50 1 1999915472 11502880 7454768
19:19:09 63722 8192000000 10919787520 11389755392 1935091904 19.108 97 18 36 0 1954244752 13619760 5533088
19:21:09 88777 8192000000 10902982528 11380772864 1921401728 18.998 97 17 34 0 1945178144 18487408 5289008
19:22:52 75630 8192000000 10910201616 11377934336 1960948368 19.314 99 17 32 1 1977910640 12310320 4651952
19:24:17 15438 8192000000 10932748832 11385151488 1982627712 19.485 100 63 125 0 2013503008 13267184 17608112
19:24:38 28751 8192000000 10908165936 11374391296 1956589856 19.279 99 39 78 2 1979524240 11898000 11036384
19:25:20 59048 8192000000 10898110512 11339198464 1867194672 18.562 94 38 76 1 1886815056 9098400 10521984
19:26:29 34040 8192000000 10898254816 11372576768 1961260736 19.316 100 37 73 1 1983845760 12434784 10150240
19:27:10 29287 8192000000 9600431200 9931980800 739850880 8.283 38 1 2 0 747519408 7606400 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 31-03-2021 19:29:33 to 31-03-2021 19:30:05.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 136 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 31-03-2021 19:30:06 to 31-03-2021 19:30:07.

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          231519
MON$OLDEST_ACTIVE               231520
MON$OLDEST_SNAPSHOT             231520
MON$NEXT_TRANSACTION            231520
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                       2020352
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

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

Database validation

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

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

--- start of diff output ---
--- end of diff output ---

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

31.03.21 19:30:08. 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-31 19:30:11 No severe PSQL-related problems occured
31.03.21 19:30:12. End of report.