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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17146336 kB
MemAvailable 31449464 kB
Buffers 0 kB
Cached 14564628 kB
SwapCached 3488 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-11-16 01:27:05
DTS_END                         2020-11-16 01:27:05.5660
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/42718
TRN_ID                          241222
ATT_ID                          713
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: 9750.39 17733 1170047
customer order: creation 178.45 343 21414
customer order: refuse 15.40 360 1848
order to supplier: creation 47.19 1209 5663
order to supplier: removal 3.60 104002 432
invoice (draft): creation 46.44 2802 5573
invoice (draft): removal 55.81 810 6697
invoice accept: apply 42.23 16817 5068
invoice accept: cancel 50.91 715 6109
customer reserve: creation 3990.84 163 478901
customer reserve: removal 5010.38 59 601246
realization accept: apply 86.52 173 10382
realization accept: cancel 91.67 102 11000
payment from customer: creation 60.38 99 7246
payment from customer: removal 5.83 63 699
payment to supplier: creation 49.31 119 5917
payment to supplier: removal 3.43 52 412
service: total inventory turnovers 4.67 1044 560
service: total monetary turnovers 6.39 31 767
service: aggregate perf. data 0.91 17040 109
service: refresh index statistics 0.03 208648 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-11-2020 01:29:20 to 16-11-2020 01:29:22.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5646
TEST_TIME 2 5333
TEST_TIME 3 5661
TEST_TIME 4 5457
TEST_TIME 5 5572
TEST_TIME 6 5574
TEST_TIME 7 5875
TEST_TIME 8 5899
TEST_TIME 9 6319
TEST_TIME 10 6143
TEST_TIME 11 6191
TEST_TIME 12 6320
TEST_TIME 13 6798
TEST_TIME 14 6911
TEST_TIME 15 7270
TEST_TIME 16 7518
TEST_TIME 17 7510
TEST_TIME 18 8469
TEST_TIME 19 8782
TEST_TIME 20 8791
TEST_TIME 21 9161
TEST_TIME 22 9097
TEST_TIME 23 9141
TEST_TIME 24 9575
TEST_TIME 25 10093
TEST_TIME 26 10201
TEST_TIME 27 10512
TEST_TIME 28 11297
TEST_TIME 29 11409
TEST_TIME 30 11603
TEST_TIME 31 11448
TEST_TIME 32 11444
TEST_TIME 33 11296
TEST_TIME 34 11352
TEST_TIME 35 11348
TEST_TIME 36 11247
TEST_TIME 37 11039
TEST_TIME 38 10908
TEST_TIME 39 10708
TEST_TIME 40 10660
TEST_TIME 41 10665
TEST_TIME 42 10483
TEST_TIME 43 10478
TEST_TIME 44 10439
TEST_TIME 45 10477
TEST_TIME 46 10443
TEST_TIME 47 10415
TEST_TIME 48 10350
TEST_TIME 49 10236
TEST_TIME 50 10149
TEST_TIME 51 10159
TEST_TIME 52 10066
TEST_TIME 53 10039
TEST_TIME 54 10040
TEST_TIME 55 10066
TEST_TIME 56 10025
TEST_TIME 57 10138
TEST_TIME 58 10041
TEST_TIME 59 10105
TEST_TIME 60 10122
TEST_TIME 61 10250
TEST_TIME 62 10168
TEST_TIME 63 10212
TEST_TIME 64 10207
TEST_TIME 65 10323
TEST_TIME 66 10331
TEST_TIME 67 10292
TEST_TIME 68 10341
TEST_TIME 69 10458
TEST_TIME 70 10403
TEST_TIME 71 10344
TEST_TIME 72 10256
TEST_TIME 73 10279
TEST_TIME 74 10258
TEST_TIME 75 10190
TEST_TIME 76 10153
TEST_TIME 77 10094
TEST_TIME 78 10035
TEST_TIME 79 10053
TEST_TIME 80 10045
TEST_TIME 81 9961
TEST_TIME 82 9906
TEST_TIME 83 9904
TEST_TIME 84 9917
TEST_TIME 85 9928
TEST_TIME 86 9914
TEST_TIME 87 9879
TEST_TIME 88 9945
TEST_TIME 89 9930
TEST_TIME 90 10018
TEST_TIME 91 10015
TEST_TIME 92 10005
TEST_TIME 93 10028
TEST_TIME 94 10050
TEST_TIME 95 10056
TEST_TIME 96 10058
TEST_TIME 97 10026
TEST_TIME 98 9950
TEST_TIME 99 9974
TEST_TIME 100 9920
TEST_TIME 101 9918
TEST_TIME 102 9863
TEST_TIME 103 9869
TEST_TIME 104 9834
TEST_TIME 105 9814
TEST_TIME 106 9788
TEST_TIME 107 9806
TEST_TIME 108 9807
TEST_TIME 109 9787
TEST_TIME 110 9835
TEST_TIME 111 9871
TEST_TIME 112 9840
TEST_TIME 113 9870
TEST_TIME 114 9867
TEST_TIME 115 9963
TEST_TIME 116 9942
TEST_TIME 117 9951
TEST_TIME 118 9891
TEST_TIME 119 9837
TEST_TIME 120 9756

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 16-11-2020 01:29:24 to 16-11-2020 01:29:27.

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 1613603 1613603 0 0.00 0 15947 6 0 0
doc_list_biud 1613603 1613603 0 0.00 0 47839 28 0 0
sp_add_invoice_to_stock 5207 5068 139 2.66 21 217130 16818 0 139
sp_cancel_adding_invoice 6109 6109 0 0.00 3 72016 716 0 0
sp_cancel_client_order 1848 1848 0 0.00 4 9968 361 0 0
sp_cancel_customer_reserve 601246 601246 0 0.00 1 47841 59 0 0
sp_cancel_pay_from_customer 699 699 0 0.00 3 5502 64 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 1291 53 0 0
sp_cancel_supplier_invoice 6721 6697 24 0.35 1 43526 811 0 24
sp_cancel_supplier_order 432 432 0 0.00 6 1008385 104003 0 0
sp_cancel_write_off 11000 11000 0 0.00 1 11700 102 0 0
sp_client_order 21414 21414 0 0.00 3 22129 344 0 0
sp_customer_reserve 478901 478901 0 0.00 0 121514 163 0 0
sp_fill_shopping_cart 32635 32635 0 0.00 1 13641 32 0 0
sp_fill_shopping_cart_clo_res 478884 478884 0 0.00 0 14595 12 0 0
sp_get_clo_for_invoice 5051 5051 0 0.00 0 33645 257 0 0
sp_kill_cost_storno 18220 18220 0 0.00 0 5498 53 0 0
sp_kill_qstorno_ret_qs2qd 1220621 1220621 0 0.00 0 47835 32 0 0
sp_kill_qty_storno 642765 642765 0 0.00 0 47839 69 0 0
sp_lock_selected_doc 21320 21320 0 0.00 0 11052 4 0 0
sp_make_cost_storno 28596 28596 0 0.00 0 15092 51 0 0
sp_multiply_rows_for_pdistr 28596 28596 0 0.00 0 6535 24 0 0
sp_multiply_rows_for_qdistr 21414 21414 0 0.00 0 14376 155 0 0
sp_pay_from_customer 7246 7246 0 0.00 4 15577 99 0 0
sp_pay_to_supplier 5917 5917 0 0.00 5 18869 120 0 0
sp_payment_common 13163 13163 0 0.00 1 18842 26 0 0
sp_qd_handle_on_cancel_clo 1848 1848 0 0.00 0 9961 328 0 0
sp_qd_handle_on_invoice_upd_sts 11160 11160 0 0.00 0 22025 305 0 0
sp_qd_handle_on_reserve_upd_sts 10382 10382 0 0.00 0 15357 60 0 0
sp_reserve_write_off 10382 10382 0 0.00 6 16094 173 0 0
sp_supplier_invoice 5573 5573 0 0.00 6 73863 2803 0 0
sp_supplier_order 5663 5663 0 0.00 5 31131 1210 0 0
srv_aggregate_perf_data 109 109 0 0.00 2468 143544 17040 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 1699 170132 30451 0 0
srv_find_qd_qs_mism 1121063 1121063 0 0.00 0 11687 5 0 0
srv_make_invnt_saldo 560 560 0 0.00 34 87382 1045 0 0
srv_make_money_saldo 767 767 0 0.00 1 7265 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 120527 380966 208649 0 0
t$perf-abend:sp_add_invoice_to_stock 139 139 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 24 24 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5068 5068 0 0.00 0 15383 171 0 0
t$perf-norm:sp_cancel_adding_invoice 405 405 0 0.00 0 2392 69 0 0
t$perf-norm:sp_cancel_client_order 1848 1848 0 0.00 0 5419 10 0 0
t$perf-norm:sp_cancel_customer_reserve 672 672 0 0.00 0 1109 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 699 699 0 0.00 0 2689 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 712 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 422 422 0 0.00 0 6064 41 0 0
t$perf-norm:sp_cancel_supplier_order 432 432 0 0.00 0 45933 1877 0 0
t$perf-norm:sp_cancel_write_off 1001 1001 0 0.00 0 556 2 0 0
t$perf-norm:sp_client_order 21414 21414 0 0.00 0 11440 18 0 0
t$perf-norm:sp_customer_reserve 1020 1020 0 0.00 0 1434 4 0 0
t$perf-norm:sp_pay_from_customer 7246 7246 0 0.00 0 4611 7 0 0
t$perf-norm:sp_pay_to_supplier 5917 5917 0 0.00 0 6564 10 0 0
t$perf-norm:sp_reserve_write_off 10382 10382 0 0.00 0 9888 11 0 0
t$perf-norm:sp_supplier_invoice 5573 5573 0 0.00 0 10912 17 0 0
t$perf-norm:sp_supplier_order 5663 5663 0 0.00 0 9360 15 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 336 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 623 6 0 0
t$perf-norm:srv_make_invnt_saldo 560 560 0 0.00 0 1143 17 0 0
t$perf-norm:srv_make_money_saldo 767 767 0 0.00 0 708 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 10378 10100 278 2.67 0 7877 18 0 278
v_all_customers 39084 39084 0 0.00 0 71 1 0 0
v_all_suppliers 31180 31180 0 0.00 0 144 1 0 0
v_all_wares 42814 42814 0 0.00 0 100 1 0 0
v_cancel_adding_invoice 810 810 0 0.00 0 2271 8 0 0
v_cancel_client_order 3696 3696 0 0.00 0 3401 5 0 0
v_cancel_customer_prepayment 1398 1398 0 0.00 0 2666 6 0 0
v_cancel_customer_reserve 1344 1344 0 0.00 0 1734 6 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 305 3 0 0
v_cancel_supplier_invoice 892 844 48 5.38 0 2375 19 0 48
v_cancel_supplier_order 864 864 0 0.00 0 1430 6 0 0
v_cancel_write_off 2002 2002 0 0.00 0 2807 16 0 0
v_max_id_clo_ord 5660 5660 0 0.00 0 856 2 0 0
v_max_id_clo_res 1020 1020 0 0.00 0 2008 16 0 0
v_max_id_ord_sup 5568 5568 0 0.00 0 5518 6 0 0
v_max_non_paid_invoice 1555 1555 0 0.00 0 1514 3 0 0
v_max_non_paid_realizn 3750 3750 0 0.00 0 750 2 0 0
v_min_id_clo_ord 5660 5660 0 0.00 0 1701 6 0 0
v_min_id_clo_res 1020 1020 0 0.00 0 4009 9 0 0
v_min_id_ord_sup 5568 5568 0 0.00 0 6703 6 0 0
v_min_non_paid_invoice 5917 5917 0 0.00 0 18837 18 0 0
v_min_non_paid_realizn 7246 7246 0 0.00 0 5630 13 0 0
v_our_firm 10722 10722 0 0.00 0 144 1 0 0
v_reserve_write_off 20758 20758 0 0.00 0 2779 5 0 0
x_lock_depdocs_on_canc_invoice 12384 12384 0 0.00 0 11562 100 0 0
x_lock_depdocs_on_canc_sup_ord 432 432 0 0.00 0 12504 333 0 0
x_make_qstorno_1000_1200 5663 5663 0 0.00 2 31121 1138 0 0
x_make_qstorno_1200_2000 5573 5573 0 0.00 2 73853 2686 0 0
x_make_qstorno_2100_3300 478901 478901 0 0.00 0 121511 148 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-11-2020 01:29:28 to 16-11-2020 01:29:32.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:15 15157 8192000000 10187281024 10487353344 797897680 8.875 65 52 106 0 818123936 2385824 17840432
22:57:38 28421 8192000000 10322094496 10632491008 1359256080 14.231 100 87 175 0 1392177920 4571536 28350304
22:58:20 28363 8192000000 10368816048 10689171456 1417384096 14.749 100 90 180 0 1453849168 6613936 29851136
22:59:08 18698 8192000000 10399698784 10724331520 1449239072 15.031 100 89 177 1 1485184240 7520304 28424864
22:59:35 41112 8192000000 10432501856 10763743232 1485277824 15.348 100 89 178 0 1522685936 8718624 28689488
23:00:25 23389 8192000000 10441963408 10776248320 1497754768 15.457 100 85 170 1 1534272176 9342976 27174432
23:00:58 15087 8192000000 10460095600 10798297088 1511320352 15.575 100 80 160 0 1546319888 9328304 25671232
23:01:27 24061 8192000000 10496815024 10838835200 1550279984 15.912 100 89 178 3 1587359904 9685104 27394816
23:02:06 14386 8192000000 10525464144 10878709760 1576461056 16.138 100 72 144 0 1608669248 10225184 21983008
23:02:28 17535 8192000000 10551169760 10906480640 1604565712 16.378 100 76 152 0 1637949840 10607648 22776480
23:02:53 13179 8192000000 10573547360 10935197696 1638546928 16.667 100 79 159 1 1673617056 11825008 23245120
23:03:16 10024 8192000000 10593732768 10954674176 1656721728 16.821 100 84 167 0 1693645280 12524128 24399424
23:03:33 9134 8192000000 10607308656 10975727616 1667811360 16.915 100 77 155 2 1702677232 12338864 22527008
23:03:50 9338 8192000000 10630903552 10998456320 1684300384 17.053 100 73 146 2 1717320752 11989552 21030816
23:04:07 8134 8192000000 10640727088 11010576384 1705762608 17.233 100 75 148 0 1739048288 12282720 21002960
23:04:23 8218 8192000000 10662275744 11037237248 1722558800 17.374 100 79 156 3 1757947440 12689520 22699120
23:04:38 7717 8192000000 10676603312 11052711936 1735194688 17.479 100 71 141 1 1766439712 11396272 19848752
23:04:53 5428 8192000000 10684590224 11067133952 1746532928 17.573 100 72 145 3 1778264592 12049776 19681888
23:05:06 6503 8192000000 10701284272 11080601600 1759450656 17.680 100 83 166 1 1795795184 13228880 23115648
23:05:20 7681 8192000000 10708014832 11088281600 1768791456 17.757 100 78 156 1 1803651728 13009616 21850656
23:05:40 3466 8192000000 10724842512 11110100992 1785165312 17.892 100 76 151 1 1818629824 11800816 21663696
23:05:51 4571 8192000000 10735664592 11120111616 1796281152 17.983 100 71 142 1 1828426352 12418576 19726624
23:06:02 3765 8192000000 10756282832 11147689984 1811704448 18.110 100 82 166 1 1852326832 17776848 22845536
23:06:13 1522 8192000000 10766846352 11152027648 1825276112 18.221 100 91 182 0 1864120464 12933520 25910832
23:06:22 2151 8192000000 10771185264 11157999616 1835802800 18.307 100 86 172 2 1872940000 12824272 24312928
23:06:32 2733 8192000000 10770140464 11161239552 1839139088 18.334 100 93 186 2 1879086816 13723712 26224016
23:06:41 2048 8192000000 10785340368 11171840000 1842896000 18.364 100 86 174 1 1880463424 13547712 24019712
23:06:50 2342 8192000000 10790097248 11174866944 1844501904 18.377 100 85 171 1 1881843776 13166032 24175840
23:06:59 1944 8192000000 10792593616 11180838912 1851288224 18.433 100 90 180 0 1891179200 14166128 25724848
23:07:08 2207 8192000000 10804231760 11189907456 1858681552 18.493 100 87 175 0 1897483088 14480896 24320640
23:07:17 2125 8192000000 10804256656 11189829632 1856623184 18.476 100 89 178 0 1895509824 13575232 25311408
23:07:26 1695 8192000000 10793796720 11186532352 1860640256 18.508 100 81 162 2 1895367792 12696560 22030976
23:07:35 1428 8192000000 10806862464 11197779968 1865141216 18.545 100 93 182 3 1904712480 13046144 26525120
23:07:43 2002 8192000000 10820480096 11207573504 1873356944 18.611 100 94 183 0 1913477712 14108960 26011808
23:07:51 1814 8192000000 10822118880 11209502720 1874835600 18.623 100 94 188 2 1915493216 14097744 26559872
23:07:59 2686 8192000000 10817100224 11213864960 1879253088 18.659 100 83 166 2 1913937024 12108720 22575216
23:08:08 35146 8192000000 10802465408 11210956800 1875530528 18.629 100 50 100 0 1899370592 9987456 13852608
23:08:50 3420 8192000000 10793444640 11212304384 1875641120 18.630 100 45 89 2 1897491392 9882816 11967456
23:08:59 5331 8192000000 10804663488 11216318464 1878899808 18.656 100 56 111 1 1905264560 10497744 15867008
23:09:11 4681 8192000000 10798414112 11219714048 1879133072 18.658 100 49 98 2 1903470416 10960048 13377296
23:09:26 3401 8192000000 10812209952 11219619840 1879869280 18.664 100 51 99 1 1903053296 9674032 13509984
23:09:36 5030 8192000000 10810273904 11218735104 1880452208 18.669 100 48 95 0 1903197440 8590720 14154512
23:09:47 8000 8192000000 10788086112 11218001920 1880291200 18.667 100 35 70 1 1902264912 12542000 9431712
23:10:11 5133 8192000000 10810078096 11228893184 1885321280 18.708 100 39 77 0 1902570336 6270048 10979008
23:10:24 4120 8192000000 10799074000 11227262976 1885061184 18.706 100 40 80 0 1907709504 11547792 11100528
23:10:35 6023 8192000000 10794423184 11218264064 1886305904 18.716 100 37 73 3 1902765904 6019584 10440416
23:10:47 6574 8192000000 10794007600 11221544960 1884333264 18.700 100 25 50 3 1898434528 7156944 6944320
23:11:01 4591 8192000000 10806822992 11223007232 1885784592 18.712 100 25 50 3 1898899280 5723024 7391664
23:11:15 7936 8192000000 10795106400 11225202688 1888300176 18.732 100 20 40 0 1899829232 6243968 5285088
23:11:31 12607 8192000000 10799119408 11229614080 1894641872 18.783 100 33 62 4 1911093232 6626960 9824400
23:11:51 56015 8192000000 10841710896 11250610176 1900102688 18.827 100 27 54 2 1913943168 5171904 8668576
23:12:54 7689 8192000000 10808995200 11242725376 1901554384 18.839 100 18 35 3 1912687056 5498992 5633680
23:13:10 6927 8192000000 10825480272 11252088832 1907092752 18.883 100 44 84 4 1924840272 6034592 11712928
23:13:25 11404 8192000000 10816063744 11250454528 1903281984 18.853 100 24 48 1 1917523200 7409904 6831312
23:13:45 5579 8192000000 10831750080 11255197696 1905289872 18.869 100 27 53 4 1919411584 6453024 7668688
23:14:00 6179 8192000000 10811415840 11251871744 1908040720 18.891 100 40 80 2 1928136608 6921568 13174320
23:14:13 5357 8192000000 10827216864 11258494976 1908998320 18.899 100 29 56 2 1927080544 9604800 8477424
23:14:25 5062 8192000000 10816613376 11255058432 1910564368 18.911 100 28 56 1 1925490176 6917520 8008288
23:14:37 5329 8192000000 10824020720 11256700928 1906595584 18.879 100 19 38 0 1917790816 6100160 5095072
23:14:49 5475 8192000000 10821808672 11255988224 1907073376 18.883 100 20 40 0 1918932048 5882400 5976272
23:15:01 7301 8192000000 10825971632 11258544128 1907314944 18.885 100 21 42 3 1919542048 5896976 6330128
23:15:17 7985 8192000000 10804706016 11248058368 1899573712 18.823 100 20 40 1 1911020976 5568640 5878624
23:15:33 9851 8192000000 10806528208 11248197632 1902589456 18.847 100 19 38 2 1913784688 5006432 6188800
23:15:49 11450 8192000000 10807483648 11247284224 1883149376 18.691 99 23 46 1 1899402720 9860896 6392448
23:16:12 56062 8192000000 10859438528 11257606144 1906491920 18.878 100 61 121 4 1929331408 5250528 17588960
23:17:14 5691 8192000000 10805292416 11243036672 1894526400 18.782 100 29 58 1 1911225184 8935888 7762896
23:17:28 6655 8192000000 10815454768 11245047808 1897407888 18.805 100 28 56 1 1920536352 14376080 8752384
23:17:41 6752 8192000000 10800679280 11229552640 1841613376 18.354 97 28 56 1 1859905824 10583344 7709104
23:17:56 4981 8192000000 10788942256 11201253376 1818172064 18.163 97 46 91 2 1846189712 15698048 12319600
23:18:12 5362 8192000000 10735129968 11160104960 1789495008 17.928 97 24 48 2 1806314448 10286816 6532624
23:18:24 7076 8192000000 10733936032 11156893696 1764804320 17.724 96 24 48 3 1776972320 5047472 7120528
23:18:37 5590 8192000000 10747037040 11168796672 1810988912 18.104 98 35 70 2 1828058832 7006112 10063808
23:18:50 5796 8192000000 10728475168 11137052672 1746107024 17.569 96 30 60 1 1761352800 6462640 8783136
23:19:02 9526 8192000000 10728001056 11140677632 1773226112 17.794 98 25 50 3 1786827552 6306528 7294912
23:19:19 7318 8192000000 10711575936 11136000000 1782653536 17.871 99 17 34 1 1793720928 5487536 5579856
23:19:37 6195 8192000000 10722965488 11132510208 1760532544 17.689 97 29 56 3 1775183472 6050000 8600928
23:19:49 4430 8192000000 10721211072 11144015872 1806996960 18.071 100 22 42 0 1818829088 5618336 6213792
23:20:02 9250 8192000000 10723220368 11139764224 1790199776 17.933 99 20 38 2 1801834880 5717152 5917952
23:20:17 8579 8192000000 10707016016 11118858240 1791248048 17.942 99 28 56 1 1804666064 5854720 7563296
23:20:33 61897 8192000000 10707483584 11114061824 1756523504 17.656 97 29 57 1 1774300544 9571648 8205392
23:21:43 8236 8192000000 10671538064 11089891328 1723632032 17.382 95 19 37 1 1734712128 4905072 6175024
23:21:58 6542 8192000000 10728622352 11142483968 1791585872 17.945 99 32 63 1 1811635424 10632800 9416752
23:22:11 5439 8192000000 10721244768 11135913984 1788234480 17.917 99 22 42 1 1800149552 5464592 6450480
23:22:23 7171 8192000000 10740597136 11142565888 1806593504 18.068 100 24 47 2 1819295168 5808576 6893088
23:22:39 7918 8192000000 10744849056 11158921216 1821834512 18.193 100 35 70 2 1838585824 7234464 9516848
23:22:57 5662 8192000000 10738728208 11157090304 1809776304 18.094 99 34 64 1 1824637680 5543968 9317408
23:23:10 3995 8192000000 10729853008 11153465344 1822339376 18.197 100 46 91 5 1842492640 6114160 14039104
23:23:21 11553 8192000000 10746159440 11167051776 1830142432 18.260 100 17 33 1 1839812000 5012160 4657408
23:23:38 9296 8192000000 10744887120 11174629376 1838099280 18.325 100 20 36 1 1849259408 5317904 5842224
23:23:57 9121 8192000000 10754692000 11180523520 1825174048 18.220 99 14 28 1 1834419200 5483552 3761600
23:24:13 8194 8192000000 10769367568 11194585088 1852606704 18.443 100 25 50 3 1866555072 7308528 6639840
23:24:30 5656 8192000000 10773696640 11199254528 1853117232 18.447 100 24 49 3 1866353984 6838864 6397888
23:24:47 11563 8192000000 10767727072 11197784064 1855636848 18.468 100 24 49 0 1872358784 9559552 7162384
23:25:06 22633 8192000000 10778821312 11196809216 1857232224 18.481 100 14 28 2 1866792416 5349472 4210720
23:25:37 69004 8192000000 10770143696 11203424256 1862668608 18.525 100 38 77 1 1879490320 4920336 11901376
23:26:56 6087 8192000000 10779090064 11205865472 1864639040 18.541 100 24 48 1 1877754832 6903504 6212288
23:27:10 37698 8192000000 10815466416 11233189888 1883265920 18.691 100 37 69 3 1899773376 6341776 10165680
23:27:58 9300 8192000000 10837870368 11250835456 1903687632 18.856 100 58 114 4 1930186976 9678880 16820464
23:28:19 24953 8192000000 10851052992 11269525504 1909197936 18.900 100 47 94 2 1934015808 12025072 12792800
23:28:53 6089 8192000000 10858502144 11277402112 1928494576 19.055 100 62 123 1 1957481888 11798912 17188400
23:29:09 15957 8192000000 10859347856 11284746240 1929494800 19.063 100 45 90 2 1954955936 12295920 13165216
23:29:43 13620 8192000000 10876787184 11301707776 1938847920 19.138 100 41 82 1 1966824240 16703264 11273056
23:30:08 32260 8192000000 10866541392 11305193472 1945112848 19.188 100 43 87 3 1974413920 16639696 12661376
23:30:50 17741 8192000000 10887612976 11312640000 1948752096 19.217 100 39 78 0 1974619264 14249616 11617552
23:31:18 12586 8192000000 10898283440 11321794560 1958413952 19.293 100 54 108 1 1991617952 17482416 15721584
23:31:42 6931 8192000000 10908411984 11328970752 1958548480 19.295 100 53 106 1 1997058368 22734224 15775664
23:32:01 3966 8192000000 10904809872 11329445888 1960758208 19.312 100 55 110 0 1994301248 17545952 15997088
23:32:13 8858 8192000000 10911925120 11329114112 1965240176 19.348 100 65 125 0 2001380352 18152640 17987536
23:32:29 2072 8192000000 10914723456 11329290240 1963979344 19.338 100 65 130 2 2000984304 18034288 18970672
23:32:40 12781 8192000000 10914446144 11338084352 1967115808 19.363 100 63 124 2 2008039216 22167984 18755424
23:33:02 10780 8192000000 10904766176 11335118848 1966352192 19.356 100 57 112 1 2002696240 19166192 17177856
23:33:44 21328 8192000000 10914351792 11353133056 1974159408 19.418 100 34 68 2 2011757952 26813184 10785360
23:34:13 22928 8192000000 10915309456 11355963392 1980212544 19.466 100 33 66 2 2010496992 19587872 10696576
23:34:43 5258 8192000000 10935681296 11363663872 1984567888 19.501 100 41 82 3 2018151072 20811504 12771680
23:34:58 6410 8192000000 10935555488 11367276544 1992065344 19.560 100 58 114 0 2033272624 22653248 18554032
23:35:13 23197 8192000000 10945913680 11379417088 1993935552 19.575 100 44 88 0 2032627920 25438112 13254256
23:35:53 27464 8192000000 10951131008 11388973056 1999679232 19.620 100 49 98 2 2042447504 27832992 14935280
23:36:27 10580 8192000000 10957926336 11390853120 2004316128 19.657 100 54 108 4 2047938416 26964016 16658272
23:36:48 1825 8192000000 10961461344 11391512576 2010441328 19.705 100 53 105 2 2051277392 24997360 15838704
23:37:00 8700 8192000000 10965543520 11398721536 2013732896 19.731 100 49 98 1 2054170416 25314480 15123040
23:37:18 3157 8192000000 10972128624 11399122944 2016705568 19.754 100 68 135 3 2061820272 24955616 20159088
23:37:30 8863 8192000000 10982776752 11408842752 2019597760 19.777 100 63 126 1 2066673024 27150640 19924624
23:37:49 14728 8192000000 10979970560 11410440192 2024289120 19.814 100 69 138 2 2074025440 28667072 21069248
23:38:14 5153 8192000000 10967213408 11394908160 2005117376 19.663 100 62 124 1 2053569840 29497088 18955376
23:38:27 8347 8192000000 10975263840 11402870784 2012578544 19.722 100 70 136 1 2064595936 29504256 22513136
23:38:45 8007 8192000000 10986623504 11408711680 2018397680 19.768 100 80 156 1 2073860128 31288592 24173856
23:39:00 4260 8192000000 10992554480 11419377664 2019995968 19.780 100 65 130 0 2073791568 34291520 19504080
23:39:19 7168 8192000000 10992173248 11426627584 2026911088 19.834 100 56 112 1 2081554944 37041696 17602160
23:39:38 6331 8192000000 11000632096 11434147840 2034265104 19.892 100 60 119 2 2090659520 37626448 18767968
23:39:54 3847 8192000000 10990134576 11415367680 2018315616 19.767 99 72 144 2 2078873056 37888112 22669328
23:40:06 2295 8192000000 10980640560 11401535488 1987485344 19.524 99 72 144 2 2049302864 38790848 23026672
23:40:16 2764 8192000000 10996115120 11413897216 2016786160 19.755 100 83 163 1 2078902816 37213168 24903488
23:40:26 3956 8192000000 10975881968 11406057472 1977218016 19.443 98 73 146 2 2038523888 39045488 22260384
23:40:37 1970 8192000000 10949928256 11357626368 1951133760 19.236 97 85 169 1 2017157200 40058592 25964848
23:40:46 3308 8192000000 10964498224 11388002304 1991083408 19.552 100 74 147 1 2049608896 36102720 22422768
23:40:56 1916 8192000000 10966406144 11384442880 1978161648 19.450 99 79 158 1 2039717520 36672976 24882896
23:41:07 10602 8192000000 10967312080 11396222976 1995933152 19.591 100 67 133 0 2052312944 35836608 20543184
23:41:37 3237 8192000000 10979140032 11407245312 2005644704 19.667 100 61 118 1 2064573152 40450992 18477456
23:41:51 4682 8192000000 10997507568 11423412224 2017062960 19.757 100 63 126 0 2079213264 41271424 20878880
23:42:04 3851 8192000000 10964098384 11385663488 1969641808 19.383 99 72 144 1 2035710992 42723952 23345232
23:42:15 2770 8192000000 10996877376 11411988480 2004159776 19.656 100 80 160 0 2073126592 42978816 25988000
23:42:25 1698 8192000000 10998451968 11414274048 2011030912 19.710 100 89 177 0 2081534304 41867936 28635456
23:42:36 8003 8192000000 10970344608 11405864960 1998482512 19.611 100 60 119 2 2060569552 42430224 19656816
23:42:53 6706 8192000000 10951401392 11377627136 1951154992 19.236 98 60 120 3 2015550928 44062544 20333392
23:43:07 2737 8192000000 10967152464 11391320064 1983873024 19.495 100 68 131 3 2052826640 47233712 21719904
23:43:20 8268 8192000000 10956938256 11389489152 1974376608 19.420 100 51 102 0 2045139472 52136944 18625920
23:43:44 4283 8192000000 10970772000 11407933440 1994843008 19.582 100 64 126 1 2066062736 50207344 21012384
23:44:00 4837 8192000000 10985392496 11404206080 1991240752 19.554 100 72 143 2 2063066368 48502016 23323600
23:44:13 3480 8192000000 10986543376 11406200832 1991153168 19.553 100 80 160 3 2068854688 51053920 26647600
23:44:25 3485 8192000000 10980063120 11395952640 1987501024 19.524 100 78 154 3 2066660544 53758384 25401136
23:44:35 3668 8192000000 10974953472 11394985984 1979036608 19.457 100 69 138 1 2057269184 54618192 23614384
23:44:46 1949 8192000000 10977644736 11386900480 1962246672 19.324 99 83 161 1 2045177520 56231792 26699056
23:44:56 4393 8192000000 10974064560 11393859584 1976178752 19.434 100 74 148 4 2057166208 56695184 24292272
23:45:10 2885 8192000000 10981805968 11404824576 1986266416 19.514 100 74 147 2 2070273232 58837184 25169632
23:45:21 2353 8192000000 10981633360 11406565376 1986965168 19.520 100 77 152 1 2067485152 55698752 24821232
23:45:31 3099 8192000000 10975417968 11403464704 1972139008 19.402 99 67 134 0 2048906576 54846608 21920960
23:45:42 9658 8192000000 10933622752 11376365568 1958812544 19.297 99 36 72 1 2016749168 45421520 12515104
23:46:00 10887 8192000000 10951839808 11390308352 1939182464 19.140 98 48 96 1 2004334288 49581488 15570336
23:46:21 8666 8192000000 10930924768 11376881664 1967990688 19.370 100 41 82 1 2022833104 41566768 13275648
23:46:55 7420 8192000000 10934169568 11370905600 1951328368 19.237 99 44 88 2 2002354368 36587872 14438128
23:47:09 7176 8192000000 10938786112 11375435776 1971819408 19.400 100 41 82 0 2023755056 38195104 13740544
23:47:22 6838 8192000000 10952172064 11388157952 1981146592 19.474 100 50 100 1 2037841072 40550064 16144416
23:47:37 6171 8192000000 10951345088 11388489728 1973032624 19.409 100 50 98 0 2031299088 42397888 15868576
23:47:55 8482 8192000000 10959519088 11398197248 1983290784 19.491 100 49 99 2 2041535472 42393648 15851040
23:48:19 13238 8192000000 10944893312 11394945024 1978387168 19.452 100 32 64 0 2030007072 40832976 10786928
23:48:42 3792 8192000000 10951275792 11401162752 1980003536 19.465 100 35 70 0 2036794608 44893680 11897392
23:49:01 7853 8192000000 10959904992 11399028736 1971497984 19.397 99 42 82 0 2028529856 43735344 13296528
23:49:17 21175 8192000000 10948778304 11398766592 1962851840 19.329 99 33 66 0 2018712640 44955696 10905104
23:50:15 25262 8192000000 10929824176 11377025024 1942264368 19.165 99 30 60 2 1999494816 47222368 10008080
23:50:54 21623 8192000000 10941109104 11384442880 1941299072 19.157 99 30 60 2 2004123328 52228128 10596128
23:51:25 26028 8192000000 10938293824 11384156160 1953411008 19.254 100 27 54 1 2019423904 56302016 9710880
23:52:02 19364 8192000000 10930356512 11383234560 1950740544 19.232 100 28 56 0 2014602240 53988704 9872992
23:52:49 26285 8192000000 10906208288 11369205760 1906372912 18.878 98 22 43 4 1971384912 56816592 8195408
23:53:22 11792 8192000000 10900946128 11356676096 1912250144 18.925 99 26 52 0 1966514512 45311776 8952592
23:53:43 30750 8192000000 10907274240 11361689600 1922973248 19.011 100 26 52 0 1981823712 50182336 8668128
23:54:21 19181 8192000000 10890910144 11363528704 1904613232 18.863 99 22 44 1 1971227344 58649600 7964512
23:55:46 25530 8192000000 10860540992 11335380992 1878998304 18.657 98 10 20 1 1915022192 33039088 2984800
23:56:26 22354 8192000000 10867428368 11309629440 1899399360 18.821 99 37 74 4 1927751040 16767680 11584000
23:56:55 32461 8192000000 10843941728 11311804416 1890568672 18.750 99 19 38 1 1913397296 17450112 5378512
23:57:48 96312 8192000000 10846922704 11308687360 1843328112 18.368 96 16 32 0 1866105248 18396608 4380528
23:59:38 82156 8192000000 10885522624 11346935808 1930357968 19.070 99 39 80 1 1954212752 12800224 11054560
00:01:12 113786 8192000000 10870014464 11334889472 1873339248 18.611 96 12 24 2 1897295776 20376160 3580368
00:03:12 87658 8192000000 10892796080 11331452928 1883425824 18.693 96 33 62 2 1904127936 11764320 8937792
00:04:47 50952 8192000000 10881833472 11328626688 1916984496 18.963 98 38 76 0 1940240384 11121584 12134304
00:06:13 62438 8192000000 10881516912 11323719680 1906760496 18.881 98 47 92 4 1934706752 13137056 14809200
00:07:23 32997 8192000000 10905813472 11336896512 1909999120 18.907 98 45 90 2 1931718720 9465024 12254576
00:08:04 28915 8192000000 10883592480 11340820480 1951832832 19.241 100 30 60 1 1969595200 9792944 7969424
00:08:50 170131 8192000000 10898500768 11356012544 1912955824 18.930 97 26 52 0 1933971392 13446176 7569392
00:11:47 34073 8192000000 10898823888 11354976256 1947176992 19.204 99 31 61 3 1966158368 9756944 9224432
00:12:28 49450 8192000000 10886923824 11364950016 1963398800 19.333 100 37 71 0 1984048768 10410288 10239680
00:13:26 29667 8192000000 10899337680 11367809024 1962895248 19.329 100 19 36 5 1980977296 12972352 5109696
00:14:02 28803 8192000000 10894531392 11370647552 1972545824 19.406 100 30 60 0 1994874416 14205920 8122672
00:14:54 24561 8192000000 10895965392 11375079424 1976443888 19.437 100 17 34 3 1994312112 13456544 4411680
00:15:26 13264 8192000000 10892195648 11377541120 1978191456 19.450 100 8 16 2 1986662976 6455584 2015936
00:15:46 12949 8192000000 10897310192 11377762304 1979839312 19.463 100 5 10 0 1987934336 6665392 1429632
00:16:06 12644 8192000000 10905565808 11382063104 1982201440 19.482 100 5 10 0 1990033680 6749648 1082592
00:16:34 36964 8192000000 10887532528 11363266560 1957080352 19.283 99 12 24 1 1968875952 8360608 3434992
00:17:34 21579 8192000000 10884667456 11366588416 1959957680 19.306 100 10 20 2 1975164256 12146544 3060032
00:18:02 34222 8192000000 10875451776 11367989248 1959293584 19.300 100 8 16 0 1971180272 9774464 2112224
00:18:50 56479 8192000000 10897402704 11369041920 1968394960 19.373 100 25 50 2 1985073008 9351312 7326736
00:19:55 9057 8192000000 10905875296 11372670976 1977813712 19.447 100 30 61 2 1994424256 8158800 8451744
00:20:10 45173 8192000000 10902321232 11388669952 1976930624 19.440 100 15 30 0 1992500656 11614512 3955520
00:21:02 36546 8192000000 10888859360 11379146752 1957041168 19.283 99 3 6 0 1968204672 10209904 953600
00:21:52 40334 8192000000 10879188880 11345133568 1914452208 18.942 97 26 54 1 1929226432 7373584 7400640
00:22:38 49408 8192000000 10899514096 11365228544 1949018672 19.219 99 22 43 1 1967173248 12220160 5934416
00:23:37 73613 8192000000 10891568320 11382657024 1949211296 19.220 99 20 40 2 1969206576 14392960 5602320
00:24:58 31558 8192000000 10896081280 11366608896 1957033520 19.282 99 12 24 0 1967348688 6910512 3404656
00:25:41 16769 8192000000 10907128528 11362467840 1961900064 19.321 99 32 65 1 1979860528 9081088 8879376
00:26:06 24491 8192000000 10889724464 11353808896 1927134368 19.044 98 31 62 0 1949636736 13237888 9264480
00:26:38 45921 8192000000 10886771104 11348643840 1914364944 18.942 98 13 26 1 1931352400 13701984 3285472
00:27:30 58952 8192000000 10883232544 11345022976 1882864176 18.688 96 11 22 2 1896178224 10543152 2770896
00:28:38 42551 8192000000 10833699760 11306782720 1828323936 18.246 94 8 16 0 1844081904 13670256 2087712
00:29:27 19883 8192000000 10886724368 11322638336 1917559040 18.967 99 51 102 1 1939594096 7355360 14679696
00:29:54 14602 8192000000 10899946688 11345993728 1951618176 19.239 100 38 76 0 1973325664 11075328 10632160
00:30:23 68642 8192000000 10861758864 11337277440 1884485648 18.701 97 13 26 0 1904903008 16825536 3591824
00:31:43 46542 8192000000 10860044336 11308314624 1881334512 18.676 97 17 34 0 1900156176 13915712 4905952
00:32:36 64348 8192000000 10843823968 11304226816 1865283824 18.546 96 14 28 1 1883867472 14642704 3940944
00:33:47 71500 8192000000 10878357392 11335372800 1902781328 18.849 98 16 32 0 1930343856 23102960 4459568
00:35:05 47686 8192000000 10876435632 11349454848 1876996032 18.641 97 11 22 0 1905011888 24926064 3089792
00:35:59 49586 8192000000 10866841872 11364478976 1925989712 19.035 100 7 14 1 1956516016 28348400 2177904
00:37:00 113707 8192000000 10836278928 11305586688 1874289264 18.619 97 17 34 1 1889533296 10834016 4410016
00:39:49 61408 8192000000 10850806560 11326050304 1913270384 18.933 99 30 60 3 1935204800 13669104 8265312
00:40:56 88846 8192000000 10853234928 11336531968 1897317584 18.805 98 10 20 0 1915499456 15381456 2800416
00:42:35 34661 8192000000 10857637040 11334295552 1913131136 18.932 99 8 16 0 1934822128 19330704 2360288
00:43:17 52454 8192000000 10837611552 11313405952 1899952864 18.826 98 17 35 0 1914378048 9835408 4589776
00:44:23 46322 8192000000 10847745968 11319930880 1911895184 18.922 99 10 20 0 1925511232 10741360 2874688
00:45:22 98016 8192000000 10837451088 11319132160 1911385312 18.918 99 19 38 0 1932813168 16107376 5320480
00:47:06 9836 8192000000 10859208832 11322134528 1925638784 19.032 100 22 41 0 1942749488 10367760 6742944
00:47:24 73930 8192000000 10856530240 11342573568 1935103312 19.108 100 2 4 0 1948621600 13086608 431680
00:48:44 39320 8192000000 10868777088 11355484160 1946533824 19.199 100 7 14 0 1964090464 15771184 1785456
00:50:25 50530 8192000000 10878534816 11347324928 1902125440 18.843 97 24 48 1 1920374560 11506000 6743120
00:51:23 41452 8192000000 10875850000 11340267520 1918170608 18.972 99 11 22 0 1933684864 12213936 3300320
00:53:23 25712 8192000000 10861671520 11320389632 1911130496 18.916 98 33 66 2 1927846096 7813904 8901696
00:54:05 23568 8192000000 10914340272 11366547456 1956489120 19.278 100 44 88 0 1981235952 12581664 12165168
00:54:36 51850 8192000000 10909614208 11377295360 1969824544 19.384 100 28 56 0 1992444832 14757456 7862832
00:55:40 41218 8192000000 10884239056 11364638720 1942913584 19.170 99 16 32 1 1966241872 18594464 4733824
00:56:27 56981 8192000000 10906954432 11368435712 1927969424 19.051 98 31 61 1 1952759584 16279744 8510416
00:57:37 56055 8192000000 10894918496 11363631104 1926594224 19.040 98 17 34 0 1942326400 11271968 4460208
00:58:47 40188 8192000000 10908352784 11373682688 1953592288 19.255 99 15 30 3 1966061536 8421072 4048176
00:59:35 16012 8192000000 10910407024 11365875712 1958657968 19.295 99 25 50 1 1972727616 7362816 6706832
00:59:57 10763 8192000000 10939962464 11388600320 1985154800 19.505 100 50 100 0 2008281728 8984544 14142384
01:00:15 21070 8192000000 10916082640 11374600192 1945756784 19.193 98 42 84 3 1971183584 13944496 11482304
01:00:49 83222 8192000000 10884164752 11357134848 1895533216 18.790 96 25 50 1 1916260480 13742912 6984352
01:02:19 78528 8192000000 10919430896 11380432896 1953679504 19.256 99 19 38 2 1970610432 11781392 5149536
01:03:43 49304 8192000000 10887930256 11355840512 1904913856 18.866 96 38 76 1 1924539104 9094640 10530608
01:04:45 75902 8192000000 10904544416 11368226816 1972657104 19.407 100 46 88 2 1992904688 8607392 11640192
01:06:10 69627 8192000000 10890161872 11374514176 1946690448 19.200 99 11 22 0 1959917712 10301072 2926192
01:07:26 5935 8192000000 10888791936 11370151936 1966873072 19.361 100 9 19 1 1980288752 11088016 2327664
01:07:38 23979 8192000000 10899607408 11362766848 1925092832 19.028 98 18 36 0 1938116976 8360496 4663648
01:08:20 57782 8192000000 10870887312 11350122496 1910337168 18.909 97 11 22 1 1921432384 7972320 3122896
01:09:28 60412 8192000000 10882076944 11358650368 1917353472 18.966 98 8 16 1 1927328192 7963520 2011200
01:10:59 42682 8192000000 10869992896 11353444352 1924314064 19.021 98 9 18 0 1935420416 8475568 2630784
01:11:55 71342 8192000000 10878631344 11354497024 1901915424 18.842 97 15 30 1 1914046688 7962240 4169024
01:13:19 72434 8192000000 10871901696 11358109696 1924781728 19.025 98 8 16 0 1937499968 10756560 1961680
01:14:38 27326 8192000000 10876062032 11345465344 1923325984 19.013 98 16 33 0 1937305936 9356400 4623552
01:15:38 53897 8192000000 10898491936 11367899136 1917829744 18.969 97 18 35 2 1931209216 8153920 5225552
01:16:44 85797 8192000000 10876104816 11351134208 1870867200 18.591 95 15 30 0 1891780272 16750928 4162144
01:18:16 64146 8192000000 10868692112 11339038720 1913777008 18.937 98 12 24 0 1928902400 11735200 3390192
01:19:27 13471 8192000000 10846371792 11304681472 1846369952 18.393 95 25 50 2 1860146416 5946768 7829696
01:19:51 29333 8192000000 10889822352 11341754368 1943109728 19.172 100 37 74 0 1967673088 14051584 10511776
01:20:26 37907 8192000000 10886178640 11345240064 1908236704 18.892 98 29 58 3 1928201392 11368048 8596640
01:21:12 107168 8192000000 10856917664 11348836352 1865959472 18.552 96 17 34 0 1889634448 19013280 4661696
01:24:18 35300 8192000000 10853948224 11319324672 1868232416 18.570 97 12 24 0 1886351376 14652496 3466464
01:25:01 17899 8192000000 10872556944 11329953792 1929894912 19.066 100 36 72 1 1951615120 11428832 10291376
01:25:36 103058 8192000000 9290412784 9563344896 446366976 5.167 23 15 30 2 467193152 15873536 4952640

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 16-11-2020 01:29:34 to 16-11-2020 01:30:06.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 139 v_add_invoice_to_stock 335544517
except 24 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-11-2020 01:30:07 to 16-11-2020 01:30:09.

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          239454
MON$OLDEST_ACTIVE               241867
MON$OLDEST_SNAPSHOT             241867
MON$NEXT_TRANSACTION            241867
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                       2052704
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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 ---
:149: 
:150: mscs-test-161.budzdorov.ru    Mon Nov 16 01:28:02 2020
:151:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:152: 
:153: 
:154: mscs-test-161.budzdorov.ru    Mon Nov 16 01:28:03 2020
:155:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:156: 
--- end of diff output ---

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

16.11.20 01:30:10. 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-11-16 01:30:13 No severe PSQL-related problems occured
16.11.20 01:30:14. End of report.