Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.03.2021 01: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 17630292 kB
MemAvailable 31556524 kB
Buffers 0 kB
Cached 14068800 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-21 01:27:21
DTS_END                         2021-03-21 01:27:21.4350
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/60626
TRN_ID                          237945
ATT_ID                          628
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: 8643.86 22521 1037263
customer order: creation 171.09 353 20531
customer order: refuse 14.73 363 1767
order to supplier: creation 45.08 1269 5409
order to supplier: removal 3.16 90505 379
invoice (draft): creation 45.55 3441 5466
invoice (draft): removal 48.22 704 5786
invoice accept: apply 40.39 18455 4847
invoice accept: cancel 44.12 812 5294
customer reserve: creation 3637.60 189 436512
customer reserve: removal 4306.48 52 516777
realization accept: apply 81.53 160 9783
realization accept: cancel 78.87 107 9464
payment from customer: creation 58.75 114 7050
payment from customer: removal 5.33 70 639
payment to supplier: creation 48.11 125 5773
payment to supplier: removal 3.43 82 412
service: total inventory turnovers 4.77 1095 572
service: total monetary turnovers 5.80 24 696
service: aggregate perf. data 0.85 17790 102
service: refresh index statistics 0.03 314718 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-03-2021 01:28:56 to 21-03-2021 01:28:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4500
TEST_TIME 2 5232
TEST_TIME 3 4487
TEST_TIME 4 5012
TEST_TIME 5 4890
TEST_TIME 6 5586
TEST_TIME 7 5701
TEST_TIME 8 5659
TEST_TIME 9 5939
TEST_TIME 10 5824
TEST_TIME 11 5989
TEST_TIME 12 6660
TEST_TIME 13 7075
TEST_TIME 14 7111
TEST_TIME 15 7359
TEST_TIME 16 7641
TEST_TIME 17 7781
TEST_TIME 18 8111
TEST_TIME 19 8587
TEST_TIME 20 8704
TEST_TIME 21 8695
TEST_TIME 22 9229
TEST_TIME 23 9286
TEST_TIME 24 9388
TEST_TIME 25 9429
TEST_TIME 26 9651
TEST_TIME 27 9390
TEST_TIME 28 9574
TEST_TIME 29 9791
TEST_TIME 30 9494
TEST_TIME 31 9913
TEST_TIME 32 9712
TEST_TIME 33 9500
TEST_TIME 34 9524
TEST_TIME 35 9326
TEST_TIME 36 9279
TEST_TIME 37 9191
TEST_TIME 38 9261
TEST_TIME 39 9121
TEST_TIME 40 8985
TEST_TIME 41 8931
TEST_TIME 42 9096
TEST_TIME 43 9023
TEST_TIME 44 8952
TEST_TIME 45 8914
TEST_TIME 46 8792
TEST_TIME 47 8674
TEST_TIME 48 8798
TEST_TIME 49 8705
TEST_TIME 50 8782
TEST_TIME 51 8772
TEST_TIME 52 8808
TEST_TIME 53 8902
TEST_TIME 54 8838
TEST_TIME 55 8883
TEST_TIME 56 8856
TEST_TIME 57 8841
TEST_TIME 58 8866
TEST_TIME 59 9007
TEST_TIME 60 9046
TEST_TIME 61 8956
TEST_TIME 62 9098
TEST_TIME 63 9135
TEST_TIME 64 9113
TEST_TIME 65 8989
TEST_TIME 66 8936
TEST_TIME 67 8884
TEST_TIME 68 8837
TEST_TIME 69 8818
TEST_TIME 70 8730
TEST_TIME 71 8649
TEST_TIME 72 8743
TEST_TIME 73 8779
TEST_TIME 74 8825
TEST_TIME 75 8823
TEST_TIME 76 8816
TEST_TIME 77 8823
TEST_TIME 78 8879
TEST_TIME 79 8914
TEST_TIME 80 8901
TEST_TIME 81 8907
TEST_TIME 82 8878
TEST_TIME 83 8939
TEST_TIME 84 8942
TEST_TIME 85 8960
TEST_TIME 86 8939
TEST_TIME 87 8839
TEST_TIME 88 8793
TEST_TIME 89 8867
TEST_TIME 90 8792
TEST_TIME 91 8732
TEST_TIME 92 8699
TEST_TIME 93 8655
TEST_TIME 94 8673
TEST_TIME 95 8753
TEST_TIME 96 8757
TEST_TIME 97 8770
TEST_TIME 98 8816
TEST_TIME 99 8773
TEST_TIME 100 8763
TEST_TIME 101 8823
TEST_TIME 102 8861
TEST_TIME 103 8815
TEST_TIME 104 8953
TEST_TIME 105 8930
TEST_TIME 106 8951
TEST_TIME 107 8936
TEST_TIME 108 8904
TEST_TIME 109 8841
TEST_TIME 110 8810
TEST_TIME 111 8800
TEST_TIME 112 8828
TEST_TIME 113 8792
TEST_TIME 114 8755
TEST_TIME 115 8745
TEST_TIME 116 8732
TEST_TIME 117 8724
TEST_TIME 118 8705
TEST_TIME 119 8678
TEST_TIME 120 8648

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-03-2021 01:28:59 to 21-03-2021 01:29:02.

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 1442467 1442467 0 0.00 0 21148 6 0 0
doc_list_biud 1442465 1442465 0 0.00 0 33608 24 0 0
sp_add_invoice_to_stock 4980 4847 133 2.67 28 181444 18455 0 133
sp_cancel_adding_invoice 5294 5294 0 0.00 5 67399 812 0 0
sp_cancel_client_order 1767 1767 0 0.00 4 13926 363 0 0
sp_cancel_customer_reserve 516777 516777 0 0.00 1 25995 52 0 0
sp_cancel_pay_from_customer 639 639 0 0.00 3 9260 70 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 5655 83 0 0
sp_cancel_supplier_invoice 5799 5786 13 0.22 2 30903 705 0 13
sp_cancel_supplier_order 379 379 0 0.00 5 697251 90506 0 0
sp_cancel_write_off 9464 9464 0 0.00 1 9828 107 0 0
sp_client_order 20531 20531 0 0.00 4 24601 353 0 0
sp_customer_reserve 436512 436512 0 0.00 0 70015 189 0 0
sp_fill_shopping_cart 31390 31390 0 0.00 1 17109 37 0 0
sp_fill_shopping_cart_clo_res 436503 436503 0 0.00 0 15917 14 0 0
sp_get_clo_for_invoice 4836 4836 0 0.00 0 24721 306 0 0
sp_kill_cost_storno 15809 15809 0 0.00 0 21109 54 0 0
sp_kill_qstorno_ret_qs2qd 1049183 1049183 0 0.00 0 30894 28 0 0
sp_kill_qty_storno 554085 554085 0 0.00 0 33600 62 0 0
sp_lock_selected_doc 20186 20186 0 0.00 0 6570 4 0 0
sp_make_cost_storno 27442 27442 0 0.00 0 20549 48 0 0
sp_multiply_rows_for_pdistr 27441 27441 0 0.00 0 10151 26 0 0
sp_multiply_rows_for_qdistr 20531 20531 0 0.00 0 20521 144 0 0
sp_pay_from_customer 7050 7050 0 0.00 4 15550 114 0 0
sp_pay_to_supplier 5773 5773 0 0.00 5 20558 126 0 0
sp_payment_common 12823 12823 0 0.00 1 9262 25 0 0
sp_qd_handle_on_cancel_clo 1767 1767 0 0.00 0 13915 327 0 0
sp_qd_handle_on_invoice_upd_sts 10130 10130 0 0.00 0 33593 335 0 0
sp_qd_handle_on_reserve_upd_sts 9782 9782 0 0.00 0 10281 58 0 0
sp_reserve_write_off 9783 9783 0 0.00 6 12739 161 0 0
sp_supplier_invoice 5466 5466 0 0.00 6 82654 3441 0 0
sp_supplier_order 5409 5409 0 0.00 5 20868 1270 0 0
srv_aggregate_perf_data 103 102 1 0.97 2852 245066 17790 0 1
srv_fill_mon_cache_memory 154 154 0 0.00 1670 158142 34665 0 0
srv_find_qd_qs_mism 991350 991350 0 0.00 0 20439 6 0 0
srv_make_invnt_saldo 572 572 0 0.00 40 77070 1096 0 0
srv_make_money_saldo 696 696 0 0.00 1 2175 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 104131 511431 314718 0 0
t$perf-abend:sp_add_invoice_to_stock 133 133 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 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 4847 4847 0 0.00 0 10707 149 0 0
t$perf-norm:sp_cancel_adding_invoice 394 394 0 0.00 0 2114 77 0 0
t$perf-norm:sp_cancel_client_order 1767 1767 0 0.00 0 9255 23 0 0
t$perf-norm:sp_cancel_customer_reserve 661 661 0 0.00 0 880 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 639 639 0 0.00 0 2175 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 526 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 381 381 0 0.00 0 601 8 0 0
t$perf-norm:sp_cancel_supplier_order 379 379 0 0.00 0 16064 1629 0 0
t$perf-norm:sp_cancel_write_off 943 943 0 0.00 0 7647 15 0 0
t$perf-norm:sp_client_order 20531 20531 0 0.00 0 5684 17 0 0
t$perf-norm:sp_customer_reserve 943 943 0 0.00 0 837 5 0 0
t$perf-norm:sp_pay_from_customer 7050 7050 0 0.00 0 7359 9 0 0
t$perf-norm:sp_pay_to_supplier 5773 5773 0 0.00 0 5466 14 0 0
t$perf-norm:sp_reserve_write_off 9783 9783 0 0.00 0 10301 12 0 0
t$perf-norm:sp_supplier_invoice 5466 5466 0 0.00 0 8299 19 0 0
t$perf-norm:sp_supplier_order 5409 5409 0 0.00 0 5998 18 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 1401 26 0 0
t$perf-norm:srv_fill_mon_cache_memory 154 154 0 0.00 0 830 11 0 0
t$perf-norm:srv_make_invnt_saldo 572 572 0 0.00 0 6651 40 0 0
t$perf-norm:srv_make_money_saldo 696 696 0 0.00 0 703 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 10 4 0 0
v_add_invoice_to_stock 9922 9656 266 2.68 0 6467 20 0 266
v_all_customers 37368 37368 0 0.00 0 35 1 0 0
v_all_suppliers 29812 29812 0 0.00 0 21 1 0 0
v_all_wares 41062 41062 0 0.00 0 53 1 0 0
v_cancel_adding_invoice 788 788 0 0.00 0 3587 10 0 0
v_cancel_client_order 3534 3534 0 0.00 0 9462 9 0 0
v_cancel_customer_prepayment 1278 1278 0 0.00 0 453 3 0 0
v_cancel_customer_reserve 1322 1322 0 0.00 0 3425 10 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 1626 7 0 0
v_cancel_supplier_invoice 788 762 26 3.29 0 3463 19 0 26
v_cancel_supplier_order 758 758 0 0.00 0 4833 14 0 0
v_cancel_write_off 1886 1886 0 0.00 0 2530 17 0 0
v_max_id_clo_ord 5405 5405 0 0.00 0 187 1 0 0
v_max_id_clo_res 943 943 0 0.00 0 7495 23 0 0
v_max_id_ord_sup 5453 5453 0 0.00 0 3683 5 0 0
v_max_non_paid_invoice 1725 1725 0 0.00 0 5642 5 0 0
v_max_non_paid_realizn 3808 3808 0 0.00 0 1905 4 0 0
v_min_id_clo_ord 5405 5405 0 0.00 0 9434 7 0 0
v_min_id_clo_res 943 943 0 0.00 0 2703 7 0 0
v_min_id_ord_sup 5453 5453 0 0.00 0 4896 9 0 0
v_min_non_paid_invoice 5773 5773 0 0.00 0 6045 12 0 0
v_min_non_paid_realizn 7050 7050 0 0.00 0 9258 17 0 0
v_our_firm 10178 10178 0 0.00 0 18 1 0 0
v_reserve_write_off 19564 19564 0 0.00 0 11100 7 0 0
x_lock_depdocs_on_canc_invoice 10699 10699 0 0.00 0 30266 110 0 0
x_lock_depdocs_on_canc_sup_ord 379 379 0 0.00 0 2839 304 0 0
x_make_qstorno_1000_1200 5409 5409 0 0.00 2 20859 1195 0 0
x_make_qstorno_1200_2000 5466 5466 0 0.00 3 71726 3309 0 0
x_make_qstorno_2100_3300 436511 436511 0 0.00 0 70009 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-03-2021 01:29:03 to 21-03-2021 01:29:07.

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
22:57:25 9 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:31 12699 8192000000 10209668544 10517164032 891770400 9.817 70 53 107 2 912319376 2384608 18164368
22:57:53 28286 8192000000 10337273888 10651365376 1369556592 14.323 100 82 164 0 1401471568 4408896 27506080
22:58:33 23220 8192000000 10368400400 10692476928 1428455744 14.848 100 92 184 2 1465355600 6362448 30537408
22:59:09 26605 8192000000 10405303488 10728218624 1459860784 15.125 100 91 181 0 1496270112 7086128 29323200
22:59:45 17063 8192000000 10425535888 10754490368 1485032448 15.345 100 91 182 0 1521806160 7955552 28818160
23:00:13 21689 8192000000 10452127472 10784772096 1503255216 15.505 100 87 174 1 1543886752 12804240 27827296
23:00:42 8851 8192000000 10468350912 10802003968 1523808832 15.683 100 93 186 0 1562979872 9190208 29980832
23:01:02 19387 8192000000 10479908400 10822590464 1527462224 15.715 100 83 166 0 1563134336 9382896 26289216
23:01:31 15129 8192000000 10505324752 10850504704 1558259328 15.981 100 82 164 0 1593569632 9428320 25881984
23:01:59 17886 8192000000 10539283728 10892013568 1597991072 16.322 100 89 178 1 1635624512 10587888 27045552
23:02:31 18992 8192000000 10577201056 10937724928 1637838496 16.661 100 85 169 1 1674016448 10852368 25325584
23:02:57 8317 8192000000 10586987552 10949058560 1649902656 16.764 100 77 154 1 1683597264 11090560 22604048
23:03:13 8777 8192000000 10619220144 10981314560 1671916000 16.949 100 84 169 0 1708827664 11821360 25090304
23:03:34 6421 8192000000 10622725008 10990739456 1684866640 17.058 100 79 158 1 1720863024 12667312 23329072
23:03:53 8918 8192000000 10634065104 11005009920 1692614336 17.123 100 77 153 1 1727700064 12930384 22155344
23:04:09 8408 8192000000 10643912912 11018326016 1709139472 17.262 100 82 165 0 1746258240 13189024 23929744
23:04:27 6336 8192000000 10668135664 11040378880 1728428816 17.422 100 78 155 3 1763385264 12983824 21972624
23:04:40 7921 8192000000 10673644032 11051524096 1737916816 17.501 100 78 157 0 1773478576 13198928 22362832
23:04:55 4211 8192000000 10681187728 11060080640 1748070976 17.586 100 74 146 0 1782378656 12996432 21311248
23:05:07 5475 8192000000 10684708720 11069341696 1758610640 17.673 100 73 146 1 1792858288 13938464 20309184
23:05:19 4861 8192000000 10703013808 11086798848 1769451264 17.762 100 79 158 2 1805225184 13284848 22489072
23:05:31 4259 8192000000 10716504480 11097976832 1781413424 17.861 100 75 151 2 1815254368 12654560 21186384
23:05:44 8747 8192000000 10720591792 11107241984 1788661424 17.921 100 74 146 1 1822212816 13350000 20201392
23:06:00 4117 8192000000 10744880864 11127271424 1798769360 18.004 100 84 169 3 1835458400 13239664 23449376
23:06:10 2693 8192000000 10742052704 11132141568 1808915440 18.087 100 73 147 2 1841923824 11813312 21195072
23:06:20 3627 8192000000 10745979120 11140509696 1821785488 18.192 100 75 150 2 1855425120 10955152 22684480
23:06:30 3283 8192000000 10771539952 11155718144 1830777408 18.266 100 80 160 1 1865776288 12488560 22510320
23:06:39 3546 8192000000 10777162784 11165790208 1837163872 18.318 100 79 158 2 1872453472 12519024 22770576
23:06:49 3455 8192000000 10792800528 11178622976 1842495328 18.361 100 89 178 3 1882574336 15018432 25060576
23:06:59 2683 8192000000 10793257600 11180425216 1852135696 18.439 100 93 186 0 1893478560 14950688 26392176
23:07:08 1733 8192000000 10800245728 11186921472 1852833840 18.445 100 92 180 0 1892215232 14186448 25194944
23:07:17 2017 8192000000 10799662000 11185643520 1856309328 18.473 100 81 163 1 1893327104 13333920 23683856
23:07:25 1628 8192000000 10795774304 11191795712 1859111248 18.496 100 87 172 1 1896365456 12763952 24490256
23:07:34 1319 8192000000 10809430192 11195977728 1862622304 18.525 100 89 176 1 1901445872 13637600 25185968
23:07:41 3204 8192000000 10798807184 11196743680 1861475040 18.515 100 76 150 0 1896905168 14566736 20863392
23:07:51 4810 8192000000 10802797552 11194560512 1863579472 18.532 100 82 164 2 1900842304 12909248 24353584
23:08:02 4405 8192000000 10801595728 11192385536 1864498016 18.540 100 82 164 0 1900251536 12781488 22972032
23:08:13 17800 8192000000 10763731648 11189805056 1859235536 18.497 100 41 82 1 1880272256 9663920 11372800
23:08:37 6300 8192000000 10781223920 11194683392 1863297296 18.530 100 48 98 1 1884788656 7927600 13563760
23:08:50 11561 8192000000 10781086368 11198988288 1863893936 18.535 100 26 50 1 1878723792 8028464 6801392
23:09:09 5981 8192000000 10793057408 11207241728 1872873280 18.608 100 35 70 0 1890837552 7503856 10460416
23:09:22 15348 8192000000 10777727584 11202658304 1868104608 18.569 100 14 28 0 1878743072 6364848 4273616
23:09:43 8040 8192000000 10784758784 11208081408 1871976816 18.600 100 16 32 0 1882402896 6141824 4284256
23:09:58 5270 8192000000 10787969872 11209109504 1877948768 18.649 100 34 69 0 1894638880 7354000 9336112
23:10:10 4733 8192000000 10785858544 11214303232 1878936208 18.657 100 27 54 0 1893561952 7239632 7386112
23:10:29 13161 8192000000 10785930432 11214327808 1875872624 18.632 100 9 18 0 1888301552 10062624 2366304
23:10:51 9182 8192000000 10785546032 11216793600 1877524944 18.645 100 17 34 0 1887624672 5136432 4963296
23:11:08 21971 8192000000 10797027520 11225128960 1880847456 18.672 100 25 50 2 1894320080 6501552 6971072
23:12:05 28227 8192000000 10804804192 11234660352 1885208800 18.707 100 28 56 3 1898335600 5506192 7620608
23:12:40 7329 8192000000 10803416544 11236548608 1893569088 18.775 100 31 62 3 1909542496 7265040 8708368
23:12:53 6877 8192000000 10820490992 11243139072 1894783888 18.784 100 32 64 1 1911054784 7022240 9248656
23:13:08 3695 8192000000 10817224640 11246592000 1900078816 18.827 100 31 62 0 1915132128 6814480 8238832
23:13:19 5169 8192000000 10817224864 11248447488 1901914800 18.842 100 44 86 3 1922023504 7116368 12992336
23:13:32 4375 8192000000 10822460128 11249975296 1904147728 18.860 100 41 82 0 1922803520 7013168 11642624
23:13:44 2877 8192000000 10824928624 11255013376 1903583728 18.855 100 37 74 1 1921593104 7584176 10425200
23:13:56 9374 8192000000 10819406144 11256987648 1900718400 18.832 100 15 30 1 1910635744 6100960 3816384
23:14:11 5676 8192000000 10813834080 11251384320 1905271808 18.869 100 20 40 3 1916825712 5786096 5767808
23:14:23 6883 8192000000 10825779184 11254120448 1904179840 18.860 100 24 48 0 1917540032 6114192 7246000
23:14:38 8327 8192000000 10816197280 11252203520 1903369728 18.853 100 14 28 1 1912698176 5632784 3695664
23:14:53 8369 8192000000 10830626032 11258974208 1907827616 18.889 100 17 34 0 1917144704 5267536 4049552
23:15:07 8246 8192000000 10815139424 11259838464 1908157872 18.892 100 24 47 2 1925580912 10890800 6532240
23:15:21 10748 8192000000 10816100624 11257274368 1893644368 18.775 99 30 60 0 1909557824 6514320 9399136
23:15:39 11905 8192000000 10822624448 11255517184 1903055504 18.851 100 18 34 1 1913646928 6054384 4537040
23:15:57 47423 8192000000 10785940752 11211104256 1830789568 18.266 96 36 72 2 1845766688 4476352 10500768
23:16:50 19222 8192000000 10788594288 11217371136 1834081856 18.293 97 32 63 2 1849138800 6045664 9011280
23:17:16 6148 8192000000 10793345456 11231096832 1881062832 18.674 100 19 38 1 1892930752 6749248 5118672
23:17:32 9567 8192000000 10783247008 11221733376 1861590928 18.516 99 14 28 0 1871048192 5766832 3690432
23:17:51 8657 8192000000 10788666448 11221282816 1863923456 18.535 99 23 45 3 1875789744 5489888 6376400
23:18:06 7455 8192000000 10752285376 11173576704 1773334240 17.795 95 21 42 2 1784805184 5827456 5643488
23:18:21 4615 8192000000 10755552448 11173515264 1814424352 18.132 99 25 49 2 1831917824 10714992 6778480
23:18:32 8040 8192000000 10744977296 11175092224 1824333984 18.213 99 19 38 0 1836113248 6226432 5552832
23:18:50 6525 8192000000 10739415184 11164594176 1797829504 17.996 98 16 32 0 1807616512 5254528 4532480
23:19:04 6316 8192000000 10716137488 11138703360 1747316688 17.579 96 13 26 1 1755841264 5187008 3337568
23:19:16 9340 8192000000 10725337632 11147763712 1770237632 17.769 97 19 38 0 1782022416 5870112 5914672
23:19:32 10306 8192000000 10680394928 11095994368 1646973456 16.739 91 19 38 2 1657778320 4754112 6050752
23:19:51 10843 8192000000 10684944528 11113029632 1753009568 17.627 98 23 46 3 1766138816 6402736 6726512
23:20:09 11059 8192000000 10676239776 11083624448 1680823200 17.024 95 14 27 2 1690114384 5192336 4098848
23:20:28 51778 8192000000 10686343520 11085512704 1628075744 16.579 92 25 50 1 1640214832 4209536 7929552
23:21:35 20517 8192000000 10670031248 11081146368 1689428240 17.097 95 25 50 0 1702466224 6413360 6624624
23:22:06 4556 8192000000 10696043088 11094765568 1750052112 17.602 98 34 68 3 1765656064 6246688 9357264
23:22:17 7047 8192000000 10726808528 11135528960 1800236016 18.016 100 37 76 0 1816742896 5654640 10852240
23:22:34 6552 8192000000 10717959952 11142529024 1805272576 18.057 100 15 30 1 1814868512 5066480 4529456
23:22:49 8042 8192000000 10739125600 11162460160 1822315600 18.197 100 28 56 1 1837090304 7120064 7654640
23:23:04 5737 8192000000 10748264768 11166449664 1825892432 18.226 100 25 49 2 1840249440 6443792 7913216
23:23:18 6011 8192000000 10736968240 11157118976 1808332112 18.082 99 27 54 2 1821411872 5416896 7662864
23:23:31 7161 8192000000 10739081824 11161616384 1825534304 18.223 100 23 47 1 1837813680 5638816 6640560
23:23:47 13089 8192000000 10757464416 11178864640 1839257040 18.335 100 30 58 1 1854703984 6619792 8827152
23:24:07 6856 8192000000 10758441472 11179859968 1837703728 18.322 100 18 36 2 1848285728 5565680 5016320
23:24:20 7637 8192000000 10759476352 11182444544 1841580560 18.354 100 21 40 2 1852265104 4875536 5809008
23:24:34 10292 8192000000 10756300768 11189153792 1846489920 18.394 100 21 42 0 1858194928 5511984 6193024
23:24:50 15433 8192000000 10777617616 11201781760 1853416800 18.450 100 18 36 1 1863688064 5205472 5065792
23:25:15 60585 8192000000 10794098544 11208781824 1860934192 18.511 100 21 42 3 1871862688 4729456 6199040
23:26:25 18197 8192000000 10773226336 11201761280 1863051616 18.528 100 17 33 1 1872998368 5338592 4608160
23:26:50 8004 8192000000 10784979744 11211243520 1868990288 18.576 100 37 74 1 1886900976 8186544 9724144
23:27:05 2841 8192000000 10805374832 11225452544 1881421648 18.677 100 44 88 2 1901224960 7657584 12145728
23:27:15 4486 8192000000 10806972432 11231383552 1889678592 18.743 100 29 59 1 1902639136 4680000 8280544
23:27:30 20777 8192000000 10836723392 11254071296 1903000896 18.850 100 46 93 1 1922874720 7094896 12778928
23:28:13 14993 8192000000 10844648832 11264376832 1914480656 18.943 100 42 84 1 1935200144 8905936 11813552
23:28:36 5517 8192000000 10857045488 11272847360 1921397280 18.998 100 57 113 3 1946328112 8317952 16612880
23:28:51 19984 8192000000 10846380752 11273785344 1927101920 19.044 100 46 92 2 1950460704 9538720 13820064
23:29:18 27812 8192000000 10861526880 11284566016 1933734160 19.097 100 43 86 2 1954892672 8429056 12729456
23:29:55 17069 8192000000 10871839984 11292471296 1940459936 19.150 100 55 109 3 1966444512 9285152 16699424
23:30:33 20615 8192000000 10882025408 11306196992 1946344480 19.197 100 46 90 2 1972494416 12071696 14078240
23:31:02 5297 8192000000 10885676880 11309641728 1950764272 19.233 100 45 90 1 1975147584 10666544 13716768
23:31:23 5804 8192000000 10882974240 11311017984 1953599952 19.255 100 48 91 4 1978441680 11208352 13633376
23:31:35 5318 8192000000 10894782640 11318210560 1957402816 19.285 100 52 103 2 1984105280 11834576 14867888
23:31:47 23415 8192000000 10889597072 11325632512 1960837792 19.313 100 49 98 5 1992786368 16987360 14961216
23:32:23 41311 8192000000 10901708176 11333431296 1958675040 19.296 100 35 70 3 1983891984 14358800 10858144
23:33:22 16832 8192000000 10901165824 11340492800 1966996096 19.362 100 34 68 0 1990865584 13598160 10271328
23:33:50 11210 8192000000 10906727936 11344920576 1974732688 19.423 100 46 92 0 2001634576 13510288 13391600
23:34:08 7918 8192000000 10915921888 11351891968 1979882880 19.464 100 50 99 1 2007492144 13029328 14579936
23:34:24 12533 8192000000 10909531968 11347767296 1979986960 19.465 100 46 91 0 2008927136 14966384 13973792
23:34:46 21106 8192000000 10923779888 11357368320 1985238976 19.506 100 55 110 0 2018968368 17874240 15855152
23:35:14 20614 8192000000 10922721776 11356106752 1970175504 19.387 99 56 112 0 2002447392 15422144 16849744
23:35:43 9625 8192000000 10929497744 11359227904 1987551632 19.524 100 53 106 0 2018253248 14785424 15916192
23:36:00 13750 8192000000 10936828288 11363946496 1990434880 19.547 100 65 130 2 2026757440 16775280 19547280
23:36:25 8217 8192000000 10933556544 11365158912 1975882960 19.432 99 59 115 2 2007812128 15077776 16851392
23:36:41 2549 8192000000 10934531696 11358498816 1984528640 19.501 100 67 132 2 2018416208 14479904 19407664
23:36:51 8651 8192000000 10939950880 11369844736 1989683808 19.541 100 62 124 3 2027586016 19684016 18218192
23:37:06 11738 8192000000 10934141744 11368960000 1995208976 19.585 100 59 117 3 2030445072 17684496 17551600
23:37:29 8073 8192000000 10940850720 11362279424 1988504672 19.532 100 59 119 0 2025128416 18440640 18183104
23:37:44 13916 8192000000 10941707872 11373740032 1989799600 19.542 100 54 106 1 2025687488 19704032 16183856
23:38:19 11818 8192000000 10941371680 11385413632 1999932880 19.622 100 58 116 2 2041656576 23302576 18421120
23:38:42 12260 8192000000 10929321264 11361259520 1948579360 19.215 98 46 92 2 1985639680 22434816 14625504
23:39:02 6890 8192000000 10940478192 11371970560 1965462896 19.349 99 58 116 1 2006742048 23692736 17586416
23:39:16 4211 8192000000 10957951312 11376521216 1994965008 19.583 100 86 171 1 2042401264 21988704 25447552
23:39:27 3444 8192000000 10956097280 11378688000 1995505792 19.587 100 83 167 1 2044797216 23773040 25518384
23:39:38 7883 8192000000 10947897408 11380027392 1997855536 19.606 100 64 128 1 2038087104 21284144 18947424
23:39:54 4789 8192000000 10943466960 11376709632 1977898896 19.448 99 61 120 2 2017316592 21439904 17977792
23:40:07 3555 8192000000 10940304192 11352768512 1958341936 19.293 98 88 178 5 2003797296 18951648 26503712
23:40:21 8751 8192000000 10909176096 11333242880 1937330288 19.125 98 70 139 4 1978010608 20688368 19991952
23:40:46 4786 8192000000 10910114624 11333054464 1952075472 19.243 99 61 121 0 1992133296 21009264 19048560
23:40:58 11015 8192000000 10924307968 11362181120 1969530736 19.382 100 52 103 1 2008838048 23731712 15575600
23:41:16 7603 8192000000 10916858256 11347574784 1959502128 19.302 99 57 114 2 1999592880 23009568 17081184
23:41:31 5074 8192000000 10933775920 11367038976 1977941312 19.448 100 53 105 1 2016544144 23057536 15545296
23:41:46 7281 8192000000 10916620864 11344306176 1947867760 19.209 98 57 113 0 1986896656 22307808 16721088
23:42:03 8125 8192000000 10944158544 11374350336 1985845856 19.511 100 64 128 1 2032380704 27937968 18596880
23:42:19 2643 8192000000 10942054672 11362979840 1975839616 19.432 100 74 146 4 2022631072 24853792 21937664
23:42:29 1970 8192000000 10943178992 11367690240 1968939088 19.377 99 83 166 0 2018293344 24985264 24368992
23:42:38 1666 8192000000 10956071888 11367723008 1980736672 19.471 100 91 182 1 2033366032 25768976 26860384
23:42:46 1935 8192000000 10944818352 11361591296 1965479600 19.350 99 85 170 1 2016930864 26335616 25115648
23:42:56 2586 8192000000 10961596432 11375276032 1985902064 19.511 100 84 167 0 2040481120 29671696 24907360
23:43:05 4775 8192000000 10943142064 11379355648 1984945264 19.504 100 57 114 0 2033379648 31142480 17291904
23:43:24 7125 8192000000 10936100272 11380056064 1982234992 19.482 100 38 76 1 2024360320 29677872 12447456
23:43:38 5836 8192000000 10934460592 11365281792 1971883696 19.400 100 57 112 1 2018820320 28211600 18725024
23:43:55 5703 8192000000 10882397568 11316981760 1918645520 18.976 99 59 118 1 1965024128 28549808 17828800
23:44:08 5509 8192000000 10877484496 11310211072 1913060256 18.931 99 56 111 1 1955535936 25830944 16644736
23:44:25 9056 8192000000 10883550176 11299364864 1875251152 18.627 97 58 117 5 1920940688 27104192 18585344
23:44:45 1784 8192000000 10866593648 11298349056 1901523760 18.839 99 56 112 1 1946768672 28039248 17205664
23:44:59 6802 8192000000 10892269376 11325755392 1936307952 19.117 100 49 98 0 1982585248 30637376 15639920
23:45:17 7011 8192000000 10888302112 11320373248 1927759056 19.049 100 60 116 2 1977571984 30252592 19560336
23:45:32 4262 8192000000 10914723792 11340840960 1945477232 19.190 100 64 128 0 2000584384 34169088 20938064
23:45:46 8668 8192000000 10894354384 11337375744 1944501680 19.183 100 45 89 1 1992575296 33894672 14178944
23:46:02 4601 8192000000 10858971152 11298631680 1904045552 18.859 99 35 70 2 1945885840 30368240 11472048
23:46:15 8785 8192000000 10887734560 11324452864 1928927712 19.058 100 49 98 2 1974855376 30248752 15678912
23:46:31 20157 8192000000 10863968288 11314081792 1920621280 18.992 99 35 70 0 1964591520 32252448 11717792
23:47:13 8146 8192000000 10890533728 11326910464 1933212432 19.093 100 31 62 1 1971871232 29103792 9555008
23:47:28 16261 8192000000 10858370864 11313684480 1902591152 18.847 99 22 45 0 1938279504 28475216 7213136
23:47:51 15143 8192000000 10868058080 11313369088 1918701696 18.976 100 32 64 0 1958247008 28661680 10883632
23:48:13 13145 8192000000 10859828800 11305799680 1889091248 18.738 98 35 70 1 1930882704 30628736 11162720
23:48:33 7355 8192000000 10874364336 11304210432 1891257632 18.756 98 52 102 4 1939093280 31614400 16221248
23:48:52 2311 8192000000 10843125088 11260145664 1849993392 18.422 97 62 122 2 1903423984 34786304 18644288
23:49:01 11036 8192000000 10868513952 11307565056 1882568288 18.686 99 37 74 2 1939053088 44367264 12117536
23:49:27 16952 8192000000 10844678240 11292459008 1875072544 18.625 99 21 42 1 1915383808 33648176 6663088
23:49:54 23327 8192000000 10846696224 11295002624 1882219376 18.683 99 26 52 2 1921863280 31422480 8221424
23:50:34 20389 8192000000 10844818400 11296468992 1886506224 18.718 99 20 40 1 1924307904 31377424 6424256
23:51:02 27374 8192000000 10867585248 11311067136 1910135424 18.908 100 24 48 0 1951691680 33712288 7843968
23:51:56 11908 8192000000 10872647520 11317182464 1921111632 18.996 100 23 46 1 1961094752 32970512 7012608
23:52:44 19382 8192000000 10909124704 11351748608 1934420192 19.102 100 28 56 1 1979552096 35676240 9455664
23:53:11 24270 8192000000 10895788640 11351863296 1937244512 19.125 100 18 34 0 1979999840 35797088 6958240
23:53:41 27785 8192000000 10906468480 11350609920 1945719008 19.192 100 31 62 1 1989197568 34017808 9460752
23:54:22 36751 8192000000 10912945088 11355664384 1944367200 19.182 100 32 64 2 1990193840 35320112 10506528
23:55:42 40298 8192000000 10862475488 11334623232 1901546624 18.839 98 15 30 0 1935827536 29551760 4729152
23:56:35 58029 8192000000 10868889728 11320815616 1923722464 19.017 100 20 40 2 1949803376 20042848 6038064
23:57:40 27524 8192000000 10870165792 11311538176 1897654032 18.807 98 50 93 0 1933450688 22543856 13252800
23:58:25 14691 8192000000 10868719456 11317530624 1929530992 19.063 100 23 46 1 1959809664 23692688 6585984
23:58:49 22446 8192000000 10868267216 11326033920 1920290752 18.989 99 16 33 1 1938726960 14130800 4305408
23:59:19 64226 8192000000 10874162608 11319435264 1918032496 18.971 98 42 81 0 1938045472 9094976 10918000
00:00:31 94438 8192000000 10861433280 11321868288 1889118304 18.739 97 51 100 2 1914967840 11101696 14747840
00:02:24 78628 8192000000 10877418640 11347775488 1948967600 19.218 100 14 28 0 1966850368 14083216 3799552
00:04:21 50536 8192000000 10889558304 11359338496 1966455824 19.357 100 23 44 4 1990946592 16831936 7658832
00:05:26 80233 8192000000 10883642016 11350941696 1927592960 19.048 98 16 32 0 1952200880 20377472 4230448
00:06:53 18146 8192000000 10899546720 11346165760 1959111840 19.299 100 29 58 0 1985449952 18002448 8335664
00:07:17 30002 8192000000 10901389328 11340845056 1963262704 19.332 100 67 127 1 1994977696 13170720 18544272
00:07:57 43028 8192000000 10888955936 11340992512 1958108272 19.291 100 25 51 0 1979123088 13717216 7297600
00:09:42 58597 8192000000 10893040000 11349827584 1964864624 19.345 100 11 22 1 1975274880 7416064 2994192
00:10:52 41311 8192000000 10868899200 11335331840 1952667024 19.248 99 19 38 0 1964673056 6819552 5186480
00:11:40 39377 8192000000 10887410464 11356991488 1973306224 19.412 100 21 42 1 1988402976 9201728 5895024
00:12:50 83311 8192000000 10904675248 11382493184 1986816560 19.519 100 15 30 1 2007481904 16033440 4631904
00:14:52 69783 8192000000 10893673040 11373326336 1965571568 19.350 99 12 24 1 1985176768 16032800 3572400
00:16:07 59438 8192000000 10898913584 11375083520 1962047200 19.322 99 8 16 1 1975129328 10756176 2325952
00:17:16 34477 8192000000 10889294848 11366957056 1945028832 19.187 98 10 20 1 1962255216 14617184 2609200
00:18:07 26294 8192000000 10900552192 11368398848 1966787904 19.360 99 25 50 0 1981749616 7783808 7177904
00:18:44 69220 8192000000 10903569568 11380199424 1945343424 19.189 98 15 30 1 1958988080 9414720 4229936
00:19:59 63404 8192000000 10884161904 11361038336 1945049168 19.187 98 25 50 1 1962838992 10466032 7323792
00:21:09 27648 8192000000 10904003376 11362865152 1957559984 19.287 99 19 38 0 1970773312 7892736 5320592
00:21:43 30366 8192000000 10926633024 11380613120 1986714512 19.518 100 38 76 1 2006558768 9563552 10280704
00:22:20 48123 8192000000 10878468208 11342675968 1904520944 18.863 96 26 52 0 1921819552 10148896 7149712
00:23:25 36970 8192000000 10913377888 11358834688 1936828064 19.121 98 40 80 2 1958310128 10285424 11196640
00:24:10 24675 8192000000 10910511088 11361669120 1955333888 19.269 99 41 82 0 1979885584 12803344 11748352
00:24:41 46088 8192000000 10898751760 11365146624 1969880128 19.384 100 31 62 0 1991664656 13300528 8484000
00:25:39 15727 8192000000 10924298704 11367104512 1966906800 19.361 99 56 112 2 1994311952 12457440 14947712
00:26:08 60506 8192000000 10895042368 11371622400 1946455200 19.198 98 26 52 0 1970667136 17088544 7123392
00:27:20 48994 8192000000 10886905696 11333902336 1862666848 18.525 94 31 60 5 1878856240 7064880 9124512
00:28:16 30096 8192000000 10894417792 11335942144 1892179600 18.763 96 35 68 1 1912111136 10809952 9121584
00:28:55 95260 8192000000 10865793232 11343597568 1853951328 18.454 95 15 30 1 1874200000 16304864 3943808
00:30:36 158142 8192000000 10841488624 11303636992 1778733072 17.839 91 15 30 0 1795898288 13462960 3702256
00:33:21 43926 8192000000 10844867520 11306491904 1891518112 18.758 98 30 60 3 1909262128 9539104 8204912
00:34:11 37024 8192000000 10838815472 11305951232 1905912432 18.874 99 12 24 0 1921969936 12839760 3217744
00:34:54 36947 8192000000 10817555776 11282165760 1864980784 18.544 97 11 21 0 1880188480 12768592 2439104
00:35:56 37287 8192000000 10826945088 11301179392 1901662816 18.840 99 7 14 0 1913329168 9225184 2441168
00:36:40 25956 8192000000 10823613936 11292561408 1898675632 18.816 99 13 26 2 1915791024 13888304 3227088
00:37:12 47494 8192000000 10833897952 11296247808 1881351424 18.676 98 12 24 0 1895360016 10617024 3391568
00:38:11 81477 8192000000 10821174320 11280809984 1856084384 18.472 96 14 28 0 1873226176 12785456 4356336
00:39:38 57328 8192000000 10832923584 11309023232 1890227856 18.748 99 9 18 0 1906300128 13518192 2554080
00:40:47 96217 8192000000 10857299728 11298226176 1879073872 18.658 98 20 40 1 1907354512 22101328 6179312
00:42:40 115537 8192000000 10872685664 11340640256 1906043200 18.875 98 19 38 0 1926075888 14658704 5373984
00:44:41 53916 8192000000 10863308576 11326595072 1900455040 18.830 98 25 50 2 1926156128 18474944 7226144
00:45:43 68363 8192000000 10856745904 11319975936 1893261312 18.772 98 20 40 0 1917231424 17940736 6029376
00:46:59 38495 8192000000 10875604336 11324297216 1904590816 18.863 98 35 68 1 1924629648 10949936 9088896
00:47:46 42586 8192000000 10879249584 11330834432 1919963808 18.987 99 29 57 1 1938375728 10740080 7671840
00:48:58 39968 8192000000 10888320720 11335815168 1931944128 19.082 99 38 76 1 1954278736 11887696 10446912
00:49:45 14055 8192000000 10893714832 11339378688 1939405472 19.142 99 51 102 1 1967066752 12619904 15041376
00:50:07 35286 8192000000 10902112064 11356909568 1955712672 19.272 100 40 80 0 1982307568 15523440 11071456
00:50:52 102544 8192000000 10893358768 11374030848 1940290256 19.149 99 14 28 1 1958756016 14643632 3822128
00:54:12 103787 8192000000 10895665040 11362476032 1922039840 19.003 97 29 58 0 1942080528 11858816 8181872
00:56:02 26051 8192000000 10881273248 11364925440 1962672288 19.327 100 12 24 1 1977704448 11626000 3406160
00:56:51 92090 8192000000 10869479600 11350695936 1928102464 19.052 98 5 10 0 1938086784 8831712 1152608
00:58:33 71404 8192000000 10899636048 11367854080 1933814992 19.097 98 15 30 2 1946524800 9000672 3709136
00:59:55 51071 8192000000 10908194944 11386941440 1984421088 19.500 100 11 22 0 1996824736 9339824 3063824
01:00:52 78459 8192000000 10905514224 11390083072 1974684480 19.423 99 19 38 2 1994235696 13974464 5576752
01:02:43 120592 8192000000 10895153744 11374366720 1867501936 18.564 94 12 24 0 1885681696 15456192 2723568
01:04:52 51913 8192000000 10907103424 11387023360 1971496256 19.397 100 14 28 0 1991597248 16274240 3826752
01:05:55 32593 8192000000 10912379856 11367116800 1963929616 19.337 99 35 70 3 1981811824 7821408 10060800
01:06:36 35620 8192000000 10924301568 11376832512 1968917712 19.377 99 33 66 1 1988044800 9114736 10012352
01:07:22 44332 8192000000 10924482032 11381587968 1969958736 19.385 99 36 73 0 1993254704 13141520 10154448
01:08:18 131317 8192000000 10910346880 11375865856 1922093008 19.004 97 15 30 0 1938505040 12563552 3848480
01:10:36 61855 8192000000 10916142784 11397681152 1968456256 19.373 99 44 86 1 1997802464 17063888 12282320
01:11:48 85612 8192000000 10905660976 11362775040 1919040816 18.979 97 20 40 1 1936286272 11972768 5272688
01:13:22 50181 8192000000 10911608208 11389325312 1974330704 19.420 100 27 54 1 1991496112 9452032 7713376
01:14:18 106292 8192000000 10893417488 11365416960 1919471408 18.983 97 14 29 0 1932449728 9609664 3368656
01:16:47 120328 8192000000 10905776928 11382697984 1944363168 19.182 98 30 60 1 1968321760 15439520 8519072
01:19:04 46748 8192000000 10862635008 11332722688 1863136560 18.529 95 24 48 1 1879179200 9142480 6900160
01:19:59 29256 8192000000 10848740352 11317174272 1925100384 19.028 99 17 34 1 1940049104 9933312 5015408
01:20:34 45578 8192000000 10859145424 11335806976 1919392848 18.982 99 8 16 1 1935044896 13477424 2174624
01:21:26 54799 8192000000 10859427328 11332546560 1908529264 18.895 98 10 20 1 1921659600 10417264 2713072
01:22:27 42592 8192000000 10852347536 11324481536 1900932880 18.834 98 10 19 2 1915233136 11593984 2706272
01:23:22 51936 8192000000 10858879536 11331604480 1934363424 19.102 100 9 18 1 1945631920 8799040 2469456
01:24:30 80659 8192000000 10856615872 11335520256 1886057520 18.714 97 14 28 0 1900350000 10737520 3554960
01:26:08 84148 8192000000 9808786416 10167091200 919017840 10.086 47 16 30 1 930650992 7118800 4514352

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 21-03-2021 01:29:09 to 21-03-2021 01:29:40.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 133 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-03-2021 01:29:41 to 21-03-2021 01:29:43.

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          237622
MON$OLDEST_ACTIVE               238214
MON$OLDEST_SNAPSHOT             238214
MON$NEXT_TRANSACTION            238214
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                       2007808
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:89: 
:90: mscs-test-161.budzdorov.ru    Sun Mar 21 01:27:36 2021
:91:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:92: 
:93: 
:94: mscs-test-161.budzdorov.ru    Sun Mar 21 01:27:42 2021
:95:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:96: 
--- end of diff output ---

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

21.03.21 01:29:44. 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-21 01:29:46 No severe PSQL-related problems occured
21.03.21 01:29:47. End of report.