Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 06.01.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 e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17205252 kB
MemAvailable 31427316 kB
Buffers 0 kB
Cached 14508716 kB
SwapCached 4864 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-06 19:27:09
DTS_END                         2021-01-06 19:27:09.1540
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_TO_SUPPLIER(26:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44792
TRN_ID                          238307
ATT_ID                          706
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: 9671.38 16655 1160565
customer order: creation 172.60 362 20712
customer order: refuse 14.39 326 1727
order to supplier: creation 45.09 1348 5411
order to supplier: removal 3.65 101154 438
invoice (draft): creation 45.88 3425 5506
invoice (draft): removal 58.07 727 6968
invoice accept: apply 40.65 17700 4878
invoice accept: cancel 52.58 788 6310
customer reserve: creation 3818.06 172 458167
customer reserve: removal 5119.21 56 614305
realization accept: apply 82.62 185 9914
realization accept: cancel 91.48 110 10978
payment from customer: creation 58.96 121 7075
payment from customer: removal 5.89 84 707
payment to supplier: creation 47.36 136 5683
payment to supplier: removal 3.19 78 383
service: total inventory turnovers 4.35 1510 522
service: total monetary turnovers 6.43 29 772
service: aggregate perf. data 0.88 17061 105
service: refresh index statistics 0.03 187730 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-01-2021 19:29:13 to 06-01-2021 19:29:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5071
TEST_TIME 2 5094
TEST_TIME 3 5277
TEST_TIME 4 5324
TEST_TIME 5 4928
TEST_TIME 6 5299
TEST_TIME 7 6002
TEST_TIME 8 6479
TEST_TIME 9 6789
TEST_TIME 10 6710
TEST_TIME 11 6954
TEST_TIME 12 7249
TEST_TIME 13 7114
TEST_TIME 14 7199
TEST_TIME 15 7404
TEST_TIME 16 7451
TEST_TIME 17 7580
TEST_TIME 18 8073
TEST_TIME 19 8417
TEST_TIME 20 8984
TEST_TIME 21 9434
TEST_TIME 22 9618
TEST_TIME 23 9930
TEST_TIME 24 10165
TEST_TIME 25 10274
TEST_TIME 26 10511
TEST_TIME 27 11592
TEST_TIME 28 11494
TEST_TIME 29 11253
TEST_TIME 30 11070
TEST_TIME 31 10997
TEST_TIME 32 10981
TEST_TIME 33 10862
TEST_TIME 34 10787
TEST_TIME 35 10728
TEST_TIME 36 10817
TEST_TIME 37 10622
TEST_TIME 38 10584
TEST_TIME 39 10560
TEST_TIME 40 10665
TEST_TIME 41 10545
TEST_TIME 42 10529
TEST_TIME 43 10418
TEST_TIME 44 10424
TEST_TIME 45 10403
TEST_TIME 46 10192
TEST_TIME 47 10200
TEST_TIME 48 10066
TEST_TIME 49 10180
TEST_TIME 50 10032
TEST_TIME 51 9988
TEST_TIME 52 9977
TEST_TIME 53 9887
TEST_TIME 54 9804
TEST_TIME 55 9866
TEST_TIME 56 9862
TEST_TIME 57 9992
TEST_TIME 58 9927
TEST_TIME 59 9903
TEST_TIME 60 10035
TEST_TIME 61 10040
TEST_TIME 62 9975
TEST_TIME 63 10055
TEST_TIME 64 10043
TEST_TIME 65 10152
TEST_TIME 66 10191
TEST_TIME 67 10250
TEST_TIME 68 10202
TEST_TIME 69 10312
TEST_TIME 70 10250
TEST_TIME 71 10127
TEST_TIME 72 10069
TEST_TIME 73 10046
TEST_TIME 74 9967
TEST_TIME 75 10037
TEST_TIME 76 10012
TEST_TIME 77 9940
TEST_TIME 78 9880
TEST_TIME 79 9877
TEST_TIME 80 9872
TEST_TIME 81 9810
TEST_TIME 82 9847
TEST_TIME 83 9829
TEST_TIME 84 9797
TEST_TIME 85 9817
TEST_TIME 86 9788
TEST_TIME 87 9792
TEST_TIME 88 9932
TEST_TIME 89 9865
TEST_TIME 90 9919
TEST_TIME 91 9939
TEST_TIME 92 9905
TEST_TIME 93 9933
TEST_TIME 94 9931
TEST_TIME 95 9970
TEST_TIME 96 9928
TEST_TIME 97 9873
TEST_TIME 98 9857
TEST_TIME 99 9823
TEST_TIME 100 9807
TEST_TIME 101 9780
TEST_TIME 102 9727
TEST_TIME 103 9716
TEST_TIME 104 9707
TEST_TIME 105 9642
TEST_TIME 106 9614
TEST_TIME 107 9684
TEST_TIME 108 9679
TEST_TIME 109 9647
TEST_TIME 110 9681
TEST_TIME 111 9682
TEST_TIME 112 9687
TEST_TIME 113 9706
TEST_TIME 114 9671
TEST_TIME 115 9735
TEST_TIME 116 9748
TEST_TIME 117 9767
TEST_TIME 118 9751
TEST_TIME 119 9733
TEST_TIME 120 9679

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-01-2021 19:29:17 to 06-01-2021 19:29:20.

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 1585989 1585989 0 0.00 0 25763 6 0 0
doc_list_biud 1585989 1585989 0 0.00 0 66332 27 0 0
sp_add_invoice_to_stock 4996 4878 118 2.36 26 191449 17700 0 118
sp_cancel_adding_invoice 6310 6310 0 0.00 5 62815 788 0 0
sp_cancel_client_order 1727 1727 0 0.00 4 8388 327 0 0
sp_cancel_customer_reserve 614305 614305 0 0.00 1 57689 56 0 0
sp_cancel_pay_from_customer 707 707 0 0.00 2 7798 85 0 0
sp_cancel_pay_to_supplier 383 383 0 0.00 3 4679 79 0 0
sp_cancel_supplier_invoice 6978 6968 10 0.14 2 66337 727 0 10
sp_cancel_supplier_order 438 438 0 0.00 7 1042432 101155 0 0
sp_cancel_write_off 10978 10978 0 0.00 1 11504 111 0 0
sp_client_order 20712 20712 0 0.00 3 30125 362 0 0
sp_customer_reserve 458167 458167 0 0.00 0 99525 172 0 0
sp_fill_shopping_cart 31621 31621 0 0.00 1 22062 40 0 0
sp_fill_shopping_cart_clo_res 458162 458162 0 0.00 0 16726 13 0 0
sp_get_clo_for_invoice 4869 4869 0 0.00 0 22004 271 0 0
sp_kill_cost_storno 18378 18378 0 0.00 0 8890 58 0 0
sp_kill_qstorno_ret_qs2qd 1246994 1246994 0 0.00 0 66330 30 0 0
sp_kill_qty_storno 655509 655509 0 0.00 0 66331 65 0 0
sp_lock_selected_doc 20517 20517 0 0.00 0 11007 6 0 0
sp_make_cost_storno 27541 27541 0 0.00 0 23471 65 0 0
sp_multiply_rows_for_pdistr 27541 27541 0 0.00 0 8347 30 0 0
sp_multiply_rows_for_qdistr 20712 20712 0 0.00 0 21468 169 0 0
sp_pay_from_customer 7075 7075 0 0.00 4 15965 121 0 0
sp_pay_to_supplier 5683 5683 0 0.00 4 17290 137 0 0
sp_payment_common 12758 12758 0 0.00 2 15950 41 0 0
sp_qd_handle_on_cancel_clo 1727 1727 0 0.00 0 5681 296 0 0
sp_qd_handle_on_invoice_upd_sts 11179 11179 0 0.00 0 14523 309 0 0
sp_qd_handle_on_reserve_upd_sts 9914 9914 0 0.00 0 15409 50 0 0
sp_reserve_write_off 9914 9914 0 0.00 6 22377 185 0 0
sp_supplier_invoice 5506 5506 0 0.00 5 95816 3426 0 0
sp_supplier_order 5411 5411 0 0.00 5 70926 1348 0 0
srv_aggregate_perf_data 106 105 1 0.94 2694 144275 17062 0 1
srv_fill_mon_cache_memory 157 157 0 0.00 1166 131871 33377 0 0
srv_find_qd_qs_mism 1113830 1113830 0 0.00 0 15936 5 0 0
srv_make_invnt_saldo 522 522 0 0.00 52 187888 1510 0 0
srv_make_money_saldo 772 772 0 0.00 0 2936 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 163025 239168 187730 0 0
t$perf-abend:sp_add_invoice_to_stock 118 118 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 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 4878 4878 0 0.00 0 16776 200 0 0
t$perf-norm:sp_cancel_adding_invoice 426 426 0 0.00 0 7736 108 0 0
t$perf-norm:sp_cancel_client_order 1727 1727 0 0.00 0 1915 12 0 0
t$perf-norm:sp_cancel_customer_reserve 658 658 0 0.00 0 1979 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 707 707 0 0.00 0 3818 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 383 383 0 0.00 0 4579 25 0 0
t$perf-norm:sp_cancel_supplier_invoice 375 375 0 0.00 0 1062 15 0 0
t$perf-norm:sp_cancel_supplier_order 438 438 0 0.00 0 28388 1624 0 0
t$perf-norm:sp_cancel_write_off 1021 1021 0 0.00 0 4407 10 0 0
t$perf-norm:sp_client_order 20712 20712 0 0.00 0 7592 18 0 0
t$perf-norm:sp_customer_reserve 1005 1005 0 0.00 0 14175 22 0 0
t$perf-norm:sp_pay_from_customer 7075 7075 0 0.00 0 13760 16 0 0
t$perf-norm:sp_pay_to_supplier 5683 5683 0 0.00 0 13986 17 0 0
t$perf-norm:sp_reserve_write_off 9914 9914 0 0.00 0 9532 13 0 0
t$perf-norm:sp_supplier_invoice 5506 5506 0 0.00 0 5433 22 0 0
t$perf-norm:sp_supplier_order 5411 5411 0 0.00 0 3110 15 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 385 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 1537 16 0 0
t$perf-norm:srv_make_invnt_saldo 522 522 0 0.00 0 1878 35 0 0
t$perf-norm:srv_make_money_saldo 772 772 0 0.00 0 11121 25 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 256 71 0 0
v_add_invoice_to_stock 9974 9738 236 2.36 0 12244 22 0 236
v_all_customers 37780 37780 0 0.00 0 66 1 0 0
v_all_suppliers 30484 30484 0 0.00 0 190 1 0 0
v_all_wares 41424 41424 0 0.00 0 154 1 0 0
v_cancel_adding_invoice 852 852 0 0.00 0 191 6 0 0
v_cancel_client_order 3454 3454 0 0.00 0 2123 4 0 0
v_cancel_customer_prepayment 1414 1414 0 0.00 0 1966 9 0 0
v_cancel_customer_reserve 1316 1316 0 0.00 0 423 3 0 0
v_cancel_payment_to_supplier 766 766 0 0.00 0 164 2 0 0
v_cancel_supplier_invoice 770 750 20 2.59 0 2227 20 0 20
v_cancel_supplier_order 876 876 0 0.00 0 331 3 0 0
v_cancel_write_off 2042 2042 0 0.00 0 1722 14 0 0
v_max_id_clo_ord 5411 5411 0 0.00 0 3830 3 0 0
v_max_id_clo_res 1005 1005 0 0.00 0 3379 15 0 0
v_max_id_ord_sup 5498 5498 0 0.00 0 5306 5 0 0
v_max_non_paid_invoice 1350 1350 0 0.00 0 1074 5 0 0
v_max_non_paid_realizn 3718 3718 0 0.00 0 13098 8 0 0
v_min_id_clo_ord 5411 5411 0 0.00 0 16619 10 0 0
v_min_id_clo_res 1005 1005 0 0.00 0 3144 7 0 0
v_min_id_ord_sup 5498 5498 0 0.00 0 7634 8 0 0
v_min_non_paid_invoice 5683 5683 0 0.00 0 8435 26 0 0
v_min_non_paid_realizn 7075 7075 0 0.00 0 11481 26 0 0
v_our_firm 10358 10358 0 0.00 0 124 1 0 0
v_reserve_write_off 19826 19826 0 0.00 0 12253 8 0 0
x_lock_depdocs_on_canc_invoice 12903 12903 0 0.00 0 40319 131 0 0
x_lock_depdocs_on_canc_sup_ord 438 438 0 0.00 0 13157 384 0 0
x_make_qstorno_1000_1200 5411 5411 0 0.00 1 69669 1263 0 0
x_make_qstorno_1200_2000 5506 5506 0 0.00 2 95808 3285 0 0
x_make_qstorno_2100_3300 458167 458167 0 0.00 0 99524 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-01-2021 19:29:21 to 06-01-2021 19:29:25.

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:12 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:18 7579 8192000000 10155941600 10447355904 868045168 9.581 71 56 114 0 890015120 2362000 19607952
16:57:33 19834 8192000000 10303630416 10618859520 1344503936 14.098 100 82 165 1 1375333024 3900192 26928896
16:58:03 34359 8192000000 10375696784 10695901184 1418774752 14.762 100 86 172 0 1452124976 5474432 27875792
16:58:46 17052 8192000000 10386111872 10710695936 1443817056 14.983 100 85 170 0 1478130448 6840944 27472448
16:59:13 32194 8192000000 10435297824 10766979072 1472484368 15.236 100 89 178 0 1508813136 7634320 28694448
17:00:02 23022 8192000000 10451368768 10786967552 1507518752 15.542 100 90 180 2 1545288192 8682240 29087200
17:00:38 16755 8192000000 10467534224 10807488512 1522909056 15.675 100 89 178 0 1560450256 9227200 28314000
17:01:06 9916 8192000000 10478379696 10821500928 1538595776 15.811 100 85 170 0 1575244320 9921632 26726912
17:01:25 18926 8192000000 10504135392 10851823616 1559272720 15.990 100 81 162 1 1593946960 9981104 24693136
17:01:55 13851 8192000000 10528647760 10881298432 1583534432 16.198 100 79 158 0 1617852160 10681344 23636384
17:02:23 22643 8192000000 10575063024 10933280768 1628867072 16.585 100 77 154 2 1662757392 11343584 22546736
17:02:58 11792 8192000000 10597842688 10961498112 1653496720 16.794 100 85 170 1 1691525664 12862288 25166656
17:03:18 14194 8192000000 10605611744 10974134272 1666835328 16.907 100 79 158 2 1703569824 12950384 23784112
17:03:40 9140 8192000000 10627358992 10993315840 1684464976 17.055 100 84 168 0 1722781824 13096288 25220560
17:04:00 13860 8192000000 10635764928 11005952000 1699361584 17.180 100 81 162 2 1735857584 13224688 23271312
17:04:27 8898 8192000000 10647869552 11024814080 1715728064 17.317 100 81 162 0 1752115920 13793408 22594448
17:04:43 6008 8192000000 10663728528 11040108544 1724825616 17.392 100 69 138 0 1755889552 11873808 19190128
17:04:56 4945 8192000000 10687089744 11060703232 1737846192 17.501 100 78 152 1 1771981232 12928240 21206800
17:05:11 3626 8192000000 10694567136 11072389120 1755029616 17.643 100 71 142 2 1786797328 12057376 19710336
17:05:25 5135 8192000000 10705532656 11084001280 1766045968 17.734 100 81 162 0 1802345904 13315344 22984592
17:05:38 4066 8192000000 10706706464 11091132416 1771721136 17.781 100 80 162 1 1807758176 14048512 21988528
17:05:49 4152 8192000000 10715412992 11100459008 1780436688 17.853 100 75 150 0 1814401936 13051472 20913776
17:06:00 3120 8192000000 10730841536 11110621184 1792743136 17.954 100 86 173 0 1830076576 13663872 23669568
17:06:10 11246 8192000000 10720950368 11111948288 1793383424 17.960 100 73 146 2 1826893040 13503232 20006384
17:06:29 3810 8192000000 10748102624 11133579264 1799780544 18.012 100 87 174 1 1838351344 14214400 24356400
17:06:40 3111 8192000000 10751855472 11137368064 1812629696 18.117 100 85 170 1 1851363520 14462128 24271696
17:06:50 3318 8192000000 10762363520 11151618048 1820806416 18.184 100 78 154 0 1857115744 14160832 22148496
17:07:00 3001 8192000000 10766432720 11154350080 1827042928 18.235 100 84 166 0 1863612880 12637440 23932512
17:07:10 2390 8192000000 10771965056 11160211456 1832790368 18.282 100 81 160 2 1868956576 12863952 23302256
17:07:19 1640 8192000000 10782503872 11168419840 1838259696 18.327 100 86 170 3 1876413744 13720336 24433712
17:07:27 2070 8192000000 10785556880 11173191680 1841298896 18.351 100 90 180 1 1880343120 13488720 25555504
17:07:35 2880 8192000000 10790575168 11180072960 1851964512 18.438 100 94 187 1 1892436304 13943040 26528752
17:07:46 2730 8192000000 10789845568 11183529984 1854155424 18.456 100 87 172 0 1892022816 14190144 23677248
17:07:55 2236 8192000000 10801008912 11193466880 1856224288 18.473 100 83 166 2 1892736768 13118448 23394032
17:08:04 1988 8192000000 10805976048 11194822656 1860924944 18.511 100 94 190 1 1900992128 13562400 26504784
17:08:13 1677 8192000000 10811611776 11196669952 1863592256 18.532 100 92 184 2 1903374336 13940928 25841152
17:08:21 1513 8192000000 10818384800 11205783552 1871224384 18.594 100 92 184 1 1909563456 12436784 25902288
17:08:29 1607 8192000000 10810655616 11205464064 1870596528 18.589 100 93 182 2 1909686608 13038176 26051904
17:08:37 3154 8192000000 10800846816 11204296704 1876931632 18.640 100 76 152 1 1910964928 12017568 22015728
17:08:46 31818 8192000000 10811238800 11206045696 1870840688 18.591 100 58 119 1 1896674784 8428496 17405600
17:09:25 1662 8192000000 10830757728 11222097920 1879754240 18.663 100 96 192 2 1918274400 11668544 26851616
17:09:33 3349 8192000000 10810535520 11221004288 1874702672 18.622 100 63 126 0 1909588544 17467568 17418304
17:09:43 1878 8192000000 10803230880 11213180928 1875245504 18.627 100 58 111 4 1901213552 11237184 14730864
17:09:52 5496 8192000000 10786061824 11210407936 1874141264 18.618 100 41 83 0 1894577648 9003680 11432704
17:10:03 5572 8192000000 10804973440 11218395136 1875046320 18.625 100 43 84 2 1898611056 11487120 12077616
17:10:16 4356 8192000000 10794226816 11214360576 1880386256 18.668 100 39 73 0 1898810224 8182304 10241664
17:10:28 6618 8192000000 10789721040 11213787136 1877317456 18.643 100 25 48 2 1890678576 6488896 6872224
17:10:41 5774 8192000000 10794612512 11221028864 1884751040 18.703 100 45 90 0 1906649584 9582400 12316144
17:10:53 6814 8192000000 10790784768 11217793024 1881052736 18.674 100 27 54 1 1896071616 7200912 7817968
17:11:06 8616 8192000000 10798013616 11227901952 1882409744 18.685 100 22 44 1 1898816288 10533744 5872800
17:11:22 13271 8192000000 10793201664 11220475904 1883564224 18.694 100 26 52 1 1897268288 5143664 8560400
17:11:43 60671 8192000000 10809236416 11230994432 1886350992 18.716 100 36 70 3 1901102352 4849456 9901904
17:12:55 4235 8192000000 10803201264 11237228544 1891820288 18.760 100 45 90 0 1913711328 8677776 13213264
17:13:05 6236 8192000000 10798066016 11233570816 1888278464 18.732 100 22 44 0 1900425712 6194016 5953232
17:13:19 5588 8192000000 10811972688 11244990464 1895063728 18.787 100 35 70 0 1917444304 11382304 10998272
17:13:33 4840 8192000000 10817556224 11241328640 1895263376 18.788 100 28 54 2 1909001536 6265184 7472976
17:13:44 5946 8192000000 10809341952 11240292352 1894215504 18.780 100 22 44 0 1906716848 6579088 5922256
17:13:56 8075 8192000000 10801926288 11241963520 1895128960 18.787 100 27 55 2 1909386560 6960672 7296928
17:14:12 6308 8192000000 10806446544 11242303488 1895920400 18.793 100 24 48 4 1908296096 5590880 6784816
17:14:26 9389 8192000000 10806111280 11242864640 1897341648 18.805 100 31 58 5 1912286112 5440336 9504128
17:14:42 10886 8192000000 10804704432 11243958272 1898740384 18.816 100 20 40 2 1910884672 6187968 5956320
17:15:00 19683 8192000000 10807697696 11249176576 1901110960 18.835 100 32 64 2 1919696224 9704352 8880912
17:15:52 21868 8192000000 10792375296 11232346112 1861499456 18.515 98 27 54 1 1874858160 4938448 8420256
17:16:20 10131 8192000000 10807225088 11242336256 1894205120 18.780 100 31 60 2 1909311312 6704304 8401888
17:16:38 9141 8192000000 10817741424 11247898624 1880464512 18.669 99 25 50 0 1898111024 10780720 6865792
17:16:53 7385 8192000000 10814020912 11233505280 1877265120 18.643 99 29 58 1 1891555920 5720720 8570080
17:17:07 10325 8192000000 10796297152 11227975680 1862250720 18.522 99 20 38 1 1873989856 6713136 5026000
17:17:24 5993 8192000000 10794430864 11217248256 1846899376 18.397 98 30 60 1 1861664528 6509920 8255232
17:17:37 7208 8192000000 10784216576 11218321408 1860611728 18.508 99 20 39 0 1875769760 9519776 5638256
17:17:54 11095 8192000000 10770153632 11198132224 1804313616 18.049 96 24 48 2 1817614160 5652720 7647824
17:18:13 5899 8192000000 10773904672 11199471616 1855605552 18.468 100 19 38 1 1866379744 5444080 5330112
17:18:30 8504 8192000000 10749072784 11171958784 1796502224 17.985 97 17 34 0 1807168240 6004832 4661184
17:18:48 7710 8192000000 10731885392 11157680128 1771393632 17.779 96 29 58 0 1785943408 6027440 8522336
17:19:02 6940 8192000000 10710353120 11127066624 1752984992 17.626 96 15 30 1 1762730928 5115760 4630176
17:19:17 7018 8192000000 10716504752 11118960640 1770234224 17.769 99 16 33 0 1780624000 5852032 4537744
17:19:32 50664 8192000000 10735181968 11156930560 1788321072 17.918 98 24 48 0 1800601488 5377008 6903408
17:20:34 14270 8192000000 10701954784 11124310016 1719762512 17.350 94 28 56 1 1732987728 4683840 8541376
17:20:55 10977 8192000000 10711164960 11129413632 1749854528 17.600 97 19 38 0 1761165360 5915936 5394896
17:21:12 4548 8192000000 10718120992 11123613696 1775815888 17.815 99 31 62 1 1791697552 6255392 9626272
17:21:23 4215 8192000000 10694427792 11110383616 1753302288 17.629 98 31 62 0 1768600432 7181008 8117136
17:21:34 7153 8192000000 10686997280 11094228992 1739493536 17.514 97 40 78 2 1758424768 7798448 11132784
17:21:49 6741 8192000000 10707257040 11114455040 1771302960 17.778 99 34 64 0 1788558848 7303408 9952480
17:22:02 7206 8192000000 10672975472 11087147008 1708043792 17.252 96 24 48 1 1721239088 5992624 7202672
17:22:16 9231 8192000000 10698476288 11115778048 1774905296 17.807 99 28 56 2 1789355696 6413248 8037152
17:22:32 8051 8192000000 10695262992 11110445056 1766883168 17.741 98 27 56 1 1780001808 4934128 8184512
17:22:46 8535 8192000000 10736197216 11144830976 1810868928 18.103 100 19 38 2 1821777808 5561504 5347376
17:23:01 15971 8192000000 10730777248 11151826944 1819151920 18.171 100 17 33 0 1829100192 5349168 4599104
17:23:26 9086 8192000000 10756265792 11170975744 1833037952 18.284 100 31 62 2 1847703056 4951408 9713696
17:23:41 10651 8192000000 10747754976 11174551552 1836313488 18.311 100 30 59 1 1851172768 6171408 8687872
17:24:01 21504 8192000000 10775160416 11192225792 1850604384 18.427 100 28 56 1 1864666208 6278048 7783776
17:24:30 57726 8192000000 10751904480 11190632448 1852772928 18.445 100 24 48 2 1865861888 4900544 8188416
17:25:35 11537 8192000000 10761199888 11192074240 1853446096 18.450 100 16 33 1 1862797472 4693760 4657616
17:25:55 7736 8192000000 10776577184 11200282624 1860318032 18.506 100 22 44 2 1873029648 6025808 6685808
17:26:13 8322 8192000000 10769237120 11200417792 1862756816 18.526 100 22 44 5 1875422176 5913664 6751696
17:26:28 7244 8192000000 10781072224 11209699328 1865752912 18.550 100 27 53 0 1879620048 6930272 6936864
17:26:42 11599 8192000000 10772717872 11204378624 1864406128 18.539 100 23 47 2 1877313216 6122768 6784320
17:27:03 6901 8192000000 10792121200 11219255296 1875649088 18.630 100 36 72 1 1892012928 5491104 10872736
17:27:35 29459 8192000000 10818926448 11238965248 1892837936 18.769 100 41 82 0 1913078016 8072544 12167536
17:28:14 10016 8192000000 10847935232 11255627776 1905447104 18.870 100 49 97 3 1929097152 10026768 13623280
17:28:39 2857 8192000000 10855330768 11266764800 1914584976 18.943 100 53 106 1 1940278784 10943584 14750224
17:28:52 18980 8192000000 10853590944 11275603968 1921154496 18.996 100 59 111 4 1949075760 12432192 15489072
17:29:20 12577 8192000000 10872386800 11288584192 1932285248 19.085 100 54 108 0 1961239632 13753712 15200672
17:29:41 32903 8192000000 10860562032 11292897280 1935366112 19.110 100 50 102 0 1963385472 13334224 14685136
17:30:22 40724 8192000000 10872651504 11306135552 1938588704 19.135 100 38 76 1 1964360000 13753648 12017648
17:31:38 96856 8192000000 10879476400 11321315328 1948650272 19.216 100 29 58 0 1974464560 17106192 8708096
17:33:27 2040 8192000000 10909832176 11330232320 1961720032 19.320 100 55 109 2 1995441888 17705648 16016208
17:33:36 3771 8192000000 10913256048 11339624448 1964833568 19.344 100 62 124 1 2004630128 21368816 18427744
17:33:46 4486 8192000000 10920790528 11340357632 1968805776 19.376 100 63 123 0 2004224912 18076608 17342528
17:33:58 8629 8192000000 10914341936 11342905344 1965315680 19.348 100 57 112 1 2002796272 20955376 16525216
17:34:14 12535 8192000000 10913094432 11344515072 1968404784 19.373 100 48 96 0 2003315360 20714464 14196112
17:34:34 2680 8192000000 10926054544 11350978560 1972114032 19.402 100 64 129 0 2013574800 21673152 19787616
17:34:44 3903 8192000000 10924695040 11347767296 1956757840 19.280 99 77 154 3 2001377264 22075184 22544240
17:34:55 8976 8192000000 10925438656 11349782528 1972735104 19.407 100 67 135 1 2014076992 21697648 19644240
17:35:11 15371 8192000000 10920595248 11355312128 1973429344 19.413 100 56 112 2 2012621824 22390592 16801888
17:35:36 4710 8192000000 10940165488 11356434432 1982747504 19.486 100 66 131 1 2021626576 19884352 18994720
17:35:47 5493 8192000000 10944629024 11370274816 1989929200 19.543 100 79 157 0 2039036336 25733664 23373472
17:36:00 3576 8192000000 10946020224 11370000384 1989258672 19.538 100 69 135 3 2029209312 21135184 18815456
17:36:11 3272 8192000000 10934655200 11360428032 1969661888 19.383 99 70 135 1 2010842752 21220592 19960272
17:36:22 2129 8192000000 10940447504 11353010176 1965063968 19.346 99 69 138 1 2006567808 21655184 19848656
17:36:31 11363 8192000000 10930716128 11360657408 1979555376 19.461 100 59 118 0 2019895696 22507792 17832528
17:37:10 7505 8192000000 10934009024 11370344448 1988503888 19.532 100 51 99 2 2026444336 22776368 15164080
17:37:26 10780 8192000000 10949882864 11386146816 1999218448 19.617 100 62 124 2 2041113360 22876304 19018608
17:37:49 6592 8192000000 10944408816 11376435200 1995894928 19.590 100 59 116 2 2038554544 24200368 18459248
17:38:03 3541 8192000000 10961259840 11389943808 2001381024 19.634 100 67 134 0 2046703344 23953488 21368832
17:38:14 5689 8192000000 10950103728 11380277248 1985990832 19.512 99 58 112 1 2024270288 20889328 17390128
17:38:27 4493 8192000000 10947938720 11380420608 1998608832 19.612 100 62 125 0 2039968848 22193312 19166704
17:38:43 3536 8192000000 10959460000 11390255104 2005652608 19.667 100 69 137 1 2049025328 23031856 20340864
17:38:54 6382 8192000000 10967155680 11392737280 2005339120 19.665 100 74 148 2 2054019072 26331456 22348496
17:39:08 7092 8192000000 10968515232 11391918080 2003127088 19.647 100 73 145 1 2051869456 26723216 22019152
17:39:23 2405 8192000000 10974259680 11402948608 2010501536 19.705 100 71 140 1 2059389040 26984672 21902832
17:39:35 14841 8192000000 10956051840 11389886464 1989928528 19.543 99 59 116 0 2032850320 25177936 17743856
17:39:58 4779 8192000000 10956992592 11383447552 1983594800 19.493 99 59 118 1 2025436400 23721232 18120368
17:40:11 2799 8192000000 10965201392 11379236864 1984829904 19.503 99 81 161 2 2035044352 24796928 25417520
17:40:23 4682 8192000000 10948183040 11368177664 1981232032 19.474 99 66 132 0 2026804752 25752512 19820208
17:40:36 5179 8192000000 10956372368 11377364992 1977443824 19.444 99 77 153 2 2029811392 29086560 23281008
17:40:47 4560 8192000000 10956533520 11373027328 1984013248 19.496 100 77 155 1 2037225696 30385376 22827072
17:40:59 3877 8192000000 10952139744 11360473088 1974734048 19.423 100 84 168 0 2032941776 31937600 26270128
17:41:11 2687 8192000000 10953936384 11361357824 1959002144 19.298 99 84 169 0 2018906608 33588096 26316368
17:41:22 3351 8192000000 10952810192 11364466688 1975233136 19.427 100 87 174 2 2037522816 35152096 27137584
17:41:32 7756 8192000000 10940390752 11361349632 1973187072 19.411 100 68 135 1 2029341312 33788496 22365744
17:41:47 9026 8192000000 10941070512 11356069888 1943162608 19.172 98 81 162 3 2001746592 33624512 24959472
17:42:04 6189 8192000000 10929975568 11354685440 1965273120 19.348 100 63 126 0 2019250336 34402032 19575184
17:42:20 5832 8192000000 10927176768 11340414976 1948601984 19.215 100 79 157 1 2008192240 35186656 24403600
17:42:33 4352 8192000000 10916405632 11337142272 1948142752 19.212 100 69 138 2 2004892944 35510720 21239472
17:42:47 2306 8192000000 10932808112 11340570624 1952291280 19.245 100 88 176 2 2015865968 35996512 27578176
17:42:56 5160 8192000000 10926267872 11341774848 1950692944 19.232 100 81 162 5 2012235232 35700752 25841536
17:43:08 4088 8192000000 10940252656 11348606976 1955550272 19.271 100 82 164 3 2018983344 37153920 26279152
17:43:19 2749 8192000000 10947361584 11354906624 1950868464 19.233 99 83 165 4 2014329504 38099088 25361952
17:43:31 5670 8192000000 10938839920 11351605248 1956595504 19.279 100 70 141 1 2018462880 39836976 22030400
17:43:45 1163 8192000000 10961886480 11369910272 1971237104 19.395 100 88 170 1 2038610560 40885744 26487712
17:43:53 4082 8192000000 10931805392 11352031232 1952419552 19.246 99 73 146 3 2016616896 39973808 24223536
17:44:09 3590 8192000000 10949423088 11355385856 1960490832 19.310 100 88 175 1 2028884256 40497808 27895616
17:44:20 5418 8192000000 10951746768 11358363648 1964678864 19.343 100 85 169 0 2035336032 43780576 26876592
17:44:33 1987 8192000000 10952562432 11364679680 1963400000 19.333 100 84 167 2 2034477536 43725280 27352256
17:44:45 2010 8192000000 10943028688 11354247168 1954766064 19.264 99 91 181 3 2029232400 45455712 29010624
17:44:57 1498 8192000000 10943774112 11348185088 1948383248 19.214 99 83 164 0 2017551120 43376464 25791408
17:45:06 2765 8192000000 10951133568 11362967552 1966462080 19.357 100 75 150 0 2030552752 40669376 23421296
17:45:19 3757 8192000000 10967977344 11374407680 1970836832 19.392 100 83 164 1 2040784640 44223776 25724032
17:45:30 3612 8192000000 10962191520 11380256768 1974056288 19.418 100 73 146 2 2043641376 45611424 23973664
17:45:42 2334 8192000000 10957837744 11366502400 1950982320 19.234 99 79 158 2 2021573712 45450416 25140976
17:45:51 10407 8192000000 10962843632 11379306496 1974758128 19.423 100 78 156 1 2045352304 45577584 25016592
17:46:16 5195 8192000000 10981531632 11397050368 1986598848 19.517 100 80 160 0 2060066176 47957680 25509648
17:46:29 2721 8192000000 10974965440 11385724928 1964125840 19.339 99 82 164 1 2038219552 47439776 26653936
17:46:40 4644 8192000000 10950226208 11369103360 1958469856 19.294 99 62 125 3 2030492768 51525504 20497408
17:46:57 11608 8192000000 10950442960 11395993600 1973104864 19.410 100 48 96 2 2043071344 53149520 16816960
17:47:15 10558 8192000000 10934867888 11378675712 1953120864 19.251 99 42 84 0 2015938256 48541408 14275984
17:47:36 14859 8192000000 10939274976 11375955968 1943814560 19.177 99 48 97 1 2005763696 45956544 15992592
17:48:00 20447 8192000000 10916124528 11360178176 1921476704 18.999 98 39 78 0 1980675424 45335648 13863072
17:48:27 19391 8192000000 10921818864 11364634624 1939354800 19.142 99 34 68 1 1995888064 44669552 11863712
17:48:54 12453 8192000000 10908690624 11351646208 1923468128 19.015 99 34 68 1 1978903872 42593744 12842000
17:49:28 17065 8192000000 10916749728 11357732864 1944228912 19.180 100 30 60 1 1997072368 42568240 10275216
17:49:57 6596 8192000000 10912050656 11355230208 1946902400 19.202 100 44 87 1 2003172032 42694864 13574768
17:50:18 27383 8192000000 10904726464 11352641536 1946082128 19.195 100 27 54 3 1994664496 40103600 8478768
17:51:03 21010 8192000000 10883890784 11330506752 1897276784 18.804 98 27 54 1 1948516944 41622784 9617376
17:51:32 21926 8192000000 10891460976 11346628608 1928555312 19.055 100 26 52 2 1979401504 41710912 9135280
17:52:05 33183 8192000000 10888270128 11352301568 1935253008 19.109 100 16 32 1 1980531040 39709056 5568976
17:52:55 31174 8192000000 10880218592 11331756032 1908411792 18.894 100 19 38 1 1963321136 47408368 7500976
17:54:30 35473 8192000000 10844535856 11304759296 1858300848 18.490 97 11 22 2 1884952320 23022432 3629040
17:55:13 96788 8192000000 10864195760 11316019200 1895532304 18.790 99 11 22 1 1910774592 12125888 3116400
17:57:09 54854 8192000000 10868342704 11312844800 1904687488 18.864 98 36 70 0 1920540496 6513408 9339600
17:58:10 95307 8192000000 10847642656 11283996672 1843487632 18.369 95 20 39 1 1856331056 8056064 4787360
17:59:53 70317 8192000000 10880477696 11320766464 1913330464 18.933 98 30 58 2 1930750512 9774032 7646016
18:01:14 73695 8192000000 10895249696 11367346176 1949672944 19.224 100 22 44 0 1975568240 19172704 6722592
18:02:34 88760 8192000000 10893095408 11371966464 1952961200 19.250 100 10 21 2 1978249504 22238016 3050288
18:04:09 20710 8192000000 10881684672 11347750912 1951114848 19.235 100 15 30 1 1972829440 17415792 4298800
18:04:37 7601 8192000000 10885484512 11335651328 1932893168 19.090 99 30 56 1 1956109776 14606384 8610224
18:04:51 8279 8192000000 10879523008 11340046336 1950110224 19.227 100 20 40 3 1971645856 15260800 6274832
18:05:11 53269 8192000000 10913721568 11354742784 1954495520 19.262 99 36 71 2 1977479728 11662528 11321680
18:06:10 45897 8192000000 10875436912 11325935616 1936992512 19.123 99 31 61 0 1958757952 13391920 8373520
18:07:04 34092 8192000000 10871960400 11352223744 1946858480 19.201 100 11 22 0 1963415184 12668128 3888576
18:07:45 20282 8192000000 10895122784 11351375872 1962247328 19.324 100 13 26 0 1974196128 7913536 4035264
18:08:12 91231 8192000000 10891566016 11361927168 1961243712 19.316 99 18 36 1 1976704896 9543904 5917280
18:09:58 87403 8192000000 10913675664 11380822016 1973245456 19.411 100 13 26 0 1993678496 16851344 3581696
18:11:40 48276 8192000000 10885013280 11368480768 1954863136 19.265 99 10 20 0 1967341312 9059488 3418688
18:12:37 115938 8192000000 10906390048 11376496640 1961325088 19.317 99 25 50 0 1979366304 10352544 7688672
18:14:43 87467 8192000000 10921698896 11386290176 1969415888 19.381 99 34 68 0 1991887408 12641488 9830032
18:16:30 59515 8192000000 10925254320 11381014528 1956582272 19.279 98 36 71 0 1974851776 8445760 9823744
18:17:45 47454 8192000000 10932365824 11396640768 1993196016 19.569 100 38 76 1 2020375808 16587696 10592096
18:18:43 38208 8192000000 10921194176 11395506176 1993579952 19.572 100 16 32 0 2014589552 16425936 4583664
18:19:41 77447 8192000000 10921525424 11403444224 1954565088 19.263 98 13 26 0 1975610256 16532064 4513104
18:21:05 67149 8192000000 10923756192 11402248192 1995180672 19.585 100 14 28 0 2018964144 19347616 4435856
18:22:18 44376 8192000000 10921464000 11408244736 1993921824 19.575 100 16 32 2 2015938368 17702896 4313648
18:23:09 48974 8192000000 10923920960 11408994304 1975987936 19.433 99 6 12 1 1993014528 15505840 1520752
18:24:34 32886 8192000000 10907822576 11396218880 1974597088 19.422 99 14 28 0 1997319424 18187552 4534784
18:25:16 72785 8192000000 10943890688 11401658368 1986124096 19.513 99 38 76 1 2011844880 14666800 11053984
18:26:34 29795 8192000000 10914464896 11393204224 1975051696 19.426 99 39 78 0 2004227552 17524208 11651648
18:28:02 40527 8192000000 10915587968 11370610688 1977627760 19.446 100 25 50 0 1995013664 10603456 6782448
18:28:49 44800 8192000000 10933818400 11392614400 1975695184 19.431 99 19 38 0 1990618592 9689856 5233552
18:29:41 59961 8192000000 10910585696 11379380224 1942101056 19.164 97 23 46 0 1965386784 16656688 6629040
18:31:18 94326 8192000000 10891521808 11375595520 1898118320 18.811 96 10 20 1 1921318592 20446768 2753504
18:33:20 125581 8192000000 10883049184 11350847488 1890691840 18.751 96 16 32 1 1907941408 12822768 4426800
18:35:32 46153 8192000000 10893512496 11359399936 1896641760 18.799 96 19 38 0 1913329200 11628640 5058800
18:36:29 78152 8192000000 10878411968 11349364736 1897526912 18.806 97 8 14 1 1917912352 18716080 1669360
18:38:01 83531 8192000000 10869104960 11319226368 1866462880 18.556 96 30 60 0 1888762496 13397056 8902560
18:39:59 90569 8192000000 10848819328 11315937280 1855390544 18.466 96 21 42 1 1872667648 11158384 6118720
18:41:43 40839 8192000000 10883044688 11336290304 1895658784 18.791 97 37 73 2 1922153952 15525824 10969344
18:42:50 86878 8192000000 10843638320 11309166592 1842391360 18.360 95 9 18 0 1860812688 15661840 2759488
18:44:27 61722 8192000000 10819520016 11281833984 1824436944 18.214 95 15 28 2 1840341168 12070304 3833920
18:45:52 70788 8192000000 10811404288 11267817472 1848529488 18.410 97 21 42 0 1867208576 12315408 6363680
18:48:15 52883 8192000000 10820954624 11282505728 1885512448 18.710 99 20 40 0 1902853408 11068480 6272480
18:49:17 34965 8192000000 10813559008 11286708224 1885397280 18.709 99 12 24 2 1899004608 9851824 3755504
18:49:58 33627 8192000000 10821543840 11281735680 1847873552 18.405 97 16 32 0 1859773600 7455600 4444448
18:50:43 75943 8192000000 10833533088 11300483072 1907509104 18.887 100 14 28 2 1920281952 9322512 3450336
18:52:24 27652 8192000000 10839425904 11299196928 1897482576 18.806 99 26 52 0 1913378480 8488752 7407152
18:53:00 24307 8192000000 10862010960 11315785728 1923599264 19.016 100 32 64 0 1940827472 8410480 8817728
18:53:31 24630 8192000000 10891317056 11330637824 1922040992 19.003 99 43 86 0 1950303776 15701184 12561600
18:54:05 26742 8192000000 10862629632 11324162048 1901110432 18.835 98 36 72 1 1927122048 15852240 10159376
18:54:41 61792 8192000000 10869747504 11340062720 1910839952 18.913 99 18 36 1 1933397552 17355792 5201808
18:55:57 50561 8192000000 10863792992 11327471616 1899525904 18.822 98 13 26 0 1918112640 14593952 3992784
18:57:00 40466 8192000000 10894609264 11351924736 1935680720 19.112 99 34 68 3 1959263712 13290016 10292976
18:57:47 70977 8192000000 10884692304 11332747264 1874032304 18.617 96 16 32 3 1889851088 11966288 3852496
18:59:06 26083 8192000000 10903678832 11351580672 1963289536 19.332 100 45 88 1 1984469200 9220496 11959168
18:59:38 24959 8192000000 10913535728 11365376000 1974989520 19.425 100 37 74 1 1995337152 10301616 10046016
19:00:14 57407 8192000000 10897919296 11360292864 1910658032 18.912 97 26 52 0 1935691168 17844224 7188912
19:01:20 89798 8192000000 10913452512 11380957184 1975121760 19.426 100 17 34 0 1989591056 9862960 4606336
19:02:59 131870 8192000000 10906412816 11367022592 1928882288 19.058 97 38 76 0 1948965552 9749072 10334192
19:05:34 89208 8192000000 10889962752 11362779136 1936161872 19.116 98 21 40 1 1953039648 11250208 5627568
19:07:09 15942 8192000000 10904396800 11369164800 1967597536 19.366 100 19 38 1 1985678256 13173248 4907472
19:07:33 66117 8192000000 10893812032 11377012736 1979299536 19.459 100 12 24 0 1992704640 9542640 3862464
19:08:45 38169 8192000000 10903995056 11357970432 1923237968 19.013 97 17 34 0 1936840432 9079136 4523328
19:09:35 76323 8192000000 10882839136 11355889664 1938196224 19.132 98 26 53 0 1957223200 11509744 7517232
19:11:01 75286 8192000000 10903039824 11385610240 1980499424 19.469 100 11 22 0 1992258064 8685680 3072960
19:12:48 79955 8192000000 10918561312 11406475264 2000261072 19.625 100 13 26 0 2024109312 19952624 3895616
19:14:45 37881 8192000000 10916867088 11399933952 1984634384 19.501 100 13 26 1 1997360976 9552672 3173920
19:15:29 27441 8192000000 10904076928 11370192896 1950497952 19.230 98 20 38 0 1962274560 6819152 4957456
19:16:07 34447 8192000000 10921008256 11376254976 1971382624 19.396 99 30 60 1 1987114944 7567792 8164528
19:16:49 35772 8192000000 10904098320 11374542848 1965748816 19.352 99 35 70 0 1984702736 9153376 9800544
19:17:39 56568 8192000000 10896582480 11373506560 1921027664 18.995 97 25 51 1 1941284288 13137056 7119568
19:18:44 50276 8192000000 10903365712 11383099392 1969358208 19.380 100 16 32 0 1984068432 10579552 4130672
19:19:55 54057 8192000000 10918083872 11386318848 1948543552 19.215 98 16 32 3 1964008640 10374752 5090336
19:20:56 78796 8192000000 10875660224 11334045696 1819837920 18.176 92 19 38 1 1837455728 11895568 5722240
19:24:03 126020 8192000000 10895719168 11361198080 1826785264 18.233 93 15 30 1 1848201472 17521584 3894624
19:26:20 60101 8192000000 9755723408 10102476800 855207216 9.452 44 8 14 1 867892240 10408064 2276960

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 06-01-2021 19:29:27 to 06-01-2021 19:29:58.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 118 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

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          238576
MON$OLDEST_ACTIVE               238577
MON$OLDEST_SNAPSHOT             238577
MON$NEXT_TRANSACTION            238577
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                       2042912
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:483: 
:484: mscs-test-161.budzdorov.ru    Wed Jan  6 19:27:23 2021
:485:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:486: 
:487: 
:488: mscs-test-161.budzdorov.ru    Wed Jan  6 19:27:35 2021
:489:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:490: 
:491: 
:492: mscs-test-161.budzdorov.ru    Wed Jan  6 19:27:36 2021
:493:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:494: 
--- end of diff output ---

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

06.01.21 19:30:01. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-01-06 19:30:04 No severe PSQL-related problems occured
06.01.21 19:30:05. End of report.