Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.11.2020 16:31
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 17251344 kB
MemAvailable 31449560 kB
Buffers 0 kB
Cached 14408456 kB
SwapCached 2868 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.7
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-04 16:30:48
DTS_END                         2020-11-04 16:30:48.1350
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/33192
TRN_ID                          242439
ATT_ID                          644
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: 9464.24 21053 1135709
customer order: creation 172.78 367 20733
customer order: refuse 14.96 338 1795
order to supplier: creation 46.27 1307 5552
order to supplier: removal 3.43 103109 411
invoice (draft): creation 44.35 3344 5322
invoice (draft): removal 53.61 767 6433
invoice accept: apply 41.96 19345 5035
invoice accept: cancel 48.73 843 5848
customer reserve: creation 3913.85 190 469662
customer reserve: removal 4819.38 58 578325
realization accept: apply 84.26 194 10111
realization accept: cancel 89.65 102 10758
payment from customer: creation 60.28 112 7233
payment from customer: removal 6.08 106 730
payment to supplier: creation 48.53 150 5824
payment to supplier: removal 3.38 120 406
service: total inventory turnovers 5.11 1194 613
service: total monetary turnovers 6.71 26 805
service: aggregate perf. data 0.91 20087 109
service: refresh index statistics 0.03 269305 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-11-2020 16:31:34 to 04-11-2020 16:31:36.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2870
TEST_TIME 2 4652
TEST_TIME 3 5274
TEST_TIME 4 4826
TEST_TIME 5 4748
TEST_TIME 6 5687
TEST_TIME 7 5301
TEST_TIME 8 5583
TEST_TIME 9 6090
TEST_TIME 10 6280
TEST_TIME 11 6514
TEST_TIME 12 6789
TEST_TIME 13 7504
TEST_TIME 14 7690
TEST_TIME 15 8123
TEST_TIME 16 8291
TEST_TIME 17 8726
TEST_TIME 18 8769
TEST_TIME 19 9067
TEST_TIME 20 9148
TEST_TIME 21 9264
TEST_TIME 22 9155
TEST_TIME 23 9838
TEST_TIME 24 10107
TEST_TIME 25 10136
TEST_TIME 26 10367
TEST_TIME 27 10187
TEST_TIME 28 10315
TEST_TIME 29 10492
TEST_TIME 30 10700
TEST_TIME 31 11165
TEST_TIME 32 11488
TEST_TIME 33 11578
TEST_TIME 34 11284
TEST_TIME 35 10971
TEST_TIME 36 10928
TEST_TIME 37 10763
TEST_TIME 38 10807
TEST_TIME 39 10657
TEST_TIME 40 10506
TEST_TIME 41 10408
TEST_TIME 42 10345
TEST_TIME 43 10211
TEST_TIME 44 10082
TEST_TIME 45 10023
TEST_TIME 46 10200
TEST_TIME 47 10024
TEST_TIME 48 9900
TEST_TIME 49 10235
TEST_TIME 50 10204
TEST_TIME 51 10139
TEST_TIME 52 10063
TEST_TIME 53 10030
TEST_TIME 54 9926
TEST_TIME 55 9811
TEST_TIME 56 9814
TEST_TIME 57 9663
TEST_TIME 58 9698
TEST_TIME 59 9622
TEST_TIME 60 9578
TEST_TIME 61 9466
TEST_TIME 62 9513
TEST_TIME 63 9452
TEST_TIME 64 9483
TEST_TIME 65 9441
TEST_TIME 66 9542
TEST_TIME 67 9598
TEST_TIME 68 9583
TEST_TIME 69 9542
TEST_TIME 70 9659
TEST_TIME 71 9658
TEST_TIME 72 9632
TEST_TIME 73 9686
TEST_TIME 74 9745
TEST_TIME 75 9714
TEST_TIME 76 9709
TEST_TIME 77 9652
TEST_TIME 78 9588
TEST_TIME 79 9562
TEST_TIME 80 9529
TEST_TIME 81 9492
TEST_TIME 82 9485
TEST_TIME 83 9473
TEST_TIME 84 9426
TEST_TIME 85 9372
TEST_TIME 86 9408
TEST_TIME 87 9356
TEST_TIME 88 9434
TEST_TIME 89 9438
TEST_TIME 90 9471
TEST_TIME 91 9421
TEST_TIME 92 9475
TEST_TIME 93 9568
TEST_TIME 94 9560
TEST_TIME 95 9568
TEST_TIME 96 9603
TEST_TIME 97 9605
TEST_TIME 98 9675
TEST_TIME 99 9707
TEST_TIME 100 9685
TEST_TIME 101 9602
TEST_TIME 102 9598
TEST_TIME 103 9589
TEST_TIME 104 9556
TEST_TIME 105 9526
TEST_TIME 106 9513
TEST_TIME 107 9467
TEST_TIME 108 9444
TEST_TIME 109 9435
TEST_TIME 110 9398
TEST_TIME 111 9366
TEST_TIME 112 9395
TEST_TIME 113 9405
TEST_TIME 114 9440
TEST_TIME 115 9411
TEST_TIME 116 9447
TEST_TIME 117 9464
TEST_TIME 118 9478
TEST_TIME 119 9470
TEST_TIME 120 9471

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 04-11-2020 16:31:38 to 04-11-2020 16:31:41.

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 1568969 1568969 0 0.00 0 26969 7 0 0
doc_list_biud 1568966 1568966 0 0.00 0 49086 27 0 0
sp_add_invoice_to_stock 5184 5035 149 2.87 20 194665 19346 0 149
sp_cancel_adding_invoice 5848 5848 0 0.00 2 55327 843 0 0
sp_cancel_client_order 1795 1795 0 0.00 4 13182 338 0 0
sp_cancel_customer_reserve 578325 578325 0 0.00 1 49090 58 0 0
sp_cancel_pay_from_customer 730 730 0 0.00 3 5844 107 0 0
sp_cancel_pay_to_supplier 406 406 0 0.00 3 8895 120 0 0
sp_cancel_supplier_invoice 6440 6433 7 0.10 2 30387 767 0 7
sp_cancel_supplier_order 411 411 0 0.00 9 937882 103110 0 0
sp_cancel_write_off 10758 10758 0 0.00 1 13674 102 0 0
sp_client_order 20733 20733 0 0.00 3 28263 367 0 0
sp_customer_reserve 469662 469662 0 0.00 0 39333 190 0 0
sp_fill_shopping_cart 31601 31601 0 0.00 1 17369 40 0 0
sp_fill_shopping_cart_clo_res 469643 469643 0 0.00 0 15576 14 0 0
sp_get_clo_for_invoice 5016 5016 0 0.00 0 22010 301 0 0
sp_kill_cost_storno 17742 17742 0 0.00 0 26957 59 0 0
sp_kill_qstorno_ret_qs2qd 1174252 1174252 0 0.00 0 41252 31 0 0
sp_kill_qty_storno 618694 618694 0 0.00 0 49086 68 0 0
sp_lock_selected_doc 20989 20989 0 0.00 0 7809 6 0 0
sp_make_cost_storno 28184 28184 0 0.00 0 25108 62 0 0
sp_multiply_rows_for_pdistr 28183 28183 0 0.00 0 8853 32 0 0
sp_multiply_rows_for_qdistr 20733 20733 0 0.00 0 24463 171 0 0
sp_pay_from_customer 7233 7233 0 0.00 4 11313 112 0 0
sp_pay_to_supplier 5824 5824 0 0.00 5 25126 150 0 0
sp_payment_common 13057 13057 0 0.00 1 10637 36 0 0
sp_qd_handle_on_cancel_clo 1795 1795 0 0.00 0 13174 314 0 0
sp_qd_handle_on_invoice_upd_sts 10861 10861 0 0.00 0 37762 333 0 0
sp_qd_handle_on_reserve_upd_sts 10111 10111 0 0.00 0 28000 66 0 0
sp_reserve_write_off 10111 10111 0 0.00 6 28129 194 0 0
sp_supplier_invoice 5322 5322 0 0.00 7 109716 3344 0 0
sp_supplier_order 5552 5552 0 0.00 5 40931 1308 0 0
srv_aggregate_perf_data 109 109 0 0.00 2508 338220 20088 0 0
srv_fill_mon_cache_memory 171 171 0 0.00 945 129352 29679 0 0
srv_find_qd_qs_mism 1086746 1086746 0 0.00 0 11469 5 0 0
srv_make_invnt_saldo 613 613 0 0.00 52 94202 1194 0 0
srv_make_money_saldo 805 805 0 0.00 1 558 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 67594 362712 269305 0 0
t$perf-abend:sp_add_invoice_to_stock 149 149 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5036 5036 0 0.00 0 18770 192 0 0
t$perf-norm:sp_cancel_adding_invoice 427 427 0 0.00 1 2667 91 0 0
t$perf-norm:sp_cancel_client_order 1795 1795 0 0.00 0 2846 15 0 0
t$perf-norm:sp_cancel_customer_reserve 722 722 0 0.00 0 2163 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 730 730 0 0.00 0 598 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 406 406 0 0.00 0 2017 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 385 385 0 0.00 0 1418 29 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 26904 1989 0 0
t$perf-norm:sp_cancel_write_off 989 989 0 0.00 0 1266 5 0 0
t$perf-norm:sp_client_order 20733 20733 0 0.00 0 11624 18 0 0
t$perf-norm:sp_customer_reserve 1025 1025 0 0.00 0 2059 6 0 0
t$perf-norm:sp_pay_from_customer 7233 7233 0 0.00 0 6357 11 0 0
t$perf-norm:sp_pay_to_supplier 5824 5824 0 0.00 0 20757 17 0 0
t$perf-norm:sp_reserve_write_off 10111 10111 0 0.00 0 6177 10 0 0
t$perf-norm:sp_supplier_invoice 5322 5322 0 0.00 0 7699 21 0 0
t$perf-norm:sp_supplier_order 5552 5552 0 0.00 0 6839 16 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 904 21 0 0
t$perf-norm:srv_fill_mon_cache_memory 171 171 0 0.00 0 346 2 0 0
t$perf-norm:srv_make_invnt_saldo 613 613 0 0.00 0 3926 26 0 0
t$perf-norm:srv_make_money_saldo 805 805 0 0.00 0 3410 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 34 10 0 0
v_add_invoice_to_stock 10324 10026 298 2.88 0 6147 20 0 298
v_all_customers 37502 37502 0 0.00 0 152 1 0 0
v_all_suppliers 30044 30044 0 0.00 0 80 1 0 0
v_all_wares 41464 41464 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 854 854 0 0.00 0 313 6 0 0
v_cancel_client_order 3590 3590 0 0.00 0 2003 6 0 0
v_cancel_customer_prepayment 1460 1460 0 0.00 0 3666 9 0 0
v_cancel_customer_reserve 1444 1444 0 0.00 0 3136 7 0 0
v_cancel_payment_to_supplier 812 812 0 0.00 0 5776 15 0 0
v_cancel_supplier_invoice 784 770 14 1.78 0 1637 19 0 14
v_cancel_supplier_order 822 822 0 0.00 0 1546 8 0 0
v_cancel_write_off 1978 1978 0 0.00 0 3437 14 0 0
v_max_id_clo_ord 5552 5552 0 0.00 0 2076 2 0 0
v_max_id_clo_res 1025 1025 0 0.00 0 3021 24 0 0
v_max_id_ord_sup 5317 5317 0 0.00 0 8223 4 0 0
v_max_non_paid_invoice 1671 1671 0 0.00 0 2650 4 0 0
v_max_non_paid_realizn 4105 4105 0 0.00 0 4006 5 0 0
v_min_id_clo_ord 5552 5552 0 0.00 0 10251 13 0 0
v_min_id_clo_res 1025 1025 0 0.00 0 8020 14 0 0
v_min_id_ord_sup 5317 5317 0 0.00 0 3498 5 0 0
v_min_non_paid_invoice 5824 5824 0 0.00 0 8836 23 0 0
v_min_non_paid_realizn 7233 7233 0 0.00 0 7316 24 0 0
v_our_firm 10218 10218 0 0.00 0 16 1 0 0
v_reserve_write_off 20222 20222 0 0.00 0 5910 6 0 0
x_lock_depdocs_on_canc_invoice 11896 11896 0 0.00 0 15394 129 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 4162 333 0 0
x_make_qstorno_1000_1200 5552 5552 0 0.00 2 40904 1220 0 0
x_make_qstorno_1200_2000 5322 5322 0 0.00 3 109704 3204 0 0
x_make_qstorno_2100_3300 469662 469662 0 0.00 0 39329 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-11-2020 16:31:42 to 04-11-2020 16:31:46.

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:00:51 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:00:58 16976 8192000000 10238942784 10545729536 974139184 10.627 77 55 112 0 996534928 2769072 19626672
14:01:23 19033 8192000000 10333186192 10646859776 1381259424 14.428 100 90 180 0 1415011296 4191232 29560640
14:01:56 22871 8192000000 10390102768 10712526848 1441948944 14.967 100 89 178 0 1476095696 6128976 28017776
14:02:30 14180 8192000000 10408359856 10735386624 1461513296 15.139 100 87 172 2 1496306032 7056656 27736080
14:02:55 23945 8192000000 10435266912 10764132352 1485607728 15.350 100 90 180 0 1522590400 7963600 29019072
14:03:27 1225 8192000000 10445485680 10776924160 1501828384 15.492 100 91 182 0 1539286992 8639072 28819536
14:03:39 13591 8192000000 10452206432 10786369536 1506847472 15.536 100 91 182 0 1545060256 9261776 28951008
14:04:09 21797 8192000000 10476722992 10818088960 1524554160 15.690 100 84 168 0 1560617536 9402848 26660528
14:04:46 12528 8192000000 10503946752 10847281152 1556888768 15.969 100 84 167 0 1592886336 9797040 26200528
14:05:09 16109 8192000000 10519516720 10869854208 1582246240 16.187 100 84 168 3 1619203504 10546928 26410336
14:05:34 13828 8192000000 10543847056 10900844544 1600269232 16.342 100 80 160 0 1635203520 10506496 24427792
14:05:57 7253 8192000000 10566923056 10923790336 1624228384 16.546 100 79 158 0 1659340784 11103120 24009280
14:06:15 9748 8192000000 10592693360 10955313152 1644037728 16.714 100 78 154 1 1678701808 11061504 23602576
14:06:33 6424 8192000000 10602501136 10965950464 1664812352 16.889 100 80 160 1 1700230416 11411840 24006224
14:06:46 11325 8192000000 10629820672 10994102272 1680337216 17.020 100 72 143 2 1711575184 10791488 20446480
14:07:06 8919 8192000000 10638228272 11006836736 1700510944 17.189 100 77 154 2 1733421232 11216016 21694272
14:07:26 10040 8192000000 10658859936 11031588864 1718181856 17.337 100 81 162 1 1753549152 12219056 23148240
14:07:44 6404 8192000000 10678854496 11052466176 1738861840 17.509 100 84 170 2 1775563808 12910400 23791568
14:07:58 5659 8192000000 10699937248 11075850240 1755029856 17.643 100 84 168 0 1792914912 13768848 24116208
14:08:11 8362 8192000000 10704524528 11082137600 1763270096 17.711 100 76 150 5 1797430016 13526192 20633728
14:08:27 5287 8192000000 10705118832 11084955648 1768835904 17.757 100 93 181 1 1809097584 14692992 25568688
14:08:39 5746 8192000000 10714803856 11091931136 1769242256 17.761 100 81 159 2 1804769472 12559248 22967968
14:08:52 3137 8192000000 10722097920 11098726400 1778102144 17.834 100 81 162 1 1812926928 11967408 22857376
14:09:02 4239 8192000000 10718987136 11103592448 1781998576 17.866 100 76 152 1 1815657200 11325792 22332832
14:09:13 3123 8192000000 10736245616 11116711936 1793481360 17.960 100 79 157 0 1827931008 12414096 22035552
14:09:23 8501 8192000000 10736624912 11125243904 1798896880 18.005 100 78 155 0 1836626976 16026320 21703776
14:09:40 3624 8192000000 10753902560 11139559424 1805443344 18.059 100 75 148 3 1837090064 10912272 20734448
14:09:51 2921 8192000000 10774997600 11161690112 1834466016 18.296 100 86 171 2 1868760992 10848192 23446784
14:10:00 3653 8192000000 10773875888 11165466624 1838603456 18.329 100 89 178 2 1876569616 13289776 24676384
14:10:10 3332 8192000000 10782336304 11171065856 1844315616 18.376 100 84 169 1 1880414880 12512352 23586912
14:10:20 3541 8192000000 10786756656 11178614784 1852179920 18.440 100 79 159 1 1887538480 13496464 21862096
14:10:30 1610 8192000000 10804471232 11192827904 1860924224 18.511 100 93 186 0 1902014192 14690256 26399712
14:10:38 1485 8192000000 10808303856 11197890560 1863361760 18.531 100 93 187 1 1903641648 14077840 26202048
14:10:46 1659 8192000000 10805106080 11193634816 1866788960 18.558 100 94 187 3 1906257520 14160992 25307568
14:10:54 1784 8192000000 10812011600 11201351680 1865612816 18.549 100 85 169 0 1903070608 13971008 23486784
14:11:03 1774 8192000000 10813122112 11199942656 1869199280 18.578 100 93 187 1 1910317088 14141376 26976432
14:11:11 1208 8192000000 10811998896 11198709760 1868180512 18.570 100 91 182 1 1907491952 13561120 25750320
14:11:19 1630 8192000000 10819042080 11205120000 1869756144 18.582 100 97 195 1 1910870880 13937120 27177616
14:11:27 2416 8192000000 10806541104 11197825024 1865347568 18.547 100 68 136 2 1898044496 13718144 18978784
14:11:36 3824 8192000000 10801877792 11205292032 1870831952 18.591 100 72 142 1 1903758016 12584752 20341312
14:11:46 30748 8192000000 10777841872 11198750720 1865959488 18.552 100 34 68 1 1882653808 7103872 9590448
14:12:29 4202 8192000000 10804225456 11213438976 1879771504 18.663 100 62 123 3 1903461520 5862640 17827376
14:12:42 6221 8192000000 10794355808 11210838016 1874753296 18.623 100 31 58 5 1890055056 5626656 9675104
14:12:54 5093 8192000000 10790551984 11209625600 1875975392 18.633 100 30 60 1 1892133728 7102224 9056112
14:13:07 5769 8192000000 10792947760 11215024128 1878015520 18.649 100 40 80 3 1898839680 9797072 11027088
14:13:22 6228 8192000000 10784747520 11215970304 1875005776 18.625 100 24 48 0 1887957552 6046544 6905232
14:13:36 9306 8192000000 10793870992 11221360640 1880165520 18.666 100 24 47 2 1892663984 5851472 6646992
14:13:52 5556 8192000000 10794813760 11221622784 1884846448 18.704 100 24 48 1 1897988768 6264464 6877856
14:14:10 7396 8192000000 10792322464 11227643904 1887977312 18.729 100 24 48 1 1902417584 7920720 6519552
14:14:25 9817 8192000000 10796889600 11230060544 1889706528 18.743 100 13 25 0 1898662384 5839952 3115904
14:14:44 8910 8192000000 10797906000 11230593024 1890584912 18.750 100 16 33 1 1900976288 6419808 3971568
14:14:59 5018 8192000000 10803328688 11236958208 1894799904 18.784 100 15 30 1 1904574272 5476176 4298192
14:15:12 61431 8192000000 10820769552 11250610176 1900552416 18.831 100 34 65 1 1915665504 5252304 9860784
14:16:24 8508 8192000000 10820951152 11245621248 1896768528 18.800 100 19 38 1 1907623792 5204960 5650304
14:16:40 4284 8192000000 10827085216 11254337536 1906074240 18.875 100 45 90 3 1926921312 8607216 12239856
14:16:53 5394 8192000000 10824274912 11259154432 1909951232 18.906 100 52 104 5 1932110448 7523536 14635680
14:17:05 5428 8192000000 10825547952 11254726656 1908087392 18.891 100 33 65 1 1924184080 6811584 9285104
14:17:17 4762 8192000000 10830009216 11261071360 1911314352 18.917 100 36 71 2 1928187440 7110464 9762624
14:17:30 8186 8192000000 10823810688 11260170240 1910672320 18.912 100 26 53 1 1924756800 6461232 7623248
14:17:45 9201 8192000000 10836535616 11266949120 1913065760 18.931 100 23 45 2 1925976464 6244176 6666528
14:18:02 14285 8192000000 10828229552 11264987136 1915880112 18.954 100 17 34 2 1926870688 6298864 4691712
14:18:23 14749 8192000000 10831166640 11267698688 1915942752 18.954 100 18 34 2 1926582800 5563904 5076144
14:18:45 12209 8192000000 10832211936 11268329472 1917137328 18.964 100 12 24 0 1925419088 5255760 3026000
14:19:07 12496 8192000000 10824985552 11256307712 1864206912 18.537 97 22 44 3 1876981984 6117504 6657568
14:19:27 69321 8192000000 10821604832 11251814400 1856281408 18.473 97 29 58 0 1869639328 5243776 8114144
14:20:48 9360 8192000000 10813431792 11248263168 1883384112 18.692 99 30 58 2 1897209040 5902400 7922528
14:21:03 7109 8192000000 10794030288 11214286848 1854876192 18.462 98 36 72 3 1872305696 7442048 9987456
14:21:17 5725 8192000000 10785764112 11219292160 1833853232 18.291 97 20 39 2 1845823120 5648512 6321376
14:21:33 5614 8192000000 10751193776 11179577344 1811002688 18.104 97 24 48 0 1823972304 5036432 7933184
14:21:49 7379 8192000000 10753531504 11170299904 1770253968 17.769 95 23 47 0 1782556464 4917680 7384816
14:22:03 5329 8192000000 10713691328 11133607936 1752338320 17.621 96 24 46 3 1764969504 5625008 7006176
14:22:15 6768 8192000000 10720781280 11136368640 1781152336 17.859 98 23 46 0 1793663184 6228896 6281952
14:22:29 11749 8192000000 10734069488 11148271616 1755136464 17.644 96 22 44 2 1766628080 4882576 6609040
14:22:50 6651 8192000000 10720337296 11143880704 1769988944 17.767 97 23 45 0 1781978544 5820896 6168704
14:23:03 10484 8192000000 10727818992 11137482752 1761869056 17.700 97 31 61 3 1776771280 5566704 9335520
14:23:19 10007 8192000000 10674839360 11092856832 1701812160 17.200 95 22 44 4 1713287424 4671120 6804144
14:23:39 13528 8192000000 10690662912 11108286464 1736772640 17.492 97 18 36 1 1747215616 5718336 4724640
14:23:58 14743 8192000000 10668820912 11081162752 1643961728 16.713 92 25 48 2 1656229440 4995472 7272240
14:24:21 66782 8192000000 10691318640 11114201088 1739442112 17.514 98 33 64 0 1754345104 5493664 9409328
14:25:36 9600 8192000000 10715689824 11135356928 1786700528 17.905 99 17 34 1 1797292928 5760928 4831472
14:25:52 4346 8192000000 10735680352 11148623872 1803656048 18.044 99 34 68 0 1820240208 7062016 9522144
14:26:04 5616 8192000000 10752380240 11165933568 1827440880 18.238 100 37 74 0 1844850048 7088016 10321152
14:26:18 5484 8192000000 10743994416 11163529216 1825816544 18.225 100 28 57 1 1841288032 6840464 8631024
14:26:34 6323 8192000000 10758681312 11176366080 1834530864 18.296 100 32 64 2 1848956160 5267760 9157536
14:26:49 7820 8192000000 10755695520 11181871104 1842167488 18.358 100 21 42 1 1853844400 5952496 5724416
14:27:04 12891 8192000000 10768170032 11195392000 1856630512 18.476 100 19 38 0 1867422800 5121872 5670416
14:27:24 6316 8192000000 10774740224 11204968448 1860812336 18.510 100 28 56 1 1879085216 10313360 7959520
14:27:39 8270 8192000000 10785866480 11210215424 1863788576 18.534 100 26 52 1 1882137520 9881632 8467312
14:27:54 18732 8192000000 10792844640 11214798848 1866586416 18.557 100 20 41 1 1878197456 5660144 5950896
14:28:22 9739 8192000000 10782259040 11213987840 1868793312 18.575 100 15 29 0 1878096208 5129120 4173776
14:28:40 11105 8192000000 10790157616 11217063936 1874020752 18.617 100 19 38 1 1885308880 5662656 5625472
14:28:57 62341 8192000000 10790575584 11228082176 1884895808 18.705 100 40 78 1 1900568896 4918768 10754320
14:30:06 4824 8192000000 10827311584 11250253824 1902490064 18.846 100 38 73 3 1917437184 5168272 9778848
14:30:18 5120 8192000000 10826732736 11253501952 1908859888 18.897 100 33 67 2 1924656336 6355008 9441440
14:30:32 10810 8192000000 10830520512 11257044992 1913606864 18.936 100 28 56 0 1926592112 5096624 7888624
14:30:52 18592 8192000000 10854140368 11272212480 1925958144 19.035 100 51 103 2 1949232864 8169840 15104880
14:31:17 27091 8192000000 10871672960 11290832896 1932510592 19.087 100 60 120 0 1959250128 10026480 16713056
14:31:53 13900 8192000000 10882341840 11298906112 1941487744 19.159 100 66 131 0 1972153440 12102704 18562992
14:32:19 28323 8192000000 10874109504 11307528192 1947697792 19.208 100 59 118 0 1977424432 12938992 16787648
14:32:54 10339 8192000000 10872422512 11305828352 1954123200 19.259 100 45 90 0 1977025872 9954416 12948256
14:33:13 16218 8192000000 10886165488 11317637120 1956108512 19.275 100 50 96 2 1979106288 8813648 14184128
14:33:42 29621 8192000000 10898462288 11330334720 1965596624 19.351 100 40 80 3 1991355920 14289392 11469904
14:34:22 22987 8192000000 10910193120 11338448896 1970322992 19.388 100 47 94 1 1997714016 14661376 12729648
14:34:53 9577 8192000000 10918060256 11343298560 1978984864 19.457 100 66 132 0 2015112960 16776640 19351456
14:35:21 34563 8192000000 10917773200 11353739264 1977576864 19.446 100 45 87 3 2006261552 16443200 12241488
14:36:38 17564 8192000000 10911711696 11359715328 1980021104 19.465 100 34 67 2 2006292624 16455120 9816400
14:37:05 14898 8192000000 10914905776 11350990848 1964369728 19.341 99 45 90 2 1994305152 16971968 12963456
14:37:29 19089 8192000000 10934551904 11363975168 1986919840 19.519 100 55 110 2 2022830976 18943232 16967904
14:38:01 19032 8192000000 10932266768 11366068224 1987521216 19.524 100 48 94 1 2020838640 18993056 14324368
14:38:28 10657 8192000000 10942159536 11373068288 1993257472 19.570 100 46 92 1 2027125136 20056320 13811344
14:38:47 3929 8192000000 10939727472 11374096384 1996659552 19.596 100 50 100 1 2030823728 19425376 14738800
14:39:00 5169 8192000000 10952995632 11380330496 2001942304 19.638 100 60 118 2 2037737184 18223056 17571824
14:39:13 4165 8192000000 10944832512 11378446336 2003768928 19.652 100 62 124 1 2041354880 18903168 18682784
14:39:24 3307 8192000000 10914323872 11333394432 1958711472 19.296 98 64 128 0 1996117248 18797168 18608608
14:39:36 2426 8192000000 10930880800 11353026560 1980665744 19.470 100 75 149 0 2022735040 20046720 22022576
14:39:47 8317 8192000000 10949000912 11370299392 1989989312 19.544 100 73 144 1 2035635408 24789504 20856592
14:40:02 8725 8192000000 10934538176 11362328576 1973663040 19.414 99 64 126 1 2012613328 20349184 18601104
14:40:18 1315 8192000000 10951154128 11374133248 1999903728 19.622 100 83 166 2 2044673664 20825744 23944192
14:40:28 7483 8192000000 10961381712 11386417152 2006891616 19.677 100 72 142 1 2049344016 21713536 20738864
14:40:43 2358 8192000000 10971344896 11393855488 2011807760 19.716 100 72 144 0 2057974896 25229248 20937888
14:40:52 7048 8192000000 10970373472 11399573504 2013636592 19.730 100 71 141 0 2059610496 25229712 20744192
14:41:08 4343 8192000000 10959802032 11381817344 1997157056 19.600 100 75 150 0 2045333584 25793760 22382768
14:41:20 5297 8192000000 10950197952 11380510720 2000076400 19.623 100 69 138 0 2046038976 25358400 20604176
14:41:33 5766 8192000000 10963577632 11392778240 2004421680 19.658 100 62 122 2 2051567760 28231968 18914112
14:41:48 3533 8192000000 10960649504 11376373760 1979935248 19.464 99 80 158 1 2032262384 28964816 23362320
14:41:58 1401 8192000000 10966247056 11378012160 1983976016 19.496 99 88 174 3 2041144832 31357312 25811504
14:42:06 2365 8192000000 10973186096 11388518400 1996212240 19.593 100 86 171 0 2053466480 32210784 25043456
14:42:16 2523 8192000000 10960448928 11391324160 2003099792 19.647 100 68 136 1 2056622880 33076976 20446112
14:42:26 3435 8192000000 10940919168 11357528064 1963322544 19.332 98 71 140 1 2018187360 33924176 20940640
14:42:38 3500 8192000000 10954867728 11375570944 1983758576 19.494 100 76 152 3 2041661664 34668784 23234304
14:42:50 4622 8192000000 10924763392 11349172224 1936355696 19.118 98 73 146 0 1995089680 35991040 22742944
14:43:03 2680 8192000000 10925668512 11353612288 1958126768 19.291 100 72 142 1 2015882192 36125776 21629648
14:43:14 7517 8192000000 10941582112 11362488320 1965866704 19.353 100 78 156 1 2027919712 37208928 24844080
14:43:28 6504 8192000000 10935385760 11368185856 1971558736 19.398 100 74 149 0 2031964464 37918528 22487200
14:43:49 5502 8192000000 10907626720 11335135232 1935396096 19.110 98 61 121 1 1981123040 27662960 18063984
14:44:04 8945 8192000000 10930166144 11358064640 1970164400 19.387 100 69 139 0 2020243296 28746032 21332864
14:44:25 2059 8192000000 10954369248 11371782144 1983447968 19.492 100 73 145 2 2033749200 28574800 21726432
14:44:35 6146 8192000000 10937014816 11358130176 1967197376 19.363 100 69 138 0 2016019408 27580752 21241280
14:44:48 944 8192000000 10909710720 11317911552 1935996240 19.115 99 83 163 1 1989887904 28058896 25832768
14:44:56 2412 8192000000 10923551200 11341893632 1951591744 19.239 100 79 156 1 2007282464 31313680 24377040
14:45:08 4465 8192000000 10907003584 11330592768 1930868400 19.074 99 72 144 3 1982351520 29061376 22421744
14:45:19 4369 8192000000 10915956064 11344424960 1951116896 19.235 100 57 112 3 1998633984 30163008 17354080
14:45:30 4494 8192000000 10925159584 11336130560 1935768064 19.113 99 76 150 2 1987807344 28338640 23700640
14:45:42 6546 8192000000 10908145424 11327004672 1925598848 19.032 99 78 155 1 1978010768 29068528 23343392
14:45:55 3533 8192000000 10917124608 11328258048 1928383488 19.054 99 89 178 2 1986490960 31480496 26626976
14:46:10 3454 8192000000 10914521264 11322195968 1915722416 18.953 99 85 170 1 1975318720 33782352 25813952
14:46:20 3389 8192000000 10894563232 11306758144 1913465968 18.934 99 74 149 1 1969992432 33905696 22620768
14:46:31 4074 8192000000 10910258144 11326001152 1934486592 19.103 100 79 156 3 1992801296 33726240 24588464
14:46:43 2449 8192000000 10895003984 11314696192 1930316928 19.069 100 72 142 0 1982257408 30275152 21665328
14:46:54 3231 8192000000 10915146032 11323293696 1936991088 19.123 100 69 138 1 1989900448 31769984 21139376
14:47:04 2578 8192000000 10905754224 11324833792 1938251552 19.133 100 67 134 0 1992176336 32924288 21000496
14:47:14 4051 8192000000 10905594416 11319492608 1924180704 19.020 99 76 152 1 1980931744 34452384 22298656
14:47:25 1775 8192000000 10938088880 11342438400 1949391552 19.222 100 76 150 2 2008496592 35428080 23676960
14:47:33 5100 8192000000 10904284848 11335368704 1945369056 19.190 100 59 117 2 1994308000 30605152 18333792
14:47:48 6735 8192000000 10924015456 11342139392 1947831344 19.209 100 54 108 3 1993534080 28992752 16709984
14:48:03 3358 8192000000 10926384160 11342745600 1939568688 19.143 99 82 164 2 1995512288 30673632 25269968
14:48:14 3342 8192000000 10934210400 11341606912 1952652720 19.248 100 81 162 0 2009703792 32093376 24957696
14:48:26 1456 8192000000 10940459584 11345629184 1960205840 19.308 100 95 184 2 2020916048 32983888 27726320
14:48:35 5099 8192000000 10937181552 11347124224 1957412112 19.285 100 86 171 1 2017472064 33788800 26271152
14:48:47 2230 8192000000 10944669856 11352924160 1959616128 19.303 100 83 168 0 2019845872 34026704 26203040
14:48:58 1961 8192000000 10947720480 11359129600 1962774016 19.328 100 79 158 2 2023050336 36393248 23883072
14:49:07 3053 8192000000 10957165552 11362103296 1963892768 19.337 100 87 174 1 2029833696 39457456 26483472
14:49:17 2130 8192000000 10953342992 11364831232 1966937152 19.361 100 84 168 0 2029186160 36845008 25404000
14:49:27 4914 8192000000 10941897296 11365539840 1968454288 19.373 100 69 138 1 2027553872 37656944 21442640
14:49:45 11623 8192000000 10924018144 11350487040 1941647600 19.160 99 54 108 3 1993995936 35677312 16671024
14:50:15 6633 8192000000 10902103776 11332464640 1940012544 19.147 100 42 83 0 1985324784 32074736 13237504
14:50:29 4813 8192000000 10932876976 11355803648 1960973472 19.314 100 63 125 1 2014250064 33380128 19896464
14:50:43 8185 8192000000 10927560480 11351842816 1936076912 19.115 99 64 128 2 1995030560 39492256 19461392
14:51:02 5476 8192000000 10929749936 11353673728 1952973488 19.250 100 57 111 1 2005753504 35330448 17449568
14:51:19 14231 8192000000 10907299184 11344588800 1947057936 19.203 100 41 82 1 1996785504 36589216 13138352
14:51:41 6975 8192000000 10877341072 11313065984 1911094640 18.915 98 40 78 1 1963443632 39688960 12660032
14:52:06 22656 8192000000 10896756560 11338977280 1938447920 19.134 100 39 78 3 1991643904 39563536 13632448
14:52:42 11610 8192000000 10908596464 11337957376 1918193136 18.972 99 29 58 2 1972270912 43770864 10306912
14:53:08 5563 8192000000 10915869840 11347619840 1937818720 19.129 100 46 94 1 2002240480 47818016 16603744
14:53:20 4655 8192000000 10928882032 11356606464 1945030896 19.187 100 55 108 0 2014916528 51618096 18267536
14:53:31 3782 8192000000 10937024576 11363762176 1951427984 19.238 100 69 139 0 2025831952 51832112 22571856
14:53:42 3677 8192000000 10940527952 11363749888 1958765296 19.296 100 72 142 1 2026781632 45335392 22680944
14:53:52 16481 8192000000 10903136528 11356151808 1952393408 19.246 100 40 80 2 2002291808 36689968 13208432
14:54:25 13613 8192000000 10922537104 11361230848 1951900112 19.242 100 31 60 2 1995303408 32808976 10594320
14:54:48 7473 8192000000 10909234976 11347914752 1934443984 19.102 99 42 84 0 1984516272 36984368 13087920
14:55:06 13600 8192000000 10907208848 11359662080 1949803232 19.225 100 29 58 0 1990790800 31663376 9324192
14:55:26 10954 8192000000 10914506192 11355897856 1939795168 19.145 99 32 64 0 1982192000 32049104 10347728
14:55:45 9271 8192000000 10920124432 11362930688 1955169200 19.268 100 26 52 1 1998592736 34685216 8738320
14:56:14 8142 8192000000 10945632864 11382607872 1970994016 19.393 100 53 103 0 2029763472 41985008 16784448
14:56:34 12951 8192000000 10934647712 11388862464 1970458016 19.389 100 26 52 0 2013807408 34906304 8443088
14:56:54 18010 8192000000 10932825856 11380248576 1958881888 19.297 99 24 48 1 2007273344 40257312 8134144
14:57:28 16443 8192000000 10938005872 11386732544 1976945552 19.441 100 31 62 0 2026042528 39402608 9694368
14:58:08 14200 8192000000 10934041200 11385634816 1934174080 19.100 98 33 65 1 1989786384 45656736 9955568
14:58:30 18058 8192000000 10925333312 11375886336 1953782192 19.257 100 19 38 1 2003317552 42630176 6905184
14:59:25 25867 8192000000 10908210368 11373330432 1943214176 19.172 100 20 40 1 2004546208 54326480 7005552
15:00:25 17651 8192000000 10932877600 11370426368 1933366960 19.094 99 32 59 3 1993035088 49751488 9916640
15:00:48 18911 8192000000 10904020816 11350577152 1934749216 19.105 99 22 44 0 1984388736 41210512 8429008
15:01:21 55125 8192000000 10905388048 11373355008 1961939280 19.321 100 30 60 0 1999473616 28309168 9225168
15:02:25 99211 8192000000 10914437552 11385380864 1978840192 19.456 100 11 22 0 1993929792 12332800 2756800
15:04:14 109345 8192000000 10946771584 11387318272 1987551056 19.524 100 45 87 1 2015533456 13760336 14222064
15:06:13 9093 8192000000 10916173200 11357204480 1933779424 19.097 97 65 131 4 1967895808 14126224 19990160
15:06:28 51937 8192000000 10898409168 11358298112 1951048720 19.235 99 30 58 1 1969427264 10006512 8372032
15:07:27 28321 8192000000 10907449536 11371028480 1976491968 19.437 100 36 72 1 1999693376 12765680 10435728
15:08:07 27418 8192000000 10920335264 11368808448 1962019136 19.322 99 43 85 3 1987727072 13103472 12604464
15:08:42 8015 8192000000 10900127904 11369132032 1977628656 19.446 100 22 44 1 1999224400 15025344 6570400
15:08:57 65743 8192000000 10903546112 11361124352 1954912576 19.266 99 14 27 1 1967392304 8496224 3983504
15:10:11 72825 8192000000 10927057872 11385704448 1980732656 19.470 100 14 28 0 1995505920 11074016 3699248
15:11:30 42437 8192000000 10915579872 11378978816 1980525248 19.469 100 32 66 3 2000586368 10825152 9235968
15:12:36 75050 8192000000 10909131584 11364806656 1954483456 19.262 98 11 22 2 1969173280 11372016 3317808
15:13:57 50133 8192000000 10924855344 11391791104 1969698864 19.383 99 16 32 0 1990724352 16080464 4945024
15:15:05 72481 8192000000 10949096768 11424645120 2003933552 19.654 100 23 46 1 2040642848 29725696 6983600
15:16:32 37054 8192000000 10936552208 11407511552 1999582480 19.619 100 13 26 1 2027473696 23599760 4291456
15:18:00 111376 8192000000 10927471920 11404926976 1986148720 19.513 99 21 42 3 2015007024 22537392 6320912
15:20:00 112046 8192000000 10913303520 11404640256 1957019648 19.282 98 10 20 1 1979979184 20531360 2428176
15:22:00 12253 8192000000 10910265344 11394387968 1968462864 19.373 99 9 18 0 1988291376 17326880 2501632
15:22:19 2598 8192000000 10924043136 11378286592 1994147568 19.577 100 51 101 4 2014827472 6642640 14037264
15:22:28 45720 8192000000 10909303840 11372630016 1947077200 19.203 98 20 40 1 1961767568 8278544 6411824
15:23:21 52576 8192000000 10895300448 11375693824 1966134672 19.355 99 26 51 1 1982320848 8644256 7541920
15:24:52 59924 8192000000 10911360528 11376979968 1940366752 19.150 97 23 45 2 1957501792 10350784 6784256
15:26:02 79428 8192000000 10910001360 11384303616 1969409264 19.381 99 16 32 0 1984105648 10187536 4508848
15:28:20 53486 8192000000 10869052192 11333447680 1900265216 18.828 96 28 52 1 1911630384 4825392 6539776
15:29:21 33147 8192000000 10886066176 11353952256 1948843264 19.217 99 27 53 3 1963991664 7426576 7721824
15:30:06 58075 8192000000 10881710368 11360727040 1946975856 19.202 99 12 24 0 1956791760 6679664 3136240
15:31:16 99037 8192000000 10884048368 11376885760 1936936064 19.122 98 14 27 0 1956869600 16624352 3309184
15:33:43 58759 8192000000 10844187360 11310403584 1824576592 18.215 93 6 12 0 1840980128 14728976 1674560
15:34:48 40193 8192000000 10871160640 11344351232 1933765568 19.097 99 26 52 0 1951384752 10788528 6830656
15:35:34 58417 8192000000 10848693856 11323633664 1880035824 18.665 96 29 58 1 1902913888 14454352 8423712
15:36:39 110284 8192000000 10847607632 11314110464 1791847056 17.947 92 15 30 2 1808269760 12103296 4319408
15:38:38 40587 8192000000 10841966480 11298676736 1830212496 18.261 95 28 56 0 1848047936 10020240 7815200
15:39:43 67702 8192000000 10825687680 11305582592 1850355824 18.425 96 20 40 1 1873964160 17582528 6025808
15:40:57 67614 8192000000 10839775680 11295141888 1784053232 17.883 93 11 22 1 1800918544 14258368 2606944
15:42:12 23185 8192000000 10870835248 11311013888 1919536688 18.983 100 52 104 0 1945132608 11446752 14149168
15:42:42 15295 8192000000 10868458832 11316842496 1927623280 19.048 100 46 92 0 1952463680 12056128 12784272
15:43:03 24944 8192000000 10859951584 11312918528 1889292800 18.740 98 42 84 1 1912659920 11876624 11490496
15:43:34 52026 8192000000 10856818352 11332038656 1901554288 18.839 99 20 40 1 1919788000 12768464 5465248
15:44:34 129351 8192000000 10877493280 11340730368 1901517200 18.838 98 11 22 0 1922865424 18333744 3014480
15:46:55 33868 8192000000 10891573264 11346366464 1935022800 19.107 99 27 54 1 1955365136 13095696 7246640
15:48:18 90137 8192000000 10864519184 11321827328 1896061248 18.795 97 33 67 0 1914673168 9546080 9065840
15:50:00 51846 8192000000 10861489168 11319013376 1906096784 18.875 98 34 68 0 1927726672 12230528 9399360
15:51:29 74694 8192000000 10851737744 11337527296 1934141376 19.100 100 5 10 0 1945132672 9674000 1317296
15:52:50 13019 8192000000 10855370192 11343093760 1938882496 19.138 100 3 6 0 1953859808 14310784 666528
15:53:11 50973 8192000000 10858687696 11335172096 1944154144 19.180 100 10 20 0 1954536688 7495296 2887248
15:54:08 51034 8192000000 10864051904 11344220160 1935999536 19.115 99 16 32 0 1950775472 9389728 5386208
15:56:49 53435 8192000000 10873991008 11341209600 1887306640 18.724 97 12 23 0 1909103568 18364032 3432896
15:57:51 43677 8192000000 10874234928 11358236672 1946774768 19.201 100 19 37 0 1971116512 18841312 5500432
15:58:41 63511 8192000000 10883021008 11357847552 1928024288 19.051 98 25 50 0 1943151296 7524640 7602368
15:59:58 94490 8192000000 10901089952 11360600064 1929252656 19.061 98 15 30 0 1942695824 10072976 3370192
16:01:38 46469 8192000000 10914433648 11372343296 1945198416 19.188 98 24 48 1 1962785536 11123776 6463344
16:02:35 91076 8192000000 10886308544 11375173632 1915647360 18.952 97 14 28 0 1936953312 17605344 3700608
16:04:33 80355 8192000000 10929183600 11390877696 1982646800 19.486 100 19 38 0 2002496432 14709776 5139856
16:06:00 43635 8192000000 10938035248 11395674112 1995021472 19.583 100 31 62 2 2016257040 12202352 9033216
16:06:53 48702 8192000000 10940460272 11402108928 1998043776 19.607 100 35 70 0 2026647200 18842880 9760544
16:07:56 63720 8192000000 10912539808 11400396800 1968094896 19.370 99 17 34 1 1993323024 20018560 5209568
16:09:06 69094 8192000000 10907901616 11375693824 1913205600 18.932 96 15 29 1 1933842032 16611680 4024752
16:10:26 109705 8192000000 10891347008 11364212736 1936301824 19.117 98 21 42 0 1959802448 17247120 6253504
16:12:26 32670 8192000000 10916111296 11376164864 1953080048 19.251 99 27 54 0 1974433568 13655632 7697888
16:13:06 23952 8192000000 10900908832 11385741312 1970829056 19.392 100 33 66 0 2001267056 20990496 9447504
16:14:58 31472 8192000000 10881599232 11352055808 1941522816 19.159 99 10 20 0 1958728448 14110800 3094832
16:15:38 86711 8192000000 10868458512 11351916544 1925309216 19.029 98 16 32 0 1937626112 8161040 4155856
16:17:11 73802 8192000000 10876836976 11344158720 1885296944 18.708 96 15 30 1 1895181760 6178400 3706416
16:18:31 58364 8192000000 10881522032 11349819392 1923398016 19.014 98 16 32 1 1935582672 8427520 3757136
16:19:47 67719 8192000000 10887956624 11358859264 1927386960 19.046 98 19 37 1 1943625712 9646608 6592144
16:22:01 88603 8192000000 10882831728 11355144192 1912903136 18.930 97 10 20 0 1930622368 14863760 2855472
16:23:36 42297 8192000000 10874874256 11344633856 1941499216 19.159 99 12 22 0 1952147680 7569552 3078912
16:24:27 49555 8192000000 10886002112 11351871488 1912838720 18.929 97 22 44 1 1926864432 7936704 6089008
16:25:23 57261 8192000000 10881031920 11345989632 1895518272 18.790 96 31 62 1 1913663728 9981552 8163904
16:26:26 73251 8192000000 10873303504 11345797120 1897544352 18.807 97 17 34 1 1912755248 10541296 4669600
16:27:56 59706 8192000000 10855873040 11313852416 1864291984 18.538 96 14 28 2 1875689808 8322368 3075456
16:29:06 20388 8192000000 10876063872 11325931520 1903420896 18.854 98 38 74 1 1922644704 9013632 10210176
16:29:34 57336 8192000000 10869967728 11333300224 1902006496 18.842 98 25 50 0 1921324256 12263104 7054656
16:30:37 20719 8192000000 8920682672 9117990912 86873664 1.049 5 1 2 0 87911456 975664 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 04-11-2020 16:31:48 to 04-11-2020 16:32:20.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 149 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-11-2020 16:32:21 to 04-11-2020 16:32:23.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          243118
MON$OLDEST_ACTIVE               243119
MON$OLDEST_SNAPSHOT             243119
MON$NEXT_TRANSACTION            243119
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                       2045280
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33385 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33385 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33385 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33385 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 ---
--- end of diff output ---

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

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