Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 30.01.2021 16:32
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 17320900 kB
MemAvailable 31220664 kB
Buffers 0 kB
Cached 14341884 kB
SwapCached 4868 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-30 16:31:41
DTS_END                         2021-01-30 16:31:41.4140
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/40638
TRN_ID                          233779
ATT_ID                          659
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: 9298.75 19941 1115850
customer order: creation 162.31 381 19477
customer order: refuse 14.32 348 1718
order to supplier: creation 43.88 1185 5266
order to supplier: removal 3.53 101032 424
invoice (draft): creation 43.51 3399 5221
invoice (draft): removal 56.01 726 6721
invoice accept: apply 39.92 19663 4790
invoice accept: cancel 50.19 746 6023
customer reserve: creation 3751.74 193 450209
customer reserve: removal 4840.92 57 580910
realization accept: apply 79.95 158 9594
realization accept: cancel 89.98 111 10797
payment from customer: creation 55.82 101 6698
payment from customer: removal 5.13 75 616
payment to supplier: creation 46.71 113 5605
payment to supplier: removal 3.27 57 392
service: total inventory turnovers 4.68 1061 561
service: total monetary turnovers 6.01 43 721
service: aggregate perf. data 0.86 17571 103
service: refresh index statistics 0.03 251804 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 30-01-2021 16:32:33 to 30-01-2021 16:32:36.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2089
TEST_TIME 2 1780
TEST_TIME 3 2634
TEST_TIME 4 3886
TEST_TIME 5 3965
TEST_TIME 6 4151
TEST_TIME 7 4191
TEST_TIME 8 4388
TEST_TIME 9 4411
TEST_TIME 10 4683
TEST_TIME 11 4704
TEST_TIME 12 5061
TEST_TIME 13 5428
TEST_TIME 14 5771
TEST_TIME 15 5830
TEST_TIME 16 6275
TEST_TIME 17 6481
TEST_TIME 18 7149
TEST_TIME 19 7542
TEST_TIME 20 7687
TEST_TIME 21 8179
TEST_TIME 22 8541
TEST_TIME 23 9059
TEST_TIME 24 10248
TEST_TIME 25 10841
TEST_TIME 26 10630
TEST_TIME 27 10338
TEST_TIME 28 10177
TEST_TIME 29 9990
TEST_TIME 30 9978
TEST_TIME 31 9971
TEST_TIME 32 9955
TEST_TIME 33 9838
TEST_TIME 34 9827
TEST_TIME 35 9662
TEST_TIME 36 9502
TEST_TIME 37 9432
TEST_TIME 38 9421
TEST_TIME 39 9814
TEST_TIME 40 9967
TEST_TIME 41 9798
TEST_TIME 42 10005
TEST_TIME 43 10026
TEST_TIME 44 10154
TEST_TIME 45 10055
TEST_TIME 46 10024
TEST_TIME 47 10028
TEST_TIME 48 10177
TEST_TIME 49 10104
TEST_TIME 50 9936
TEST_TIME 51 9804
TEST_TIME 52 9844
TEST_TIME 53 9742
TEST_TIME 54 9720
TEST_TIME 55 9669
TEST_TIME 56 9561
TEST_TIME 57 9496
TEST_TIME 58 9454
TEST_TIME 59 9580
TEST_TIME 60 9646
TEST_TIME 61 9587
TEST_TIME 62 9607
TEST_TIME 63 9650
TEST_TIME 64 9724
TEST_TIME 65 9763
TEST_TIME 66 9768
TEST_TIME 67 9760
TEST_TIME 68 9814
TEST_TIME 69 9904
TEST_TIME 70 9847
TEST_TIME 71 9831
TEST_TIME 72 9822
TEST_TIME 73 9867
TEST_TIME 74 9786
TEST_TIME 75 9718
TEST_TIME 76 9655
TEST_TIME 77 9691
TEST_TIME 78 9666
TEST_TIME 79 9628
TEST_TIME 80 9584
TEST_TIME 81 9583
TEST_TIME 82 9514
TEST_TIME 83 9453
TEST_TIME 84 9399
TEST_TIME 85 9417
TEST_TIME 86 9416
TEST_TIME 87 9411
TEST_TIME 88 9383
TEST_TIME 89 9384
TEST_TIME 90 9380
TEST_TIME 91 9437
TEST_TIME 92 9491
TEST_TIME 93 9495
TEST_TIME 94 9438
TEST_TIME 95 9557
TEST_TIME 96 9553
TEST_TIME 97 9593
TEST_TIME 98 9548
TEST_TIME 99 9567
TEST_TIME 100 9589
TEST_TIME 101 9569
TEST_TIME 102 9534
TEST_TIME 103 9497
TEST_TIME 104 9443
TEST_TIME 105 9416
TEST_TIME 106 9376
TEST_TIME 107 9329
TEST_TIME 108 9299
TEST_TIME 109 9301
TEST_TIME 110 9267
TEST_TIME 111 9266
TEST_TIME 112 9235
TEST_TIME 113 9231
TEST_TIME 114 9275
TEST_TIME 115 9275
TEST_TIME 116 9276
TEST_TIME 117 9286
TEST_TIME 118 9322
TEST_TIME 119 9286
TEST_TIME 120 9299

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 30-01-2021 16:32:37 to 30-01-2021 16:32:40.

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 1532408 1532408 0 0.00 0 20076 6 0 0
doc_list_biud 1532408 1532408 0 0.00 0 27111 27 0 0
sp_add_invoice_to_stock 4911 4790 121 2.46 35 225993 19664 0 121
sp_cancel_adding_invoice 6023 6023 0 0.00 5 67150 746 0 0
sp_cancel_client_order 1718 1718 0 0.00 5 12021 348 0 0
sp_cancel_customer_reserve 580910 580910 0 0.00 1 18684 58 0 0
sp_cancel_pay_from_customer 616 616 0 0.00 3 5373 75 0 0
sp_cancel_pay_to_supplier 392 392 0 0.00 3 2084 58 0 0
sp_cancel_supplier_invoice 6734 6721 13 0.19 2 16069 726 0 13
sp_cancel_supplier_order 424 424 0 0.00 14 1208732 101032 0 0
sp_cancel_write_off 10797 10797 0 0.00 1 16653 112 0 0
sp_client_order 19477 19477 0 0.00 3 37597 382 0 0
sp_customer_reserve 450209 450209 0 0.00 0 61739 193 0 0
sp_fill_shopping_cart 29930 29930 0 0.00 1 19914 38 0 0
sp_fill_shopping_cart_clo_res 450208 450208 0 0.00 0 15015 14 0 0
sp_get_clo_for_invoice 4789 4789 0 0.00 0 22107 305 0 0
sp_kill_cost_storno 17828 17828 0 0.00 0 6169 53 0 0
sp_kill_qstorno_ret_qs2qd 1179762 1179762 0 0.00 0 27109 31 0 0
sp_kill_qty_storno 620975 620975 0 0.00 0 27109 67 0 0
sp_lock_selected_doc 19921 19921 0 0.00 0 5361 4 0 0
sp_make_cost_storno 26685 26685 0 0.00 0 19040 50 0 0
sp_multiply_rows_for_pdistr 26685 26685 0 0.00 0 14043 27 0 0
sp_multiply_rows_for_qdistr 19477 19477 0 0.00 0 31735 176 0 0
sp_pay_from_customer 6698 6698 0 0.00 4 14050 102 0 0
sp_pay_to_supplier 5605 5605 0 0.00 4 18959 113 0 0
sp_payment_common 12303 12303 0 0.00 1 13745 23 0 0
sp_qd_handle_on_cancel_clo 1718 1718 0 0.00 0 12013 318 0 0
sp_qd_handle_on_invoice_upd_sts 10811 10811 0 0.00 0 14780 312 0 0
sp_qd_handle_on_reserve_upd_sts 9594 9594 0 0.00 0 12062 46 0 0
sp_reserve_write_off 9594 9594 0 0.00 6 16344 159 0 0
sp_supplier_invoice 5221 5221 0 0.00 7 81694 3399 0 0
sp_supplier_order 5266 5266 0 0.00 6 32079 1185 0 0
srv_aggregate_perf_data 103 103 0 0.00 2268 113871 17572 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1252 141949 32558 0 0
srv_find_qd_qs_mism 1070052 1070052 0 0.00 0 20075 6 0 0
srv_make_invnt_saldo 561 561 0 0.00 47 20592 1061 0 0
srv_make_money_saldo 721 721 0 0.00 1 5682 44 0 0
srv_recalc_idx_stat 4 4 0 0.00 189594 296137 251805 0 0
t$perf-abend:sp_add_invoice_to_stock 121 121 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-norm:sp_add_invoice_to_stock 4790 4790 0 0.00 0 19069 177 0 0
t$perf-norm:sp_cancel_adding_invoice 392 392 0 0.00 0 5392 123 0 0
t$perf-norm:sp_cancel_client_order 1718 1718 0 0.00 0 4299 14 0 0
t$perf-norm:sp_cancel_customer_reserve 641 641 0 0.00 0 5580 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 616 616 0 0.00 0 879 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 392 392 0 0.00 0 471 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 396 396 0 0.00 0 701 7 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 24245 1624 0 0
t$perf-norm:sp_cancel_write_off 960 960 0 0.00 0 4236 8 0 0
t$perf-norm:sp_client_order 19477 19477 0 0.00 0 17130 19 0 0
t$perf-norm:sp_customer_reserve 1013 1013 0 0.00 0 2888 9 0 0
t$perf-norm:sp_pay_from_customer 6698 6698 0 0.00 0 5968 11 0 0
t$perf-norm:sp_pay_to_supplier 5605 5605 0 0.00 0 5775 9 0 0
t$perf-norm:sp_reserve_write_off 9594 9594 0 0.00 0 8886 12 0 0
t$perf-norm:sp_supplier_invoice 5221 5221 0 0.00 0 10285 21 0 0
t$perf-norm:sp_supplier_order 5266 5266 0 0.00 0 9852 18 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 576 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 2345 29 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 1553 19 0 0
t$perf-norm:srv_make_money_saldo 721 721 0 0.00 0 4622 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 9818 9576 242 2.46 0 3520 16 0 242
v_all_customers 35634 35634 0 0.00 0 24 1 0 0
v_all_suppliers 29032 29032 0 0.00 0 25 1 0 0
v_all_wares 38954 38954 0 0.00 0 92 1 0 0
v_cancel_adding_invoice 784 784 0 0.00 0 366 5 0 0
v_cancel_client_order 3436 3436 0 0.00 0 3718 7 0 0
v_cancel_customer_prepayment 1232 1232 0 0.00 0 2204 4 0 0
v_cancel_customer_reserve 1282 1282 0 0.00 0 1047 4 0 0
v_cancel_payment_to_supplier 784 784 0 0.00 0 1891 6 0 0
v_cancel_supplier_invoice 818 792 26 3.17 0 1257 13 0 26
v_cancel_supplier_order 848 848 0 0.00 0 1576 5 0 0
v_cancel_write_off 1920 1920 0 0.00 0 222 11 0 0
v_max_id_clo_ord 5266 5266 0 0.00 0 4575 3 0 0
v_max_id_clo_res 1013 1013 0 0.00 0 3800 16 0 0
v_max_id_ord_sup 5185 5185 0 0.00 0 8842 7 0 0
v_max_non_paid_invoice 1540 1540 0 0.00 0 2814 4 0 0
v_max_non_paid_realizn 3489 3489 0 0.00 0 1878 4 0 0
v_min_id_clo_ord 5266 5266 0 0.00 0 3628 5 0 0
v_min_id_clo_res 1013 1013 0 0.00 0 4770 10 0 0
v_min_id_ord_sup 5185 5185 0 0.00 0 4150 5 0 0
v_min_non_paid_invoice 5605 5605 0 0.00 0 13737 13 0 0
v_min_non_paid_realizn 6698 6698 0 0.00 0 5421 15 0 0
v_our_firm 9738 9738 0 0.00 0 20 1 0 0
v_reserve_write_off 19188 19188 0 0.00 0 3787 5 0 0
x_lock_depdocs_on_canc_invoice 12348 12348 0 0.00 0 25349 126 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 11655 397 0 0
x_make_qstorno_1000_1200 5266 5266 0 0.00 2 32067 1107 0 0
x_make_qstorno_1200_2000 5221 5221 0 0.00 3 81651 3259 0 0
x_make_qstorno_2100_3300 450209 450209 0 0.00 0 50894 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-01-2021 16:32:41 to 30-01-2021 16:32:45.

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
14:01:45 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:01:51 11846 8192000000 10184147872 10483232768 910561984 10.003 74 55 110 0 932720768 2477232 19681552
14:02:11 29711 8192000000 10315819136 10628501504 1354987056 14.192 100 86 173 0 1388399904 4709152 28703696
14:02:52 27246 8192000000 10363025984 10680770560 1407285984 14.660 100 89 178 0 1443185024 6258240 29640800
14:03:28 21504 8192000000 10386697008 10709073920 1441766560 14.965 100 91 182 0 1478467280 7219472 29481248
14:03:59 24070 8192000000 10409807072 10740072448 1464256528 15.163 100 87 174 1 1500489408 8178656 28054224
14:04:39 25215 8192000000 10437540912 10775969792 1492537360 15.411 100 88 176 0 1529258304 9010256 27710688
14:05:14 15796 8192000000 10457201072 10792660992 1510623424 15.569 100 80 160 0 1545143152 9434832 25084896
14:05:37 17929 8192000000 10481934560 10825236480 1543292080 15.852 100 84 168 0 1579408240 10255536 25860624
14:06:04 21819 8192000000 10508397520 10859884544 1557675680 15.976 100 80 160 2 1593080784 10557664 24847440
14:06:34 19406 8192000000 10539180864 10894241792 1595259840 16.299 100 80 158 1 1630787856 11475904 24052112
14:07:01 9920 8192000000 10560220304 10917941248 1621066784 16.519 100 79 158 1 1655530912 10974320 23489808
14:07:20 14877 8192000000 10586991184 10946555904 1641546496 16.693 100 84 168 3 1678759520 12341392 24871632
14:07:43 11201 8192000000 10604523632 10966835200 1658856656 16.839 100 84 167 1 1696230160 13267712 24105792
14:08:05 9650 8192000000 10620281664 10985517056 1675385056 16.979 100 80 161 0 1711568896 13034688 23149152
14:08:22 9522 8192000000 10636216848 11005497344 1694091984 17.136 100 83 166 0 1730997184 12962256 23942944
14:08:39 8132 8192000000 10646993456 11017285632 1713889584 17.301 100 85 170 0 1751702064 13326160 24486320
14:08:54 5661 8192000000 10666835840 11046182912 1725709872 17.400 100 81 162 1 1762575104 13717712 23147520
14:09:07 7032 8192000000 10677000032 11051610112 1744033136 17.552 100 81 162 0 1779650112 12848416 22768560
14:09:21 7010 8192000000 10697618416 11072229376 1754390416 17.638 100 85 170 0 1792425488 13890016 24145056
14:09:37 4356 8192000000 10701452768 11077758976 1761221808 17.694 100 78 156 0 1795988080 12548832 22217440
14:09:51 3492 8192000000 10700336528 11082522624 1769205216 17.760 100 79 158 1 1804365696 12526080 22634400
14:10:01 4578 8192000000 10713202176 11092721664 1773621424 17.797 100 82 162 2 1809398448 12514560 23262464
14:10:13 4151 8192000000 10732036832 11111350272 1791083024 17.941 100 90 181 0 1829398160 13062656 25252480
14:10:25 4394 8192000000 10732091552 11116294144 1797113168 17.990 100 81 163 1 1833030928 12922912 22994848
14:10:37 3555 8192000000 10744875344 11127549952 1803490976 18.043 100 82 164 3 1839535920 13186368 22858576
14:10:47 2673 8192000000 10752467232 11132743680 1812491696 18.116 100 85 168 3 1849089856 13277776 23320384
14:10:56 7232 8192000000 10762067184 11142537216 1816531520 18.149 100 90 176 0 1855010560 13814464 24664576
14:11:12 3724 8192000000 10761455360 11145748480 1819307408 18.172 100 83 166 0 1856214512 14117264 22789840
14:11:22 1750 8192000000 10773584656 11155804160 1833063952 18.284 100 90 180 1 1872018240 13365760 25588528
14:11:31 2675 8192000000 10785417568 11168993280 1840681216 18.346 100 91 180 2 1878992688 12042000 26269472
14:11:41 2493 8192000000 10784250752 11175546880 1845535600 18.386 100 89 177 0 1882684768 12604352 24544816
14:11:50 2262 8192000000 10790397440 11178795008 1847484576 18.402 100 91 184 0 1888095040 14450128 26160336
14:11:59 1472 8192000000 10804247296 11188609024 1853318512 18.449 100 93 187 0 1895408272 15858080 26231680
14:12:07 1808 8192000000 10800899360 11187847168 1855523920 18.467 100 84 170 2 1892419296 12956480 23938896
14:12:15 1402 8192000000 10806032928 11196211200 1864317264 18.538 100 91 184 1 1903884352 13781008 25786080
14:12:24 1898 8192000000 10804080480 11191844864 1868524656 18.572 100 87 175 1 1906275872 13469568 24281648
14:12:32 2363 8192000000 10806421200 11202912256 1874005648 18.617 100 88 174 0 1912115568 13570288 24539632
14:12:41 1221 8192000000 10826510608 11217715200 1877932384 18.648 100 95 192 2 1917112720 12710320 26470016
14:12:48 1730 8192000000 10826403456 11214729216 1880939344 18.673 100 89 179 0 1918891072 13471600 24480128
14:12:56 1953 8192000000 10825567536 11217117184 1881564320 18.678 100 93 183 2 1920892544 13764960 25563264
14:13:04 38758 8192000000 10802090192 11207327744 1874911792 18.624 100 56 111 1 1901222192 11153392 15157008
14:13:50 4963 8192000000 10793176112 11216740352 1875820384 18.631 100 48 96 0 1902337904 12856816 13660704
14:14:02 2558 8192000000 10797343376 11215343616 1882775120 18.688 100 62 124 0 1908435280 7863568 17796592
14:14:14 6438 8192000000 10796884064 11216859136 1878444736 18.653 100 28 56 1 1893779840 6936320 8398784
14:14:27 6198 8192000000 10801612400 11217108992 1880197584 18.667 100 23 47 2 1893509008 6683504 6627920
14:14:40 4459 8192000000 10793763520 11220570112 1882157728 18.683 100 31 64 0 1897048256 6346112 8544416
14:14:50 4493 8192000000 10822221296 11228299264 1889373728 18.741 100 40 77 1 1908225712 7287600 11564384
14:15:02 6654 8192000000 10789724288 11222867968 1885327984 18.708 100 17 34 0 1896461680 6574080 4559616
14:15:15 6823 8192000000 10794747024 11224829952 1886085360 18.714 100 23 46 2 1899633248 6815648 6732240
14:15:28 7946 8192000000 10804793232 11233882112 1889230416 18.740 100 25 51 0 1906267488 10160064 6877008
14:15:50 4685 8192000000 10809712816 11234942976 1898347696 18.813 100 35 70 0 1915325792 6402256 10575840
14:16:06 6578 8192000000 10810941648 11233140736 1894200192 18.780 100 29 58 2 1908848208 6798272 7849744
14:16:18 9755 8192000000 10792257184 11234177024 1895200672 18.788 100 19 38 1 1907095744 5770288 6124784
14:16:34 6591 8192000000 10801242352 11237244928 1898796064 18.817 100 23 46 1 1911075680 5712688 6566928
14:16:50 52912 8192000000 10826520416 11252592640 1905434960 18.870 100 39 78 1 1921495808 4737248 11323600
14:17:51 19511 8192000000 10808489344 11251847168 1908986672 18.899 100 41 82 1 1927980400 6256880 12736848
14:18:17 8191 8192000000 10825284880 11261038592 1905406624 18.870 100 22 44 1 1922344752 10452512 6485616
14:18:32 9349 8192000000 10822417744 11257290752 1908470192 18.894 100 24 48 0 1921470016 6307888 6691936
14:18:50 6148 8192000000 10828436240 11260141568 1911112112 18.916 100 25 49 1 1928338352 10557024 6669216
14:19:03 6158 8192000000 10824875440 11264106496 1914191296 18.940 100 33 66 0 1931205616 7091984 9922336
14:19:17 11906 8192000000 10825853568 11264319488 1913044432 18.931 100 20 39 1 1923639232 5237360 5357440
14:19:35 4060 8192000000 10835760912 11270586368 1917026480 18.963 100 33 66 4 1933157936 6321552 9809904
14:19:49 5370 8192000000 10829873136 11264942080 1918093232 18.972 100 25 50 1 1930923472 5793552 7036688
14:20:04 4590 8192000000 10827874256 11266146304 1920391568 18.990 100 31 61 2 1934981952 5640528 8949856
14:20:16 14276 8192000000 10819712928 11250012160 1859997056 18.503 97 15 30 0 1869301216 4885392 4418768
14:20:38 5578 8192000000 10819095712 11253112832 1905371328 18.869 100 20 40 0 1917000096 6279120 5349648
14:20:50 9335 8192000000 10807662512 11241816064 1870814800 18.591 98 21 40 2 1882215280 5792576 5607904
14:21:05 13059 8192000000 10786800048 11222753280 1849986928 18.422 98 15 30 2 1859771264 5731568 4052768
14:21:28 8523 8192000000 10807444864 11232608256 1887461824 18.725 100 23 45 2 1899788976 5319184 7007968
14:21:42 78187 8192000000 10765363968 11202142208 1775127200 17.809 94 23 45 1 1787127392 4710896 7289296
14:23:11 7498 8192000000 10806532096 11220803584 1876251456 18.635 100 40 81 1 1895218208 7260080 11706672
14:23:26 3817 8192000000 10775777120 11199021056 1843652288 18.371 99 34 68 1 1860289328 6254240 10382800
14:23:36 6527 8192000000 10755282496 11180900352 1801193616 18.024 97 23 46 2 1813893888 6342912 6357360
14:23:49 5892 8192000000 10733325792 11159252992 1787882624 17.914 98 28 54 2 1805782032 10442256 7457152
14:24:02 9233 8192000000 10721890224 11140808704 1705295936 17.229 93 20 40 0 1716097376 5154208 5647232
14:24:19 5203 8192000000 10700940288 11113672704 1769019856 17.759 98 27 50 2 1786550928 10115104 7415968
14:24:32 8132 8192000000 10702573216 11112210432 1736172624 17.487 97 29 57 1 1751263120 5391728 9698768
14:24:48 7783 8192000000 10724365568 11147952128 1809316144 18.090 100 25 50 0 1822399920 5253104 7830672
14:25:02 7746 8192000000 10696477184 11110383616 1736374096 17.489 96 18 36 0 1746694816 4850096 5470624
14:25:16 11751 8192000000 10722793712 11144142848 1766300000 17.736 97 28 56 1 1779735584 4943328 8492256
14:25:37 8210 8192000000 10706535392 11122831360 1736402752 17.489 96 30 60 1 1750893040 5320080 9170208
14:25:52 12134 8192000000 10704338704 11124277248 1759525248 17.680 98 15 30 1 1769284272 5667712 4091312
14:26:11 10756 8192000000 10714027072 11117150208 1774508576 17.804 99 11 22 1 1783326256 5372224 3445456
14:26:31 82688 8192000000 10731712688 11151036416 1758561216 17.672 97 20 40 1 1769015120 4763008 5690896
14:28:04 6351 8192000000 10765762880 11176083456 1836071568 18.309 100 47 92 2 1857082544 6819568 14191408
14:28:17 8269 8192000000 10753558064 11176697856 1838916608 18.332 100 30 61 0 1853762112 5714656 9130848
14:28:32 6595 8192000000 10767862480 11185688576 1846184368 18.391 100 28 56 0 1860314480 6029952 8100160
14:28:45 9512 8192000000 10754005856 11184156672 1847220128 18.400 100 17 34 0 1857688384 5214720 5253536
14:29:04 6740 8192000000 10763423392 11191738368 1854825024 18.461 100 23 47 2 1867162608 5704656 6632928
14:29:18 7559 8192000000 10788794224 11207536640 1857530752 18.483 100 27 55 1 1875651312 10287520 7833040
14:29:35 11837 8192000000 10776815728 11205599232 1861205680 18.513 100 28 56 2 1875095072 5375552 8513840
14:29:56 13255 8192000000 10784238768 11209920512 1866976624 18.560 100 18 35 2 1877653568 5401168 5275776
14:30:19 11987 8192000000 10770783648 11208744960 1869219280 18.578 100 22 44 2 1881154032 5400912 6533840
14:30:39 15408 8192000000 10781949568 11215200256 1870344704 18.587 100 18 36 1 1881552816 6274752 4933360
14:31:00 17107 8192000000 10816439712 11235639296 1880312624 18.668 100 18 36 1 1895930640 9515712 6102304
14:31:24 75859 8192000000 10823196432 11254661120 1903273728 18.853 100 39 77 4 1919878480 4686912 11917840
14:33:15 37876 8192000000 10846508288 11269345280 1916118528 18.956 100 48 95 0 1937173136 7709968 13344640
14:34:00 7277 8192000000 10857583152 11276509184 1927971952 19.051 100 59 116 2 1955452480 11163216 16317312
14:34:15 6342 8192000000 10869521744 11288154112 1930221712 19.069 100 55 108 1 1957963296 12592272 15149312
14:34:32 10662 8192000000 10877112992 11288915968 1930471216 19.071 100 67 135 3 1963348208 14278624 18598368
14:34:57 5707 8192000000 10871237184 11293958144 1933966832 19.099 100 57 114 0 1964619968 14433408 16219728
14:35:18 23346 8192000000 10878155584 11306876928 1945680128 19.192 100 50 100 2 1973905424 14028944 14196352
14:35:52 37762 8192000000 10897505728 11326869504 1948677888 19.216 100 33 64 1 1969725744 11568048 9479808
14:36:51 20231 8192000000 10892141648 11333382144 1960692448 19.312 100 34 68 1 1986385408 15619152 10073808
14:37:19 20437 8192000000 10919156688 11346960384 1976171504 19.434 100 47 94 0 2009363856 19180112 14012240
14:37:55 5416 8192000000 10928036304 11354849280 1980459344 19.468 100 57 111 1 2015847600 18717440 16670816
14:38:09 8676 8192000000 10924544272 11349291008 1980245136 19.467 100 67 131 1 2019087456 20434736 18407584
14:38:26 17794 8192000000 10932257408 11359485952 1984909440 19.504 100 55 110 2 2022191728 21196608 16085680
14:38:53 12631 8192000000 10933630176 11370397696 1994192864 19.577 100 50 100 1 2030164272 21016176 14955232
14:39:27 8099 8192000000 10954620752 11387060224 2002708736 19.644 100 55 110 0 2046357712 26305136 17343840
14:39:48 10311 8192000000 10952060144 11383926784 2003666000 19.652 100 51 102 1 2044884800 25847248 15371552
14:40:10 8748 8192000000 10957049728 11384942592 1986916784 19.519 99 59 118 0 2035253664 31450272 16886608
14:40:34 12680 8192000000 10958168160 11392393216 2006277280 19.672 100 53 105 2 2052168864 30037328 15854256
14:40:57 12353 8192000000 10972041648 11406577664 2013430208 19.729 100 52 104 2 2062177504 32744720 16002576
14:41:19 10602 8192000000 10973083936 11410808832 2017902896 19.764 100 49 98 0 2064969840 32027552 15039392
14:41:37 5042 8192000000 10979198176 11416363008 2022856224 19.803 100 50 96 0 2070811840 32570704 15384912
14:41:48 2676 8192000000 11003216976 11429335040 2031188000 19.868 100 66 131 0 2088868112 37219152 20460960
14:41:59 6601 8192000000 10989552160 11424485376 2023540016 19.808 100 57 109 3 2074072944 34079776 16453152
14:42:16 8803 8192000000 10984745520 11412783104 1994776672 19.582 98 60 120 0 2050671824 37039360 18855792
14:42:34 2741 8192000000 10999076592 11426226176 2021734336 19.794 100 75 150 1 2087870560 42616304 23519920
14:42:48 5224 8192000000 10996464272 11425779712 2025329296 19.822 100 60 120 1 2083615024 39847024 18438704
14:43:03 4546 8192000000 11002281760 11432378368 2031645984 19.872 100 69 138 1 2094180416 41240896 21293536
14:43:16 6546 8192000000 11021837232 11448983552 2037610240 19.918 100 77 152 2 2109539136 47876848 24052048
14:43:30 2934 8192000000 10988595520 11418804224 2016445600 19.752 100 71 142 1 2083420800 44698624 22276576
14:43:42 8582 8192000000 11008292704 11441807360 2030682624 19.864 100 68 134 2 2097495888 45241440 21571824
14:43:59 3719 8192000000 11003571104 11438227456 2031425984 19.870 100 68 137 2 2094591280 42322128 20843168
14:44:11 2832 8192000000 10999877488 11429122048 2027448384 19.839 100 70 141 2 2088836992 40016864 21371744
14:44:23 3024 8192000000 10971753872 11397693440 1995382608 19.586 99 68 135 2 2057407520 41734256 20290656
14:44:33 2865 8192000000 10991009280 11416887296 2006635936 19.675 100 64 125 1 2067597072 41762704 19198432
14:44:45 5209 8192000000 10977731984 11402575872 1989587184 19.541 99 70 140 3 2055300016 42615504 23097328
14:45:00 9682 8192000000 10989316000 11419975680 2010754176 19.707 100 66 132 1 2074083248 43111040 20218032
14:45:18 9328 8192000000 10987573504 11423838208 1998145232 19.608 99 53 106 2 2061754608 46536368 17073008
14:45:39 3502 8192000000 11007638112 11434266624 2020992080 19.788 100 81 161 3 2094587312 49634240 23960992
14:45:49 3070 8192000000 10990699264 11408896000 1980918400 19.472 98 80 161 2 2054515616 48258640 25338576
14:46:00 3754 8192000000 11001517280 11423035392 2008335776 19.688 100 68 136 3 2079643200 49638272 21669152
14:46:10 2424 8192000000 11006753616 11424997376 2011989904 19.717 100 85 166 1 2087840528 50228800 25621824
14:46:19 3681 8192000000 10996388816 11415281664 1977251120 19.443 98 73 146 1 2050197152 50921904 22024128
14:46:31 3549 8192000000 10986143872 11411976192 2001336400 19.633 100 71 138 4 2077938816 54684912 21917504
14:46:42 4049 8192000000 10999921984 11423707136 1998630944 19.612 100 69 136 3 2075228720 55087232 21510544
14:46:55 2125 8192000000 10989160240 11415339008 1984991216 19.504 99 69 139 2 2062271696 55854304 21426176
14:47:04 1930 8192000000 10996324736 11418198016 2000348880 19.625 100 76 149 1 2080727728 56668592 23710256
14:47:13 2623 8192000000 11002927840 11416432640 1990233776 19.546 99 80 157 4 2068329536 54217856 23877904
14:47:24 3504 8192000000 10996402304 11410620416 1981030560 19.473 99 90 179 2 2062747056 54448704 27267792
14:47:34 1251 8192000000 10986182544 11391926272 1977641472 19.446 100 93 184 1 2062612256 55987600 28983184
14:47:42 2678 8192000000 10983295376 11396157440 1979639664 19.462 100 82 163 2 2060409392 55395376 25374352
14:47:53 2315 8192000000 10987874496 11401641984 1987278640 19.522 100 87 174 0 2071639328 56912960 27447728
14:48:03 4422 8192000000 10986916752 11403993088 1988317984 19.531 100 74 144 1 2068429344 56726992 23384368
14:48:14 2528 8192000000 11005465456 11424526336 2002139472 19.640 100 88 177 0 2089025824 58554832 28331520
14:48:24 2186 8192000000 11004498224 11428311040 2005216704 19.664 100 79 156 2 2089881472 59545648 25119120
14:48:32 3702 8192000000 11020445280 11434065920 2008662960 19.691 100 90 177 2 2097804720 60757408 28384352
14:48:43 3773 8192000000 11017572960 11432890368 2008247440 19.688 100 84 167 0 2096599568 61535872 26816256
14:48:53 4745 8192000000 11018228480 11441426432 2010295776 19.704 100 76 151 2 2096777488 61850944 24630768
14:49:07 2036 8192000000 11007311728 11425169408 1988248816 19.530 99 87 171 0 2077845456 62649184 26947456
14:49:16 1829 8192000000 11023506464 11437375488 2008848800 19.692 100 83 165 0 2097195008 62355712 25990496
14:49:25 6061 8192000000 11006352624 11428069376 2002960464 19.646 100 73 146 2 2087059168 60437856 23660848
14:49:39 3279 8192000000 11023628656 11443167232 2013185408 19.727 100 83 166 3 2100008000 61237024 25585568
14:49:55 9340 8192000000 10968422432 11414360064 1986295120 19.515 100 45 90 2 2061069744 59607648 15166976
14:50:14 10295 8192000000 10981161440 11420024832 1989673920 19.541 100 44 89 1 2064252544 59786992 14791632
14:50:40 1442 8192000000 10981954304 11404259328 1971703712 19.399 99 71 143 4 2052071472 56829888 23537872
14:50:48 4117 8192000000 10962131776 11378327552 1953218944 19.252 99 76 147 2 2036135952 59490240 23426768
14:51:00 9877 8192000000 10947966304 11381432320 1956058736 19.275 100 48 96 0 2031461856 59673136 15729984
14:51:16 25990 8192000000 10969608608 11411533824 1972296768 19.404 100 38 76 0 2049727280 64188912 13241600
14:51:55 13382 8192000000 10978079904 11416616960 1982750608 19.486 100 47 94 2 2061649552 62698816 16200128
14:52:15 4283 8192000000 10972793632 11410415616 1964873328 19.345 99 54 107 3 2048817968 65565680 18378960
14:52:27 18213 8192000000 10954544736 11409244160 1946661120 19.200 98 47 92 2 2028638880 66450880 15526880
14:53:11 26563 8192000000 10936075584 11381850112 1946199888 19.196 100 28 56 1 2017173520 61053024 9920608
14:53:48 16078 8192000000 10933203216 11392733184 1947875488 19.210 100 27 53 2 2018461888 60770384 9816016
14:54:16 20933 8192000000 10927784624 11384340480 1947163056 19.204 100 24 48 0 2016074384 59882064 9029264
14:54:44 15898 8192000000 10918904848 11378298880 1920204352 18.988 99 22 45 0 1984649616 55427024 9018240
14:55:06 7873 8192000000 10900889280 11366617088 1935929904 19.114 100 17 34 0 1987824608 45477824 6416880
14:55:21 10650 8192000000 10886398704 11350343680 1919692672 18.984 99 11 22 0 1959724112 35842224 4189216
14:55:40 34597 8192000000 10875601808 11347062784 1882015248 18.681 97 9 17 2 1911592128 26462176 3114704
14:56:29 47346 8192000000 10874626224 11299594240 1871234272 18.594 97 18 35 3 1891305072 14172912 5897888
14:57:24 58626 8192000000 10848148960 11305926656 1887073808 18.722 98 32 63 1 1904949216 8908656 8966752
14:58:52 61249 8192000000 10868062544 11324952576 1929507296 19.063 100 35 70 0 1947412016 7832704 10072016
15:00:05 47155 8192000000 10881707136 11337326592 1940170160 19.148 100 43 86 3 1961362384 9385344 11806880
15:00:59 7145 8192000000 10892974144 11340189696 1950471344 19.230 100 52 107 2 1977869904 12078880 15319680
15:01:12 22761 8192000000 10880937984 11343527936 1953327968 19.253 100 30 60 1 1969028752 7925856 7774928
15:01:42 28031 8192000000 10898748608 11352559616 1966363504 19.357 100 28 54 1 1985430528 12378960 6688064
15:02:17 42318 8192000000 10887726944 11358470144 1949992432 19.226 99 21 42 0 1966730624 11127776 5610416
15:03:06 54525 8192000000 10883793168 11356667904 1928293984 19.053 98 9 18 0 1939953440 9380272 2279184
15:04:07 10097 8192000000 10887387296 11359477760 1969677280 19.383 100 10 20 1 1981040704 9265024 2098400
15:04:23 6791 8192000000 10889525664 11364745216 1968780816 19.376 100 3 6 0 1977753648 8496144 476688
15:04:40 4720 8192000000 10895224368 11368681472 1975821968 19.432 100 14 28 0 1988831056 9600128 3408960
15:04:52 9048 8192000000 10894674880 11370696704 1976299952 19.435 100 9 18 1 1987686256 9131632 2254672
15:05:09 14103 8192000000 10886636848 11358453760 1957139760 19.283 99 14 26 2 1974004432 13142784 3721888
15:06:11 39334 8192000000 10898217776 11374419968 1958390464 19.293 99 16 33 1 1973292768 10791472 4110832
15:07:08 36015 8192000000 10914836176 11383861248 1962853536 19.329 99 23 46 0 1984416016 15104544 6457936
15:08:21 67344 8192000000 10910980384 11382550528 1944118032 19.180 98 13 26 0 1967865536 19563088 4184416
15:09:52 36157 8192000000 10948637904 11417804800 1986853152 19.519 100 25 50 0 2028976912 33536752 8587008
15:10:38 95120 8192000000 10911642544 11391033344 1939985712 19.147 98 11 22 0 1964733408 21457504 3290192
15:12:19 38549 8192000000 10946337328 11391655936 1934350096 19.102 98 35 69 0 1968012912 23363344 10299472
15:13:11 41510 8192000000 10918087552 11371913216 1949204976 19.220 99 33 66 0 1976618688 17775872 9637840
15:14:00 29324 8192000000 10922673264 11379970048 1953118512 19.251 99 22 44 1 1975825504 16796432 5910560
15:14:40 72219 8192000000 10898861504 11385470976 1933662736 19.096 98 19 38 1 1963342672 24182640 5497296
15:15:58 42395 8192000000 10914227392 11371446272 1974831840 19.424 100 20 40 0 1994903152 13717536 6353776
15:16:51 51473 8192000000 10948170224 11381686272 1965526784 19.350 99 37 74 1 1988822960 12322528 10973648
15:17:50 23909 8192000000 10927134816 11377156096 1973298672 19.412 99 47 92 0 1996880400 10083984 13497744
15:18:43 48613 8192000000 10922898368 11387813888 1960863008 19.313 99 25 50 0 1978536288 11122896 6550384
15:19:41 53666 8192000000 10924203392 11389284352 1980931392 19.472 100 13 26 0 1995640816 11037712 3671712
15:20:42 84348 8192000000 10933987728 11387060224 1992194272 19.561 100 19 38 0 2014809152 17140800 5474080
15:22:26 62062 8192000000 10906419472 11361054720 1895688576 18.792 95 30 60 1 1913874336 9898336 8287424
15:23:36 60615 8192000000 10915090576 11368361984 1957917888 19.289 99 34 68 0 1978109680 10946928 9244864
15:24:44 29565 8192000000 10913113424 11357802496 1944852304 19.185 99 34 68 0 1964817904 9770896 10194704
15:25:27 56228 8192000000 10901176272 11372130304 1970246912 19.387 100 24 48 0 1991402128 14143040 7012176
15:26:30 66291 8192000000 10897880096 11372470272 1936533248 19.119 98 11 22 1 1953066896 13805904 2727744
15:27:54 64141 8192000000 10896356672 11367809024 1925254976 19.029 97 24 48 1 1949902816 16902816 7745024
15:29:11 99037 8192000000 10879451568 11373502464 1927464496 19.047 98 19 38 1 1956482144 22965520 6052128
15:31:10 58274 8192000000 10866267488 11339821056 1895621920 18.791 97 9 18 1 1914508736 16526352 2360464
15:32:14 57187 8192000000 10901850256 11363102720 1925761040 19.033 98 27 53 1 1943488848 10875456 6852352
15:33:21 69970 8192000000 10906692992 11363745792 1904511728 18.863 96 19 37 1 1918734848 9083072 5140048
15:34:42 71368 8192000000 10877373760 11343667200 1862376400 18.523 95 10 20 0 1874254976 9440128 2438448
15:36:03 62709 8192000000 10875151312 11339476992 1858835808 18.494 95 11 22 0 1877769424 15688320 3245296
15:37:12 69453 8192000000 10862595264 11330154496 1858719648 18.493 95 23 46 0 1874531872 9601872 6210352
15:38:35 16685 8192000000 10883622208 11334975488 1912244896 18.925 98 33 64 1 1931741088 10755776 8740416
15:38:59 42394 8192000000 10899547552 11358449664 1924715920 19.025 99 26 52 1 1948435312 16491040 7228352
15:39:47 42248 8192000000 10891339440 11364941824 1933277920 19.093 99 23 46 0 1962455424 22468320 6709184
15:41:22 50538 8192000000 10883723376 11334053888 1885838192 18.712 96 34 67 3 1905690368 10325440 9526736
15:42:19 53990 8192000000 10889153552 11338964992 1908343104 18.893 98 22 44 1 1925837856 11973568 5521184
15:43:20 71315 8192000000 10892266944 11340161024 1883790192 18.696 96 24 48 0 1903129216 11622912 7716112
15:44:37 141949 8192000000 10864453168 11327627264 1876938464 18.640 96 19 38 0 1897224976 15019872 5266640
15:47:17 98123 8192000000 10865231216 11338334208 1902791120 18.849 98 16 32 1 1922395008 15052656 4551232
15:49:02 8921 8192000000 10863243632 11343745024 1933046896 19.091 100 6 12 0 1952467024 17723280 1696848
15:49:26 29099 8192000000 10870792096 11340865536 1945567008 19.191 100 14 29 1 1956547360 6788416 4191936
15:50:07 42613 8192000000 10867082016 11339743232 1938594000 19.136 99 17 34 0 1951866928 8175536 5097392
15:50:56 42515 8192000000 10884690080 11359264768 1957498560 19.286 100 13 25 0 1973211456 12220064 3492832
15:51:45 48526 8192000000 10871791392 11338690560 1922176336 19.004 98 9 18 0 1934383408 9477424 2729648
15:52:43 43983 8192000000 10870290864 11353833472 1954507776 19.262 100 6 12 0 1965092000 9128368 1455856
15:53:34 62318 8192000000 10874206592 11341377536 1923761616 19.017 98 22 44 0 1935880192 6006608 6111968
15:54:47 64175 8192000000 10858953072 11329462272 1887821856 18.728 97 11 22 0 1905975424 15373584 2779984
15:55:57 34000 8192000000 10865373040 11339702272 1921682800 19.000 99 12 24 0 1935845760 10721568 3441392
15:56:44 57831 8192000000 10871709984 11346055168 1944896848 19.186 100 11 22 0 1967757776 19875856 2985072
15:58:09 84122 8192000000 10869839840 11337924608 1892494096 18.766 97 12 24 0 1906996288 11118768 3383424
15:59:45 40270 8192000000 10889865984 11355230208 1938148800 19.132 99 21 42 1 1958143424 13857984 6136640
16:00:32 68393 8192000000 10894603872 11370643456 1962659936 19.327 100 16 31 2 1981512560 14596816 4255808
16:01:47 39631 8192000000 10928193104 11377012736 1963033696 19.330 99 42 84 2 1989283872 14408688 11841488
16:02:41 53430 8192000000 10885953136 11372437504 1959130768 19.299 99 39 78 0 1984292192 13886512 11274912
16:03:44 65674 8192000000 10885825440 11348312064 1890209056 18.747 96 13 26 1 1910464400 16743072 3512272
16:04:58 47713 8192000000 10910187920 11357319168 1927288400 19.045 98 22 44 1 1948838704 15220384 6329920
16:05:56 50339 8192000000 10894104208 11355889664 1943262928 19.173 99 30 60 2 1974681824 22795040 8623856
16:06:53 47012 8192000000 10913987808 11381067776 1970201280 19.387 100 31 62 0 1994287344 15822544 8263520
16:07:48 94750 8192000000 10905443440 11370909696 1937768960 19.129 98 23 45 0 1956654224 12472976 6412288
16:09:38 10470 8192000000 10933392112 11380256768 1984105296 19.497 100 63 124 0 2011166080 9475680 17585104
16:09:58 22675 8192000000 10934253216 11386892288 1981074672 19.473 100 43 86 2 2005331872 12252000 12005200
16:10:29 116873 8192000000 10936839680 11377246208 1903242960 18.852 96 22 44 0 1923058704 13885360 5930384
16:12:36 65005 8192000000 10903794912 11370184704 1954565520 19.263 99 37 74 0 1977508256 12634224 10308512
16:15:08 65803 8192000000 10885989616 11353296896 1956872640 19.281 99 18 36 1 1969644320 7469824 5301856
16:16:24 41544 8192000000 10869974000 11345752064 1911728944 18.921 97 7 14 1 1920327536 6669360 1929232
16:17:27 56165 8192000000 10876155792 11347181568 1935667520 19.112 99 13 26 0 1946087744 6516160 3904064
16:18:42 48309 8192000000 10863152320 11331940352 1923033472 19.011 98 9 18 0 1932894720 7152112 2709136
16:19:36 86987 8192000000 10871676368 11362164736 1943001056 19.171 99 11 22 0 1955615344 9437952 3176336
16:21:10 86019 8192000000 10876933872 11349356544 1909289312 18.901 97 8 16 0 1920247984 8926064 2032608
16:22:43 51254 8192000000 10856733760 11332636672 1879965088 18.665 96 12 24 1 1893858560 10609744 3283728
16:23:41 65695 8192000000 10879382112 11352006656 1890187456 18.747 97 26 52 2 1916874864 19180976 7506432
16:25:38 59891 8192000000 10875265536 11339886592 1941108976 19.156 100 15 30 3 1954400528 8886320 4405232
16:26:48 47057 8192000000 10889047504 11342807040 1898194496 18.812 97 20 40 1 1911681472 7489552 5997424
16:27:41 68856 8192000000 10883257376 11361898496 1917159616 18.964 98 15 30 0 1934283600 12223184 4900800
16:29:17 98594 8192000000 10850962864 11304558592 1761535904 17.697 90 18 36 0 1776684432 10550464 4598064
16:31:03 56847 8192000000 9032662864 9221836800 196578352 2.343 11 4 7 0 199126384 1688336 859696

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 30-01-2021 16:32:47 to 30-01-2021 16:33:19.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 121 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:01, from 30-01-2021 16:33:20 to 30-01-2021 16:33:21.

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          234228
MON$OLDEST_ACTIVE               234229
MON$OLDEST_SNAPSHOT             234229
MON$NEXT_TRANSACTION            234229
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                       2003968
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.33407 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33407 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33407 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33407 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Sat Jan 30 16:32:01 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
--- end of diff output ---

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

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