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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-30 22:27:05
DTS_END                         2020-11-30 22:27:05.4450
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/57558
TRN_ID                          239632
ATT_ID                          640
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: 9313.20 20070 1117584
customer order: creation 172.33 354 20679
customer order: refuse 14.42 340 1730
order to supplier: creation 46.41 1290 5569
order to supplier: removal 3.45 90534 414
invoice (draft): creation 46.76 3568 5611
invoice (draft): removal 51.66 717 6199
invoice accept: apply 42.07 17381 5048
invoice accept: cancel 46.91 736 5629
customer reserve: creation 3972.73 168 476727
customer reserve: removal 4622.75 53 554730
realization accept: apply 84.09 174 10091
realization accept: cancel 81.73 109 9808
payment from customer: creation 58.78 127 7053
payment from customer: removal 5.69 107 683
payment to supplier: creation 48.68 130 5842
payment to supplier: removal 3.31 88 397
service: total inventory turnovers 4.38 1225 526
service: total monetary turnovers 6.25 21 750
service: aggregate perf. data 0.78 20398 94
service: refresh index statistics 0.03 263885 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 30-11-2020 22:28:20 to 30-11-2020 22:28:22.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6718
TEST_TIME 2 5254
TEST_TIME 3 6119
TEST_TIME 4 5691
TEST_TIME 5 5790
TEST_TIME 6 5891
TEST_TIME 7 5969
TEST_TIME 8 5665
TEST_TIME 9 5692
TEST_TIME 10 5831
TEST_TIME 11 5923
TEST_TIME 12 6038
TEST_TIME 13 6321
TEST_TIME 14 6728
TEST_TIME 15 6969
TEST_TIME 16 7087
TEST_TIME 17 7228
TEST_TIME 18 7363
TEST_TIME 19 7620
TEST_TIME 20 7798
TEST_TIME 21 8298
TEST_TIME 22 8438
TEST_TIME 23 8398
TEST_TIME 24 8673
TEST_TIME 25 8807
TEST_TIME 26 8929
TEST_TIME 27 9042
TEST_TIME 28 9183
TEST_TIME 29 9440
TEST_TIME 30 9718
TEST_TIME 31 10406
TEST_TIME 32 10511
TEST_TIME 33 10345
TEST_TIME 34 10371
TEST_TIME 35 10435
TEST_TIME 36 10324
TEST_TIME 37 10159
TEST_TIME 38 9923
TEST_TIME 39 9948
TEST_TIME 40 9918
TEST_TIME 41 9959
TEST_TIME 42 9862
TEST_TIME 43 9901
TEST_TIME 44 9818
TEST_TIME 45 9891
TEST_TIME 46 9886
TEST_TIME 47 9788
TEST_TIME 48 9720
TEST_TIME 49 9604
TEST_TIME 50 9562
TEST_TIME 51 9573
TEST_TIME 52 9509
TEST_TIME 53 9571
TEST_TIME 54 9626
TEST_TIME 55 9598
TEST_TIME 56 9630
TEST_TIME 57 9613
TEST_TIME 58 9626
TEST_TIME 59 9615
TEST_TIME 60 9617
TEST_TIME 61 9651
TEST_TIME 62 9679
TEST_TIME 63 9802
TEST_TIME 64 9835
TEST_TIME 65 9851
TEST_TIME 66 9839
TEST_TIME 67 9719
TEST_TIME 68 9691
TEST_TIME 69 9641
TEST_TIME 70 9600
TEST_TIME 71 9509
TEST_TIME 72 9514
TEST_TIME 73 9500
TEST_TIME 74 9402
TEST_TIME 75 9409
TEST_TIME 76 9403
TEST_TIME 77 9378
TEST_TIME 78 9425
TEST_TIME 79 9429
TEST_TIME 80 9459
TEST_TIME 81 9439
TEST_TIME 82 9502
TEST_TIME 83 9485
TEST_TIME 84 9496
TEST_TIME 85 9591
TEST_TIME 86 9634
TEST_TIME 87 9620
TEST_TIME 88 9675
TEST_TIME 89 9603
TEST_TIME 90 9533
TEST_TIME 91 9502
TEST_TIME 92 9473
TEST_TIME 93 9448
TEST_TIME 94 9444
TEST_TIME 95 9396
TEST_TIME 96 9453
TEST_TIME 97 9481
TEST_TIME 98 9476
TEST_TIME 99 9447
TEST_TIME 100 9454
TEST_TIME 101 9444
TEST_TIME 102 9490
TEST_TIME 103 9535
TEST_TIME 104 9509
TEST_TIME 105 9528
TEST_TIME 106 9524
TEST_TIME 107 9543
TEST_TIME 108 9587
TEST_TIME 109 9536
TEST_TIME 110 9488
TEST_TIME 111 9461
TEST_TIME 112 9457
TEST_TIME 113 9456
TEST_TIME 114 9428
TEST_TIME 115 9390
TEST_TIME 116 9348
TEST_TIME 117 9367
TEST_TIME 118 9401
TEST_TIME 119 9388
TEST_TIME 120 9315

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 30-11-2020 22:28:23 to 30-11-2020 22:28: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 1558354 1558354 0 0.00 0 20720 6 0 0
doc_list_biud 1558353 1558353 0 0.00 0 69711 24 0 0
sp_add_invoice_to_stock 5135 5048 87 1.69 21 155287 17382 0 87
sp_cancel_adding_invoice 5629 5629 0 0.00 4 60440 736 0 0
sp_cancel_client_order 1730 1730 0 0.00 4 7981 341 0 0
sp_cancel_customer_reserve 554730 554730 0 0.00 1 20525 54 0 0
sp_cancel_pay_from_customer 683 683 0 0.00 2 6266 107 0 0
sp_cancel_pay_to_supplier 397 397 0 0.00 2 6494 88 0 0
sp_cancel_supplier_invoice 6206 6199 7 0.11 1 69780 717 0 7
sp_cancel_supplier_order 414 414 0 0.00 5 861937 90535 0 0
sp_cancel_write_off 9808 9808 0 0.00 1 12265 110 0 0
sp_client_order 20679 20679 0 0.00 4 29246 355 0 0
sp_customer_reserve 476727 476727 0 0.00 0 93120 169 0 0
sp_fill_shopping_cart 31845 31845 0 0.00 1 10466 40 0 0
sp_fill_shopping_cart_clo_res 476724 476724 0 0.00 0 16862 14 0 0
sp_get_clo_for_invoice 5045 5045 0 0.00 0 28663 303 0 0
sp_kill_cost_storno 16517 16517 0 0.00 0 12264 56 0 0
sp_kill_qstorno_ret_qs2qd 1125881 1125881 0 0.00 0 69710 29 0 0
sp_kill_qty_storno 593646 593646 0 0.00 0 69711 63 0 0
sp_lock_selected_doc 20812 20812 0 0.00 0 7949 8 0 0
sp_make_cost_storno 28031 28031 0 0.00 0 14080 52 0 0
sp_multiply_rows_for_pdistr 28031 28031 0 0.00 0 7874 33 0 0
sp_multiply_rows_for_qdistr 20679 20679 0 0.00 0 9778 157 0 0
sp_pay_from_customer 7053 7053 0 0.00 4 31881 128 0 0
sp_pay_to_supplier 5842 5842 0 0.00 5 10337 130 0 0
sp_payment_common 12895 12895 0 0.00 1 31840 42 0 0
sp_qd_handle_on_cancel_clo 1730 1730 0 0.00 0 7353 300 0 0
sp_qd_handle_on_invoice_upd_sts 10674 10674 0 0.00 0 17017 303 0 0
sp_qd_handle_on_reserve_upd_sts 10091 10091 0 0.00 0 14091 50 0 0
sp_reserve_write_off 10091 10091 0 0.00 6 14107 175 0 0
sp_supplier_invoice 5611 5611 0 0.00 5 87146 3569 0 0
sp_supplier_order 5569 5569 0 0.00 5 33317 1290 0 0
srv_aggregate_perf_data 94 94 0 0.00 2831 233548 20399 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1528 179738 33459 0 0
srv_find_qd_qs_mism 1069020 1069020 0 0.00 0 20718 5 0 0
srv_make_invnt_saldo 526 526 0 0.00 39 95772 1225 0 0
srv_make_money_saldo 750 750 0 0.00 0 1462 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 136256 451240 263885 0 0
t$perf-abend:sp_add_invoice_to_stock 87 87 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 5048 5048 0 0.00 0 21973 158 0 0
t$perf-norm:sp_cancel_adding_invoice 410 410 0 0.00 0 13676 104 0 0
t$perf-norm:sp_cancel_client_order 1730 1730 0 0.00 0 8455 23 0 0
t$perf-norm:sp_cancel_customer_reserve 624 624 0 0.00 0 2987 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 683 683 0 0.00 0 974 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 397 397 0 0.00 0 4947 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 384 384 0 0.00 0 356 9 0 0
t$perf-norm:sp_cancel_supplier_order 414 414 0 0.00 0 24461 1653 0 0
t$perf-norm:sp_cancel_write_off 1034 1034 0 0.00 0 8879 15 0 0
t$perf-norm:sp_client_order 20679 20679 0 0.00 0 19396 18 0 0
t$perf-norm:sp_customer_reserve 1018 1018 0 0.00 0 2436 12 0 0
t$perf-norm:sp_pay_from_customer 7053 7053 0 0.00 0 5387 10 0 0
t$perf-norm:sp_pay_to_supplier 5842 5842 0 0.00 0 9045 10 0 0
t$perf-norm:sp_reserve_write_off 10091 10091 0 0.00 0 8454 11 0 0
t$perf-norm:sp_supplier_invoice 5611 5611 0 0.00 0 8780 23 0 0
t$perf-norm:sp_supplier_order 5569 5569 0 0.00 0 14211 20 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 229 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 229 4 0 0
t$perf-norm:srv_make_invnt_saldo 526 526 0 0.00 0 973 16 0 0
t$perf-norm:srv_make_money_saldo 750 750 0 0.00 0 2392 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10264 10090 174 1.69 0 8737 21 0 174
v_all_customers 37856 37856 0 0.00 0 21 1 0 0
v_all_suppliers 30642 30642 0 0.00 0 17 1 0 0
v_all_wares 41358 41358 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 820 820 0 0.00 0 2840 11 0 0
v_cancel_client_order 3460 3460 0 0.00 0 3428 8 0 0
v_cancel_customer_prepayment 1366 1366 0 0.00 0 5180 14 0 0
v_cancel_customer_reserve 1248 1248 0 0.00 0 1898 4 0 0
v_cancel_payment_to_supplier 794 794 0 0.00 0 2940 9 0 0
v_cancel_supplier_invoice 782 768 14 1.79 0 182 12 0 14
v_cancel_supplier_order 828 828 0 0.00 0 291 5 0 0
v_cancel_write_off 2068 2068 0 0.00 0 1125 12 0 0
v_max_id_clo_ord 5569 5569 0 0.00 0 606 1 0 0
v_max_id_clo_res 1018 1018 0 0.00 0 1506 12 0 0
v_max_id_ord_sup 5597 5597 0 0.00 0 7385 9 0 0
v_max_non_paid_invoice 1687 1687 0 0.00 0 4543 6 0 0
v_max_non_paid_realizn 3721 3721 0 0.00 0 5986 5 0 0
v_min_id_clo_ord 5569 5569 0 0.00 0 7646 8 0 0
v_min_id_clo_res 1018 1018 0 0.00 0 3503 16 0 0
v_min_id_ord_sup 5597 5597 0 0.00 0 6044 8 0 0
v_min_non_paid_invoice 5842 5842 0 0.00 0 8116 24 0 0
v_min_non_paid_realizn 7053 7053 0 0.00 0 7072 27 0 0
v_our_firm 10166 10166 0 0.00 0 15 1 0 0
v_reserve_write_off 20182 20182 0 0.00 0 5278 6 0 0
x_lock_depdocs_on_canc_invoice 11444 11444 0 0.00 0 29604 104 0 0
x_lock_depdocs_on_canc_sup_ord 414 414 0 0.00 0 10281 333 0 0
x_make_qstorno_1000_1200 5569 5569 0 0.00 2 33291 1203 0 0
x_make_qstorno_1200_2000 5611 5611 0 0.00 2 87136 3425 0 0
x_make_qstorno_2100_3300 476727 476727 0 0.00 0 93118 152 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-11-2020 22:28:27 to 30-11-2020 22:28: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
19:57:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:15 18345 8192000000 10254220048 10562678784 1138121280 12.198 87 65 130 0 1163456464 3281264 22053920
19:57:41 22040 8192000000 10325795584 10639929344 1379181968 14.409 100 89 178 0 1413180464 4790944 29207552
19:58:12 22613 8192000000 10372421136 10694156288 1419945920 14.772 100 84 168 0 1453536832 6142256 27448656
19:58:44 26669 8192000000 10423301744 10747273216 1461460832 15.139 100 88 176 0 1496670480 6994992 28214656
19:59:22 11839 8192000000 10427045472 10756014080 1482741232 15.325 100 85 170 0 1517527440 7888960 26897248
19:59:55 18824 8192000000 10452737248 10785529856 1509859392 15.562 100 94 188 1 1548401232 8956080 29585760
20:00:22 19716 8192000000 10463754192 10799857664 1519393536 15.645 100 93 186 0 1558138336 9734336 29010464
20:00:55 19157 8192000000 10487646912 10829496320 1544208064 15.860 100 82 164 1 1579698160 10482112 25007984
20:01:22 12594 8192000000 10506338576 10854166528 1560149584 15.998 100 82 164 2 1596105648 10959136 24996928
20:01:47 14050 8192000000 10529409168 10881798144 1588314944 16.239 100 82 165 0 1624794576 11294864 25184768
20:02:14 11553 8192000000 10554898656 10908708864 1603383264 16.368 100 84 168 0 1640046096 11555664 25107168
20:02:37 16693 8192000000 10592861264 10952851456 1644038272 16.714 100 86 172 0 1681870256 12168688 25663296
20:03:01 12292 8192000000 10611570928 10976043008 1664306864 16.885 100 86 172 2 1703529136 13489920 25732352
20:03:21 8218 8192000000 10617849504 10981191680 1674852032 16.974 100 86 173 1 1713752576 13757600 25142944
20:03:38 9010 8192000000 10622485056 10991763456 1686654544 17.073 100 86 173 2 1726118416 13626688 25837184
20:03:54 8224 8192000000 10644110416 11008987136 1694296496 17.137 100 89 178 0 1734333568 13858576 26178496
20:04:12 6710 8192000000 10651049776 11023966208 1711803648 17.284 100 78 156 0 1747739696 13481968 22454080
20:04:29 6529 8192000000 10669533392 11042381824 1729285408 17.430 100 87 174 2 1768791344 14048688 25457248
20:04:43 6396 8192000000 10675352352 11051098112 1736544384 17.490 100 82 165 0 1774264352 14325728 23394240
20:04:57 6102 8192000000 10676510640 11052896256 1745727120 17.566 100 80 158 1 1781338800 13301616 22310064
20:05:11 5327 8192000000 10692619120 11067596800 1756387360 17.654 100 86 170 1 1792851536 12143088 24321088
20:05:24 2812 8192000000 10706705840 11084664832 1768246624 17.753 100 83 164 0 1803342000 12496272 22599104
20:05:34 4134 8192000000 10727746448 11104174080 1778492464 17.837 100 82 164 2 1814134144 12949856 22691824
20:05:45 4420 8192000000 10723159632 11099594752 1784657632 17.888 100 88 176 0 1824220432 14355472 25207328
20:05:56 3383 8192000000 10734559376 11114008576 1789975200 17.932 100 87 174 2 1828511056 14438352 24097504
20:06:06 4343 8192000000 10734527008 11116724224 1796723120 17.987 100 90 180 1 1835707456 14137760 24846576
20:06:21 3152 8192000000 10748916944 11126214656 1800961136 18.022 100 91 179 3 1840554528 14677280 24916112
20:06:31 2553 8192000000 10756998128 11141890048 1813688016 18.126 100 85 170 0 1852646560 14877200 24081344
20:06:40 3358 8192000000 10769081456 11154558976 1825337168 18.221 100 84 167 0 1862345328 13018864 23989296
20:06:50 2329 8192000000 10775020384 11159281664 1836450608 18.312 100 94 188 1 1875690704 13905792 25334304
20:06:59 1870 8192000000 10773688512 11156758528 1834449648 18.296 100 95 188 0 1876333328 15241072 26642608
20:07:07 2154 8192000000 10773722240 11162202112 1836243408 18.310 100 82 161 2 1872329296 12314432 23771456
20:07:16 2424 8192000000 10785293936 11169574912 1840150992 18.342 100 92 185 1 1879187120 13227024 25809104
20:07:25 2741 8192000000 10790199920 11174957056 1841843248 18.356 100 90 180 0 1880016576 12873600 25299728
20:07:34 1635 8192000000 10793917056 11176886272 1846673824 18.395 100 95 190 2 1886141696 12339888 27127984
20:07:42 1925 8192000000 10793420208 11177959424 1847677440 18.403 100 88 174 1 1884540784 11643024 25220320
20:07:50 3086 8192000000 10786074720 11177426944 1849825520 18.421 100 85 171 0 1886776832 12364704 24586608
20:08:00 1640 8192000000 10797870528 11182301184 1853213712 18.448 100 93 184 1 1892762128 13196032 26352384
20:08:08 2991 8192000000 10796430464 11186114560 1853801984 18.453 100 91 180 1 1893307136 13175168 26329984
20:08:18 1766 8192000000 10800137712 11186257920 1855236992 18.465 100 96 193 1 1895390320 13188096 26965232
20:08:26 1550 8192000000 10805245680 11188559872 1856049152 18.471 100 99 198 2 1898033728 13919312 28065264
20:08:34 1983 8192000000 10808811296 11193528320 1858993728 18.495 100 95 191 0 1900464448 14713616 26757104
20:08:42 2673 8192000000 10808534704 11195174912 1863152816 18.529 100 96 193 2 1904685648 14786240 26746592
20:08:51 1682 8192000000 10814061728 11201011712 1866842544 18.559 100 95 191 0 1907460576 14373216 26244816
20:08:59 1697 8192000000 10812146416 11203149824 1869566816 18.581 100 91 182 1 1909012912 14358480 25087616
20:09:08 36032 8192000000 10784279248 11193880576 1862726560 18.525 100 58 116 1 1895235936 16285648 16223728
20:09:53 3241 8192000000 10805012064 11206352896 1866863856 18.559 100 75 149 1 1896845744 8179664 21802224
20:10:03 4831 8192000000 10794018080 11205177344 1867191536 18.562 100 51 101 3 1889954912 8983008 13780368
20:10:14 3083 8192000000 10792788992 11206901760 1870130560 18.585 100 54 110 2 1894823088 9876144 14816384
20:10:26 3749 8192000000 10782281008 11205074944 1867165216 18.561 100 39 76 1 1887046592 9494128 10387248
20:10:37 12569 8192000000 10775726208 11205443584 1869474480 18.580 100 30 61 0 1884139632 6211280 8453872
20:11:00 10891 8192000000 10772025712 11203723264 1871797808 18.599 100 20 40 0 1883184352 5348736 6037808
20:11:18 5325 8192000000 10788141392 11212947456 1874986288 18.625 100 41 82 0 1893656832 6603392 12067152
20:11:29 5997 8192000000 10780723344 11207520256 1872317504 18.603 100 18 36 0 1883194768 5793392 5083872
20:11:45 6906 8192000000 10776377744 11211296768 1875668272 18.630 100 22 40 1 1886848576 5509072 5671232
20:12:05 6919 8192000000 10788943424 11217342464 1878749344 18.655 100 22 45 2 1890795120 5925200 6120576
20:12:18 7012 8192000000 10787447520 11219800064 1879934640 18.665 100 21 42 2 1891935824 6315280 5685904
20:12:34 8194 8192000000 10786905776 11221549056 1881108352 18.674 100 22 42 1 1893015040 6159808 5746880
20:12:49 64764 8192000000 10824347088 11238400000 1889799040 18.744 100 33 66 1 1905644608 5792464 10053104
20:14:01 15813 8192000000 10807848128 11233296384 1878362048 18.652 99 37 71 1 1895878256 6496544 11019664
20:14:23 8064 8192000000 10794349904 11231834112 1890180064 18.747 100 27 55 0 1904251520 6383088 7688368
20:14:38 7905 8192000000 10804787824 11237527552 1893504784 18.774 100 38 75 1 1911179824 6787280 10887760
20:14:54 6923 8192000000 10810638288 11244916736 1899519696 18.822 100 24 47 1 1912962960 6822768 6620496
20:15:08 5493 8192000000 10819389984 11245486080 1900919088 18.834 100 27 54 1 1914880496 5906112 8055296
20:15:20 5656 8192000000 10831498928 11257044992 1907836240 18.889 100 44 89 1 1928646656 8097888 12712528
20:15:33 5149 8192000000 10824482016 11252580352 1907909136 18.890 100 29 56 5 1922752336 6431152 8412048
20:15:45 5110 8192000000 10816347168 11252793344 1905946192 18.874 100 32 65 3 1922237440 6469152 9822096
20:16:00 8136 8192000000 10820459776 11254112256 1904037104 18.859 100 18 36 1 1914302592 5026224 5239264
20:16:16 6412 8192000000 10824741456 11254644736 1907385856 18.886 100 31 63 1 1923212416 7398880 8427680
20:16:29 10035 8192000000 10793687536 11228102656 1868096912 18.569 98 30 56 6 1887436928 10561056 8778960
20:16:47 7136 8192000000 10800631312 11227668480 1877849632 18.648 99 19 38 0 1889188992 5062848 6276512
20:17:06 5541 8192000000 10812660016 11242680320 1893107264 18.771 100 20 40 2 1908549840 9629056 5813520
20:17:18 6376 8192000000 10814208464 11241431040 1879986224 18.665 99 23 45 2 1892451520 6082112 6383184
20:17:33 7787 8192000000 10778450720 11202076672 1850277392 18.424 98 22 44 2 1862911184 6373040 6260752
20:17:51 17388 8192000000 10798744800 11218710528 1851771296 18.437 98 30 61 2 1866295952 6192288 8332368
20:19:00 18759 8192000000 10782500944 11209252864 1820214240 18.179 97 22 44 1 1832773856 5674304 6885312
20:19:28 9721 8192000000 10755707872 11172806656 1765335888 17.728 95 18 34 1 1774827216 4659072 4832256
20:19:44 3977 8192000000 10745851248 11159797760 1791602640 17.945 98 37 74 4 1812741152 10375840 10762672
20:19:55 7750 8192000000 10715490544 11128954880 1720560416 17.357 95 36 72 0 1742916752 12055056 10301280
20:20:12 9618 8192000000 10677990528 11091484672 1739115888 17.511 97 31 62 1 1754774912 6937184 8721840
20:20:28 8810 8192000000 10683098112 11100590080 1761348496 17.696 99 27 55 2 1774884944 5709376 7827072
20:20:47 5502 8192000000 10699407552 11109777408 1769630528 17.764 99 30 59 2 1783449456 5477392 8341536
20:20:59 7205 8192000000 10696751440 11100794880 1729597456 17.432 97 24 48 1 1742313424 4807184 7908784
20:21:13 9856 8192000000 10700346912 11112177664 1750194224 17.603 98 22 44 0 1761804208 5073200 6536784
20:21:29 7520 8192000000 10694343792 11108089856 1758054432 17.668 98 26 52 0 1775511008 10269200 7187376
20:21:48 6574 8192000000 10710273664 11130273792 1786544256 17.903 99 27 54 0 1800011696 5456688 8010752
20:22:01 9132 8192000000 10718475616 11131035648 1794365792 17.968 99 18 36 3 1805498896 5941280 5191824
20:22:17 7888 8192000000 10740349904 11156598784 1823939920 18.210 100 34 70 2 1839501280 5057584 10503776
20:22:32 8840 8192000000 10744403280 11164983296 1814722816 18.135 99 23 46 1 1826624016 5004096 6897104
20:22:47 64124 8192000000 10748558064 11173285888 1837525728 18.321 100 36 72 2 1853547264 5614704 10406832
20:23:59 7935 8192000000 10748601824 11180064768 1840870848 18.348 100 22 44 2 1852656064 6012496 5772720
20:24:13 7751 8192000000 10755107504 11183874048 1846514464 18.394 100 24 48 0 1859545936 5643392 7388080
20:24:27 10882 8192000000 10779550176 11184754688 1846913056 18.397 100 35 68 1 1862419312 6139728 9366528
20:24:45 8239 8192000000 10760087936 11186003968 1849091712 18.415 100 24 48 0 1862328384 5850736 7385936
20:25:02 9661 8192000000 10761437440 11187732480 1853515184 18.451 100 34 68 2 1870371728 6008656 10847888
20:25:18 7402 8192000000 10773242016 11194437632 1856220736 18.473 100 30 60 3 1870539296 5869680 8448880
20:25:32 5168 8192000000 10768041312 11191562240 1852516704 18.443 100 13 26 0 1861154512 4584960 4052848
20:25:44 7262 8192000000 10766201840 11196387328 1858240256 18.489 100 38 76 0 1875952576 6388432 11323888
20:25:59 9109 8192000000 10776031024 11195527168 1855336368 18.465 100 16 32 1 1865376144 5090928 4948848
20:26:15 8162 8192000000 10780453344 11202920448 1861115840 18.512 100 31 62 2 1876111136 5502400 9492896
20:26:32 8312 8192000000 10776394880 11203092480 1860770704 18.510 100 21 42 0 1872639616 5689440 6179472
20:26:48 9929 8192000000 10766184816 11200278528 1861097120 18.512 100 19 38 0 1873368448 6014544 6256784
20:27:11 13260 8192000000 10814018416 11229265920 1884901888 18.705 100 45 88 4 1903675984 5627664 13146432
20:27:33 11761 8192000000 10817488736 11233939456 1892235408 18.764 100 45 91 0 1911613792 6542608 12835776
20:27:56 24666 8192000000 10832226816 11251523584 1903417856 18.854 100 55 110 0 1927234112 8202464 15613792
20:28:33 83496 8192000000 10845348016 11265019904 1911560192 18.919 100 62 124 2 1938118384 8817600 17740592
20:30:04 40692 8192000000 10839748464 11273854976 1912545200 18.927 100 29 58 3 1930240960 9517488 8178272
20:30:55 15438 8192000000 10843916384 11278475264 1922128192 19.004 100 31 62 1 1939956544 9451584 8376768
20:31:17 25980 8192000000 10863942752 11290857472 1931927296 19.082 100 46 92 5 1955358896 10143808 13287792
20:31:52 30462 8192000000 10874316752 11303485440 1937945488 19.130 100 45 90 1 1962546368 11626256 12974624
20:32:51 7528 8192000000 10883040272 11309916160 1950060432 19.227 100 50 100 0 1974711968 9542144 15109392
20:33:12 8310 8192000000 10877413840 11304062976 1932868320 19.090 99 50 99 1 1958475408 10586512 15020576
20:33:28 13409 8192000000 10893146336 11309981696 1931827664 19.081 99 65 129 2 1962690848 12031120 18832064
20:33:51 15644 8192000000 10884575936 11313094656 1948876128 19.218 100 51 100 0 1977264560 13523456 14864976
20:34:20 6693 8192000000 10896197824 11322548224 1953866032 19.257 100 56 110 0 1985900928 15214528 16820368
20:34:36 15375 8192000000 10896107040 11325157376 1958596576 19.295 100 56 112 1 1992115408 16435632 17083200
20:34:58 12676 8192000000 10918635360 11334070272 1963171760 19.331 100 58 116 0 1993801952 14200640 16429552
20:35:21 12389 8192000000 10908240288 11336540160 1968384752 19.373 100 58 114 2 2000217552 15659872 16172928
20:35:55 23363 8192000000 10908058144 11344179200 1970346384 19.388 100 44 88 2 2000396784 16708816 13341584
20:36:30 6359 8192000000 10916617152 11349389312 1979517600 19.461 100 53 106 1 2010981920 15723888 15740432
20:36:44 13746 8192000000 10928221280 11356426240 1982330880 19.483 100 58 116 1 2016549024 16421008 17797136
20:37:04 42923 8192000000 10909957424 11344887808 1965773776 19.352 99 54 108 1 2001241520 18287136 17180608
20:37:54 30972 8192000000 10927230816 11365023744 1976193872 19.435 100 31 61 0 2004168496 17845552 10129072
20:38:40 24686 8192000000 10914192352 11357057024 1974827216 19.424 100 37 74 2 2005269472 18757792 11684464
20:39:16 14064 8192000000 10911402048 11343876096 1953560112 19.255 99 41 79 5 1982630032 16808336 12261584
20:39:42 3712 8192000000 10929483904 11356372992 1978867824 19.456 100 70 140 0 2020606592 19962224 21776544
20:39:53 10136 8192000000 10923743472 11353714688 1957924176 19.290 99 53 106 1 1998810592 24057968 16828448
20:40:17 3291 8192000000 10910383632 11341570048 1953472240 19.254 99 53 104 0 1990663104 21106688 16084176
20:40:29 4969 8192000000 10922802688 11349729280 1971592416 19.398 100 65 130 0 2012580944 20696144 20292384
20:40:49 1926 8192000000 10923909088 11350380544 1971959120 19.401 100 67 134 3 2013700128 21206320 20534688
20:40:58 3105 8192000000 10954731760 11364564992 1983097200 19.489 100 85 169 2 2031786880 23637472 25052208
20:41:07 4374 8192000000 10938620544 11366100992 1984839072 19.503 100 64 128 1 2027074944 23138384 19097488
20:41:21 7430 8192000000 10933033664 11372408832 1987275136 19.522 100 46 91 1 2024233600 23179584 13778880
20:41:43 11294 8192000000 10936544896 11374895104 1987886832 19.527 100 44 88 1 2024889120 23263456 13738832
20:42:05 8469 8192000000 10935645856 11372126208 1983795632 19.495 100 51 100 3 2022518048 23641088 15081328
20:42:28 9093 8192000000 10916294960 11359858688 1972491152 19.405 99 47 94 1 2010305136 23423008 14390976
20:42:45 4650 8192000000 10920878944 11354591232 1975246368 19.427 100 49 96 0 2011171056 21022400 14902288
20:43:07 21681 8192000000 10925232176 11359305728 1961590912 19.319 99 49 98 0 2004391104 26630144 16170048
20:43:44 12711 8192000000 10929383584 11365916672 1965744704 19.352 99 46 92 0 2005767744 24945984 15077056
20:44:03 2253 8192000000 10932085984 11341426688 1959432320 19.302 100 80 161 1 2010254368 25443968 25378080
20:44:15 3775 8192000000 10920921184 11346587648 1950933760 19.234 99 64 127 1 1997636592 26812880 19889952
20:44:28 3445 8192000000 10918973088 11343691776 1958479344 19.294 99 73 145 1 2007186032 25462464 23244224
20:44:40 1743 8192000000 10928674800 11344465920 1960638160 19.311 100 76 149 1 2011519568 27748208 23133200
20:44:50 3081 8192000000 10945736480 11356446720 1970362896 19.388 100 80 157 1 2021664640 27163008 24138736
20:45:03 2685 8192000000 10942080736 11358613504 1960880160 19.313 99 83 164 1 2014352624 29045504 24426960
20:45:14 3818 8192000000 10948214336 11360788480 1973669456 19.415 100 82 164 0 2028314096 30151552 24493088
20:45:24 6413 8192000000 10930170512 11363250176 1973308032 19.412 100 52 104 1 2019408128 30444688 15655408
20:45:38 8074 8192000000 10921125904 11357335552 1951945632 19.242 99 46 90 1 1996652000 30100176 14606192
20:45:55 1528 8192000000 10937328368 11346132992 1963157216 19.331 100 83 163 4 2017418288 29185584 25075488
20:46:04 2561 8192000000 10905866944 11311415296 1900177968 18.828 97 82 164 2 1956984112 30971088 25835056
20:46:14 6495 8192000000 10908899584 11334189056 1945044272 19.187 100 57 114 1 1995608848 32729360 17835216
20:46:28 4573 8192000000 10897890640 11330359296 1911348176 18.917 98 46 91 1 1954574784 28020480 15206128
20:46:40 9391 8192000000 10887792112 11314872320 1901875168 18.841 98 48 96 1 1944691488 27420560 15395760
20:46:58 4417 8192000000 10899943328 11320332288 1931414976 19.078 100 63 124 3 1981214032 29908304 19890752
20:47:12 8818 8192000000 10896233104 11331973120 1942131520 19.164 100 45 90 0 1985735648 28749456 14854672
20:47:32 14232 8192000000 10896101744 11324997632 1932873888 19.090 100 52 103 4 1980548560 31512608 16162064
20:47:53 2173 8192000000 10902183728 11318620160 1929483664 19.063 99 76 147 2 1982659504 29576224 23599616
20:48:02 4038 8192000000 10901952880 11313725440 1906649472 18.880 98 74 147 1 1960042576 30191328 23201776
20:48:13 4160 8192000000 10902783184 11322040320 1921320336 18.997 99 63 126 0 1972241808 30906160 20015312
20:48:26 10126 8192000000 10894442336 11330318336 1937098560 19.124 100 44 86 1 1985621648 33824928 14698160
20:48:51 4616 8192000000 10893554160 11330994176 1933788000 19.097 100 45 90 0 1978808160 30368688 14651472
20:49:05 7849 8192000000 10871389616 11307405312 1906003424 18.875 99 27 54 1 1940370096 26038768 8327904
20:49:25 6950 8192000000 10881626000 11313848320 1926779520 19.041 100 40 80 0 1965926128 26491104 12655504
20:49:38 11816 8192000000 10874455104 11317690368 1913188720 18.932 99 37 73 1 1953312368 28559952 11563696
20:49:57 17621 8192000000 10884593984 11317854208 1910364368 18.910 99 31 63 1 1951595152 30958816 10271968
20:50:24 12443 8192000000 10878448064 11313516544 1891112016 18.755 98 34 68 0 1932964336 31081936 10770384
20:51:03 3094 8192000000 10929035392 11342770176 1948739392 19.216 100 82 161 4 2008967840 33815600 26412848
20:51:14 8937 8192000000 10905536896 11337818112 1945224192 19.188 100 47 93 0 1997006768 36559072 15223504
20:51:32 5893 8192000000 10905937088 11339247616 1943067504 19.171 100 39 78 0 1989372336 33044576 13260256
20:51:48 10967 8192000000 10901127712 11338973184 1927767456 19.049 99 34 68 0 1971471024 31939776 11763792
20:52:20 24830 8192000000 10885271632 11330195456 1900295760 18.829 98 26 52 2 1940588544 30803184 9489600
20:52:51 27616 8192000000 10891871200 11332743168 1933696272 19.096 100 29 58 0 1978386656 34655680 10034704
20:53:26 12617 8192000000 10902652480 11323514880 1931134320 19.076 100 41 82 0 1976015344 31623408 13257616
20:54:02 13160 8192000000 10890469952 11323408384 1911662048 18.920 99 30 60 1 1957081328 35727424 9691856
20:54:22 11421 8192000000 10870712784 11304943616 1866109728 18.553 97 34 69 1 1913684704 36229792 11345184
20:54:45 3548 8192000000 10879642096 11318398976 1914748784 18.945 100 33 66 1 1962962880 37818960 10395136
20:55:03 13827 8192000000 10876868192 11315748864 1913555328 18.935 100 32 64 2 1964008816 39628832 10824656
20:55:30 20864 8192000000 10882451568 11329544192 1921007136 18.995 100 23 46 1 1960380128 32052080 7320912
20:56:35 53074 8192000000 10849614864 11307184128 1892204976 18.764 99 23 46 1 1935506416 36148160 7153280
20:57:37 34529 8192000000 10869606768 11322675200 1907157856 18.884 100 12 24 0 1949332880 37764224 4410800
20:58:30 53286 8192000000 10866411552 11323850752 1911017536 18.915 99 8 16 0 1932206080 18829216 2359328
20:59:36 59563 8192000000 10868585296 11302965248 1903857888 18.857 98 22 43 1 1920645536 11804064 4983584
21:00:46 15634 8192000000 10895930912 11324555264 1945616432 19.192 100 50 102 2 1968563280 9109520 13837328
21:01:23 19428 8192000000 10886899168 11310645248 1904120624 18.859 98 29 59 4 1919072464 6904560 8047280
21:01:52 27482 8192000000 10866277200 11301449728 1899544176 18.823 98 31 62 0 1915223120 7122368 8556576
21:02:27 126966 8192000000 10866605632 11327565824 1881743008 18.679 97 15 31 2 1896093328 10801120 3549200
21:04:45 101400 8192000000 10900965856 11348389888 1961030512 19.314 100 44 88 1 1981915184 8722480 12162192
21:06:34 179738 8192000000 10871025184 11333279744 1905719584 18.872 97 21 42 3 1925009840 13622816 5667440
21:09:40 42293 8192000000 10890678384 11344240640 1953028320 19.251 100 29 56 2 1969957712 8645552 8283840
21:10:33 46684 8192000000 10888836912 11353235456 1946101856 19.195 99 18 36 2 1963397056 11666128 5629072
21:11:27 14942 8192000000 10921007600 11352064000 1950096544 19.227 99 51 102 1 1972637488 7547008 14993936
21:11:48 29404 8192000000 10932611648 11369066496 1977847904 19.448 100 59 118 0 2007283024 11598960 17836160
21:12:52 48595 8192000000 10908093328 11374866432 1972324400 19.404 100 16 32 0 1990894416 13715088 4854928
21:13:47 21558 8192000000 10888787648 11367239680 1972733792 19.407 100 5 10 1 1981536144 7487744 1314608
21:14:15 16885 8192000000 10891421952 11365220352 1974977840 19.425 100 12 26 0 1985796016 7060832 3757344
21:14:38 19406 8192000000 10895201392 11361787904 1962438576 19.325 99 23 46 1 1976542048 7004128 7099344
21:15:04 65931 8192000000 10890330320 11365683200 1957328544 19.285 99 11 22 0 1968888528 7984208 3575776
21:16:16 80383 8192000000 10877911616 11351756800 1951954032 19.242 99 33 66 1 1970259216 8478896 9826288
21:17:47 94556 8192000000 10892335888 11383287808 1951836288 19.241 99 16 32 0 1974972608 18851168 4285152
21:19:28 63165 8192000000 10902489200 11395084288 1968962032 19.377 100 6 12 0 1993402384 22784848 1655504
21:20:37 34504 8192000000 10899877296 11370356736 1937532736 19.127 98 9 18 0 1948638176 8673696 2431744
21:21:24 64260 8192000000 10921916896 11389583360 1981940752 19.480 100 17 34 0 1998058208 11452256 4665200
21:22:35 63415 8192000000 10889919520 11359559680 1880495008 18.669 95 23 46 4 1898915904 11863872 6557024
21:23:44 42250 8192000000 10917062720 11372204032 1947974928 19.210 99 34 67 3 1966416192 9130544 9310720
21:24:39 13365 8192000000 10886640032 11346747392 1921434896 18.998 98 24 48 1 1935900048 7928896 6536256
21:25:02 15513 8192000000 10903427920 11356491776 1942732768 19.169 99 36 72 1 1961591136 8804752 10053616
21:25:25 41964 8192000000 10907127984 11373137920 1950676160 19.232 99 34 68 0 1975147552 15143600 9327792
21:26:13 57378 8192000000 10907382976 11372007424 1936455472 19.118 98 19 39 1 1955583296 14457424 4670400
21:27:20 54546 8192000000 10887037264 11354677248 1910458416 18.910 97 22 44 1 1929404864 12741616 6204832
21:28:21 56653 8192000000 10905574016 11362729984 1895105568 18.787 96 21 42 1 1919553024 18599584 5847872
21:29:26 70497 8192000000 10882733344 11351912448 1875273392 18.627 96 10 20 1 1896036800 17477296 3286112
21:30:53 59188 8192000000 10878222144 11351080960 1906096864 18.875 98 5 10 0 1923055808 15544768 1414176
21:32:08 57676 8192000000 10883014720 11344707584 1874084784 18.617 96 14 28 1 1893959680 15433216 4441680
21:34:37 88160 8192000000 10849811136 11308699648 1875327744 18.627 96 27 55 1 1890942912 7941552 7673616
21:37:18 78474 8192000000 10827588416 11300265984 1870242544 18.586 97 12 24 2 1883061904 9302336 3517024
21:38:46 56851 8192000000 10827144784 11295956992 1883130192 18.690 98 16 30 0 1896630304 9343984 4156128
21:39:52 33318 8192000000 10845534240 11316461568 1903089216 18.851 99 25 50 0 1918427376 8062464 7275696
21:40:36 63861 8192000000 10808161344 11272257536 1833396368 18.287 95 24 47 1 1850867632 10675456 6795808
21:41:46 80155 8192000000 10829458656 11313025024 1910394480 18.910 100 14 28 1 1928425328 13998000 4032848
21:43:28 73021 8192000000 10838156688 11310551040 1859518496 18.499 97 7 14 0 1874196768 12602608 2075664
21:44:51 48937 8192000000 10839485536 11303067648 1867204848 18.562 97 17 34 1 1883423888 11192816 5026224
21:45:55 38906 8192000000 10846759264 11289411584 1861297952 18.514 97 20 40 0 1878734480 11727968 5708560
21:46:41 61540 8192000000 10854754080 11321933824 1872311632 18.603 97 37 74 0 1898459328 15423728 10723968
21:47:49 48017 8192000000 10853535568 11321860096 1913026576 18.931 100 16 32 1 1934102288 16529248 4546464
21:48:50 56056 8192000000 10856813952 11317469184 1874623088 18.622 97 18 36 0 1895941616 15875840 5442688
21:50:00 53486 8192000000 10866767024 11307794432 1843787168 18.372 96 21 43 2 1858976672 9540576 5648928
21:51:02 38924 8192000000 10873217040 11322642432 1894225888 18.780 98 50 102 0 1920383344 11731488 14425968
21:51:50 59431 8192000000 10856357216 11327320064 1906334288 18.877 99 25 50 0 1926984944 13581168 7069488
21:53:00 57211 8192000000 10865533664 11337089024 1928781552 19.057 100 10 20 1 1947733456 16227744 2724160
21:54:06 53631 8192000000 10888871584 11324624896 1897655952 18.807 98 20 40 1 1916745376 12834864 6254560
21:55:06 8504 8192000000 10891283216 11335860224 1949491856 19.222 100 65 130 1 1976103632 7815280 18796496
21:55:21 8715 8192000000 10905807648 11349987328 1950644880 19.232 100 48 96 1 1975552080 11575728 13331472
21:55:38 32717 8192000000 10882289824 11357421568 1947075040 19.203 100 28 56 1 1973282128 18330752 7876336
21:56:17 94813 8192000000 10887568432 11343896576 1934835104 19.106 99 21 42 1 1953004464 12340912 5828448
21:58:05 51766 8192000000 10895244544 11355922432 1941710032 19.160 99 27 54 1 1960495344 11488864 7296448
21:59:03 14748 8192000000 10910890464 11368947712 1964444128 19.341 100 32 64 1 1990299840 16945664 8910048
21:59:24 18342 8192000000 10888944512 11370987520 1966201120 19.355 100 16 32 1 1990077136 19464832 4411184
21:59:54 25172 8192000000 10887476640 11365388288 1947595856 19.207 99 8 16 0 1974279184 24500576 2182752
22:00:40 67337 8192000000 10891497488 11377639424 1941655328 19.160 99 9 18 0 1962064704 18219072 2190304
22:01:54 22883 8192000000 10892617376 11381080064 1962093856 19.323 100 8 16 0 1983656848 19520592 2042400
22:02:23 8656 8192000000 10896885216 11379617792 1963249536 19.332 100 13 26 1 1986891088 19752976 3888576
22:02:45 69176 8192000000 10893435248 11374903296 1926104496 19.036 98 14 28 0 1940291968 10670384 3517088
22:04:05 67883 8192000000 10897027680 11378401280 1964746848 19.344 100 14 28 1 1980995744 12622336 3626560
22:05:45 45154 8192000000 10917966912 11384524800 1981586800 19.477 100 16 31 0 1993094064 7062752 4444512
22:06:39 35659 8192000000 10928689664 11384459264 1969519040 19.382 99 39 77 1 1989015920 8303744 11193136
22:07:20 59967 8192000000 10909427728 11383316480 1955890784 19.273 98 25 50 1 1976138464 14105072 6142608
22:08:31 33849 8192000000 10882752560 11341438976 1848166736 18.407 93 29 58 2 1865652576 9141968 8343872
22:09:12 43360 8192000000 10896887536 11360874496 1919841776 18.986 98 28 56 0 1938649520 11178608 7629136
22:10:05 75709 8192000000 10879425824 11353415680 1934807632 19.105 99 11 22 1 1950049856 12486384 2755840
22:11:33 83214 8192000000 10917725824 11383615488 1950063680 19.227 99 13 26 0 1965464112 11496448 3903984
22:13:04 67126 8192000000 10906956256 11374522368 1945312464 19.189 98 22 44 0 1966593280 14763152 6517664
22:14:21 119266 8192000000 10883980288 11355820032 1853088768 18.447 93 14 26 3 1867403024 10349776 3964480
22:16:28 121313 8192000000 10869266432 11334393856 1851670688 18.436 94 22 41 1 1863448960 6246144 5532128
22:18:38 75256 8192000000 10853154128 11328495616 1835254544 18.302 94 16 32 1 1854090496 14471184 4364768
22:20:00 6869 8192000000 10865217792 11337388032 1928851584 19.058 100 14 28 1 1951936784 19093392 3991808
22:20:13 6747 8192000000 10856399024 11337527296 1930364688 19.070 100 6 12 2 1951232144 19368704 1498752
22:20:27 11537 8192000000 10862114752 11343581184 1933182320 19.092 100 4 7 0 1952481984 18474080 825584
22:20:46 31489 8192000000 10869559840 11339976704 1922598336 19.008 99 7 14 0 1941714512 17356768 1759408
22:21:28 45994 8192000000 10866869872 11343970304 1942700944 19.168 100 7 14 0 1952174176 7481040 1992192
22:22:24 59091 8192000000 10887328336 11361226752 1963796976 19.336 100 14 28 1 1978637456 10191392 4649088
22:23:29 65880 8192000000 10876277408 11348893696 1943959600 19.178 99 16 32 0 1960318320 11400880 4957840
22:25:02 112441 8192000000 10895764976 11377754112 1951475888 19.238 99 13 26 0 1970078448 14906768 3695792

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 30-11-2020 22:28:33 to 30-11-2020 22:29:05.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 87 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 30-11-2020 22:29:06 to 30-11-2020 22:29: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          239422
MON$OLDEST_ACTIVE               239769
MON$OLDEST_SNAPSHOT             239769
MON$NEXT_TRANSACTION            239769
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                       2031200
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:162: 
:163: mscs-test-161.budzdorov.ru    Mon Nov 30 22:27:07 2020
:164:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:165: 
:166: 
:167: mscs-test-161.budzdorov.ru    Mon Nov 30 22:27:09 2020
:168:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:169: 
--- end of diff output ---

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

30.11.20 22:29: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-11-30 22:29:11 No severe PSQL-related problems occured
30.11.20 22:29:12. End of report.