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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17007752 kB
MemAvailable 31173560 kB
Buffers 0 kB
Cached 14635420 kB
SwapCached 4876 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-02-05 22:27:14
DTS_END                         2021-02-05 22:27:14.8230
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/53258
TRN_ID                          245800
ATT_ID                          664
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: 9360.36 17827 1123243
customer order: creation 184.98 339 22198
customer order: refuse 15.41 336 1849
order to supplier: creation 49.08 1291 5889
order to supplier: removal 3.52 94644 422
invoice (draft): creation 48.07 3282 5768
invoice (draft): removal 50.51 778 6061
invoice accept: apply 43.81 17892 5257
invoice accept: cancel 46.08 801 5529
customer reserve: creation 4081.20 175 489744
customer reserve: removal 4527.73 58 543327
realization accept: apply 88.65 183 10638
realization accept: cancel 84.27 114 10112
payment from customer: creation 62.06 128 7447
payment from customer: removal 6.45 81 774
payment to supplier: creation 51.84 116 6221
payment to supplier: removal 3.72 91 446
service: total inventory turnovers 5.17 974 620
service: total monetary turnovers 7.13 24 856
service: aggregate perf. data 0.68 26101 81
service: refresh index statistics 0.03 209123 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-02-2021 22:28:30 to 05-02-2021 22:28:32.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5165
TEST_TIME 2 5255
TEST_TIME 3 4962
TEST_TIME 4 5456
TEST_TIME 5 5628
TEST_TIME 6 5430
TEST_TIME 7 5712
TEST_TIME 8 5975
TEST_TIME 9 6191
TEST_TIME 10 6581
TEST_TIME 11 7182
TEST_TIME 12 7107
TEST_TIME 13 7331
TEST_TIME 14 7426
TEST_TIME 15 7618
TEST_TIME 16 7891
TEST_TIME 17 8292
TEST_TIME 18 8317
TEST_TIME 19 8387
TEST_TIME 20 9030
TEST_TIME 21 9172
TEST_TIME 22 9675
TEST_TIME 23 9899
TEST_TIME 24 9841
TEST_TIME 25 9934
TEST_TIME 26 10028
TEST_TIME 27 10452
TEST_TIME 28 11125
TEST_TIME 29 11051
TEST_TIME 30 11001
TEST_TIME 31 10793
TEST_TIME 32 10746
TEST_TIME 33 10747
TEST_TIME 34 10740
TEST_TIME 35 10669
TEST_TIME 36 10592
TEST_TIME 37 10475
TEST_TIME 38 10271
TEST_TIME 39 10296
TEST_TIME 40 10225
TEST_TIME 41 10156
TEST_TIME 42 10045
TEST_TIME 43 9964
TEST_TIME 44 9976
TEST_TIME 45 9839
TEST_TIME 46 10014
TEST_TIME 47 10128
TEST_TIME 48 9979
TEST_TIME 49 9902
TEST_TIME 50 9875
TEST_TIME 51 9801
TEST_TIME 52 9867
TEST_TIME 53 9799
TEST_TIME 54 9785
TEST_TIME 55 9792
TEST_TIME 56 9806
TEST_TIME 57 10069
TEST_TIME 58 10094
TEST_TIME 59 10058
TEST_TIME 60 10102
TEST_TIME 61 10088
TEST_TIME 62 10179
TEST_TIME 63 10186
TEST_TIME 64 10056
TEST_TIME 65 9998
TEST_TIME 66 9893
TEST_TIME 67 9807
TEST_TIME 68 9857
TEST_TIME 69 9788
TEST_TIME 70 9719
TEST_TIME 71 9725
TEST_TIME 72 9702
TEST_TIME 73 9658
TEST_TIME 74 9612
TEST_TIME 75 9699
TEST_TIME 76 9650
TEST_TIME 77 9656
TEST_TIME 78 9649
TEST_TIME 79 9619
TEST_TIME 80 9694
TEST_TIME 81 9691
TEST_TIME 82 9730
TEST_TIME 83 9789
TEST_TIME 84 9753
TEST_TIME 85 9791
TEST_TIME 86 9864
TEST_TIME 87 9843
TEST_TIME 88 9864
TEST_TIME 89 9780
TEST_TIME 90 9710
TEST_TIME 91 9690
TEST_TIME 92 9735
TEST_TIME 93 9684
TEST_TIME 94 9629
TEST_TIME 95 9618
TEST_TIME 96 9612
TEST_TIME 97 9573
TEST_TIME 98 9597
TEST_TIME 99 9655
TEST_TIME 100 9614
TEST_TIME 101 9656
TEST_TIME 102 9661
TEST_TIME 103 9691
TEST_TIME 104 9659
TEST_TIME 105 9663
TEST_TIME 106 9769
TEST_TIME 107 9769
TEST_TIME 108 9747
TEST_TIME 109 9667
TEST_TIME 110 9638
TEST_TIME 111 9605
TEST_TIME 112 9596
TEST_TIME 113 9543
TEST_TIME 114 9531
TEST_TIME 115 9499
TEST_TIME 116 9463
TEST_TIME 117 9451
TEST_TIME 118 9429
TEST_TIME 119 9426
TEST_TIME 120 9361

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-02-2021 22:28:34 to 05-02-2021 22:28:37.

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 1576935 1576935 0 0.00 0 35005 7 0 0
doc_list_biud 1576935 1576935 0 0.00 0 54469 26 0 0
sp_add_invoice_to_stock 5364 5257 107 1.99 24 170885 17893 0 107
sp_cancel_adding_invoice 5529 5529 0 0.00 5 74834 801 0 0
sp_cancel_client_order 1849 1849 0 0.00 4 13591 336 0 0
sp_cancel_customer_reserve 543327 543327 0 0.00 1 54473 59 0 0
sp_cancel_pay_from_customer 774 774 0 0.00 3 4441 81 0 0
sp_cancel_pay_to_supplier 446 446 0 0.00 3 5600 92 0 0
sp_cancel_supplier_invoice 6070 6061 9 0.14 2 16832 778 0 9
sp_cancel_supplier_order 422 422 0 0.00 7 850940 94645 0 0
sp_cancel_write_off 10112 10112 0 0.00 1 12410 115 0 0
sp_client_order 22198 22198 0 0.00 4 12458 339 0 0
sp_customer_reserve 489744 489744 0 0.00 0 117312 176 0 0
sp_fill_shopping_cart 33835 33835 0 0.00 1 14110 35 0 0
sp_fill_shopping_cart_clo_res 489741 489741 0 0.00 0 16996 13 0 0
sp_get_clo_for_invoice 5253 5253 0 0.00 0 19052 296 0 0
sp_kill_cost_storno 16861 16861 0 0.00 0 7047 56 0 0
sp_kill_qstorno_ret_qs2qd 1103249 1103249 0 0.00 0 54455 32 0 0
sp_kill_qty_storno 583191 583191 0 0.00 0 54468 68 0 0
sp_lock_selected_doc 22029 22029 0 0.00 0 6999 5 0 0
sp_make_cost_storno 29559 29559 0 0.00 0 34990 57 0 0
sp_multiply_rows_for_pdistr 29559 29559 0 0.00 0 7665 30 0 0
sp_multiply_rows_for_qdistr 22198 22198 0 0.00 0 12450 162 0 0
sp_pay_from_customer 7447 7447 0 0.00 4 27178 128 0 0
sp_pay_to_supplier 6221 6221 0 0.00 5 14374 117 0 0
sp_payment_common 13668 13668 0 0.00 1 27135 33 0 0
sp_qd_handle_on_cancel_clo 1849 1849 0 0.00 0 13580 305 0 0
sp_qd_handle_on_invoice_upd_sts 10782 10782 0 0.00 0 15956 320 0 0
sp_qd_handle_on_reserve_upd_sts 10638 10638 0 0.00 0 14199 53 0 0
sp_reserve_write_off 10638 10638 0 0.00 6 17693 183 0 0
sp_supplier_invoice 5768 5768 0 0.00 8 72917 3283 0 0
sp_supplier_order 5889 5889 0 0.00 6 38697 1292 0 0
srv_aggregate_perf_data 82 81 1 1.21 2880 485076 26102 0 1
srv_fill_mon_cache_memory 168 168 0 0.00 892 171631 29988 0 0
srv_find_qd_qs_mism 1072629 1072629 0 0.00 0 8328 6 0 0
srv_make_invnt_saldo 620 620 0 0.00 22 27131 974 0 0
srv_make_money_saldo 856 856 0 0.00 1 467 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 147629 289970 209123 0 0
t$perf-abend:sp_add_invoice_to_stock 107 107 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5257 5257 0 0.00 0 18779 190 0 0
t$perf-norm:sp_cancel_adding_invoice 441 441 0 0.00 1 4914 108 0 0
t$perf-norm:sp_cancel_client_order 1849 1849 0 0.00 0 1831 12 0 0
t$perf-norm:sp_cancel_customer_reserve 717 717 0 0.00 0 8205 31 0 0
t$perf-norm:sp_cancel_pay_from_customer 774 774 0 0.00 0 1931 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 446 446 0 0.00 0 360 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 416 416 0 0.00 0 1114 11 0 0
t$perf-norm:sp_cancel_supplier_order 422 422 0 0.00 0 22970 1634 0 0
t$perf-norm:sp_cancel_write_off 1073 1073 0 0.00 0 3963 16 0 0
t$perf-norm:sp_client_order 22198 22198 0 0.00 0 10533 22 0 0
t$perf-norm:sp_customer_reserve 1085 1085 0 0.00 0 3700 16 0 0
t$perf-norm:sp_pay_from_customer 7447 7447 0 0.00 0 6135 10 0 0
t$perf-norm:sp_pay_to_supplier 6221 6221 0 0.00 0 9203 11 0 0
t$perf-norm:sp_reserve_write_off 10638 10638 0 0.00 0 11423 13 0 0
t$perf-norm:sp_supplier_invoice 5768 5768 0 0.00 0 6065 24 0 0
t$perf-norm:sp_supplier_order 5889 5889 0 0.00 0 10440 22 0 0
t$perf-norm:srv_aggregate_perf_data 81 81 0 0.00 0 345 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 2045 13 0 0
t$perf-norm:srv_make_invnt_saldo 620 620 0 0.00 0 591 17 0 0
t$perf-norm:srv_make_money_saldo 856 856 0 0.00 0 757 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 18 7 0 0
v_add_invoice_to_stock 10720 10506 214 1.99 0 6623 20 0 214
v_all_customers 40300 40300 0 0.00 0 21 1 0 0
v_all_suppliers 32548 32548 0 0.00 0 17 1 0 0
v_all_wares 44396 44396 0 0.00 0 152 1 0 0
v_cancel_adding_invoice 882 882 0 0.00 0 1044 8 0 0
v_cancel_client_order 3698 3698 0 0.00 0 5561 10 0 0
v_cancel_customer_prepayment 1548 1548 0 0.00 0 3268 11 0 0
v_cancel_customer_reserve 1434 1434 0 0.00 0 2366 5 0 0
v_cancel_payment_to_supplier 892 892 0 0.00 0 3433 9 0 0
v_cancel_supplier_invoice 850 832 18 2.11 0 2325 15 0 18
v_cancel_supplier_order 844 844 0 0.00 0 3526 9 0 0
v_cancel_write_off 2146 2146 0 0.00 0 3592 18 0 0
v_max_id_clo_ord 5884 5884 0 0.00 0 1204 2 0 0
v_max_id_clo_res 1085 1085 0 0.00 0 2839 14 0 0
v_max_id_ord_sup 5753 5753 0 0.00 0 1837 2 0 0
v_max_non_paid_invoice 1584 1584 0 0.00 0 483 3 0 0
v_max_non_paid_realizn 3977 3977 0 0.00 0 8623 7 0 0
v_min_id_clo_ord 5884 5884 0 0.00 0 4231 5 0 0
v_min_id_clo_res 1085 1085 0 0.00 0 4087 7 0 0
v_min_id_ord_sup 5753 5753 0 0.00 0 5203 5 0 0
v_min_non_paid_invoice 6221 6221 0 0.00 0 10441 17 0 0
v_min_non_paid_realizn 7447 7447 0 0.00 0 13936 19 0 0
v_our_firm 11036 11036 0 0.00 0 13 1 0 0
v_reserve_write_off 21276 21276 0 0.00 0 6708 6 0 0
x_lock_depdocs_on_canc_invoice 11174 11174 0 0.00 0 19125 113 0 0
x_lock_depdocs_on_canc_sup_ord 422 422 0 0.00 0 9439 362 0 0
x_make_qstorno_1000_1200 5889 5889 0 0.00 1 38650 1212 0 0
x_make_qstorno_1200_2000 5768 5768 0 0.00 4 72902 3156 0 0
x_make_qstorno_2100_3300 489744 489744 0 0.00 0 117311 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-02-2021 22:28:38 to 05-02-2021 22:28:42.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:18 2 8192000000 8799382368 8810233856 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:24 18940 8192000000 10247070048 10556686336 907003136 9.968 71 52 102 1 926841344 2336976 17501232
19:57:52 21124 8192000000 10359664448 10677530624 1410249552 14.686 100 89 178 1 1444614864 5212480 29152832
19:58:25 27849 8192000000 10394524592 10716884992 1445821440 15.001 100 91 182 1 1481730352 6534656 29374256
19:59:03 31823 8192000000 10417752672 10745315328 1465916192 15.178 100 83 166 0 1500156608 7872336 26368080
19:59:45 30768 8192000000 10439994992 10772566016 1494330464 15.427 100 91 182 1 1531964384 8775712 28858208
20:00:27 20273 8192000000 10471319936 10806640640 1516051712 15.616 100 90 179 2 1554433504 9382160 28999632
20:00:59 16013 8192000000 10482048176 10824044544 1537300336 15.800 100 84 168 0 1573121680 9745312 26076032
20:01:32 16228 8192000000 10504185376 10849755136 1559378512 15.991 100 84 168 1 1595737216 10223968 26134736
20:02:01 12639 8192000000 10518896784 10870603776 1581157600 16.178 100 78 156 0 1615987056 10235920 24593536
20:02:22 11212 8192000000 10537187584 10892103680 1603314048 16.368 100 73 146 0 1635202000 10306704 21581248
20:02:41 10108 8192000000 10552778608 10911580160 1617672256 16.490 100 77 154 0 1651261088 10557376 23031456
20:03:00 20203 8192000000 10572812848 10932027392 1628761904 16.584 100 79 158 0 1663854528 11170640 23921984
20:03:30 14859 8192000000 10602402560 10957922304 1653429296 16.793 100 87 174 2 1690898592 12698752 24770544
20:03:55 13169 8192000000 10610403936 10976915456 1669770464 16.931 100 83 166 1 1706754192 12907488 24076240
20:04:15 8785 8192000000 10621173984 10992144384 1688152176 17.086 100 72 144 1 1720970736 12624896 20193664
20:04:31 8615 8192000000 10647525728 11015454720 1705440192 17.231 100 82 162 0 1741630352 12967216 23222944
20:04:47 4876 8192000000 10668150208 11037810688 1722092224 17.370 100 84 165 1 1758822240 13436464 23293552
20:04:59 6471 8192000000 10678358608 11051479040 1740975408 17.527 100 84 168 3 1779047664 14028848 24043408
20:05:12 6341 8192000000 10694410464 11065778176 1748598304 17.590 100 83 165 2 1785782592 13849536 23334752
20:05:25 6406 8192000000 10689490192 11071913984 1756397968 17.655 100 78 154 0 1791188128 13233872 21556288
20:05:39 5844 8192000000 10710490896 11091140608 1772511808 17.788 100 86 171 1 1808952736 12738736 23702192
20:05:52 4060 8192000000 10719426784 11094159360 1777132576 17.826 100 87 173 0 1815900736 14231088 24537072
20:06:02 3466 8192000000 10725326912 11105984512 1784645424 17.888 100 91 182 1 1824769056 14685376 25438256
20:06:12 3052 8192000000 10721237120 11103096832 1789889888 17.931 100 86 173 0 1828504832 15160128 23454816
20:06:21 4027 8192000000 10743907344 11126784000 1800186928 18.015 100 89 177 1 1837851488 13071392 24593168
20:06:32 2260 8192000000 10747485296 11128430592 1804594080 18.052 100 85 167 1 1842384096 14293616 23496400
20:06:41 9508 8192000000 10746287168 11134402560 1814083632 18.129 100 77 151 0 1848571680 13641712 20846336
20:06:59 3149 8192000000 10757084464 11143217152 1819718928 18.175 100 77 155 1 1853496640 12131696 21646016
20:07:12 1633 8192000000 10779619296 11165753344 1838643840 18.330 100 80 160 0 1871953152 10482720 22826592
20:07:19 2897 8192000000 10784145488 11170271232 1844886320 18.381 100 92 185 1 1883001040 11353104 26761616
20:07:29 2553 8192000000 10791482448 11177701376 1847849456 18.405 100 81 158 0 1882302432 11892960 22560016
20:07:38 2515 8192000000 10790687296 11180781568 1853096560 18.447 100 88 172 2 1892360496 13837920 25426016
20:07:48 1534 8192000000 10809442400 11195645952 1862622336 18.525 100 96 191 2 1903361376 14131296 26607744
20:07:57 2653 8192000000 10810131872 11198152704 1864611424 18.541 100 92 181 2 1903997856 13858704 25527728
20:08:06 1909 8192000000 10809398656 11196411904 1864297536 18.538 100 88 172 1 1902551232 14685440 23568256
20:08:14 2530 8192000000 10819465472 11206094848 1868331728 18.571 100 93 185 0 1910129936 15497360 26300848
20:08:23 1560 8192000000 10817885136 11205726208 1870302928 18.587 100 93 185 1 1910535040 13394576 26837536
20:08:31 1523 8192000000 10820637184 11209273344 1876795984 18.639 100 96 191 2 1916845536 12905776 27143776
20:08:39 1317 8192000000 10825164336 11213361152 1877885712 18.648 100 98 199 1 1919648816 13423776 28339328
20:08:47 1378 8192000000 10821088992 11212730368 1878595312 18.654 100 91 181 3 1918073536 13585824 25892400
20:08:54 2188 8192000000 10822619376 11212697600 1885347584 18.708 100 95 189 3 1923838400 11849168 26641648
20:09:03 1007 8192000000 10831013936 11225100288 1889155856 18.739 100 94 191 0 1928943360 12873808 26913696
20:09:13 28352 8192000000 10816004496 11224608768 1882587632 18.686 100 49 96 1 1907683328 11389136 13706560
20:09:48 15544 8192000000 10828250896 11228217344 1888479968 18.734 100 62 124 2 1914265840 7233344 18552528
20:10:09 2736 8192000000 10823782832 11235282944 1894337664 18.781 100 70 138 0 1925276464 11065200 19873600
20:10:27 6682 8192000000 10798044400 11228856320 1889447600 18.741 100 31 59 1 1904266768 7154288 7664880
20:10:44 6089 8192000000 10813500912 11235274752 1895019424 18.786 100 31 62 1 1911008976 7343744 8645808
20:10:56 5117 8192000000 10806079760 11234082816 1894555760 18.782 100 30 60 1 1909713040 6385248 8772032
20:11:09 9928 8192000000 10808055408 11235168256 1895379120 18.789 100 25 50 3 1912892096 10372576 7140400
20:11:25 19580 8192000000 10798293648 11233013760 1895806448 18.793 100 18 36 2 1906749264 5702768 5240048
20:11:51 8523 8192000000 10830771024 11242692608 1899616896 18.823 100 31 61 1 1914448688 6365392 8466400
20:12:11 8361 8192000000 10833757824 11245338624 1903032560 18.851 100 39 78 2 1922311120 7674704 11603856
20:12:26 69443 8192000000 10822757136 11256508416 1907615520 18.888 100 39 78 4 1924110944 5981568 10513856
20:13:42 7469 8192000000 10816642032 11250700288 1908321200 18.893 100 33 66 4 1924199184 6139792 9738192
20:13:57 7115 8192000000 10822318336 11251843072 1906630272 18.880 100 25 50 2 1919766032 6314864 6820896
20:14:11 5833 8192000000 10823344832 11255603200 1909120768 18.900 100 19 38 0 1920558288 6383648 5053872
20:14:25 3148 8192000000 10824624560 11255824384 1909923120 18.906 100 33 65 1 1927457008 8368080 9165808
20:14:36 7344 8192000000 10817326816 11259097088 1908485616 18.894 100 26 53 1 1926526736 10999088 7042032
20:14:51 7603 8192000000 10823484992 11261952000 1911866832 18.922 100 28 56 1 1931156704 11383424 7906448
20:15:05 4933 8192000000 10841993888 11267883008 1912805280 18.929 100 27 54 0 1930163840 10070864 7287696
20:15:17 5256 8192000000 10830406160 11264454656 1912747456 18.929 100 18 36 1 1923956096 6263520 4945120
20:15:32 6156 8192000000 10826871328 11258777600 1899678624 18.824 99 34 68 1 1916259136 6991440 9589072
20:15:49 11634 8192000000 10829459808 11258535936 1911661520 18.920 100 26 50 1 1929453712 10688880 7103312
20:16:12 13543 8192000000 10801696512 11230978048 1879976544 18.665 99 18 36 1 1890805920 5463664 5365712
20:16:32 10167 8192000000 10814926960 11251122176 1902168352 18.844 100 16 30 2 1916616768 10036128 4412288
20:16:52 67134 8192000000 10775721632 11213676544 1830406544 18.263 96 34 68 0 1849480752 9319264 9754944
20:18:05 8238 8192000000 10797802256 11228073984 1888416256 18.733 100 23 46 3 1900085856 5126096 6543504
20:18:20 4548 8192000000 10777440208 11209334784 1858540512 18.491 99 36 72 1 1874987408 6075424 10371472
20:18:30 13669 8192000000 10758414384 11180027904 1798716288 18.003 96 27 54 0 1812635088 5690400 8228400
20:18:53 10482 8192000000 10762306288 11181625344 1827344848 18.238 98 28 56 1 1842780656 7126976 8308832
20:19:11 12064 8192000000 10747925760 11168784384 1770620400 17.772 96 23 46 2 1782938768 5841584 6476784
20:19:30 6440 8192000000 10745110816 11168280576 1813563568 18.125 99 15 30 1 1823755792 5522720 4669504
20:19:44 7796 8192000000 10740870656 11163488256 1823899104 18.210 99 24 48 0 1837310432 6934512 6476816
20:20:02 9559 8192000000 10741056928 11163815936 1779827104 17.848 97 25 49 2 1792820768 6211280 6782384
20:20:18 14572 8192000000 10705637440 11127062528 1695853696 17.150 93 22 42 1 1706985072 5087840 6043536
20:20:39 9466 8192000000 10694024864 11109482496 1737760864 17.500 96 20 40 1 1749224976 5694432 5769680
20:20:58 11909 8192000000 10719793344 11141103616 1787400976 17.910 99 23 47 0 1804563456 9992368 7170112
20:21:16 9691 8192000000 10699671536 11105312768 1741009888 17.527 97 28 56 3 1754252944 5314352 7928704
20:21:33 41532 8192000000 10690503760 11089428480 1712312560 17.288 96 22 42 1 1724225904 5081536 6831808
20:22:23 13020 8192000000 10726015456 11103621120 1739225648 17.512 97 79 165 4 1769367920 6232128 23910144
20:22:42 8979 8192000000 10668079840 11077509120 1702661520 17.207 96 30 58 1 1717140768 5917280 8561968
20:23:00 12902 8192000000 10672687904 11087302656 1716794608 17.325 97 25 50 0 1728842352 5235216 6812528
20:23:19 9745 8192000000 10710738912 11118399488 1759800656 17.683 98 25 50 0 1773418080 5727296 7890128
20:23:37 7801 8192000000 10723140304 11142938624 1808089984 18.080 100 24 48 1 1822333248 6334016 7909248
20:23:53 5238 8192000000 10752553920 11160674304 1820148560 18.179 100 35 68 1 1841001280 11002912 9849808
20:24:06 6824 8192000000 10740664448 11163226112 1825512752 18.223 100 31 63 1 1841310096 6680608 9116736
20:24:20 7672 8192000000 10754447280 11173535744 1842778768 18.363 100 45 90 1 1861648672 5859248 13010656
20:24:34 8442 8192000000 10754005968 11178090496 1838919856 18.332 100 24 48 0 1851674128 5817488 6936784
20:24:49 7193 8192000000 10761672912 11182501888 1844525312 18.378 100 22 44 1 1856257520 5382000 6350208
20:25:07 4417 8192000000 10771802480 11192762368 1854398496 18.458 100 40 79 1 1872394672 5955360 12040816
20:25:20 11468 8192000000 10777005328 11200897024 1855651120 18.468 100 26 52 3 1873057376 9334432 8071824
20:25:37 9933 8192000000 10775897792 11201404928 1861304016 18.514 100 22 44 1 1872506192 4920976 6281200
20:25:53 6699 8192000000 10779210640 11204276224 1861471488 18.515 100 13 26 0 1870346784 5380048 3495248
20:26:06 6015 8192000000 10776401152 11204608000 1862870000 18.527 100 18 36 1 1873555184 5619984 5065200
20:26:18 82662 8192000000 10806920368 11225272320 1871016880 18.593 100 26 52 2 1883370144 4371216 7982048
20:27:50 1965 8192000000 10837186256 11245854720 1899260080 18.820 100 69 139 0 1926644320 6844080 20540160
20:27:59 19931 8192000000 10839282240 11255238656 1906994048 18.883 100 56 112 3 1932466064 10095120 15376896
20:28:28 20464 8192000000 10847574016 11265654784 1913641680 18.936 100 55 110 0 1938898224 10580448 14676096
20:28:57 19792 8192000000 10848478880 11267297280 1915274032 18.949 100 58 115 0 1942300144 10879472 16146640
20:29:23 17074 8192000000 10855067552 11278831616 1925734704 19.033 100 52 104 0 1954890992 14337968 14818320
20:29:52 20070 8192000000 10869913840 11289927680 1936468432 19.119 100 62 123 2 1965210816 11768752 16973632
20:30:42 16537 8192000000 10875759200 11303174144 1940625152 19.152 100 57 114 2 1968844640 12116368 16103120
20:31:12 25817 8192000000 10872592224 11303833600 1942881744 19.170 100 37 72 2 1965479392 11824592 10773056
20:31:54 13492 8192000000 10886024640 11315396608 1950826880 19.233 100 44 88 0 1975450224 11282448 13340896
20:32:18 22671 8192000000 10892430688 11323748352 1956328720 19.277 100 37 74 0 1979236368 11679056 11228592
20:32:50 25574 8192000000 10888965488 11325231104 1962825408 19.328 100 39 76 0 1986410368 11939616 11645344
20:33:22 6284 8192000000 10919220096 11332952064 1969091008 19.378 100 65 129 2 2000529520 12134784 19303728
20:33:36 3185 8192000000 10917348336 11336241152 1970892848 19.393 100 67 130 3 2003785568 13597520 19295200
20:33:52 4376 8192000000 10906388640 11327033344 1953162080 19.252 99 73 144 0 1989904112 16256416 20485616
20:34:25 4423 8192000000 10911125808 11333857280 1968282800 19.372 100 60 119 3 2002850272 17592224 16975248
20:34:38 6647 8192000000 10919384816 11341074432 1972648096 19.406 100 63 125 0 2009103008 17423632 19031280
20:34:52 24174 8192000000 10915105504 11344150528 1954227328 19.260 99 56 112 0 1989617216 18585264 16804624
20:35:39 8805 8192000000 10917060672 11344846848 1966781456 19.360 100 55 108 1 2003781008 20157792 16841760
20:35:57 8378 8192000000 10917499440 11344596992 1964865792 19.345 100 54 106 3 2001872240 21155728 15850720
20:36:16 11583 8192000000 10915531808 11352096768 1969473872 19.381 100 53 105 2 2007565568 22386192 15705504
20:36:39 14715 8192000000 10936399456 11363500032 1986159936 19.513 100 71 142 1 2031038496 23802944 21075616
20:37:05 8212 8192000000 10943269520 11368763392 1978667568 19.454 100 57 114 0 2023884256 27738768 17477920
20:37:26 11956 8192000000 10924622448 11359989760 1969399024 19.381 100 55 110 0 2016250688 29923376 16928288
20:37:45 10115 8192000000 10922139744 11362615296 1974075808 19.418 100 49 98 1 2017802128 28150480 15575840
20:38:03 4721 8192000000 10932021088 11354832896 1962827536 19.329 99 62 123 0 2007808800 26552080 18429184
20:38:15 10319 8192000000 10925640192 11355402240 1960135584 19.307 99 59 116 1 2001954368 24456144 17362640
20:38:33 4487 8192000000 10947415600 11369517056 1983773776 19.495 100 71 142 0 2030298256 25126960 21397520
20:38:47 17393 8192000000 10929027216 11354595328 1970314240 19.388 99 67 133 1 2016866704 27119232 19433232
20:39:12 4979 8192000000 10948890240 11377225728 1989185312 19.537 100 62 124 3 2035350944 27440864 18724768
20:39:26 1311 8192000000 10965944000 11388911616 1999736512 19.621 100 73 146 2 2048168880 25562896 22869472
20:39:34 4951 8192000000 10956725536 11384590336 1996581472 19.596 100 63 126 2 2042919056 26414912 19922672
20:39:46 2649 8192000000 10958978192 11385823232 1996172880 19.593 100 69 138 1 2044927168 27032704 21721584
20:39:56 890 8192000000 10969277424 11387232256 2001590384 19.635 100 91 182 1 2056280912 26872256 27818272
20:40:05 5185 8192000000 10965414032 11386511360 1995055808 19.584 100 72 143 1 2046912400 29634400 22222192
20:40:17 2563 8192000000 10973521024 11391787008 2002911568 19.646 100 81 158 0 2055937280 28828048 24197664
20:40:27 10674 8192000000 10935307696 11370668032 1967438096 19.365 99 54 108 0 2014325856 29678784 17208976
20:40:46 1693 8192000000 10941246320 11367337984 1976409792 19.436 100 66 131 2 2026462112 29653024 20399296
20:41:03 5109 8192000000 10933649200 11358826496 1953243424 19.252 99 67 134 0 2004874896 30246784 21384688
20:41:16 4929 8192000000 10932667840 11361697792 1970599520 19.390 100 63 124 2 2021894848 31947648 19347680
20:41:31 5341 8192000000 10937169984 11366989824 1958544864 19.294 99 66 133 0 2016405312 37418592 20441856
20:41:45 5735 8192000000 10933939280 11363966976 1973687392 19.415 100 79 156 3 2031718064 34209952 23820720
20:41:59 4593 8192000000 10941122704 11370274816 1973342160 19.412 100 56 112 2 2025441296 34817248 17281888
20:42:12 5513 8192000000 10940735824 11361542144 1941069792 19.155 98 78 156 0 2001369648 36027408 24272448
20:42:24 4268 8192000000 10945410304 11367612416 1970304176 19.388 100 71 140 1 2029642944 37662880 21675888
20:42:36 3082 8192000000 10960688448 11374776320 1978662208 19.454 100 82 164 1 2042533728 38386992 25484528
20:42:45 1592 8192000000 10957724928 11369140224 1974054288 19.418 100 97 193 0 2040792800 36952128 29786384
20:42:54 5919 8192000000 10941029408 11364147200 1955504640 19.270 99 71 142 0 2015313760 37978416 21830704
20:43:08 1627 8192000000 10942103072 11357351936 1959323888 19.301 99 89 174 2 2023391344 37307008 26760448
20:43:16 2553 8192000000 10952837472 11378601984 1979266608 19.459 100 76 151 0 2040485792 37708896 23510288
20:43:26 4551 8192000000 10956148736 11380379648 1983424704 19.492 100 65 128 0 2037953312 34850784 19677824
20:43:41 4869 8192000000 10951916864 11370110976 1976324240 19.436 100 71 135 1 2033790480 36788896 20677344
20:43:52 2010 8192000000 10967108336 11376619520 1968074288 19.370 99 86 170 1 2028939248 35636512 25228448
20:44:01 1809 8192000000 10981154800 11388338176 1990091760 19.545 100 95 191 0 2056845312 37014560 29738992
20:44:13 2007 8192000000 10985517424 11399110656 1998712368 19.613 100 84 166 1 2062317056 38936256 24668432
20:44:21 2443 8192000000 10950169840 11372642304 1971802576 19.400 100 75 151 1 2034011952 38921664 23287712
20:44:30 9389 8192000000 10916319488 11349692416 1949665472 19.224 99 47 94 0 2001731696 36728640 15337584
20:44:50 16892 8192000000 10919186720 11362414592 1948554432 19.215 99 40 77 2 1998134752 35798400 13781920
20:45:16 7259 8192000000 10936561536 11361992704 1958530656 19.294 100 47 94 1 2013561344 38987424 16043264
20:45:35 4148 8192000000 10946128000 11362021376 1948347168 19.213 99 75 145 2 2013793056 41946992 23498896
20:45:47 3362 8192000000 10958226176 11377766400 1971334576 19.396 100 81 159 2 2038245040 42084064 24826400
20:45:57 4210 8192000000 10946914240 11363065856 1957165008 19.284 99 72 144 4 2022886576 43431056 22290512
20:46:11 4813 8192000000 10958725856 11373903872 1968679360 19.375 100 81 162 2 2038442752 44839568 24923824
20:46:26 2196 8192000000 10968259200 11376508928 1968489280 19.373 100 90 179 0 2042141328 45645024 28007024
20:46:36 2233 8192000000 10971234048 11385241600 1974722016 19.423 100 86 168 1 2048426320 47131424 26572880
20:46:48 1917 8192000000 10955499232 11363897344 1955132800 19.267 99 91 182 0 2031727248 48601744 27992704
20:46:57 5087 8192000000 10964494144 11389267968 1973270176 19.411 100 84 168 1 2050897968 50826688 26801104
20:47:09 3209 8192000000 10957451728 11380121600 1970574208 19.390 100 74 147 1 2038286064 45245104 22466752
20:47:21 7564 8192000000 10934988992 11383029760 1970532672 19.390 100 56 112 1 2029618832 41801664 17284496
20:47:42 9998 8192000000 10944306768 11370004480 1955320688 19.269 99 49 98 1 2009092768 38236640 15535440
20:47:59 3050 8192000000 10966971280 11379523584 1977305408 19.443 100 80 161 1 2041434528 39807696 24321424
20:48:09 1935 8192000000 10956869376 11375595520 1969247280 19.379 100 82 163 0 2038720112 43665696 25807136
20:48:20 1496 8192000000 10959053664 11377561600 1970612400 19.390 100 80 160 0 2042704816 46741152 25351264
20:48:30 3874 8192000000 10965716688 11384872960 1977754464 19.447 100 79 158 0 2045296352 42816224 24725664
20:48:43 6517 8192000000 10944889824 11381149696 1971818032 19.400 100 52 104 0 2031295808 42542432 16935344
20:49:04 10334 8192000000 10925469872 11373203456 1960577520 19.311 100 40 80 1 2018347296 43499152 14270624
20:49:37 12678 8192000000 10917723936 11367407616 1934925744 19.106 98 38 75 2 1986444112 38791056 12727312
20:49:57 13828 8192000000 10937928784 11380994048 1972126640 19.402 100 46 92 3 2025226608 37899280 15200688
20:50:33 14564 8192000000 10890192656 11336077312 1920422640 18.990 99 30 57 0 1963566880 33547664 9596576
20:50:54 18973 8192000000 10899791200 11345420288 1942253296 19.165 100 25 50 0 1983593984 33054608 8286080
20:51:20 36512 8192000000 10884146384 11315613696 1862455392 18.523 96 37 74 0 1905621040 31606720 11558928
20:52:04 10166 8192000000 10867118208 11319128064 1913541584 18.935 100 32 64 0 1958613264 34784624 10287056
20:52:24 17889 8192000000 10881901600 11329290240 1923840128 19.018 100 23 46 1 1964275520 32496048 7939344
20:52:50 13600 8192000000 10880406848 11338534912 1927890144 19.050 100 15 30 3 1968940240 35742240 5307856
20:53:23 29825 8192000000 10888211472 11335737344 1907242688 18.885 99 19 38 1 1951433248 37554208 6636352
20:54:03 27507 8192000000 10872063152 11335852032 1926659856 19.040 100 17 34 1 1969632832 37251008 5721968
20:54:54 34670 8192000000 10878550800 11341045760 1917626112 18.968 100 14 28 1 1955626448 33163280 4837056
20:56:50 81499 8192000000 10871561664 11343564800 1937505824 19.127 100 8 15 0 1956215360 16477248 2232288
20:58:19 171629 8192000000 10893070144 11330211840 1858404304 18.490 95 15 30 0 1873231408 11345360 3481744
21:02:03 79334 8192000000 10870283120 11333386240 1892435168 18.765 97 9 18 1 1908036704 13159072 2442464
21:03:28 66053 8192000000 10880172816 11324338176 1909249488 18.901 98 26 50 1 1926471648 10868192 6353968
21:04:53 92922 8192000000 10890220800 11340652544 1949127312 19.220 100 34 66 0 1965628944 6856464 9645168
21:06:35 49788 8192000000 10861742176 11302248448 1900440736 18.830 97 32 64 2 1916876480 7224400 9211344
21:07:33 22128 8192000000 10899721472 11338039296 1951461088 19.238 100 47 94 0 1974015088 9067632 13486368
21:08:03 122901 8192000000 10876325360 11322859520 1900580912 18.831 97 32 64 0 1917834352 7416896 9836544
21:10:12 2750 8192000000 10914373840 11343155200 1946657760 19.200 99 70 140 1 1977223408 11206832 19358816
21:10:24 10875 8192000000 10917805312 11363319808 1971689392 19.399 100 50 100 1 2002496176 16736720 14070064
21:10:46 31395 8192000000 10902054896 11365122048 1972992880 19.409 100 33 66 4 2000291760 17529840 9769040
21:11:40 25897 8192000000 10908309536 11366862848 1951755376 19.240 99 27 54 0 1976032704 15897248 8380080
21:12:12 23107 8192000000 10952545392 11382591488 1985678976 19.510 100 56 111 2 2019287280 16493952 17114352
21:12:43 36739 8192000000 10904841504 11384897536 1978494208 19.453 100 48 95 2 2018374720 24714544 15165968
21:15:22 45558 8192000000 10895960544 11360366592 1953507632 19.254 99 12 24 0 1968439552 11798912 3133008
21:16:14 58170 8192000000 10887000432 11362615296 1951508160 19.238 99 14 28 0 1972730128 16963344 4258624
21:17:19 62658 8192000000 10861618416 11340677120 1924179568 19.020 98 13 26 0 1946724816 18040336 4504912
21:18:36 52908 8192000000 10884497856 11361148928 1937175920 19.124 99 10 20 0 1957634976 17394784 3064272
21:19:41 25161 8192000000 10898040176 11342467072 1920096304 18.988 98 23 46 0 1935742512 9390240 6255968
21:20:13 17386 8192000000 10886461968 11343433728 1940659520 19.152 99 50 101 2 1966049520 9974896 15415104
21:20:41 53241 8192000000 10911236864 11355922432 1939770384 19.145 99 26 52 1 1962210288 14927552 7512352
21:21:44 17905 8192000000 10911196176 11362697216 1967410768 19.365 100 48 94 1 1993133808 12767856 12955184
21:22:18 51522 8192000000 10899035200 11363545088 1931182640 19.076 98 19 38 1 1951014064 14084560 5746864
21:23:29 66553 8192000000 10879224336 11362009088 1901716016 18.840 97 17 32 1 1925970624 19351968 4902640
21:25:08 70194 8192000000 10867797728 11339341824 1867810064 18.567 96 9 18 0 1883146288 12810528 2525696
21:26:24 72297 8192000000 10890218144 11360202752 1935332976 19.109 99 17 34 0 1954142864 14085504 4724384
21:27:44 69832 8192000000 10922782288 11358138368 1904938992 18.866 97 13 24 1 1917532256 9616928 2976336
21:29:05 29642 8192000000 10899016144 11361210368 1951585408 19.239 99 40 80 1 1974155856 10935424 11635024
21:29:56 82427 8192000000 10887830816 11357204480 1923718976 19.017 98 16 32 2 1938715984 10754704 4242304
21:31:54 76052 8192000000 10873293952 11341537280 1900051776 18.827 97 13 26 0 1912921504 9040864 3828864
21:33:33 24338 8192000000 10882953552 11352322048 1951356496 19.237 100 18 36 1 1972263232 16136688 4770048
21:34:03 19656 8192000000 10864261376 11316862976 1884216288 18.699 97 34 68 0 1904685072 11207968 9260816
21:34:30 4984 8192000000 10880235888 11326554112 1936206480 19.116 100 60 121 3 1965628864 12533968 16888416
21:34:45 37881 8192000000 10862466768 11346931712 1946149520 19.196 100 36 72 3 1973280816 16208368 10922928
21:35:46 67307 8192000000 10827108624 11301294080 1811352224 18.107 93 22 42 1 1831555424 13660288 6542912
21:37:00 37884 8192000000 10853851632 11320377344 1887045008 18.722 98 15 30 0 1905430336 14087840 4297488
21:37:48 54651 8192000000 10837396240 11316146176 1894229600 18.780 98 20 40 2 1912878960 12702096 5947264
21:39:58 78555 8192000000 10867727744 11334725632 1925859920 19.034 100 25 49 0 1948728304 16379168 6489216
21:42:43 40941 8192000000 10848130096 11314008064 1899744800 18.824 99 14 28 0 1914428256 10745936 3937520
21:43:41 16413 8192000000 10848972352 11304542208 1901570048 18.839 99 36 73 1 1920214752 8500560 10144144
21:44:05 15407 8192000000 10842612736 11300937728 1896653712 18.799 99 28 56 2 1912880176 8554976 7671488
21:44:29 55732 8192000000 10858408928 11320721408 1919823472 18.985 100 29 58 0 1939348800 11746272 7779056
21:45:33 23877 8192000000 10871215408 11320541184 1931750560 19.081 100 57 115 1 1957830160 9004352 17075248
21:46:07 29442 8192000000 10867656736 11325980672 1918101552 18.972 99 28 56 2 1937768640 11815616 7851472
21:46:44 25313 8192000000 10859433680 11319635968 1898867920 18.817 98 34 68 1 1924164672 15713584 9583168
21:47:16 45835 8192000000 10861667632 11334578176 1912266608 18.925 99 29 58 1 1938534144 17701568 8565968
21:48:40 42649 8192000000 10837803360 11307245568 1862209904 18.521 97 16 32 0 1887057776 19453904 5393968
21:49:32 31927 8192000000 10841633744 11281170432 1870739888 18.590 98 46 91 0 1898256640 14460208 13056544
21:50:12 60214 8192000000 10858375424 11308212224 1902080336 18.843 99 24 48 0 1921198400 12355968 6762096
21:51:23 18646 8192000000 10879380288 11323985920 1910302512 18.909 99 46 89 1 1930866464 8779664 11784288
21:52:05 84332 8192000000 10853451328 11340771328 1889721072 18.744 98 20 39 0 1912746272 17221424 5803776
21:53:35 42821 8192000000 10868325152 11337080832 1932184016 19.084 100 19 38 2 1949323312 12097936 5041360
21:54:24 43726 8192000000 10886677344 11346845696 1951078768 19.235 100 18 36 0 1970714208 14993152 4642288
21:55:14 117400 8192000000 10866812992 11326476288 1909394656 18.902 98 23 46 0 1928025648 12016976 6614016
21:57:18 61600 8192000000 10897522656 11353829376 1947905072 19.210 99 29 58 1 1964029248 8482112 7642064
21:58:26 30525 8192000000 10893165968 11355049984 1946783024 19.201 99 27 54 0 1962987888 8917984 7286880
21:59:18 77422 8192000000 10859011136 11349315584 1918984928 18.979 98 13 26 1 1935748512 13293760 3469824
22:00:41 26242 8192000000 10866253584 11355353088 1948056512 19.211 100 6 12 0 1961446432 11698848 1691072
22:01:18 8772 8192000000 10864837168 11355541504 1948702976 19.216 100 4 8 0 1961573408 11808480 1061952
22:02:06 56965 8192000000 10869070032 11352109056 1934404928 19.102 99 13 26 0 1947185360 9145632 3634800
22:03:09 58226 8192000000 10897834816 11372814336 1955186384 19.268 99 20 38 0 1970488064 9146016 6155664
22:04:14 29326 8192000000 10903217856 11373998080 1975668864 19.430 100 24 48 1 1992539264 10000592 6869808
22:04:52 58432 8192000000 10910249008 11391586304 1979710656 19.462 100 16 32 0 1998475248 13806528 4958064
22:05:57 56367 8192000000 10899391312 11381932032 1942247456 19.165 98 17 34 0 1963579648 17059392 4272800
22:07:04 89353 8192000000 10909515680 11399680000 1981847936 19.479 100 15 30 0 2001372640 15282176 4242528
22:08:49 138424 8192000000 10883287392 11350528000 1824223392 18.212 92 11 22 0 1841970912 14200880 3546640
22:11:17 59328 8192000000 10907908400 11381137408 1947593360 19.207 99 18 36 0 1965739440 13077936 5068144
22:12:22 36847 8192000000 10917628880 11384766464 1955580128 19.271 99 23 46 0 1978863856 16313952 6969776
22:13:09 84628 8192000000 10888475088 11382149120 1909177216 18.900 97 7 14 0 1933372832 22243600 1952016
22:14:45 118930 8192000000 10859981568 11331252224 1887078000 18.722 96 11 22 2 1901916368 11838576 2999792
22:16:50 85073 8192000000 10815756608 11282939904 1842250656 18.359 94 25 50 0 1857330512 8639008 6440848
22:18:47 65527 8192000000 10852829632 11344056320 1924903728 19.026 99 11 22 0 1936698624 8730144 3064752
22:19:58 40964 8192000000 10844541392 11330756608 1916147696 18.956 99 5 10 0 1926218080 8831696 1238688
22:21:02 25622 8192000000 10831499408 11309678592 1887048608 18.722 98 12 24 0 1897230400 6805824 3375968
22:21:39 28692 8192000000 10856155952 11331854336 1931805680 19.081 100 12 24 0 1942741920 6764720 4171520
22:22:16 57348 8192000000 10838722048 11316129792 1868312768 18.571 96 18 37 2 1881013568 7024144 5676656
22:23:30 69699 8192000000 10847117232 11331088384 1887373504 18.725 98 14 28 1 1902971888 11963392 3634992
22:25:10 28398 8192000000 10825913520 11293110272 1842560608 18.362 96 17 34 1 1853244672 6083152 4600912
22:25:53 21494 8192000000 10832740848 11304087552 1906997056 18.883 100 26 52 1 1922066496 7503424 7566016
22:26:25 19865 8192000000 10836783024 11299151872 1888650224 18.735 99 24 48 2 1902012800 6882384 6480192
22:26:53 26998 8192000000 9525512880 9844465664 677681120 7.640 36 17 31 1 686632400 4425536 4525744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 05-02-2021 22:28:44 to 05-02-2021 22:29:16.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-02-2021 22:29:16 to 05-02-2021 22:29:18.

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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:32: 
:33: mscs-test-161.budzdorov.ru    Fri Feb  5 22:27:22 2021
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
:36: 
:37: mscs-test-161.budzdorov.ru    Fri Feb  5 22:27:25 2021
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:39: 
--- end of diff output ---

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

05.02.21 22:29:19. 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-02-05 22:29:22 No severe PSQL-related problems occured
05.02.21 22:29:23. End of report.