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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-03 19:27:04
DTS_END                         2020-12-03 19:27:04.1230
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/46042
TRN_ID                          240000
ATT_ID                          675
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: 9235.63 22695 1108276
customer order: creation 175.85 342 21102
customer order: refuse 15.19 369 1823
order to supplier: creation 46.14 1302 5537
order to supplier: removal 3.39 100300 407
invoice (draft): creation 45.68 3616 5482
invoice (draft): removal 52.94 768 6353
invoice accept: apply 41.70 19889 5004
invoice accept: cancel 47.92 792 5750
customer reserve: creation 3855.52 198 462662
customer reserve: removal 4651.08 57 558129
realization accept: apply 84.99 178 10199
realization accept: cancel 84.08 111 10090
payment from customer: creation 58.98 102 7078
payment from customer: removal 5.62 82 674
payment to supplier: creation 50.18 125 6021
payment to supplier: removal 3.61 87 433
service: total inventory turnovers 4.98 1217 598
service: total monetary turnovers 6.91 40 829
service: aggregate perf. data 0.84 19070 101
service: refresh index statistics 0.03 305256 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-12-2020 19:29:20 to 03-12-2020 19:29:22.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6900
TEST_TIME 2 6233
TEST_TIME 3 6846
TEST_TIME 4 5542
TEST_TIME 5 6035
TEST_TIME 6 5554
TEST_TIME 7 5372
TEST_TIME 8 5731
TEST_TIME 9 5877
TEST_TIME 10 6469
TEST_TIME 11 6424
TEST_TIME 12 6660
TEST_TIME 13 7026
TEST_TIME 14 7279
TEST_TIME 15 7278
TEST_TIME 16 7581
TEST_TIME 17 7822
TEST_TIME 18 7870
TEST_TIME 19 8253
TEST_TIME 20 8321
TEST_TIME 21 8664
TEST_TIME 22 9116
TEST_TIME 23 9077
TEST_TIME 24 9013
TEST_TIME 25 9133
TEST_TIME 26 9538
TEST_TIME 27 9718
TEST_TIME 28 10692
TEST_TIME 29 10659
TEST_TIME 30 10401
TEST_TIME 31 10234
TEST_TIME 32 10389
TEST_TIME 33 10180
TEST_TIME 34 10261
TEST_TIME 35 10052
TEST_TIME 36 9978
TEST_TIME 37 9864
TEST_TIME 38 9724
TEST_TIME 39 10190
TEST_TIME 40 9980
TEST_TIME 41 9921
TEST_TIME 42 9897
TEST_TIME 43 9870
TEST_TIME 44 9858
TEST_TIME 45 9730
TEST_TIME 46 9786
TEST_TIME 47 9653
TEST_TIME 48 9602
TEST_TIME 49 9642
TEST_TIME 50 9539
TEST_TIME 51 9440
TEST_TIME 52 9364
TEST_TIME 53 9349
TEST_TIME 54 9312
TEST_TIME 55 9268
TEST_TIME 56 9372
TEST_TIME 57 9329
TEST_TIME 58 9323
TEST_TIME 59 9311
TEST_TIME 60 9458
TEST_TIME 61 9482
TEST_TIME 62 9568
TEST_TIME 63 9584
TEST_TIME 64 9536
TEST_TIME 65 9611
TEST_TIME 66 9615
TEST_TIME 67 9638
TEST_TIME 68 9682
TEST_TIME 69 9731
TEST_TIME 70 9736
TEST_TIME 71 9631
TEST_TIME 72 9547
TEST_TIME 73 9492
TEST_TIME 74 9513
TEST_TIME 75 9442
TEST_TIME 76 9429
TEST_TIME 77 9416
TEST_TIME 78 9312
TEST_TIME 79 9299
TEST_TIME 80 9298
TEST_TIME 81 9429
TEST_TIME 82 9421
TEST_TIME 83 9391
TEST_TIME 84 9426
TEST_TIME 85 9506
TEST_TIME 86 9475
TEST_TIME 87 9470
TEST_TIME 88 9472
TEST_TIME 89 9470
TEST_TIME 90 9484
TEST_TIME 91 9500
TEST_TIME 92 9472
TEST_TIME 93 9377
TEST_TIME 94 9340
TEST_TIME 95 9379
TEST_TIME 96 9407
TEST_TIME 97 9405
TEST_TIME 98 9370
TEST_TIME 99 9379
TEST_TIME 100 9354
TEST_TIME 101 9383
TEST_TIME 102 9403
TEST_TIME 103 9424
TEST_TIME 104 9396
TEST_TIME 105 9390
TEST_TIME 106 9426
TEST_TIME 107 9439
TEST_TIME 108 9436
TEST_TIME 109 9515
TEST_TIME 110 9486
TEST_TIME 111 9486
TEST_TIME 112 9419
TEST_TIME 113 9375
TEST_TIME 114 9380
TEST_TIME 115 9361
TEST_TIME 116 9322
TEST_TIME 117 9316
TEST_TIME 118 9286
TEST_TIME 119 9299
TEST_TIME 120 9237

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 03-12-2020 19:29:23 to 03-12-2020 19:29:26.

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 1535645 1535645 0 0.00 0 20916 7 0 0
doc_list_biud 1535645 1535645 0 0.00 0 43505 27 0 0
sp_add_invoice_to_stock 5142 5004 138 2.68 34 207927 19889 0 138
sp_cancel_adding_invoice 5750 5750 0 0.00 4 50913 792 0 0
sp_cancel_client_order 1823 1823 0 0.00 4 11142 369 0 0
sp_cancel_customer_reserve 558129 558129 0 0.00 1 43509 57 0 0
sp_cancel_pay_from_customer 674 674 0 0.00 3 5465 82 0 0
sp_cancel_pay_to_supplier 433 433 0 0.00 2 3903 87 0 0
sp_cancel_supplier_invoice 6365 6353 12 0.18 1 21542 768 0 12
sp_cancel_supplier_order 407 407 0 0.00 6 1123828 100301 0 0
sp_cancel_write_off 10090 10090 0 0.00 1 19627 112 0 0
sp_client_order 21102 21102 0 0.00 3 14577 343 0 0
sp_customer_reserve 462662 462662 0 0.00 0 45229 198 0 0
sp_fill_shopping_cart 32114 32114 0 0.00 1 18172 38 0 0
sp_fill_shopping_cart_clo_res 462659 462659 0 0.00 0 15413 14 0 0
sp_get_clo_for_invoice 5001 5001 0 0.00 0 24976 304 0 0
sp_kill_cost_storno 16947 16947 0 0.00 0 18099 57 0 0
sp_kill_qstorno_ret_qs2qd 1133108 1133108 0 0.00 0 43260 31 0 0
sp_kill_qty_storno 597752 597752 0 0.00 0 43505 68 0 0
sp_lock_selected_doc 21115 21115 0 0.00 0 10577 5 0 0
sp_make_cost_storno 28299 28299 0 0.00 0 20884 46 0 0
sp_multiply_rows_for_pdistr 28299 28299 0 0.00 0 8481 34 0 0
sp_multiply_rows_for_qdistr 21102 21102 0 0.00 0 14568 163 0 0
sp_pay_from_customer 7078 7078 0 0.00 4 11588 103 0 0
sp_pay_to_supplier 6021 6021 0 0.00 5 12388 125 0 0
sp_payment_common 13099 13099 0 0.00 1 11122 21 0 0
sp_qd_handle_on_cancel_clo 1823 1823 0 0.00 0 11126 344 0 0
sp_qd_handle_on_invoice_upd_sts 10751 10751 0 0.00 0 20128 350 0 0
sp_qd_handle_on_reserve_upd_sts 10199 10199 0 0.00 0 16814 61 0 0
sp_reserve_write_off 10199 10199 0 0.00 6 20652 179 0 0
sp_supplier_invoice 5482 5482 0 0.00 6 117763 3616 0 0
sp_supplier_order 5537 5537 0 0.00 5 42392 1303 0 0
srv_aggregate_perf_data 101 101 0 0.00 2347 243268 19070 0 0
srv_fill_mon_cache_memory 172 172 0 0.00 966 125395 31095 0 0
srv_find_qd_qs_mism 1059600 1059600 0 0.00 0 17958 6 0 0
srv_make_invnt_saldo 598 598 0 0.00 28 55489 1218 0 0
srv_make_money_saldo 829 829 0 0.00 1 10112 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 131888 466945 305257 0 0
t$perf-abend:sp_add_invoice_to_stock 138 138 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5004 5004 0 0.00 0 8837 176 0 0
t$perf-norm:sp_cancel_adding_invoice 408 408 0 0.00 1 3436 129 0 0
t$perf-norm:sp_cancel_client_order 1823 1823 0 0.00 0 3562 13 0 0
t$perf-norm:sp_cancel_customer_reserve 739 739 0 0.00 0 6636 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 674 674 0 0.00 0 3888 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 433 433 0 0.00 0 961 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 396 396 0 0.00 0 480 10 0 0
t$perf-norm:sp_cancel_supplier_order 407 407 0 0.00 0 20079 1524 0 0
t$perf-norm:sp_cancel_write_off 1035 1035 0 0.00 0 10764 30 0 0
t$perf-norm:sp_client_order 21102 21102 0 0.00 0 8537 16 0 0
t$perf-norm:sp_customer_reserve 1123 1123 0 0.00 0 4124 8 0 0
t$perf-norm:sp_pay_from_customer 7078 7078 0 0.00 0 5760 11 0 0
t$perf-norm:sp_pay_to_supplier 6021 6021 0 0.00 0 8556 13 0 0
t$perf-norm:sp_reserve_write_off 10199 10199 0 0.00 0 8077 12 0 0
t$perf-norm:sp_supplier_invoice 5482 5482 0 0.00 0 6619 18 0 0
t$perf-norm:sp_supplier_order 5537 5537 0 0.00 0 6651 18 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 311 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 283 6 0 0
t$perf-norm:srv_make_invnt_saldo 598 598 0 0.00 0 769 22 0 0
t$perf-norm:srv_make_money_saldo 829 829 0 0.00 0 2108 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10278 10002 276 2.68 0 4284 18 0 276
v_all_customers 38484 38484 0 0.00 0 131 1 0 0
v_all_suppliers 30712 30712 0 0.00 0 27 1 0 0
v_all_wares 42204 42204 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 816 816 0 0.00 0 4650 13 0 0
v_cancel_client_order 3646 3646 0 0.00 0 3168 5 0 0
v_cancel_customer_prepayment 1348 1348 0 0.00 0 2163 5 0 0
v_cancel_customer_reserve 1478 1478 0 0.00 0 968 4 0 0
v_cancel_payment_to_supplier 866 866 0 0.00 0 3884 12 0 0
v_cancel_supplier_invoice 816 792 24 2.94 0 1106 17 0 24
v_cancel_supplier_order 814 814 0 0.00 0 5838 17 0 0
v_cancel_write_off 2070 2070 0 0.00 0 5649 16 0 0
v_max_id_clo_ord 5535 5535 0 0.00 0 702 2 0 0
v_max_id_clo_res 1123 1123 0 0.00 0 1478 10 0 0
v_max_id_ord_sup 5476 5476 0 0.00 0 5267 7 0 0
v_max_non_paid_invoice 1676 1676 0 0.00 0 290 2 0 0
v_max_non_paid_realizn 3748 3748 0 0.00 0 1236 4 0 0
v_min_id_clo_ord 5535 5535 0 0.00 0 2393 7 0 0
v_min_id_clo_res 1123 1123 0 0.00 0 2252 9 0 0
v_min_id_ord_sup 5476 5476 0 0.00 0 6150 5 0 0
v_min_non_paid_invoice 6021 6021 0 0.00 0 4295 10 0 0
v_min_non_paid_realizn 7078 7078 0 0.00 0 11067 13 0 0
v_our_firm 10380 10380 0 0.00 0 21 1 0 0
v_reserve_write_off 20398 20398 0 0.00 0 6080 7 0 0
x_lock_depdocs_on_canc_invoice 11707 11707 0 0.00 0 16264 113 0 0
x_lock_depdocs_on_canc_sup_ord 407 407 0 0.00 0 9527 335 0 0
x_make_qstorno_1000_1200 5537 5537 0 0.00 1 42386 1217 0 0
x_make_qstorno_1200_2000 5482 5482 0 0.00 4 117748 3484 0 0
x_make_qstorno_2100_3300 462662 462662 0 0.00 0 45227 181 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-12-2020 19:29:27 to 03-12-2020 19:29:31.

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
16:57:07 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:14 10819 8192000000 10225183744 10521579520 912392672 10.021 71 55 111 0 933124192 2526800 18204720
16:57:33 7221 8192000000 10288004048 10597036032 1349394208 14.142 100 84 169 0 1380766208 3897936 27474064
16:57:51 30186 8192000000 10354309088 10672328704 1406424912 14.652 100 87 174 0 1439697664 5339392 27933360
16:58:35 25045 8192000000 10388762688 10714120192 1443767600 14.983 100 85 170 0 1478302832 7202432 27332800
16:59:11 24203 8192000000 10416478416 10744713216 1462509904 15.148 100 88 174 1 1498185616 8031552 27644160
16:59:44 25207 8192000000 10436483792 10766315520 1488687152 15.377 100 94 189 2 1527613872 8841168 30085552
17:00:23 27376 8192000000 10448067632 10784006144 1505141088 15.521 100 88 176 0 1542444608 9725760 27577760
17:01:02 19711 8192000000 10471496992 10811355136 1524536640 15.690 100 85 170 0 1561492048 9990560 26964848
17:01:30 15574 8192000000 10496673744 10842992640 1550643792 15.916 100 76 152 0 1584490256 10065008 23781456
17:01:57 15327 8192000000 10529795568 10878361600 1583406864 16.197 100 82 164 0 1618774032 10641552 24725616
17:02:21 10568 8192000000 10552995200 10908872704 1603293840 16.368 100 85 170 0 1640122816 11258880 25570096
17:02:40 13081 8192000000 10580493408 10942611456 1637919376 16.662 100 83 166 1 1674785472 11840880 25025216
17:03:03 10465 8192000000 10595255904 10958741504 1652800976 16.788 100 77 153 0 1688481744 12457136 23223632
17:03:22 12359 8192000000 10610410608 10974650368 1669825456 16.932 100 77 154 0 1704785632 12552464 22407712
17:03:45 10207 8192000000 10623738208 10992140288 1689286880 17.095 100 83 166 1 1727307328 13222208 24798240
17:04:06 10100 8192000000 10647282416 11020763136 1705861440 17.234 100 78 156 1 1741019088 12631216 22526432
17:04:24 5516 8192000000 10651573264 11026993152 1720587440 17.357 100 80 160 0 1755538816 11994576 22956800
17:04:37 6155 8192000000 10675107184 11047325696 1735131808 17.478 100 82 164 3 1770588656 12398080 23058768
17:04:52 6649 8192000000 10692142176 11065167872 1749125488 17.594 100 77 149 2 1781395152 11434288 20835376
17:05:05 5347 8192000000 10701162672 11081093120 1759390960 17.679 100 75 149 1 1792510128 12386784 20732384
17:05:17 4300 8192000000 10702153040 11087269888 1771077728 17.776 100 79 158 2 1805941760 12702512 22161520
17:05:29 4212 8192000000 10708150256 11095834624 1775413024 17.812 100 79 157 0 1809565216 11785680 22366512
17:05:42 4874 8192000000 10729050464 11108667392 1786900128 17.906 100 84 164 2 1823148240 12595456 23652656
17:05:53 3131 8192000000 10735096016 11119169536 1794639760 17.970 100 86 172 3 1831450064 12840800 23969504
17:06:04 4110 8192000000 10738292384 11120537600 1800004896 18.014 100 80 158 0 1835227088 13699200 21522992
17:06:15 3685 8192000000 10751675520 11134017536 1811975280 18.112 100 88 176 0 1848949104 12701152 24272672
17:06:25 6496 8192000000 10740449360 11134926848 1816209136 18.147 100 79 159 2 1851555072 12584864 22761072
17:06:38 6347 8192000000 10755940080 11145129984 1822728496 18.200 100 86 171 1 1859272256 12492768 24050992
17:06:51 3047 8192000000 10779576176 11168186368 1838850608 18.331 100 81 162 3 1874203456 12819648 22533200
17:07:00 2012 8192000000 10787495856 11172204544 1842549504 18.362 100 84 168 0 1879084544 12224208 24310832
17:07:09 2313 8192000000 10797086528 11182739456 1850722976 18.428 100 87 175 3 1889102064 13132784 25246304
17:07:18 2379 8192000000 10801184896 11187187712 1852902512 18.446 100 84 165 2 1888787648 12237920 23647216
17:07:27 2208 8192000000 10793502272 11189067776 1858272304 18.489 100 87 174 3 1896047664 12527408 25247952
17:07:35 2245 8192000000 10803886768 11192643584 1860795632 18.510 100 95 190 1 1899934848 12559568 26579648
17:07:44 1790 8192000000 10813513456 11200860160 1866461712 18.556 100 95 190 3 1906582432 13782128 26338592
17:07:52 1262 8192000000 10817541168 11205910528 1871700096 18.598 100 96 192 3 1912332096 14662080 25969920
17:07:59 1340 8192000000 10817995536 11208298496 1871273792 18.595 100 88 177 0 1909695792 13044896 25377104
17:08:07 1947 8192000000 10812890288 11206410240 1876372240 18.636 100 92 184 1 1915869232 13814032 25682960
17:08:16 2460 8192000000 10822162048 11210153984 1875122976 18.626 100 96 190 1 1914699264 12566016 27010272
17:08:25 1493 8192000000 10825707008 11213004800 1877656336 18.646 100 96 192 3 1918638640 13076624 27905680
17:08:33 2034 8192000000 10826015504 11217256448 1879399344 18.660 100 97 193 1 1921012512 13800512 27812656
17:08:41 1897 8192000000 10812300784 11213123584 1875437680 18.628 100 76 153 0 1910097216 13052096 21607440
17:08:50 1517 8192000000 10807767984 11210985472 1877215904 18.643 100 75 151 0 1910451264 11599584 21635776
17:08:58 6488 8192000000 10783183440 11203129344 1872832512 18.607 100 45 90 1 1895888832 9452288 13604032
17:09:11 40653 8192000000 10791944544 11209428992 1870346288 18.587 100 24 48 0 1883586976 6363136 6877552
17:09:59 25699 8192000000 10785327488 11222056960 1883331552 18.692 100 69 138 0 1917599216 14509712 19757952
17:10:32 12621 8192000000 10789142352 11217948672 1879951936 18.665 100 29 57 2 1893287104 5559632 7775536
17:10:52 7483 8192000000 10789743008 11222130688 1880596208 18.670 100 22 44 1 1892975312 6222544 6156560
17:11:10 10154 8192000000 10793277072 11230646272 1885837760 18.712 100 22 44 3 1897785744 6155088 5792896
17:11:27 9049 8192000000 10796343312 11226275840 1888921328 18.737 100 28 56 2 1902713376 6519600 7272448
17:11:43 7556 8192000000 10792301888 11226189824 1887131248 18.723 100 19 38 1 1899588944 6980464 5477232
17:12:01 9883 8192000000 10799650592 11229581312 1888529424 18.734 100 18 36 0 1898820960 5158288 5133248
17:12:19 6526 8192000000 10810285920 11238154240 1894764576 18.784 100 19 38 2 1906727376 6145888 5816912
17:12:32 9757 8192000000 10805221888 11239682048 1897530832 18.806 100 19 39 0 1908455440 5691968 5232640
17:12:49 6493 8192000000 10815099616 11244191744 1901025184 18.835 100 22 45 3 1914031728 5838464 7168080
17:13:01 14416 8192000000 10804586688 11241439232 1900655392 18.832 100 15 30 0 1910770912 5765424 4350096
17:13:22 11615 8192000000 10822772608 11246727168 1901489152 18.838 100 18 36 1 1912081952 5549968 5042832
17:13:41 7491 8192000000 10808374272 11247161344 1904010672 18.859 100 16 33 1 1915177648 6383024 4783952
17:13:59 10864 8192000000 10820506720 11252584448 1906519008 18.879 100 16 32 2 1916352256 5365136 4468112
17:14:17 10498 8192000000 10816233424 11251191808 1910262560 18.909 100 14 28 0 1920229184 5651904 4314720
17:14:39 8544 8192000000 10836248048 11263324160 1919554800 18.983 100 47 96 0 1939061696 6380768 13126128
17:15:20 26676 8192000000 10857806240 11259969536 1902430416 18.846 99 61 122 2 1928695872 8000496 18264960
17:15:53 17879 8192000000 10809995776 11245408256 1872055312 18.601 98 23 46 0 1884752512 6737856 5959344
17:16:18 5030 8192000000 10814473440 11244707840 1899060272 18.819 100 33 67 2 1914362496 6209920 9092304
17:16:29 5200 8192000000 10822041584 11252011008 1904000112 18.858 100 31 62 3 1919159808 6501072 8658624
17:16:44 6981 8192000000 10811455936 11242299392 1882898736 18.689 99 35 70 1 1900310400 6939120 10472544
17:16:57 5604 8192000000 10810575024 11242561536 1894768512 18.784 100 27 54 0 1908684352 6397792 7518048
17:17:10 6894 8192000000 10805796848 11238891520 1877810912 18.647 99 22 44 1 1889534816 5612512 6111392
17:17:24 3850 8192000000 10816724640 11240411136 1881576368 18.678 99 39 79 0 1899384240 5764256 12043616
17:17:36 5616 8192000000 10777551328 11206250496 1854180192 18.456 99 39 77 1 1872280448 6767760 11332496
17:17:51 14389 8192000000 10768464272 11203936256 1816648592 18.150 97 9 18 0 1824524816 5424704 2451520
17:18:11 10660 8192000000 10762193744 11187945472 1834142080 18.293 99 19 38 2 1845210112 4930912 6137120
17:18:29 5905 8192000000 10743632896 11166785536 1818239776 18.163 99 25 51 2 1832030064 6869728 6920560
17:18:42 18113 8192000000 10740860912 11168837632 1775088176 17.809 96 14 28 1 1784719104 5553584 4077344
17:19:11 38008 8192000000 10698831760 11114262528 1606070288 16.391 88 22 43 2 1618094784 4705008 7319488
17:20:22 15874 8192000000 10692680352 11111608320 1755373696 17.646 98 26 52 2 1768284752 5814880 7096176
17:20:47 10821 8192000000 10696372560 11110023168 1736077792 17.486 97 16 32 1 1746251136 5652544 4520800
17:21:05 8746 8192000000 10692886992 11108429824 1719793776 17.350 96 21 42 2 1732146176 6364128 5988272
17:21:21 4881 8192000000 10687720816 11100581888 1728117296 17.420 97 34 68 1 1744188528 6143504 9927728
17:21:33 10241 8192000000 10692980656 11104980992 1726991824 17.410 97 20 40 1 1738748304 5718608 6037872
17:21:51 9922 8192000000 10702562016 11123769344 1774923600 17.808 99 22 43 1 1787708016 5642080 7142336
17:22:08 7271 8192000000 10732740272 11148722176 1790886960 17.939 99 22 45 2 1802078288 5415856 5775472
17:22:22 13399 8192000000 10733673088 11160236032 1821384256 18.189 100 19 38 0 1833270896 6097616 5789024
17:22:42 8572 8192000000 10734634608 11162890240 1828833344 18.250 100 24 48 3 1841910432 6003376 7073712
17:22:59 9991 8192000000 10750432176 11167023104 1811929392 18.112 99 20 40 0 1823615632 5674720 6011520
17:23:17 5258 8192000000 10745807952 11171635200 1834008480 18.292 100 34 68 1 1850528784 6685504 9834800
17:23:32 8606 8192000000 10747255472 11173605376 1835939472 18.308 100 28 56 0 1850211488 5423856 8848160
17:23:53 11156 8192000000 10750113520 11181481984 1840958784 18.349 100 22 43 2 1853371296 6098560 6313952
17:24:14 21753 8192000000 10760497840 11180535808 1822047680 18.194 99 13 26 2 1831799568 6063888 3688000
17:24:43 74005 8192000000 10760570192 11192922112 1851509824 18.434 100 22 43 0 1862720896 5395632 5815440
17:26:03 6195 8192000000 10778578736 11203440640 1862681872 18.525 100 30 60 1 1876994848 6226880 8086096
17:26:21 11486 8192000000 10787613040 11213848576 1863860032 18.535 100 32 64 0 1879163008 6751248 8551728
17:26:41 6583 8192000000 10784294768 11213307904 1868831040 18.575 100 26 48 5 1882273024 6153568 7288416
17:26:57 23913 8192000000 10798663264 11220631552 1873590080 18.613 100 27 54 2 1886260512 5036784 7633648
17:27:33 4107 8192000000 10825512160 11239682048 1895770512 18.792 100 49 100 0 1917026016 6570080 14685424
17:27:46 4611 8192000000 10842080192 11253362688 1907505248 18.887 100 51 102 1 1929385200 8192768 13687184
17:28:02 21580 8192000000 10851270864 11267768320 1913828800 18.937 100 60 121 1 1940456832 10213968 16414064
17:28:33 6152 8192000000 10852778160 11267813376 1916256368 18.957 100 58 117 1 1943797744 11145120 16396256
17:28:47 19663 8192000000 10847741648 11274027008 1921537952 18.999 100 43 86 1 1947573088 13681872 12353264
17:29:14 5502 8192000000 10856598144 11278012416 1926804688 19.041 100 49 97 3 1949481808 8206880 14470240
17:29:34 40682 8192000000 10863470688 11291598848 1931568896 19.079 100 46 92 0 1959644096 15273440 12801760
17:30:42 80504 8192000000 10882509072 11312332800 1941278480 19.157 100 35 70 2 1962330736 11236032 9816224
17:32:16 21420 8192000000 10871318912 11313639424 1948685360 19.216 100 36 72 0 1972228816 13109312 10434144
17:32:48 30148 8192000000 10881042784 11319013376 1951897968 19.242 100 30 59 0 1971161584 10509680 8753936
17:33:27 7887 8192000000 10901154656 11328995328 1959855856 19.305 100 53 104 1 1988977248 13722448 15398944
17:33:44 26369 8192000000 10907266176 11337715712 1966812112 19.360 100 55 110 1 1999855328 16032560 17010656
17:34:22 13836 8192000000 10909890448 11342020608 1974205648 19.419 100 48 96 2 2007523584 18806016 14511920
17:34:45 16135 8192000000 10917186048 11354636288 1976734144 19.439 100 38 74 3 2006833456 18476720 11622592
17:35:13 18022 8192000000 10926494976 11356377088 1983753680 19.494 100 49 98 1 2012807696 14106960 14947056
17:35:40 10108 8192000000 10930089504 11363012608 1987594048 19.525 100 52 104 0 2020988160 16747168 16646944
17:35:58 15659 8192000000 10948808720 11373256704 1991853680 19.558 100 63 126 3 2030547072 20430288 18263104
17:36:22 16270 8192000000 10949346544 11380523008 1996361104 19.594 100 67 134 0 2038655040 22405984 19887952
17:36:47 6994 8192000000 10944166576 11381604352 1998309120 19.609 100 55 109 1 2036042016 21654192 16078704
17:37:02 2328 8192000000 10970368720 11390857216 2004010864 19.654 100 88 175 2 2051746176 22599216 25136096
17:37:12 1421 8192000000 10963829856 11384537088 2004134448 19.655 100 80 158 2 2050722944 23340304 23248192
17:37:21 12049 8192000000 10962641696 11387682816 2007288960 19.680 100 73 149 3 2049642416 20898752 21454704
17:37:41 2569 8192000000 10965729568 11394142208 2005783184 19.668 100 64 128 0 2051577744 27666128 18128432
17:37:54 18576 8192000000 10970143440 11394310144 1989928112 19.543 99 68 133 2 2032846592 24022048 18896432
17:38:19 7114 8192000000 10948055488 11375308800 1994498496 19.579 100 69 138 1 2038729536 24365152 19865888
17:38:36 12921 8192000000 10952115568 11384115200 2000687312 19.628 100 62 124 1 2043963968 24921664 18354992
17:38:57 5519 8192000000 10958952672 11390517248 2005284656 19.664 100 64 125 1 2046849424 23378016 18186752
17:39:14 2689 8192000000 10973033568 11399307264 2013375264 19.728 100 82 163 1 2063566224 24153728 26037232
17:39:24 4071 8192000000 10951967040 11378814976 1991787072 19.558 99 68 135 0 2037207920 25074976 20345872
17:39:36 3393 8192000000 10952847568 11374465024 1986847184 19.519 99 81 161 1 2036572864 25431856 24293824
17:39:47 1143 8192000000 10978259568 11389263872 2002033456 19.639 100 90 180 1 2055055168 26289296 26732416
17:39:54 7772 8192000000 10957934912 11380293632 1994047024 19.576 100 73 145 1 2042779776 27484656 21248096
17:40:11 2428 8192000000 10955385888 11387539456 1996793584 19.597 100 56 112 2 2045483792 31923520 16766688
17:40:20 1889 8192000000 10959350224 11380662272 1992823952 19.566 100 63 127 1 2039122944 26570112 19728880
17:40:30 2234 8192000000 10960277392 11388301312 2003233280 19.648 100 63 124 0 2046850896 24605280 19012336
17:40:40 10702 8192000000 10955235808 11384274944 1981738224 19.478 99 67 134 0 2027628336 25464096 20426016
17:40:59 2682 8192000000 10937964512 11356102656 1944936624 19.186 98 80 159 0 1997277376 27982000 24358752
17:41:09 6745 8192000000 10940499536 11365187584 1982932048 19.488 100 74 148 1 2032846032 27853792 22060192
17:41:30 2134 8192000000 10937306480 11356942336 1971582048 19.398 100 77 151 0 2022934960 28664032 22688880
17:41:40 5593 8192000000 10939360592 11358216192 1968547792 19.374 100 74 147 0 2022749072 31923072 22278208
17:41:53 5384 8192000000 10920151120 11346960384 1943680096 19.176 99 62 124 1 1994385952 31680304 19025552
17:42:07 6777 8192000000 10914083696 11342254080 1953715712 19.256 100 61 121 0 2002026064 29856720 18453632
17:42:28 5132 8192000000 10900523200 11320832000 1906375104 18.878 98 69 138 2 1958996944 30584752 22037088
17:42:42 7268 8192000000 10888288320 11304865792 1896230512 18.796 98 56 112 2 1945870320 31730432 17909376
17:42:56 4082 8192000000 10880143312 11289960448 1905590016 18.871 99 71 142 2 1961001264 32110224 23301024
17:43:09 4809 8192000000 10914651552 11331534848 1935705664 19.112 100 84 167 1 1996054320 33966304 26382352
17:43:21 4189 8192000000 10912181024 11330904064 1937756096 19.129 100 69 137 0 1992427760 32966384 21705280
17:43:36 3204 8192000000 10916853744 11329712128 1941771584 19.161 100 77 155 1 1997148800 30543792 24833424
17:43:47 4093 8192000000 10916318432 11335651328 1949190960 19.220 100 75 149 1 2003624256 30195248 24238048
17:43:58 2306 8192000000 10910921792 11325153280 1939399680 19.142 100 66 131 3 1992161376 31153936 21607760
17:44:07 4215 8192000000 10915273760 11334049792 1932858816 19.090 99 77 153 2 1990319200 32608992 24851392
17:44:20 7045 8192000000 10902079424 11319857152 1909337888 18.901 98 70 140 0 1961927024 31175408 21413728
17:44:34 3385 8192000000 10880822368 11291889664 1903171616 18.852 99 74 148 1 1958922544 33236288 22514640
17:44:44 5758 8192000000 10883451968 11298807808 1902495312 18.846 99 67 132 0 1953746176 31767824 19483040
17:45:03 3927 8192000000 10884075296 11291181056 1904859728 18.865 99 73 143 0 1960247072 32695968 22691376
17:45:14 2350 8192000000 10892001152 11295891456 1896519280 18.798 99 85 170 2 1956343568 33155648 26668640
17:45:26 7766 8192000000 10872714464 11287412736 1902590272 18.847 100 66 129 0 1956590208 34150736 19849200
17:45:42 4242 8192000000 10868444480 11281203200 1882411776 18.685 99 67 132 2 1940228944 36054864 21762304
17:45:53 1451 8192000000 10898452880 11301310464 1912652544 18.928 100 87 170 4 1977627056 37269904 27704608
17:46:02 5104 8192000000 10890423200 11303051264 1901576928 18.839 99 78 156 1 1964600944 38143264 24880752
17:46:14 7371 8192000000 10913172880 11313565696 1918376416 18.974 100 83 166 0 1986343520 41850288 26116816
17:46:29 1942 8192000000 10926342144 11323850752 1925879968 19.034 100 91 182 2 1996252048 42493536 27878544
17:46:38 2081 8192000000 10933210320 11339784192 1938260992 19.133 100 92 186 2 2008490144 41963856 28265296
17:46:47 4425 8192000000 10909486688 11336146944 1938034848 19.131 100 72 144 2 2003671408 43344128 22292432
17:47:03 3801 8192000000 10894845280 11316609024 1924148912 19.020 100 58 113 2 1981967808 38391872 19427024
17:47:16 1750 8192000000 10907914064 11330572288 1936630800 19.120 100 60 120 2 1991711488 35954304 19126384
17:47:25 8819 8192000000 10930945824 11341627392 1947035280 19.203 100 66 129 2 2004065952 37276576 19754096
17:47:41 2219 8192000000 10926238720 11339190272 1944805248 19.185 100 83 166 2 2009829584 39009952 26014384
17:47:52 2816 8192000000 10917714208 11324575744 1913649584 18.936 99 86 171 1 1981277648 41165824 26462240
17:48:03 2247 8192000000 10927083104 11330621440 1930535312 19.071 100 84 166 2 1999932368 43183600 26213456
17:48:12 3528 8192000000 10930184352 11332792320 1935275744 19.109 100 87 170 1 2006048160 43350992 27421424
17:48:22 3512 8192000000 10935108432 11344883712 1948048560 19.211 100 85 167 1 2016889760 42991184 25850016
17:48:32 964 8192000000 10927605136 11332853760 1932944736 19.090 100 87 173 2 2002940432 43125616 26870080
17:48:46 1470 8192000000 10936060912 11345408000 1943055248 19.171 100 88 173 2 2013589232 44187008 26346976
17:49:00 2440 8192000000 10932533744 11347206144 1948181136 19.212 100 66 132 0 2009382656 40654560 20546960
17:49:09 7975 8192000000 10900226448 11319877632 1918630192 18.976 99 53 105 3 1967245024 32340608 16274224
17:49:30 14227 8192000000 10882265376 11312963584 1893224496 18.772 98 34 66 2 1934336240 30631296 10480448
17:49:51 10604 8192000000 10873796080 11310166016 1915116800 18.948 100 30 60 1 1955202880 30704512 9381568
17:50:09 8153 8192000000 10899328640 11318906880 1927248784 19.045 100 63 125 3 1980231152 33726512 19255856
17:50:25 3042 8192000000 10904285984 11320606720 1930874704 19.074 100 58 117 3 1980251488 30806688 18570096
17:50:34 6160 8192000000 10901035312 11333832704 1934586752 19.104 100 48 94 2 1986130288 37256784 14286752
17:50:58 11186 8192000000 10894278864 11331145728 1927747728 19.049 100 34 68 1 1972783712 33881840 11154144
17:51:21 23013 8192000000 10892722768 11339284480 1932205392 19.085 100 22 44 0 1974592160 34312944 8073824
17:52:02 12906 8192000000 10902636528 11353956352 1942362912 19.166 100 28 56 0 1991477024 39020784 10093328
17:52:23 21346 8192000000 10885020880 11324989440 1914697920 18.944 99 29 58 0 1959330336 34851568 9780848
17:52:53 6900 8192000000 10894746128 11322429440 1920447888 18.990 100 48 96 2 1974456256 37956288 16052080
17:53:08 6681 8192000000 10895519840 11326898176 1925105472 19.028 100 51 103 4 1980311216 38635952 16569792
17:53:21 9577 8192000000 10886334240 11330220032 1927005888 19.043 100 33 66 1 1975661536 38097360 10558288
17:53:45 40614 8192000000 10894340112 11351465984 1938748272 19.137 100 23 46 1 1982388400 35769952 7870176
17:54:39 39346 8192000000 10898294048 11351019520 1923790704 19.017 99 16 32 0 1969265744 39413904 6061136
17:55:25 37129 8192000000 10871391424 11334234112 1931016848 19.075 100 15 30 0 1967271760 30915680 5339232
17:56:10 34046 8192000000 10850794912 11302182912 1823366960 18.205 94 26 52 2 1844812400 13595696 7849744
17:56:51 24581 8192000000 10864655232 11302121472 1884379504 18.700 98 27 54 2 1905556880 12945328 8232048
17:57:24 34379 8192000000 10866792832 11293245440 1905031248 18.867 99 40 80 1 1931720512 14948944 11740320
17:58:05 31191 8192000000 10883505952 11319357440 1936074768 19.115 100 45 90 0 1965517584 15690208 13752608
17:58:47 119387 8192000000 10888699184 11336507392 1943610928 19.176 100 35 70 1 1973461760 18644368 11206464
18:01:01 37404 8192000000 10894706848 11346235392 1954944976 19.266 100 30 60 1 1978159904 14721536 8493392
18:01:45 71808 8192000000 10916967040 11360071680 1971074720 19.394 100 51 103 1 1999304640 13498976 14730944
18:03:03 8022 8192000000 10918217056 11367034880 1985324288 19.507 100 53 105 1 2011600288 11795376 14480624
18:03:24 36221 8192000000 10905629088 11362271232 1972198224 19.403 99 39 75 3 1997059632 13918608 10942800
18:04:07 61821 8192000000 10929860992 11385159680 1990266592 19.546 100 17 34 0 2011600128 16221744 5111792
18:05:35 54149 8192000000 10928240032 11409088512 1993148736 19.569 100 23 46 1 2029502496 28989232 7364528
18:06:40 70948 8192000000 10923777824 11384795136 1985783952 19.510 100 9 18 0 2007562944 19284320 2494672
18:08:05 101778 8192000000 10932053344 11408478208 1996862816 19.598 100 15 31 1 2024465888 23082752 4520320
18:10:25 51858 8192000000 10912861392 11390640128 1989529184 19.540 100 14 28 0 2006632672 13038640 4064848
18:11:37 67644 8192000000 10912963184 11385946112 1994663968 19.581 100 19 38 0 2010583184 10434128 5485088
18:12:52 83182 8192000000 10924029504 11408621568 1997466208 19.603 100 19 38 1 2017222848 14946656 4809984
18:14:28 29555 8192000000 10920884240 11399340032 2000960528 19.630 100 12 24 0 2015798224 11801840 3035856
18:15:08 43478 8192000000 10929976352 11399487488 2002532720 19.643 100 22 44 1 2019959136 10852352 6574064
18:15:58 64129 8192000000 10896982368 11381501952 1947437760 19.206 97 22 43 1 1964425760 11056016 5931984
18:17:09 41144 8192000000 10895474080 11363532800 1967796464 19.368 99 14 27 2 1978708864 6934224 3978176
18:17:56 79830 8192000000 10909349248 11379306496 1945536384 19.191 98 19 36 1 1961434528 11474720 4423424
18:19:22 43832 8192000000 10895429248 11374895104 1979843504 19.463 100 17 34 0 1995404784 11219440 4341840
18:20:15 47317 8192000000 10900179232 11380461568 1977138416 19.442 100 13 26 0 1992015616 11433424 3443776
18:21:15 42655 8192000000 10910259440 11388104704 1952203520 19.244 98 14 28 1 1963947488 7602736 4141232
18:22:06 106838 8192000000 10885080880 11371122688 1915418336 18.950 96 13 26 1 1932233072 13368848 3445888
18:23:59 34072 8192000000 10908816672 11370995712 1945383280 19.190 98 22 43 2 1959381136 8378576 5619280
18:24:47 55012 8192000000 10927888208 11394994176 1984285504 19.499 100 19 38 0 2002100144 12367840 5446800
18:25:48 24601 8192000000 10904134400 11380854784 1972047808 19.402 99 23 46 2 1990487808 11647008 6792992
18:26:19 81968 8192000000 10899338352 11376599040 1911218416 18.916 96 13 26 0 1928494752 13799680 3476656
18:27:52 48650 8192000000 10906081968 11362820096 1894788064 18.784 96 13 26 1 1909524912 11425264 3311584
18:28:51 78668 8192000000 10876274480 11362025472 1887845872 18.728 96 19 38 0 1909684784 16432016 5406896
18:30:16 86825 8192000000 10890431296 11338121216 1829186848 18.253 93 17 35 0 1846119328 12664976 4267504
18:31:50 37213 8192000000 10875227616 11337883648 1914882064 18.946 98 42 83 2 1937907808 11829648 11196096
18:32:35 66963 8192000000 10846557056 11310907392 1803053712 18.039 93 8 16 0 1819317600 14247360 2016528
18:34:46 31627 8192000000 10856700224 11303591936 1879336976 18.660 97 29 58 0 1895846208 8834832 7674400
18:35:25 36178 8192000000 10884912016 11348664320 1937910176 19.130 100 33 66 2 1965989296 18231184 9847936
18:36:36 62414 8192000000 10868810688 11357204480 1945218384 19.188 100 11 22 1 1970495328 22101120 3175824
18:38:45 89639 8192000000 10824525792 11281924096 1801694352 18.028 92 21 42 3 1814016784 6288848 6033584
18:40:22 21733 8192000000 10860604240 11301634048 1882994736 18.689 98 30 59 0 1899963792 8781664 8187392
18:40:58 48535 8192000000 10842570032 11321810944 1932019184 19.083 100 35 70 2 1954278032 12217408 10041440
18:41:59 59988 8192000000 10852174688 11323920384 1922523904 19.007 99 15 30 1 1936250432 9149168 4577360
18:43:07 34311 8192000000 10830159872 11298226176 1882047616 18.682 98 15 26 2 1895775936 9553808 4174512
18:44:01 79579 8192000000 10850787120 11316748288 1879143456 18.658 97 13 26 1 1894943248 12047232 3752560
18:45:44 64839 8192000000 10865625440 11340857344 1938892720 19.138 100 21 42 2 1958855152 14034144 5928288
18:46:57 68494 8192000000 10870064832 11338424320 1925255440 19.029 99 12 24 0 1948748000 19651936 3840624
18:48:29 45617 8192000000 10876717888 11329622016 1919354256 18.982 99 10 20 0 1929308752 7282080 2672416
18:49:20 49969 8192000000 10870935792 11333885952 1916839216 18.962 99 20 40 5 1932708128 10349120 5519792
18:50:17 47992 8192000000 10860687088 11316797440 1875626112 18.630 96 31 62 4 1896908096 12531760 8750224
18:51:19 71904 8192000000 10847789504 11323449344 1886453456 18.717 98 18 36 1 1908036096 16068144 5514496
18:52:40 43715 8192000000 10869844192 11317452800 1918547680 18.975 99 33 65 0 1936868400 9234816 9085904
18:53:32 14579 8192000000 10871587296 11323174912 1924502080 19.023 99 47 93 1 1946340640 8167184 13671376
18:53:58 35601 8192000000 10881132608 11332272128 1924146000 19.020 99 33 66 1 1944700128 11280448 9273680
18:54:50 23074 8192000000 10892954768 11343036416 1948164320 19.212 100 33 66 0 1969396208 12483648 8748240
18:55:21 35586 8192000000 10901579728 11351617536 1952735904 19.248 100 38 76 0 1977707600 14188608 10783088
18:56:05 29932 8192000000 10891883072 11344637952 1950556496 19.231 100 37 74 0 1974607872 13757552 10293824
18:56:49 12171 8192000000 10898728096 11347714048 1942466528 19.166 99 45 90 3 1965104192 9687584 12950080
18:57:09 29244 8192000000 10916380736 11363344384 1965659360 19.351 100 39 78 0 1988002000 11828000 10514640
18:57:48 31989 8192000000 10888821632 11353034752 1934520864 19.103 98 31 62 0 1954363904 11424064 8418976
18:58:30 63209 8192000000 10909147040 11357192192 1954116432 19.259 99 18 36 0 1973634336 14438912 5078992
18:59:42 125394 8192000000 10924668560 11387281408 1980350784 19.467 100 35 69 1 2009693248 19021600 10320864
19:02:53 78024 8192000000 10890998896 11378667520 1957873616 19.289 99 9 18 0 1976315392 16293120 2148656
19:04:17 59334 8192000000 10909870528 11383463936 1973847600 19.416 100 5 10 0 1992970848 17543104 1580144
19:05:23 36981 8192000000 10918986560 11376693248 1971167520 19.395 99 27 54 0 1986983248 8390496 7425232
19:06:06 85502 8192000000 10902505456 11370131456 1909175792 18.900 96 20 40 0 1924807392 9806352 5825248
19:07:39 87301 8192000000 10915188208 11391815680 1959297232 19.300 99 13 26 1 1979338416 16380352 3660832
19:09:23 53521 8192000000 10886844800 11358801920 1916746160 18.961 97 8 16 0 1929066832 10080672 2240000
19:10:26 58837 8192000000 10839622336 11296043008 1825919088 18.226 93 9 18 0 1836453136 8138944 2395104
19:11:35 59746 8192000000 10888186384 11353759744 1955710000 19.272 100 23 47 0 1976463312 13796912 6956400
19:12:42 81770 8192000000 10904095600 11373916160 1946544736 19.199 99 23 46 1 1966777120 13891552 6340832
19:14:10 114692 8192000000 10895415920 11368108032 1906792672 18.881 97 14 28 0 1927108592 16545104 3770816
19:16:12 87501 8192000000 10908897456 11357708288 1928046880 19.051 98 21 42 0 1948195936 14614544 5534512
19:17:47 32411 8192000000 10895749120 11343454208 1871992176 18.600 95 26 52 0 1890924016 11959456 6972384
19:18:31 44203 8192000000 10880455168 11339550720 1944504080 19.183 100 16 32 1 1959700288 10551520 4644688
19:19:38 77883 8192000000 10847235648 11306676224 1859460368 18.499 96 16 32 0 1871729888 8043184 4226336
19:21:03 59774 8192000000 10823750016 11284807680 1854110144 18.456 96 21 42 1 1872255280 11426752 6718384
19:22:29 39491 8192000000 10851131184 11325571072 1926040880 19.035 100 12 24 0 1944198320 14827152 3330288
19:23:21 43205 8192000000 10865147136 11333193728 1933563984 19.095 100 16 30 1 1952120240 13990256 4566000
19:24:11 82321 8192000000 10864083952 11334938624 1871704608 18.598 96 14 28 2 1893317744 17293664 4319472
19:25:42 63799 8192000000 10863040400 11337314304 1920442960 18.990 99 19 38 2 1943573472 16965424 6165088
19:26:52 37099 8192000000 9271852736 9545568256 432140368 5.010 23 1 2 0 437322144 5119648 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 03-12-2020 19:29:33 to 03-12-2020 19:30:05.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 138 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-12-2020 19:30:06 to 03-12-2020 19:30:08.

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          240757
MON$OLDEST_ACTIVE               240758
MON$OLDEST_SNAPSHOT             240758
MON$NEXT_TRANSACTION            240758
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                       2028704
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.33396 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33396 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33396 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33396 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 ---
:15: 
:16: mscs-test-161.budzdorov.ru    Thu Dec  3 19:27:34 2020
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
--- end of diff output ---

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

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