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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17520952 kB
MemAvailable 31514036 kB
Buffers 0 kB
Cached 14203364 kB
SwapCached 3696 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 2020-12-22 16:27:09
DTS_END                         2020-12-22 16:27:09.5080
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60764
TRN_ID                          249272
ATT_ID                          685
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: 9350.25 21296 1122030
customer order: creation 171.88 337 20626
customer order: refuse 14.58 284 1749
order to supplier: creation 46.33 1177 5559
order to supplier: removal 3.60 64419 432
invoice (draft): creation 47.15 3190 5658
invoice (draft): removal 53.36 600 6403
invoice accept: apply 42.07 15255 5048
invoice accept: cancel 48.28 627 5794
customer reserve: creation 3860.89 152 463307
customer reserve: removal 4753.84 37 570461
realization accept: apply 86.53 174 10384
realization accept: cancel 91.26 87 10951
payment from customer: creation 59.53 123 7143
payment from customer: removal 5.73 84 687
payment to supplier: creation 49.33 137 5919
payment to supplier: removal 3.49 51 419
service: total inventory turnovers 5.18 1011 621
service: total monetary turnovers 6.34 17 761
service: aggregate perf. data 0.87 17373 104
service: refresh index statistics 0.03 320779 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-12-2020 16:28:38 to 22-12-2020 16:28:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4833
TEST_TIME 2 5036
TEST_TIME 3 4518
TEST_TIME 4 4936
TEST_TIME 5 4575
TEST_TIME 6 4666
TEST_TIME 7 5153
TEST_TIME 8 5230
TEST_TIME 9 5631
TEST_TIME 10 6399
TEST_TIME 11 7754
TEST_TIME 12 9345
TEST_TIME 13 9803
TEST_TIME 14 10079
TEST_TIME 15 10331
TEST_TIME 16 10451
TEST_TIME 17 10461
TEST_TIME 18 10181
TEST_TIME 19 10173
TEST_TIME 20 9874
TEST_TIME 21 9788
TEST_TIME 22 9678
TEST_TIME 23 9855
TEST_TIME 24 9851
TEST_TIME 25 9775
TEST_TIME 26 9707
TEST_TIME 27 9589
TEST_TIME 28 9804
TEST_TIME 29 9661
TEST_TIME 30 9844
TEST_TIME 31 9632
TEST_TIME 32 9794
TEST_TIME 33 9991
TEST_TIME 34 9926
TEST_TIME 35 9935
TEST_TIME 36 10148
TEST_TIME 37 10044
TEST_TIME 38 10311
TEST_TIME 39 10228
TEST_TIME 40 10242
TEST_TIME 41 10526
TEST_TIME 42 10520
TEST_TIME 43 10296
TEST_TIME 44 10161
TEST_TIME 45 10255
TEST_TIME 46 10179
TEST_TIME 47 10152
TEST_TIME 48 10049
TEST_TIME 49 10006
TEST_TIME 50 9967
TEST_TIME 51 9827
TEST_TIME 52 9716
TEST_TIME 53 9749
TEST_TIME 54 9856
TEST_TIME 55 9805
TEST_TIME 56 9843
TEST_TIME 57 9931
TEST_TIME 58 9940
TEST_TIME 59 10052
TEST_TIME 60 9999
TEST_TIME 61 9997
TEST_TIME 62 10162
TEST_TIME 63 10212
TEST_TIME 64 10215
TEST_TIME 65 10285
TEST_TIME 66 10219
TEST_TIME 67 10148
TEST_TIME 68 10038
TEST_TIME 69 10008
TEST_TIME 70 9958
TEST_TIME 71 9887
TEST_TIME 72 9818
TEST_TIME 73 9787
TEST_TIME 74 9761
TEST_TIME 75 9732
TEST_TIME 76 9686
TEST_TIME 77 9615
TEST_TIME 78 9650
TEST_TIME 79 9654
TEST_TIME 80 9640
TEST_TIME 81 9632
TEST_TIME 82 9721
TEST_TIME 83 9694
TEST_TIME 84 9729
TEST_TIME 85 9761
TEST_TIME 86 9705
TEST_TIME 87 9824
TEST_TIME 88 9812
TEST_TIME 89 9822
TEST_TIME 90 9880
TEST_TIME 91 9903
TEST_TIME 92 9804
TEST_TIME 93 9744
TEST_TIME 94 9729
TEST_TIME 95 9657
TEST_TIME 96 9584
TEST_TIME 97 9539
TEST_TIME 98 9601
TEST_TIME 99 9622
TEST_TIME 100 9609
TEST_TIME 101 9579
TEST_TIME 102 9602
TEST_TIME 103 9687
TEST_TIME 104 9675
TEST_TIME 105 9683
TEST_TIME 106 9699
TEST_TIME 107 9679
TEST_TIME 108 9691
TEST_TIME 109 9731
TEST_TIME 110 9687
TEST_TIME 111 9626
TEST_TIME 112 9596
TEST_TIME 113 9554
TEST_TIME 114 9547
TEST_TIME 115 9508
TEST_TIME 116 9479
TEST_TIME 117 9436
TEST_TIME 118 9425
TEST_TIME 119 9410
TEST_TIME 120 9352

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-12-2020 16:28:42 to 22-12-2020 16:28:45.

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 1552142 1552142 0 0.00 0 24232 5 0 0
doc_list_biud 1552138 1552138 0 0.00 0 51526 18 0 0
sp_add_invoice_to_stock 5155 5048 107 2.07 32 144963 15255 0 107
sp_cancel_adding_invoice 5794 5794 0 0.00 5 52152 628 0 0
sp_cancel_client_order 1749 1749 0 0.00 4 10549 284 0 0
sp_cancel_customer_reserve 570461 570461 0 0.00 1 26549 37 0 0
sp_cancel_pay_from_customer 687 687 0 0.00 3 6149 84 0 0
sp_cancel_pay_to_supplier 419 419 0 0.00 3 5155 51 0 0
sp_cancel_supplier_invoice 6416 6403 13 0.20 2 51533 600 0 13
sp_cancel_supplier_order 432 432 0 0.00 6 715540 64420 0 0
sp_cancel_write_off 10951 10951 0 0.00 1 24090 87 0 0
sp_client_order 20626 20626 0 0.00 3 26362 338 0 0
sp_customer_reserve 463307 463307 0 0.00 0 106115 152 0 0
sp_fill_shopping_cart 31833 31833 0 0.00 1 15072 37 0 0
sp_fill_shopping_cart_clo_res 463305 463305 0 0.00 0 23721 14 0 0
sp_get_clo_for_invoice 5043 5043 0 0.00 0 35012 324 0 0
sp_kill_cost_storno 17851 17851 0 0.00 0 12588 38 0 0
sp_kill_qstorno_ret_qs2qd 1158708 1158708 0 0.00 0 51523 21 0 0
sp_kill_qty_storno 611215 611215 0 0.00 0 51525 46 0 0
sp_lock_selected_doc 21226 21226 0 0.00 0 8053 5 0 0
sp_make_cost_storno 28488 28488 0 0.00 0 17542 56 0 0
sp_multiply_rows_for_pdistr 28486 28486 0 0.00 0 12335 26 0 0
sp_multiply_rows_for_qdistr 20626 20626 0 0.00 0 14448 146 0 0
sp_pay_from_customer 7143 7143 0 0.00 4 21614 123 0 0
sp_pay_to_supplier 5919 5919 0 0.00 5 17547 138 0 0
sp_payment_common 13060 13060 0 0.00 1 12373 40 0 0
sp_qd_handle_on_cancel_clo 1749 1749 0 0.00 0 10544 251 0 0
sp_qd_handle_on_invoice_upd_sts 10835 10835 0 0.00 0 26488 268 0 0
sp_qd_handle_on_reserve_upd_sts 10384 10384 0 0.00 0 11016 53 0 0
sp_reserve_write_off 10384 10384 0 0.00 6 21542 175 0 0
sp_supplier_invoice 5658 5658 0 0.00 4 82011 3190 0 0
sp_supplier_order 5559 5559 0 0.00 5 39900 1177 0 0
srv_aggregate_perf_data 105 104 1 0.95 2954 151697 17374 0 1
srv_fill_mon_cache_memory 124 124 0 0.00 1068 154237 44026 0 0
srv_find_qd_qs_mism 1074600 1074600 0 0.00 0 24230 4 0 0
srv_make_invnt_saldo 621 621 0 0.00 41 36936 1011 0 0
srv_make_money_saldo 761 761 0 0.00 0 701 18 0 0
srv_recalc_idx_stat 4 4 0 0.00 262758 442673 320780 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 13 13 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5048 5048 0 0.00 0 16372 144 0 0
t$perf-norm:sp_cancel_adding_invoice 445 445 0 0.00 0 9738 132 0 0
t$perf-norm:sp_cancel_client_order 1749 1749 0 0.00 0 5037 16 0 0
t$perf-norm:sp_cancel_customer_reserve 693 693 0 0.00 0 6629 26 0 0
t$perf-norm:sp_cancel_pay_from_customer 687 687 0 0.00 0 6316 26 0 0
t$perf-norm:sp_cancel_pay_to_supplier 419 419 0 0.00 0 3574 27 0 0
t$perf-norm:sp_cancel_supplier_invoice 415 415 0 0.00 0 4107 24 0 0
t$perf-norm:sp_cancel_supplier_order 432 432 0 0.00 0 16811 1218 0 0
t$perf-norm:sp_cancel_write_off 961 961 0 0.00 0 6306 10 0 0
t$perf-norm:sp_client_order 20626 20626 0 0.00 0 6393 13 0 0
t$perf-norm:sp_customer_reserve 970 970 0 0.00 0 1455 4 0 0
t$perf-norm:sp_pay_from_customer 7143 7143 0 0.00 0 16271 11 0 0
t$perf-norm:sp_pay_to_supplier 5919 5919 0 0.00 0 5759 10 0 0
t$perf-norm:sp_reserve_write_off 10384 10384 0 0.00 0 13343 14 0 0
t$perf-norm:sp_supplier_invoice 5658 5658 0 0.00 0 11619 19 0 0
t$perf-norm:sp_supplier_order 5559 5559 0 0.00 0 4417 11 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 368 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 124 124 0 0.00 0 8948 80 0 0
t$perf-norm:srv_make_invnt_saldo 621 621 0 0.00 0 5022 20 0 0
t$perf-norm:srv_make_money_saldo 761 761 0 0.00 0 4689 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 4 0 0
v_add_invoice_to_stock 10296 10082 214 2.07 0 9479 17 0 214
v_all_customers 37568 37568 0 0.00 0 103 0 0 0
v_all_suppliers 30998 30998 0 0.00 0 99 1 0 0
v_all_wares 41252 41252 0 0.00 0 54 1 0 0
v_cancel_adding_invoice 890 890 0 0.00 0 6002 15 0 0
v_cancel_client_order 3498 3498 0 0.00 0 7178 10 0 0
v_cancel_customer_prepayment 1374 1374 0 0.00 0 5613 14 0 0
v_cancel_customer_reserve 1386 1386 0 0.00 0 1626 6 0 0
v_cancel_payment_to_supplier 838 838 0 0.00 0 170 2 0 0
v_cancel_supplier_invoice 856 830 26 3.03 0 1361 15 0 26
v_cancel_supplier_order 864 864 0 0.00 0 2102 7 0 0
v_cancel_write_off 1922 1922 0 0.00 0 1371 12 0 0
v_max_id_clo_ord 5559 5559 0 0.00 0 1323 1 0 0
v_max_id_clo_res 970 970 0 0.00 0 5755 13 0 0
v_max_id_ord_sup 5648 5648 0 0.00 0 5807 3 0 0
v_max_non_paid_invoice 1625 1625 0 0.00 0 1504 3 0 0
v_max_non_paid_realizn 3820 3820 0 0.00 0 1621 3 0 0
v_min_id_clo_ord 5559 5559 0 0.00 0 8456 11 0 0
v_min_id_clo_res 970 970 0 0.00 0 2100 13 0 0
v_min_id_ord_sup 5648 5648 0 0.00 0 2818 3 0 0
v_min_non_paid_invoice 5917 5917 0 0.00 0 12070 31 0 0
v_min_non_paid_realizn 7143 7143 0 0.00 0 12065 33 0 0
v_our_firm 10330 10330 0 0.00 0 89 1 0 0
v_reserve_write_off 20768 20768 0 0.00 0 7199 5 0 0
x_lock_depdocs_on_canc_invoice 11782 11782 0 0.00 0 25716 108 0 0
x_lock_depdocs_on_canc_sup_ord 432 432 0 0.00 0 14538 325 0 0
x_make_qstorno_1000_1200 5559 5559 0 0.00 2 39880 1106 0 0
x_make_qstorno_1200_2000 5658 5658 0 0.00 2 81804 3061 0 0
x_make_qstorno_2100_3300 463307 463307 0 0.00 0 106113 137 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-12-2020 16:28:46 to 22-12-2020 16:28:50.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:13 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:19 11450 8192000000 10202177520 10498252800 801333568 8.910 65 45 90 0 818315824 2205888 14776368
13:57:39 30937 8192000000 10350790944 10669740032 1377623184 14.395 100 86 172 1 1410143440 4678544 27841712
13:58:20 32909 8192000000 10391186992 10715758592 1435048016 14.906 100 89 178 2 1470328816 6468048 28812752
13:59:07 20262 8192000000 10420267760 10748436480 1470010208 15.214 100 90 181 1 1507101328 7900640 29190480
13:59:37 31144 8192000000 10444457616 10777034752 1492660368 15.412 100 88 176 0 1529249328 8267552 28321408
14:00:17 21846 8192000000 10466384368 10804035584 1509799296 15.562 100 87 174 0 1546664320 9278208 27586816
14:00:46 17997 8192000000 10476712624 10819756032 1536100048 15.790 100 86 172 0 1572354352 9641104 26613200
14:01:17 17937 8192000000 10494097584 10840715264 1554807040 15.951 100 91 182 1 1593554592 10432752 28314800
14:01:50 14110 8192000000 10507638096 10859671552 1568230416 16.067 100 83 164 2 1604161216 10827936 25102864
14:02:18 13192 8192000000 10544704112 10901745664 1602912768 16.364 100 71 142 2 1634178672 9887072 21378832
14:02:41 11238 8192000000 10583813248 10945437696 1634896624 16.636 100 75 150 1 1667782224 10770592 22115008
14:03:03 8287 8192000000 10603824960 10971574272 1668944176 16.924 100 75 148 2 1701241840 10708960 21588704
14:03:19 12252 8192000000 10624749552 10998054912 1688952544 17.093 100 76 152 0 1722957344 11557264 22447536
14:03:39 7009 8192000000 10651320960 11029221376 1712341776 17.288 100 68 134 2 1746532448 14676912 19513760
14:03:55 5108 8192000000 10658588512 11037908992 1726464480 17.406 100 67 133 2 1756258608 10117504 19676624
14:04:08 5334 8192000000 10679731008 11059052544 1740246656 17.521 100 68 136 2 1771025232 10911184 19867392
14:04:21 6463 8192000000 10690521888 11068665856 1753521936 17.631 100 74 148 1 1785585760 11552896 20510928
14:04:36 4288 8192000000 10694026832 11071832064 1757455088 17.663 100 75 150 2 1791604240 12661808 21487344
14:04:47 9168 8192000000 10702072400 11088687104 1774622800 17.805 100 78 156 0 1808721984 12657136 21442048
14:05:04 4549 8192000000 10714764480 11102568448 1781222384 17.860 100 70 139 3 1812027664 11927760 18877520
14:05:15 3912 8192000000 10728996784 11118260224 1794682272 17.970 100 69 133 2 1826367776 12566512 19118992
14:05:25 2789 8192000000 10745201344 11132112896 1810804080 18.102 100 87 174 0 1848558496 13384640 24369776
14:05:35 3426 8192000000 10752678880 11142868992 1816823712 18.152 100 88 176 2 1855305952 13447760 25034480
14:05:45 4103 8192000000 10764542480 11151634432 1821862624 18.193 100 85 170 1 1860597504 14108464 24626416
14:05:57 1996 8192000000 10765649920 11155820544 1829234064 18.253 100 86 170 2 1867292608 13189968 24868576
14:06:05 2119 8192000000 10777529664 11164602368 1839772000 18.339 100 91 184 1 1879466176 14564688 25129488
14:06:14 2211 8192000000 10784011536 11168387072 1840802016 18.347 100 83 167 1 1876441264 12713024 22926224
14:06:22 2811 8192000000 10783589248 11174027264 1844974560 18.381 100 89 177 2 1884297120 14343104 24979456
14:06:31 2002 8192000000 10789894736 11178717184 1849769968 18.420 100 86 173 0 1888673968 14660880 24243120
14:06:40 2209 8192000000 10801214576 11187572736 1850736144 18.428 100 86 170 1 1889510688 13415728 25358816
14:06:49 1449 8192000000 10805142448 11192328192 1861110528 18.512 100 90 180 5 1901010720 13476032 26424160
14:06:57 2254 8192000000 10800737200 11193241600 1864187776 18.537 100 89 176 4 1902320544 12481856 25650912
14:07:05 2167 8192000000 10809991088 11198513152 1865350368 18.547 100 93 184 1 1905348672 13655152 26343152
14:07:14 2602 8192000000 10793327280 11193331712 1864602032 18.541 100 76 152 1 1899124592 13050896 21471664
14:07:27 5226 8192000000 10801744032 11199111168 1864958992 18.543 100 65 128 2 1894223616 11212976 18051648
14:07:39 2258 8192000000 10787819040 11199127552 1865325344 18.546 100 55 109 1 1891217312 10197776 15694192
14:07:49 5740 8192000000 10791681744 11203764224 1870924224 18.592 100 52 104 1 1893376608 7737920 14714464
14:08:03 3771 8192000000 10783679344 11205120000 1871797632 18.599 100 42 84 3 1893101968 9987376 11316960
14:08:15 3632 8192000000 10798249552 11212668928 1871883424 18.600 100 43 86 0 1893114112 8866672 12364016
14:08:27 4932 8192000000 10789056048 11208531968 1875413056 18.628 100 40 79 0 1896138064 9117056 11607952
14:08:38 3446 8192000000 10807816032 11216580608 1878749264 18.655 100 58 118 1 1908188080 12661344 16777472
14:08:48 13321 8192000000 10804622016 11220467712 1876192912 18.634 100 40 78 3 1894396192 6636640 11566640
14:09:08 57897 8192000000 10811172624 11224674304 1881909776 18.681 100 50 100 0 1902830992 5576960 15344256
14:10:12 1815 8192000000 10828649504 11241627648 1893446256 18.774 100 75 150 1 1925245392 9770656 22028480
14:10:22 10072 8192000000 10796303968 11230855168 1884828128 18.704 100 30 60 2 1899416272 6503568 8084576
14:10:39 4919 8192000000 10816347264 11234078720 1887806928 18.728 100 32 63 3 1902888048 6611600 8469520
14:10:52 3576 8192000000 10808590048 11239178240 1892030880 18.762 100 37 74 1 1910629600 8618528 9980192
14:11:04 4980 8192000000 10809761184 11239563264 1891550000 18.758 100 28 56 1 1905855968 6045664 8260304
14:11:18 4828 8192000000 10802851632 11241058304 1898557008 18.815 100 25 48 1 1910989392 6057136 6375248
14:11:30 5573 8192000000 10816673472 11243896832 1895173712 18.787 100 27 54 1 1909451632 6172896 8105024
14:11:43 6684 8192000000 10810296992 11243143168 1896696752 18.800 100 29 58 1 1911009600 5626768 8686080
14:11:56 15888 8192000000 10803943280 11245023232 1896817584 18.801 100 14 28 1 1906918208 6188048 3912576
14:12:21 6119 8192000000 10821363072 11250552832 1902692000 18.848 100 31 62 1 1917136112 5795392 8648720
14:12:33 7125 8192000000 10825337152 11257085952 1903974544 18.858 100 22 44 1 1920086800 9759840 6352416
14:12:46 6918 8192000000 10818007872 11255660544 1906230320 18.876 100 20 39 2 1917656240 5505040 5920880
14:12:59 10102 8192000000 10821522592 11257630720 1907906016 18.890 100 22 44 2 1920194944 6379248 5909680
14:13:16 26043 8192000000 10814437440 11260014592 1910648432 18.912 100 29 58 0 1926146688 5102736 10395520
14:14:10 21108 8192000000 10828890208 11262898176 1911937840 18.922 100 23 46 2 1924208336 5887872 6382624
14:14:39 4372 8192000000 10835986896 11271307264 1917061408 18.963 100 34 68 3 1933679744 7151200 9467136
14:14:49 13479 8192000000 10840256032 11269853184 1917165424 18.964 100 27 54 2 1931168432 6542192 7460816
14:15:10 4725 8192000000 10839339440 11270299648 1919478992 18.983 100 29 58 2 1934403888 6689152 8235744
14:15:23 4029 8192000000 10838251248 11274309632 1920374720 18.990 100 43 85 1 1941151808 8026896 12750192
14:15:34 4251 8192000000 10834298864 11269054464 1902879744 18.849 99 33 66 2 1919746896 7409152 9458000
14:15:45 4271 8192000000 10816352896 11240861696 1833801152 18.290 96 35 69 1 1850083664 6838640 9443872
14:15:58 6789 8192000000 10789744080 11220758528 1861824048 18.518 99 17 34 0 1871708080 5379168 4504864
14:16:15 7861 8192000000 10777166880 11213639680 1829428064 18.255 97 35 71 1 1845686368 5897808 10360496
14:16:29 6863 8192000000 10744381056 11158204416 1742411808 17.539 93 22 44 2 1753979408 5135088 6432512
14:16:45 7645 8192000000 10734395024 11141824512 1711635664 17.282 92 24 50 1 1724338512 4626672 8076176
14:16:59 10704 8192000000 10713294368 11132792832 1731458032 17.448 95 21 42 1 1743494880 5685792 6351056
14:17:22 13774 8192000000 10735861632 11146870784 1765388800 17.729 97 31 62 0 1780708976 5118928 10201248
14:17:42 9347 8192000000 10715225168 11137531904 1760366080 17.687 97 13 26 2 1768695504 5283920 3045504
14:17:58 58913 8192000000 10710477520 11125354496 1729795152 17.434 95 44 89 1 1752841872 9620304 13426416
14:19:05 10697 8192000000 10702423728 11118825472 1775227136 17.810 98 27 54 1 1788700704 5817536 7656032
14:19:23 4873 8192000000 10682839760 11094073344 1740787872 17.525 97 30 60 0 1755694896 6240256 8666768
14:19:36 3949 8192000000 10725640816 11136118784 1798878576 18.005 100 38 76 3 1817953872 8328224 10747072
14:19:51 6286 8192000000 10705541440 11111542784 1755722400 17.649 98 31 60 3 1771025472 6846864 8456208
14:20:05 7973 8192000000 10696101184 11105607680 1754574272 17.639 97 30 60 0 1769672496 5878320 9219904
14:20:21 8760 8192000000 10711113328 11129405440 1775230560 17.810 98 29 57 2 1789421856 5832080 8359216
14:20:37 6691 8192000000 10734012352 11146563584 1795057424 17.973 99 30 61 0 1809636128 5848288 8730416
14:20:50 7310 8192000000 10724492096 11141115904 1793371520 17.959 99 32 64 3 1812245168 9727616 9146032
14:21:06 12787 8192000000 10730205520 11151458304 1801115904 18.023 99 20 40 2 1813585104 5844816 6624384
14:21:30 10812 8192000000 10737148272 11162021888 1826137472 18.228 100 26 52 1 1840209040 6573264 7498304
14:21:50 14103 8192000000 10741527328 11167526912 1831264592 18.270 100 17 34 0 1841450384 4801472 5384320
14:22:16 11282 8192000000 10757860992 11183144960 1843666288 18.371 100 18 35 1 1854899696 5324640 5908768
14:22:34 16637 8192000000 10772908464 11195600896 1854258400 18.457 100 24 47 1 1867554976 6158464 7138112
14:23:13 46651 8192000000 10782670480 11198337024 1860641024 18.508 100 37 73 1 1877236272 5545680 11049568
14:24:09 6571 8192000000 10772217024 11202326528 1860790096 18.510 100 26 51 0 1873399456 5576560 7032800
14:24:23 7126 8192000000 10764321248 11202228224 1864106448 18.537 100 21 42 0 1875596560 5948592 5541520
14:24:37 15480 8192000000 10795738176 11217272832 1865523104 18.548 100 25 50 0 1877297712 4941376 6833232
14:25:01 8984 8192000000 10783444656 11209478144 1869165472 18.578 100 21 42 1 1880596528 5395504 6035552
14:25:17 9430 8192000000 10789397856 11216195584 1870114880 18.585 100 26 51 1 1887638176 9360848 8162448
14:25:32 7919 8192000000 10776248368 11213074432 1872814544 18.607 100 24 48 1 1885610928 6215024 6581360
14:25:46 9334 8192000000 10779717728 11213205504 1873892960 18.616 100 17 34 2 1884128288 5103440 5131888
14:26:02 12333 8192000000 10775358816 11214557184 1873139648 18.610 100 17 34 1 1883071120 5184688 4746784
14:26:20 11795 8192000000 10785183552 11219398656 1874431328 18.620 100 16 32 4 1884318176 4975072 4911776
14:26:38 12216 8192000000 10789648080 11223441408 1880447504 18.669 100 19 38 3 1890833088 5493328 4892256
14:27:01 10661 8192000000 10798603280 11232468992 1890509936 18.750 100 21 42 0 1905573056 9226176 5836944
14:27:29 6198 8192000000 10831408320 11258814464 1911012656 18.915 100 38 76 0 1927181248 5861968 10306624
14:27:50 46324 8192000000 10860975072 11289587712 1927102320 19.044 100 40 80 2 1950306336 12056992 11147024
14:28:43 37864 8192000000 10881599200 11307020288 1923901552 19.018 99 40 80 1 1955926768 20271376 11753840
14:29:37 93147 8192000000 10884108928 11320532992 1949531008 19.223 100 43 84 2 1983387744 21298688 12558048
14:31:45 33577 8192000000 10901003008 11342524416 1957463920 19.286 100 30 60 1 1988869520 22639376 8766224
14:32:42 1676 8192000000 10927912496 11355967488 1981187168 19.474 100 64 125 1 2022835392 22397568 19250656
14:32:55 16315 8192000000 10918693568 11354312704 1960231104 19.308 99 42 84 3 1996783104 23641504 12910496
14:33:30 19644 8192000000 10924606704 11366326272 1981348608 19.475 100 39 78 3 2021301376 28013824 11938944
14:34:07 10247 8192000000 10932308272 11374993408 1989149568 19.537 100 40 80 0 2030327920 28641808 12536544
14:34:26 5514 8192000000 10940812512 11372875776 1986782016 19.518 100 44 88 2 2028480464 27434240 14264208
14:34:39 1465 8192000000 10942486176 11370807296 1983764320 19.494 100 68 135 1 2031168960 27741840 19662800
14:34:47 3566 8192000000 10954965712 11380260864 1990048048 19.544 100 75 149 2 2044290832 31102320 23140464
14:35:04 8070 8192000000 10945890352 11361816576 1966845184 19.360 99 63 126 1 2016727872 30767696 19114992
14:35:22 12392 8192000000 10917311152 11335139328 1946551088 19.199 100 67 131 1 1999745152 33728432 19465632
14:35:46 22028 8192000000 10930266672 11357011968 1963125712 19.331 100 59 118 1 2016280480 34792544 18362224
14:36:16 5796 8192000000 10934740032 11357409280 1966183824 19.355 100 68 134 1 2023494432 36526176 20784432
14:36:29 5548 8192000000 10920117856 11346427904 1959590128 19.303 100 70 138 2 2017725888 36969664 21166096
14:36:46 12369 8192000000 10927605504 11356348416 1959752176 19.304 100 60 120 2 2018942288 39799904 19390208
14:37:08 19447 8192000000 10918878768 11353849856 1952249600 19.244 99 50 100 0 2011988656 43050096 16688960
14:37:41 16427 8192000000 10912527680 11342278656 1929392544 19.062 99 57 112 0 1989156880 40658288 19106048
14:38:09 2677 8192000000 10920577936 11343872000 1948175792 19.212 100 77 152 1 2012046768 39036656 24834320
14:38:18 1846 8192000000 10907602080 11319857152 1898554464 18.815 97 86 171 2 1965726512 40229040 26943008
14:38:27 3048 8192000000 10915023680 11323277312 1932176544 19.084 100 89 173 3 1996980272 37357072 27446656
14:38:38 4814 8192000000 10904098720 11323240448 1903929536 18.858 98 79 158 2 1966587696 38635408 24022752
14:38:50 1781 8192000000 10906901552 11315400704 1927228384 19.045 100 67 130 1 1981533616 34552048 19753184
14:38:59 1063 8192000000 10898520448 11311808512 1918050384 18.971 99 87 168 1 1979075312 35283648 25741280
14:39:07 2120 8192000000 10895363568 11313545216 1927898592 19.050 100 90 173 1 1984616656 30878368 25839696
14:39:20 5820 8192000000 10855081232 11272679424 1868300880 18.571 98 58 116 1 1920826544 34261488 18264176
14:39:36 3841 8192000000 10851216768 11279343616 1887576704 18.726 99 51 102 0 1925614704 22512016 15525984
14:39:46 3252 8192000000 10833192864 11253288960 1885042656 18.706 100 68 136 1 1924607536 18967680 20597200
14:40:05 6358 8192000000 10838051360 11264901120 1896244240 18.796 100 49 98 3 1928456288 17946016 14266032
14:40:18 8007 8192000000 10815515984 11249111040 1849684864 18.420 97 30 61 3 1871620832 12988384 8947584
14:40:32 12517 8192000000 10821015600 11271741440 1901697040 18.840 100 23 46 1 1923272624 13906992 7668592
14:40:53 2156 8192000000 10831042624 11252699136 1873659264 18.614 98 50 93 3 1899531376 11603792 14268320
14:41:03 2833 8192000000 10838848128 11270651904 1905247056 18.868 100 46 92 3 1933435600 14569184 13619360
14:41:28 9169 8192000000 10866419024 11290701824 1897334464 18.805 99 32 63 2 1923201904 16353408 9514032
14:41:44 6253 8192000000 10843014784 11266838528 1869249792 18.578 98 36 72 0 1899078320 18252400 11576128
14:41:57 10616 8192000000 10841058944 11275636736 1902771248 18.849 100 26 52 1 1925250336 14854624 7624464
14:42:14 27836 8192000000 10819705424 11266027520 1883801072 18.696 99 23 46 1 1907990752 17082384 7107296
14:42:48 29667 8192000000 10789726304 11214336000 1796216320 17.983 95 25 50 0 1817996560 13777600 8002640
14:43:25 39609 8192000000 10798710128 11230109696 1841562128 18.354 98 37 70 2 1860256912 9342336 9352448
14:44:13 12491 8192000000 10797932640 11217158144 1814656544 18.134 96 46 92 0 1834987600 7958480 12372576
14:44:34 36764 8192000000 10788212992 11210162176 1785462048 17.894 96 33 66 3 1806551040 11019184 10069808
14:45:21 17771 8192000000 10795431328 11227844608 1859092592 18.496 100 27 54 1 1882219808 14735408 8391808
14:45:45 124383 8192000000 10852720640 11268583424 1852769760 18.445 98 27 55 1 1879435552 18186240 8479552
14:47:57 30530 8192000000 10863276144 11290779648 1903493088 18.854 100 48 97 0 1939403376 21744416 14165872
14:48:34 13497 8192000000 10869460096 11302318080 1916830320 18.961 100 44 88 1 1958791584 28603440 13357824
14:49:05 14843 8192000000 10840483136 11287760896 1910875760 18.914 100 33 64 2 1942628080 21890288 9862032
14:49:28 71646 8192000000 10857254624 11299426304 1875679376 18.630 98 18 36 1 1907692848 26251136 5762336
14:51:09 100680 8192000000 10860848080 11307896832 1922885344 19.010 100 31 62 1 1953674528 20744176 10045008
14:53:44 41901 8192000000 10860691568 11312840704 1928605792 19.056 100 18 36 1 1946784624 12891808 5287024
14:55:32 41755 8192000000 10848808032 11329396736 1908751904 18.897 99 5 10 0 1924557216 14295472 1509840
14:56:20 28835 8192000000 10851935408 11303137280 1913450720 18.934 99 25 51 2 1934183392 13510880 7221792
14:56:55 67621 8192000000 10881363504 11341762560 1940753056 19.153 100 24 49 1 1959422928 12079440 6590432
14:58:28 17831 8192000000 10916722768 11350147072 1973804992 19.416 100 65 129 0 2001784368 9674448 18304928
14:59:04 83002 8192000000 10898613792 11366150144 1949775872 19.225 99 16 32 1 1969682128 15421232 4485024
15:00:42 101770 8192000000 10913509072 11374620672 1962493328 19.326 99 12 24 0 1978241056 12223680 3524048
15:02:35 84884 8192000000 10923833984 11400572928 1989849968 19.543 100 12 24 3 2011012256 17583520 3578768
15:04:13 54915 8192000000 10938314784 11395375104 2002012448 19.639 100 23 46 0 2025823936 16762736 7048752
15:05:17 47165 8192000000 10928427376 11400732672 1976571488 19.438 99 12 24 0 1995482224 15171056 3739680
15:06:11 98206 8192000000 10931303648 11398021120 1943121072 19.172 97 15 30 0 1963290560 15938496 4230992
15:07:55 62854 8192000000 10924332064 11407695872 1989739856 19.542 100 8 16 0 2011754528 19720720 2293952
15:09:04 74900 8192000000 10934208560 11396616192 2003751040 19.652 100 26 52 2 2023790192 12226512 7812640
15:10:29 115942 8192000000 10934245072 11413331968 2005348944 19.665 100 32 62 2 2034180160 19384624 9446592
15:12:36 109245 8192000000 10934724848 11405201408 2004941712 19.662 100 22 44 4 2020509680 9692848 5875120
15:14:33 54462 8192000000 10917235088 11393015808 1968360976 19.372 98 22 44 1 1983228928 8877968 5989984
15:15:39 47353 8192000000 10895444480 11377926144 1940664512 19.152 97 17 34 1 1955059904 9735728 4659664
15:17:15 109672 8192000000 10889962832 11357777920 1868001696 18.568 94 15 30 1 1879077600 6588752 4487152
15:19:19 61846 8192000000 10896131152 11377537024 1959199568 19.300 99 18 34 1 1976379536 12216896 4963072
15:20:35 42650 8192000000 10887208272 11365785600 1960863584 19.313 99 11 22 0 1975914048 11875424 3175040
15:21:24 41579 8192000000 10906009424 11368366080 1940424416 19.150 98 21 42 1 1957037216 10375488 6237312
15:22:16 25612 8192000000 10909237936 11364786176 1953342272 19.253 99 36 72 3 1971448704 7633728 10472704
15:22:49 29294 8192000000 10883423600 11352801280 1946433264 19.198 99 32 64 3 1967512016 11991520 9087232
15:23:24 42986 8192000000 10863389760 11326836736 1843484832 18.369 94 11 22 1 1856723264 10218640 3019792
15:24:15 71694 8192000000 10866890688 11326734336 1870962448 18.592 96 18 36 1 1890508256 14447472 5098336
15:27:03 58617 8192000000 10884603792 11348070400 1886203456 18.715 97 16 32 1 1909738560 18694640 4840464
15:28:11 37209 8192000000 10874428864 11321184256 1855010112 18.463 95 39 76 2 1879727136 14587696 10129328
15:28:58 107808 8192000000 10839246208 11312652288 1745419984 17.564 91 23 47 1 1770625200 18905776 6299440
15:30:52 66251 8192000000 10805588128 11256381440 1709663216 17.266 90 10 19 0 1725718800 13878736 2176848
15:32:10 85770 8192000000 10802205296 11260166144 1749589840 17.598 93 12 24 0 1769366592 15787728 3989024
15:33:52 54350 8192000000 10811007328 11274874880 1833388688 18.287 98 15 30 1 1851437040 13687344 4361008
15:35:04 90383 8192000000 10830555808 11287527424 1886074768 18.714 99 12 24 2 1903589472 14124304 3390400
15:38:02 85257 8192000000 10838120528 11299495936 1891953696 18.762 99 14 27 1 1902614832 6907168 3753968
15:39:33 33655 8192000000 10836416272 11301154816 1905095296 18.867 99 13 26 1 1916607824 7861120 3651408
15:40:13 54151 8192000000 10840951696 11294015488 1890211424 18.747 98 18 37 0 1903238672 7795008 5232240
15:41:27 78190 8192000000 10856579328 11326873600 1896107584 18.795 98 21 42 1 1911853472 9561280 6184608
15:42:55 96917 8192000000 10885565872 11349729280 1936423920 19.118 99 22 44 0 1957420768 14034640 6962208
15:45:11 86894 8192000000 10877673536 11367591936 1957866656 19.289 100 20 40 2 1980425888 16246608 6312624
15:46:47 58411 8192000000 10879942960 11341582336 1920310160 18.989 98 9 18 1 1930526896 7605008 2611728
15:47:52 21993 8192000000 10904812768 11360198656 1972133280 19.402 100 61 121 4 2000981568 11764576 17083712
15:48:22 62332 8192000000 10882666304 11356917760 1931107600 19.076 98 28 56 1 1952013168 13274864 7630704
15:50:32 57965 8192000000 10891673376 11361865728 1945666400 19.192 99 27 52 2 1963815312 10936384 7212528
15:52:01 56364 8192000000 10910596336 11366408192 1956498560 19.278 99 35 70 0 1975859696 9306912 10054224
15:53:05 15708 8192000000 10920103600 11375034368 1979730272 19.463 100 37 74 1 1997681040 7518608 10432160
15:53:27 10916 8192000000 10933112336 11380969472 1981524064 19.477 100 45 88 0 2009230176 15535648 12170464
15:53:47 45129 8192000000 10930262192 11397165056 1989591792 19.541 100 37 73 1 2016318160 16726896 9999472
15:54:43 87911 8192000000 10921287120 11400249344 1986613136 19.517 100 5 10 0 2003707232 15886656 1207440
15:56:17 55455 8192000000 10943549840 11407159296 2003162256 19.648 100 18 36 1 2021162816 13111456 4889104
15:57:18 154237 8192000000 10927951888 11395891200 1966137904 19.355 98 15 26 1 1982398160 12297840 3962416
16:00:00 59888 8192000000 10925694704 11398553600 2007918528 19.685 100 30 60 1 2022687664 6782000 7987136
16:01:06 24684 8192000000 10925685312 11403354112 2006490848 19.674 100 15 30 0 2017864496 7860128 3513520
16:01:37 57247 8192000000 10933994656 11421609984 2014978720 19.741 100 11 22 0 2027823296 9793312 3051264
16:03:45 58756 8192000000 10943003376 11420733440 2016523920 19.753 100 14 28 0 2035599696 14509264 4566512
16:04:56 80398 8192000000 10944752320 11446419456 2016096624 19.749 100 14 27 0 2041493776 21300144 4097008
16:06:25 66823 8192000000 10923892192 11405225984 1960331664 19.309 97 20 39 1 1977078384 11240896 5505824
16:07:53 50998 8192000000 10931183920 11411275776 1960169216 19.307 97 15 30 1 1977467872 12826960 4471696
16:08:51 97242 8192000000 10923661888 11415764992 1961971056 19.322 98 9 18 0 1983200704 18259872 2969776
16:10:34 63796 8192000000 10923639360 11387928576 1926215840 19.037 96 23 46 1 1940593984 8351312 6026832
16:11:48 73635 8192000000 10894819184 11366674432 1848349776 18.409 93 19 38 1 1864124672 10768496 5006400
16:13:22 72626 8192000000 10878623728 11313307648 1788950480 17.923 91 26 52 0 1807048992 10612944 7485568
16:14:46 46293 8192000000 10861798176 11328737280 1833354032 18.287 95 22 44 1 1851001232 11617680 6029520
16:15:40 102447 8192000000 10848624384 11317952512 1795405600 17.976 93 8 16 1 1816217728 18654672 2157456
16:17:28 74820 8192000000 10855668368 11312369664 1920129568 18.988 100 24 48 0 1939825840 13052496 6643776
16:19:05 39313 8192000000 10849098048 11303333888 1854113504 18.456 96 32 64 2 1870507072 7701872 8691696
16:19:52 59453 8192000000 10857496480 11311001600 1892288080 18.764 98 33 66 1 1910604752 8403184 9913488
16:21:15 42505 8192000000 10808154768 11284094976 1857902448 18.486 97 9 16 2 1866687424 6078128 2706848
16:22:04 35224 8192000000 10820389712 11294224384 1873818448 18.615 98 13 26 1 1883783488 6483248 3481792
16:22:47 26892 8192000000 10805891600 11279388672 1850577392 18.427 97 7 14 0 1858905744 6287632 2040720
16:23:20 12922 8192000000 10803521920 11267522560 1857223440 18.481 98 6 11 1 1865327424 6495984 1608000
16:23:39 37643 8192000000 10807183888 11277271040 1860963840 18.511 98 6 13 0 1869171920 6359760 1848320
16:24:23 35173 8192000000 10806331456 11267944448 1840895632 18.348 97 12 24 1 1849678656 5219456 3563568
16:25:04 74791 8192000000 10793301536 11260448768 1814393488 18.132 96 14 28 0 1828815184 10615840 3805856
16:26:25 49491 8192000000 9136151440 9358716928 301743744 3.552 16 4 8 0 307256768 4665488 847536

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:28, from 22-12-2020 16:28:52 to 22-12-2020 16:29:20.

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 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-12-2020 16:29:21 to 22-12-2020 16:29:23.

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          248886
MON$OLDEST_ACTIVE               249557
MON$OLDEST_SNAPSHOT             249557
MON$NEXT_TRANSACTION            249557
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                       2018048
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:226: 
:227: mscs-test-161.budzdorov.ru    Tue Dec 22 16:27:31 2020
:228:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:229: 
--- end of diff output ---

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

22.12.20 16:29:24. 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
2020-12-22 16:29:26 No severe PSQL-related problems occured
22.12.20 16:29:27. End of report.