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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-11 16:27:00
DTS_END                         2020-11-11 16:27:00.4860
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_FROM_CUSTOMER(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58812
TRN_ID                          250881
ATT_ID                          724
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: 9732.84 18705 1167941
customer order: creation 182.72 346 21926
customer order: refuse 15.45 350 1854
order to supplier: creation 49.25 1339 5910
order to supplier: removal 3.58 96293 430
invoice (draft): creation 47.72 3236 5726
invoice (draft): removal 54.98 805 6597
invoice accept: apply 44.35 16597 5322
invoice accept: cancel 49.58 848 5949
customer reserve: creation 4085.18 164 490222
customer reserve: removal 4882.98 55 585958
realization accept: apply 88.05 175 10566
realization accept: cancel 88.94 103 10673
payment from customer: creation 64.04 105 7685
payment from customer: removal 6.23 65 747
payment to supplier: creation 53.36 125 6403
payment to supplier: removal 3.90 96 468
service: total inventory turnovers 4.76 1319 571
service: total monetary turnovers 6.83 27 820
service: aggregate perf. data 0.92 17618 110
service: refresh index statistics 0.03 234438 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-11-2020 16:28:07 to 11-11-2020 16:28:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6688
TEST_TIME 2 6928
TEST_TIME 3 6130
TEST_TIME 4 5301
TEST_TIME 5 5253
TEST_TIME 6 5157
TEST_TIME 7 5032
TEST_TIME 8 5158
TEST_TIME 9 5862
TEST_TIME 10 5969
TEST_TIME 11 6132
TEST_TIME 12 6304
TEST_TIME 13 6646
TEST_TIME 14 6785
TEST_TIME 15 7378
TEST_TIME 16 7880
TEST_TIME 17 7929
TEST_TIME 18 8499
TEST_TIME 19 8487
TEST_TIME 20 8533
TEST_TIME 21 8886
TEST_TIME 22 8856
TEST_TIME 23 8881
TEST_TIME 24 9150
TEST_TIME 25 9787
TEST_TIME 26 10418
TEST_TIME 27 10738
TEST_TIME 28 10794
TEST_TIME 29 11063
TEST_TIME 30 11218
TEST_TIME 31 11247
TEST_TIME 32 11124
TEST_TIME 33 11041
TEST_TIME 34 10953
TEST_TIME 35 10921
TEST_TIME 36 10963
TEST_TIME 37 10851
TEST_TIME 38 10757
TEST_TIME 39 10759
TEST_TIME 40 10703
TEST_TIME 41 10602
TEST_TIME 42 10722
TEST_TIME 43 10560
TEST_TIME 44 10352
TEST_TIME 45 10297
TEST_TIME 46 10282
TEST_TIME 47 10108
TEST_TIME 48 10142
TEST_TIME 49 10117
TEST_TIME 50 10024
TEST_TIME 51 9907
TEST_TIME 52 10033
TEST_TIME 53 10208
TEST_TIME 54 10086
TEST_TIME 55 10056
TEST_TIME 56 9984
TEST_TIME 57 9918
TEST_TIME 58 9964
TEST_TIME 59 10028
TEST_TIME 60 9972
TEST_TIME 61 9887
TEST_TIME 62 9847
TEST_TIME 63 9815
TEST_TIME 64 9813
TEST_TIME 65 9849
TEST_TIME 66 9825
TEST_TIME 67 9848
TEST_TIME 68 9943
TEST_TIME 69 9895
TEST_TIME 70 9924
TEST_TIME 71 9956
TEST_TIME 72 9958
TEST_TIME 73 9972
TEST_TIME 74 9956
TEST_TIME 75 10002
TEST_TIME 76 9999
TEST_TIME 77 10012
TEST_TIME 78 10012
TEST_TIME 79 9915
TEST_TIME 80 9854
TEST_TIME 81 9822
TEST_TIME 82 9874
TEST_TIME 83 9827
TEST_TIME 84 9791
TEST_TIME 85 9739
TEST_TIME 86 9732
TEST_TIME 87 9667
TEST_TIME 88 9681
TEST_TIME 89 9696
TEST_TIME 90 9705
TEST_TIME 91 9700
TEST_TIME 92 9741
TEST_TIME 93 9758
TEST_TIME 94 9761
TEST_TIME 95 9885
TEST_TIME 96 9918
TEST_TIME 97 9901
TEST_TIME 98 9958
TEST_TIME 99 9954
TEST_TIME 100 9973
TEST_TIME 101 9978
TEST_TIME 102 9934
TEST_TIME 103 9903
TEST_TIME 104 9871
TEST_TIME 105 9842
TEST_TIME 106 9864
TEST_TIME 107 9859
TEST_TIME 108 9823
TEST_TIME 109 9767
TEST_TIME 110 9745
TEST_TIME 111 9759
TEST_TIME 112 9754
TEST_TIME 113 9779
TEST_TIME 114 9808
TEST_TIME 115 9786
TEST_TIME 116 9792
TEST_TIME 117 9808
TEST_TIME 118 9804
TEST_TIME 119 9819
TEST_TIME 120 9737

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-11-2020 16:28:10 to 11-11-2020 16:28:13.

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 1621053 1621053 0 0.00 0 21276 6 0 0
doc_list_biud 1621053 1621053 0 0.00 0 54773 26 0 0
sp_add_invoice_to_stock 5435 5322 113 2.07 47 198837 16598 0 113
sp_cancel_adding_invoice 5949 5949 0 0.00 4 64335 849 0 0
sp_cancel_client_order 1854 1854 0 0.00 4 11965 351 0 0
sp_cancel_customer_reserve 585958 585958 0 0.00 1 54778 55 0 0
sp_cancel_pay_from_customer 747 747 0 0.00 3 2006 66 0 0
sp_cancel_pay_to_supplier 468 468 0 0.00 3 4519 96 0 0
sp_cancel_supplier_invoice 6602 6597 5 0.07 1 32842 805 0 5
sp_cancel_supplier_order 430 430 0 0.00 7 1192539 96294 0 0
sp_cancel_write_off 10673 10673 0 0.00 1 10908 103 0 0
sp_client_order 21926 21926 0 0.00 4 36792 347 0 0
sp_customer_reserve 490222 490222 0 0.00 0 106246 164 0 0
sp_fill_shopping_cart 33559 33559 0 0.00 1 15445 38 0 0
sp_fill_shopping_cart_clo_res 490215 490215 0 0.00 0 18516 12 0 0
sp_get_clo_for_invoice 5315 5315 0 0.00 0 16648 242 0 0
sp_kill_cost_storno 17837 17837 0 0.00 0 7301 58 0 0
sp_kill_qstorno_ret_qs2qd 1189616 1189616 0 0.00 0 45738 30 0 0
sp_kill_qty_storno 627341 627341 0 0.00 0 54772 66 0 0
sp_lock_selected_doc 22065 22065 0 0.00 0 9287 7 0 0
sp_make_cost_storno 29968 29968 0 0.00 0 21147 55 0 0
sp_multiply_rows_for_pdistr 29968 29968 0 0.00 0 7351 29 0 0
sp_multiply_rows_for_qdistr 21926 21926 0 0.00 0 11656 137 0 0
sp_pay_from_customer 7685 7685 0 0.00 4 13412 106 0 0
sp_pay_to_supplier 6403 6403 0 0.00 5 17520 125 0 0
sp_payment_common 14088 14088 0 0.00 1 13406 29 0 0
sp_qd_handle_on_cancel_clo 1854 1854 0 0.00 0 11956 320 0 0
sp_qd_handle_on_invoice_upd_sts 11263 11263 0 0.00 0 20078 344 0 0
sp_qd_handle_on_reserve_upd_sts 10566 10566 0 0.00 0 8904 52 0 0
sp_reserve_write_off 10566 10566 0 0.00 6 12005 175 0 0
sp_supplier_invoice 5726 5726 0 0.00 7 80070 3237 0 0
sp_supplier_order 5910 5910 0 0.00 5 38425 1339 0 0
srv_aggregate_perf_data 111 110 1 0.90 2767 175255 17618 0 1
srv_fill_mon_cache_memory 166 166 0 0.00 992 133327 31802 0 0
srv_find_qd_qs_mism 1116548 1116548 0 0.00 0 16127 5 0 0
srv_make_invnt_saldo 571 571 0 0.00 24 99041 1320 0 0
srv_make_money_saldo 820 820 0 0.00 1 1459 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 165744 311039 234438 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5322 5322 0 0.00 0 13667 168 0 0
t$perf-norm:sp_cancel_adding_invoice 464 464 0 0.00 0 3131 92 0 0
t$perf-norm:sp_cancel_client_order 1854 1854 0 0.00 0 2186 11 0 0
t$perf-norm:sp_cancel_customer_reserve 744 744 0 0.00 0 4197 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 747 747 0 0.00 0 1218 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 468 468 0 0.00 0 2501 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 444 444 0 0.00 0 1900 26 0 0
t$perf-norm:sp_cancel_supplier_order 430 430 0 0.00 0 25309 1575 0 0
t$perf-norm:sp_cancel_write_off 1034 1034 0 0.00 0 3685 10 0 0
t$perf-norm:sp_client_order 21926 21926 0 0.00 0 8112 16 0 0
t$perf-norm:sp_customer_reserve 1020 1020 0 0.00 0 3313 10 0 0
t$perf-norm:sp_pay_from_customer 7685 7685 0 0.00 0 8069 13 0 0
t$perf-norm:sp_pay_to_supplier 6403 6403 0 0.00 0 11783 10 0 0
t$perf-norm:sp_reserve_write_off 10566 10566 0 0.00 0 12217 11 0 0
t$perf-norm:sp_supplier_invoice 5726 5726 0 0.00 0 5988 18 0 0
t$perf-norm:sp_supplier_order 5910 5910 0 0.00 0 5785 15 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 412 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 241 7 0 0
t$perf-norm:srv_make_invnt_saldo 571 571 0 0.00 0 942 24 0 0
t$perf-norm:srv_make_money_saldo 820 820 0 0.00 0 947 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10852 10626 226 2.08 0 7737 18 0 226
v_all_customers 40240 40240 0 0.00 0 14 1 0 0
v_all_suppliers 32684 32684 0 0.00 0 22 1 0 0
v_all_wares 43852 43852 0 0.00 0 69 1 0 0
v_cancel_adding_invoice 928 928 0 0.00 0 208 5 0 0
v_cancel_client_order 3708 3708 0 0.00 0 1988 6 0 0
v_cancel_customer_prepayment 1494 1494 0 0.00 0 1989 5 0 0
v_cancel_customer_reserve 1488 1488 0 0.00 0 444 4 0 0
v_cancel_payment_to_supplier 936 936 0 0.00 0 4514 14 0 0
v_cancel_supplier_invoice 898 888 10 1.11 0 959 14 0 10
v_cancel_supplier_order 860 860 0 0.00 0 1809 9 0 0
v_cancel_write_off 2068 2068 0 0.00 0 1629 12 0 0
v_max_id_clo_ord 5909 5909 0 0.00 0 1566 2 0 0
v_max_id_clo_res 1020 1020 0 0.00 0 2137 15 0 0
v_max_id_ord_sup 5724 5724 0 0.00 0 10894 5 0 0
v_max_non_paid_invoice 1694 1694 0 0.00 0 2641 5 0 0
v_max_non_paid_realizn 4126 4126 0 0.00 0 811 3 0 0
v_min_id_clo_ord 5909 5909 0 0.00 0 6882 11 0 0
v_min_id_clo_res 1020 1020 0 0.00 0 6526 19 0 0
v_min_id_ord_sup 5724 5724 0 0.00 0 9472 5 0 0
v_min_non_paid_invoice 6403 6403 0 0.00 0 6713 20 0 0
v_min_non_paid_realizn 7685 7685 0 0.00 0 13401 18 0 0
v_our_firm 10730 10730 0 0.00 0 28 1 0 0
v_reserve_write_off 21132 21132 0 0.00 0 3289 5 0 0
x_lock_depdocs_on_canc_invoice 12102 12102 0 0.00 0 25718 123 0 0
x_lock_depdocs_on_canc_sup_ord 430 430 0 0.00 0 14446 365 0 0
x_make_qstorno_1000_1200 5910 5910 0 0.00 2 38382 1247 0 0
x_make_qstorno_1200_2000 5726 5726 0 0.00 4 80002 3112 0 0
x_make_qstorno_2100_3300 490221 490221 0 0.00 0 106243 150 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 11-11-2020 16:28:14 to 11-11-2020 16:28:19.

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
13:57:04 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:11 25707 8192000000 10286125040 10603352064 1033490160 11.202 77 63 125 1 1057278880 3096416 20692304
13:57:44 35156 8192000000 10363068208 10688221184 1415050640 14.729 100 86 172 0 1448714480 5664048 27999792
13:58:30 23922 8192000000 10402192848 10728321024 1458665392 15.114 100 92 184 0 1496137008 7600704 29870912
13:59:09 24193 8192000000 10417772928 10748866560 1477131584 15.276 100 89 178 0 1514955360 8829728 28994048
13:59:42 24747 8192000000 10427245712 10763059200 1488183632 15.373 100 84 168 0 1524178672 9086048 26908992
14:00:13 21646 8192000000 10452186800 10790617088 1505335344 15.523 100 84 168 0 1541482368 9147488 26999536
14:00:51 18498 8192000000 10486515456 10827440128 1535399936 15.784 100 84 168 1 1571623536 9956800 26266800
14:01:21 11904 8192000000 10488917520 10839867392 1553825216 15.943 100 85 170 1 1591280384 10645008 26810160
14:01:41 17122 8192000000 10525874528 10878414848 1569372432 16.077 100 78 156 1 1603735744 10266800 24096512
14:02:14 13874 8192000000 10553721104 10909491200 1612272384 16.444 100 76 152 0 1645137344 10258336 22606624
14:02:37 12797 8192000000 10569135856 10927730688 1631335728 16.606 100 78 154 2 1664765808 10533216 22896864
14:03:00 7764 8192000000 10588527568 10949799936 1650051856 16.765 100 75 151 1 1683511040 11759440 21699744
14:03:15 8032 8192000000 10616047136 10979885056 1671044672 16.942 100 79 157 0 1705250400 11801824 22403904
14:03:35 7206 8192000000 10629237712 10996498432 1688309824 17.087 100 75 148 2 1722236768 12333280 21593664
14:03:50 7938 8192000000 10636053264 11011571712 1702291760 17.204 100 71 143 2 1734960080 12073248 20595072
14:04:06 9912 8192000000 10651076272 11034316800 1725246464 17.396 100 67 134 2 1756190480 11564384 19379632
14:04:24 9324 8192000000 10681865840 11063873536 1746182336 17.570 100 72 144 1 1777448880 10976800 20289744
14:04:40 6516 8192000000 10697075248 11078201344 1765123536 17.727 100 80 159 3 1800197888 12384720 22689632
14:04:54 5360 8192000000 10719776448 11097178112 1777460080 17.829 100 79 158 0 1812444672 12489264 22495328
14:05:06 4703 8192000000 10714760848 11100565504 1781884160 17.865 100 66 133 1 1812588224 12344080 18359984
14:05:17 4556 8192000000 10736744688 11117088768 1794431280 17.968 100 87 172 2 1831810768 13362560 24016928
14:05:29 6529 8192000000 10734117600 11116212224 1797735760 17.995 100 80 158 1 1833048720 13681424 21631536
14:05:42 5842 8192000000 10740257008 11125723136 1803170720 18.040 100 72 144 1 1836829152 13632032 20026400
14:05:55 2864 8192000000 10757543280 11139592192 1821230736 18.188 100 84 167 2 1857650592 13427712 22992144
14:06:04 3649 8192000000 10767918304 11152478208 1824819808 18.217 100 85 170 2 1863041952 14863072 23359072
14:06:15 3880 8192000000 10777417616 11163967488 1831308448 18.270 100 86 171 1 1868610480 13887776 23414256
14:06:26 1553 8192000000 10783387248 11166855168 1839892384 18.340 100 90 180 0 1878298512 13904736 24501392
14:06:34 2130 8192000000 10782553232 11173965824 1845694672 18.387 100 86 171 0 1882809264 13782784 23331808
14:06:42 2824 8192000000 10795184992 11182481408 1850697440 18.428 100 94 186 2 1890469040 13795392 25976208
14:06:51 1554 8192000000 10798361088 11189661696 1855042688 18.463 100 90 180 5 1895902992 14848752 26011552
14:06:59 2680 8192000000 10803988432 11193008128 1861081120 18.512 100 90 181 2 1900152368 12929632 26141616
14:07:09 1574 8192000000 10803477056 11190722560 1862465584 18.523 100 94 189 0 1901896112 13162224 26268304
14:07:16 1454 8192000000 10816614912 11204911104 1871302432 18.595 100 91 180 0 1910243472 14198928 24742112
14:07:24 1702 8192000000 10814799472 11201351680 1872046256 18.601 100 96 193 4 1912369808 12991360 27332192
14:07:32 1572 8192000000 10812235728 11203190784 1872395328 18.604 100 92 186 0 1911710128 12990672 26324128
14:07:41 1685 8192000000 10823287280 11215142912 1875054864 18.625 100 92 184 1 1919844368 18485552 26303952
14:07:48 17205 8192000000 10812625888 11211894784 1871306352 18.595 100 65 130 0 1901902896 12722880 17873664
14:08:12 1472 8192000000 10816795328 11216121856 1878051680 18.649 100 86 172 2 1915185216 13014320 24119216
14:08:20 4831 8192000000 10805804992 11215872000 1882239008 18.683 100 70 140 1 1913579696 11822976 19517712
14:08:32 2172 8192000000 10812633328 11218173952 1882499216 18.685 100 72 144 1 1914793568 12328992 19965360
14:08:41 2709 8192000000 10814865552 11221327872 1881783904 18.680 100 61 122 2 1909643632 11421200 16438528
14:08:50 5119 8192000000 10807038704 11219361792 1887031104 18.722 100 54 107 3 1913359280 11748912 14579264
14:09:02 9110 8192000000 10787912512 11215953920 1882794720 18.688 100 27 54 0 1902708832 11934256 7979856
14:09:23 7809 8192000000 10806645728 11225812992 1894406416 18.781 100 36 71 3 1910448160 5817888 10223856
14:09:38 3064 8192000000 10806542480 11232079872 1891356064 18.757 100 40 80 0 1910922256 8706784 10859408
14:09:47 58498 8192000000 10822593600 11243020288 1897325456 18.805 100 47 94 1 1917751248 5596032 14829760
14:10:52 5551 8192000000 10809848640 11242074112 1894806208 18.784 100 27 53 0 1908316608 6739664 6770736
14:11:04 6221 8192000000 10802310880 11244359680 1898185168 18.812 100 25 50 3 1912783792 7298736 7299888
14:11:22 4108 8192000000 10820974704 11248074752 1898602640 18.815 100 29 58 1 1916645328 9862144 8180544
14:11:36 2366 8192000000 10833983936 11252629504 1903776864 18.857 100 47 92 2 1922578384 5230992 13570528
14:11:45 5747 8192000000 10816417824 11247685632 1899225568 18.820 100 20 40 1 1911111872 6203568 5682736
14:11:58 6412 8192000000 10816824352 11246776320 1899545568 18.823 100 22 44 1 1911532544 6060544 5926432
14:12:11 5630 8192000000 10826419072 11251347456 1900037248 18.827 100 29 58 1 1914187728 5765392 8385088
14:12:23 4817 8192000000 10805999936 11247050752 1900488064 18.830 100 22 43 0 1913097680 6415184 6194432
14:12:37 6583 8192000000 10812362368 11247411200 1901836464 18.841 100 27 53 1 1917137040 7015824 8284752
14:12:49 8774 8192000000 10824425920 11256840192 1905435392 18.870 100 27 54 0 1920316800 6948784 7932624
14:13:04 6638 8192000000 10832049296 11254149120 1906698912 18.880 100 21 42 0 1918276464 5495344 6082208
14:13:17 5367 8192000000 10830168976 11259301888 1909686144 18.904 100 33 66 1 1925111024 6392656 9032224
14:13:29 7902 8192000000 10830704448 11261112320 1910809888 18.913 100 24 48 0 1923027904 5108208 7109808
14:13:45 11516 8192000000 10826637648 11264843776 1911899344 18.922 100 16 32 2 1921968544 6065376 4003824
14:14:03 10547 8192000000 10831159632 11262562304 1916803216 18.961 100 27 54 1 1930217120 5216352 8197552
14:14:21 63116 8192000000 10835571936 11270631424 1919572272 18.983 100 41 79 1 1937793424 6617472 11603680
14:15:31 7741 8192000000 10834513872 11270254592 1917948896 18.970 100 20 39 1 1930418144 6078032 6391216
14:15:46 8983 8192000000 10825143664 11271340032 1920450016 18.990 100 29 58 1 1935759968 6743328 8566624
14:16:01 8930 8192000000 10806727216 11245498368 1880887568 18.672 98 20 40 1 1892242176 5702320 5652288
14:16:16 7064 8192000000 10815757680 11257176064 1894977600 18.786 99 23 46 0 1906590912 5107616 6505696
14:16:30 8921 8192000000 10804754208 11240267776 1879818960 18.664 99 18 36 0 1890428496 5234736 5374800
14:16:49 8322 8192000000 10794907616 11233677312 1875517184 18.629 99 17 33 0 1885749008 5709296 4522528
14:17:05 12511 8192000000 10768785584 11204808704 1823079248 18.203 97 18 37 1 1834541616 6476160 4986208
14:17:27 6657 8192000000 10736890880 11161243648 1782428800 17.869 96 21 42 1 1793438176 5325136 5684240
14:17:43 7500 8192000000 10750171088 11175018496 1826335616 18.229 99 23 46 1 1839809456 6555360 6918480
14:17:57 6573 8192000000 10742891440 11165274112 1822629424 18.199 99 21 42 3 1833861232 5409104 5822704
14:18:14 10349 8192000000 10732965280 11150381056 1774488688 17.804 97 31 62 2 1789669984 5649696 9531600
14:18:31 10363 8192000000 10716073168 11144519680 1751503856 17.614 96 19 38 1 1762514416 5600384 5410176
14:18:48 10235 8192000000 10708433680 11120996352 1720989808 17.360 94 20 40 3 1732006992 5030816 5986368
14:19:06 19091 8192000000 10666915328 11084951552 1697129904 17.161 94 28 56 2 1711028656 5775408 8123344
14:20:05 15486 8192000000 10671124688 11092992000 1681593056 17.031 94 18 35 1 1691925856 5376032 4956768
14:20:30 8101 8192000000 10684592160 11094249472 1725031312 17.394 97 32 65 2 1743812368 9774384 9006672
14:20:44 8530 8192000000 10693332080 11104346112 1764812416 17.724 99 32 64 1 1780291088 6315312 9163360
14:21:00 5886 8192000000 10707000976 11119001600 1788230336 17.917 100 38 77 0 1805575568 5806880 11538352
14:21:15 6012 8192000000 10707987552 11112845312 1754925056 17.642 98 23 46 0 1767363472 5493552 6944864
14:21:27 7505 8192000000 10728550000 11140927488 1804367872 18.050 100 29 59 3 1819626640 7075200 8183568
14:21:42 8985 8192000000 10749444816 11166384128 1829878432 18.258 100 34 66 2 1846510832 5132240 11500160
14:22:01 8217 8192000000 10735013264 11145105408 1780057888 17.850 97 22 44 2 1791895616 5169920 6667808
14:22:18 11211 8192000000 10758075728 11180388352 1840570352 18.345 100 41 82 1 1858784480 5194336 13019792
14:22:38 9663 8192000000 10759733888 11187179520 1845776416 18.388 100 23 47 1 1858147488 5131424 7239648
14:22:54 11512 8192000000 10774152576 11191463936 1833084832 18.284 99 26 52 1 1846328784 5443616 7800336
14:23:18 12533 8192000000 10777420592 11202637824 1855718016 18.469 100 20 40 1 1866777504 5235616 5823872
14:23:37 16818 8192000000 10784510432 11206369280 1859965856 18.503 100 16 32 0 1870117600 5469536 4682208
14:24:06 72408 8192000000 10767328672 11207204864 1868560736 18.573 100 29 58 0 1881823568 5260336 8002496
14:25:24 11875 8192000000 10782876752 11214094336 1869992672 18.584 100 22 44 0 1881151792 5619136 5539984
14:25:45 8809 8192000000 10793736096 11221667840 1875696048 18.630 100 33 66 3 1892041232 7213904 9131280
14:26:00 6734 8192000000 10796837440 11224023040 1885254512 18.708 100 34 67 3 1899531232 5000144 9276576
14:26:17 4987 8192000000 10797709760 11227369472 1880366896 18.668 100 27 54 1 1894020688 5558448 8095344
14:26:28 6454 8192000000 10793668208 11224199168 1879987536 18.665 100 24 48 2 1893370256 6270400 7112320
14:26:44 7614 8192000000 10791636240 11225858048 1881731264 18.679 100 25 50 4 1894472336 5793376 6947696
14:26:58 7286 8192000000 10818559920 11235991552 1891868976 18.761 100 36 72 2 1906922016 5312304 9740736
14:27:14 7678 8192000000 10846767520 11257069568 1910238368 18.909 100 59 118 1 1933338544 6579216 16520960
14:27:29 47858 8192000000 10861013072 11277778944 1916679936 18.960 100 56 110 1 1943705424 11315744 15709744
14:28:26 25331 8192000000 10855583376 11277189120 1927318928 19.045 100 56 112 3 1954965792 12016704 15630160
14:29:00 6617 8192000000 10865970672 11287101440 1931598640 19.080 100 44 88 0 1957192848 13494336 12099872
14:29:13 23647 8192000000 10882773552 11306536960 1936886752 19.122 100 39 79 3 1960505728 12770800 10848176
14:29:47 5939 8192000000 10895654848 11317739520 1950859040 19.233 100 47 93 1 1979254176 14750992 13644144
14:30:02 49773 8192000000 10889337744 11329540096 1960771392 19.312 100 48 95 0 1994772608 19510528 14490688
14:31:15 41085 8192000000 10885888704 11321581568 1944974496 19.186 99 36 72 2 1977249856 21678112 10597248
14:32:04 15836 8192000000 10900531664 11344617472 1967090080 19.362 100 36 71 0 2003255872 25643072 10522720
14:32:27 9393 8192000000 10913202736 11345031168 1972680960 19.407 100 52 103 2 2004890080 17085264 15123856
14:32:44 10703 8192000000 10910995392 11347054592 1976569136 19.438 100 49 98 0 2009710832 18493936 14647760
14:33:03 15233 8192000000 10910228000 11345539072 1957804272 19.289 99 38 76 2 1988536800 19975232 10757296
14:33:37 13438 8192000000 10926211456 11359395840 1980425456 19.468 100 51 102 0 2018135264 22403600 15306208
14:34:05 21607 8192000000 10927821744 11368472576 1982112816 19.481 100 33 66 1 2015855616 23935248 9807552
14:34:33 21919 8192000000 10932318368 11370119168 1986490672 19.516 100 47 94 2 2026832544 25572656 14769216
14:35:06 10002 8192000000 10939340192 11382575104 1995050240 19.584 100 46 91 1 2035800256 27117040 13632976
14:35:25 8682 8192000000 10953114144 11389878272 1998969616 19.615 100 52 102 3 2041192800 27085424 15137760
14:35:41 5149 8192000000 10963343968 11398311936 2007448352 19.681 100 55 108 3 2052993040 28977104 16567584
14:36:03 6285 8192000000 10976995296 11405402112 2016073120 19.749 100 70 140 2 2065799152 29407776 20318256
14:36:17 3928 8192000000 10968822592 11402072064 2013857440 19.732 100 64 127 0 2061846816 28926448 19062928
14:36:28 6546 8192000000 10966730576 11399323648 2009353664 19.696 100 66 132 2 2057325616 28392192 19579760
14:36:45 3554 8192000000 10978987120 11404316672 2013994192 19.733 100 68 136 2 2062695648 28968816 19732640
14:36:54 2495 8192000000 10964609104 11388682240 1997707008 19.605 100 75 149 1 2049513872 29974080 21832784
14:37:06 5331 8192000000 10971306432 11392229376 2001986176 19.638 100 58 115 0 2049583424 30738640 16858608
14:37:20 2141 8192000000 10970014416 11397373952 2010498144 19.705 100 72 143 4 2062364208 30261824 21604240
14:37:31 2912 8192000000 10971401280 11399344128 2011293232 19.712 100 66 132 2 2061107744 30614880 19199632
14:37:41 11921 8192000000 10971085776 11399442432 2008190336 19.687 100 61 120 1 2056416064 30520880 17704848
14:38:01 5029 8192000000 10949706160 11373920256 1951556416 19.239 97 73 143 1 2004110800 31269152 21285232
14:38:13 4307 8192000000 10954502208 11375636480 1975980192 19.433 99 72 144 1 2030486048 32784832 21721024
14:38:32 3762 8192000000 10955977680 11375120384 1987525488 19.524 100 72 144 0 2042936336 33479184 21931664
14:38:43 16765 8192000000 10951057424 11380989952 1991832832 19.558 100 77 153 1 2049739600 34969968 22936800
14:39:09 13237 8192000000 10950521568 11384524800 1989801232 19.542 100 53 106 2 2042081888 35974960 16305696
14:39:32 6991 8192000000 10942092752 11375280128 1978297216 19.451 100 48 93 3 2028745456 35414176 15034064
14:39:47 1943 8192000000 10966074784 11382878208 1988208080 19.530 100 85 170 2 2052617232 38375168 26033984
14:39:56 4125 8192000000 10972929904 11394015232 1993537376 19.572 100 75 150 1 2053684928 37888896 22258656
14:40:09 3847 8192000000 10982269040 11399917568 2000505824 19.627 100 74 147 2 2057710032 35541744 21662464
14:40:20 3987 8192000000 10967065376 11393593344 1988340496 19.531 99 69 138 0 2047219920 38080432 20798992
14:40:37 2271 8192000000 10973006832 11394756608 1993276080 19.570 100 69 139 1 2055761392 40551248 21934064
14:40:47 8426 8192000000 10962372192 11380506624 1971578192 19.398 99 76 153 1 2035628800 40202080 23848528
14:41:03 2481 8192000000 10956210448 11372445696 1970355760 19.388 99 74 148 0 2034493600 40195088 23942752
14:41:14 9912 8192000000 10977107680 11393560576 1989841856 19.543 100 76 151 0 2058257392 44144864 24270672
14:41:32 3161 8192000000 10982238160 11395760128 1991672512 19.557 100 77 153 1 2060390496 45317504 23400480
14:41:42 4217 8192000000 10967439712 11385995264 1984353824 19.499 100 72 144 0 2053848400 46781376 22713200
14:41:52 2141 8192000000 10965568384 11382894592 1975751840 19.431 100 80 154 2 2046851312 46830944 24268528
14:42:02 3841 8192000000 10981629104 11397005312 1984793680 19.503 100 82 163 1 2058426976 47481760 26151536
14:42:13 1441 8192000000 10970195744 11381673984 1982850176 19.487 100 85 169 0 2051084592 41481376 26753040
14:42:21 2834 8192000000 10954186144 11359240192 1946224128 19.196 99 88 172 0 2015530464 42707360 26598976
14:42:33 3269 8192000000 10957138736 11375063040 1969593408 19.382 100 77 153 1 2038087936 44969376 23525152
14:42:45 4124 8192000000 10948269520 11367849984 1944428976 19.182 98 81 161 1 2014207008 44649792 25128240
14:42:56 3717 8192000000 10940449680 11351150592 1949350288 19.221 100 72 143 1 2016581360 45166864 22064208
14:43:08 5358 8192000000 10956903936 11366240256 1971326896 19.396 100 80 160 0 2036111760 39424784 25360080
14:43:21 2551 8192000000 10929096880 11332698112 1927823056 19.049 99 80 158 3 1993866912 41161696 24882160
14:43:31 4361 8192000000 10913393808 11327078400 1917291520 18.965 99 68 136 0 1981101888 42619984 21190384
14:43:42 2164 8192000000 10922020032 11326857216 1924042736 19.019 99 88 175 1 1993021392 41227648 27751008
14:43:50 5684 8192000000 10913946752 11329044480 1932383616 19.086 100 76 152 3 1999117520 43012976 23720928
14:44:05 4221 8192000000 10896535472 11305123840 1911624928 18.920 99 80 158 3 1979321344 43235264 24461152
14:44:16 4087 8192000000 10913679216 11314454528 1905392784 18.870 99 86 167 3 1975511088 44148304 25970000
14:44:28 5431 8192000000 10880595760 11288698880 1856790272 18.477 97 71 142 3 1923935184 43947296 23197616
14:44:44 10663 8192000000 10894043968 11308912640 1908558384 18.895 100 71 140 1 1976150336 44464640 23127312
14:45:06 1530 8192000000 10914154800 11313303552 1920948704 18.994 100 88 176 2 1993372400 44792000 27631696
14:45:18 3617 8192000000 10910598144 11310010368 1922233232 19.005 100 77 153 1 1989922672 44890160 22799280
14:45:28 3060 8192000000 10901816112 11309785088 1922359824 19.006 100 81 163 1 1986152336 39402624 24389888
14:45:41 4337 8192000000 10904920400 11322503168 1927031568 19.043 100 60 120 0 1988367648 42356096 18979984
14:45:58 3662 8192000000 10905430656 11317407744 1925331824 19.030 100 70 140 3 1988019408 40859872 21827712
14:46:10 12384 8192000000 10912386864 11331518464 1932895872 19.090 100 70 141 0 1997126064 42197856 22032336
14:46:35 3325 8192000000 10903226784 11322015744 1918194848 18.972 99 61 123 0 1983935328 45514592 20225888
14:46:50 3007 8192000000 10924715856 11329613824 1928757936 19.057 100 82 162 0 1998816688 45168256 24890496
14:47:01 989 8192000000 10910057152 11313168384 1918093312 18.972 99 95 190 2 1992636672 44850480 29692880
14:47:12 3677 8192000000 10920057696 11327549440 1935701904 19.112 100 86 170 2 2010231264 47295664 27233696
14:47:22 5076 8192000000 10932764208 11343593472 1941055440 19.155 100 78 152 2 2012012704 47354976 23602288
14:47:39 6248 8192000000 10927321152 11344683008 1942924912 19.170 100 65 131 1 2010138320 46459616 20753792
14:47:54 2140 8192000000 10926353744 11348500480 1945858512 19.193 100 68 133 0 2012546000 46664992 20022496
14:48:06 11620 8192000000 10907609360 11342909440 1935606960 19.112 100 30 60 1 1992413488 46307088 10499440
14:48:34 4906 8192000000 10942168096 11348545536 1951810656 19.241 100 82 165 1 2020113280 43293840 25008784
14:48:47 3844 8192000000 10944586096 11362361344 1958674944 19.296 100 80 160 2 2029954768 46993168 24286656
14:48:58 12181 8192000000 10918852624 11364433920 1956172560 19.276 100 44 87 1 2015380560 45230368 13977632
14:49:33 13177 8192000000 10917499504 11356930048 1946889920 19.202 100 37 74 0 2007471856 47811264 12770672
14:49:55 22886 8192000000 10929637424 11365781504 1948382096 19.214 100 29 56 2 2007032976 48424304 10226576
14:50:32 8044 8192000000 10929002624 11367014400 1952892736 19.250 100 40 80 3 2016657104 49839984 13924384
14:50:47 11161 8192000000 10937704912 11375542272 1952873184 19.249 100 45 90 1 2020939872 52293600 15773088
14:51:06 18386 8192000000 10916548560 11361169408 1921216480 18.997 99 33 66 4 1986330768 53660880 11453408
14:51:32 11560 8192000000 10924358192 11355037696 1922422768 19.006 99 39 76 0 1990992112 55151696 13417648
14:51:51 23458 8192000000 10915414784 11356938240 1934371168 19.102 100 29 58 1 2005042816 60035824 10635824
14:52:31 28138 8192000000 10907612544 11351085056 1926410272 19.038 100 22 44 0 1985819280 51063296 8345712
14:53:17 16393 8192000000 10906640064 11364327424 1939351184 19.142 100 31 62 0 1996338064 46256320 10730560
14:53:41 39466 8192000000 10910850224 11369267200 1939470672 19.143 100 15 30 0 1986033904 41326992 5236240
14:54:28 30814 8192000000 10917073184 11367583744 1952495440 19.246 100 18 36 2 1997689728 39548560 5645728
14:55:22 48034 8192000000 10898650992 11359543296 1946466928 19.198 99 22 44 1 1985020992 32084592 6469472
14:56:51 59132 8192000000 10901208032 11368222720 1964405728 19.341 100 12 24 0 1991763200 23560496 3796976
14:57:57 61585 8192000000 10902511408 11362234368 1966007744 19.354 100 10 20 0 1989402192 20386448 3008000
14:59:05 75755 8192000000 10932394976 11378372608 1981518848 19.477 100 20 38 1 1995233504 7790416 5924240
15:00:31 20223 8192000000 10924796960 11380887552 1993616768 19.572 100 30 60 2 2010407904 8114720 8676416
15:01:22 112817 8192000000 10937773056 11403980800 1988755632 19.534 100 12 22 2 2009342752 16653760 3933360
15:03:26 125914 8192000000 10892039728 11348336640 1878166144 18.650 94 18 36 0 1891353232 9095664 4091424
15:05:38 109954 8192000000 10891637520 11355090944 1876143840 18.634 95 19 37 4 1893094624 11525312 5425472
15:07:35 25647 8192000000 10897430480 11353460736 1951784416 19.241 99 16 32 1 1964280736 7691280 4805040
15:08:07 27698 8192000000 10927460464 11351007232 1971512608 19.397 100 44 80 3 1987487424 5733456 10241360
15:08:44 42302 8192000000 10906115152 11370369024 1974379152 19.420 100 21 42 2 1990792768 9931328 6482288
15:09:33 82528 8192000000 10914740096 11374759936 1959716752 19.304 99 15 30 0 1977482944 13656048 4110144
15:11:38 29254 8192000000 10921358976 11379400704 1992256384 19.562 100 53 105 3 2015705760 6786784 16662592
15:12:16 21294 8192000000 10912289968 11360141312 1962702080 19.328 99 40 78 1 1980046256 5694720 11649456
15:12:48 47311 8192000000 10946455616 11383672832 1991776560 19.558 100 45 89 0 2014482528 9325696 13380272
15:13:44 64086 8192000000 10922775024 11383721984 1984280672 19.499 100 23 47 1 1999554464 8703888 6569904
15:14:59 5876 8192000000 10917489776 11377557504 1985356400 19.507 100 35 70 1 2006207632 10777120 10074112
15:15:12 1227 8192000000 10932577072 11387768832 1990528352 19.548 100 38 77 1 2012400736 10543968 11328416
15:15:20 14750 8192000000 10908384480 11377479680 1972660640 19.407 99 22 44 1 1987666528 8515968 6489920
15:15:41 12902 8192000000 10928006016 11385425920 1990651040 19.549 100 21 41 0 2005951328 9412432 5887856
15:16:01 12832 8192000000 10921369072 11374116864 1964447808 19.341 99 28 56 1 1984079744 11939232 7692704
15:16:30 26673 8192000000 10911149968 11374305280 1980822800 19.471 100 18 36 1 1997580512 11513296 5244416
15:17:08 29996 8192000000 10941038992 11390500864 1978526032 19.453 99 27 54 0 1999085536 11679120 8880384
15:17:45 16301 8192000000 10925847552 11370274816 1968857104 19.376 99 56 112 0 1998345664 13146400 16342160
15:18:13 30093 8192000000 10931857216 11378737152 1983754464 19.494 100 52 104 0 2016013616 16917824 15341328
15:19:02 19777 8192000000 10930661648 11379085312 1950360224 19.229 98 51 100 2 1984000224 19390976 14249024
15:19:32 43613 8192000000 10891495280 11380330496 1952047376 19.243 99 15 30 1 1977980928 21017536 4916016
15:20:23 21885 8192000000 10871245008 11361157120 1939116976 19.140 99 9 18 0 1958631632 16337264 3177392
15:20:51 73532 8192000000 10903178256 11364110336 1904631968 18.864 97 12 24 1 1915521216 7325120 3564128
15:22:12 133326 8192000000 10890073776 11359109120 1894361712 18.781 96 21 42 0 1909808464 9689792 5756960
15:24:33 119402 8192000000 10864123232 11353772032 1906617584 18.879 98 13 26 0 1924647824 13874496 4155744
15:26:39 67316 8192000000 10871851728 11343900672 1867155744 18.561 96 7 14 0 1884195472 15544400 1495328
15:27:53 63146 8192000000 10851722016 11321655296 1874519248 18.621 96 7 14 2 1889593536 13517296 1556992
15:29:12 83791 8192000000 10854009968 11326275584 1850389088 18.425 95 14 28 0 1864839152 10698880 3751184
15:30:46 38438 8192000000 10857819744 11338448896 1932969296 19.091 100 2 4 0 1947639696 14253424 416976
15:31:30 63816 8192000000 10847077840 11339091968 1882265792 18.683 97 6 12 0 1902653232 18533440 1854000
15:32:44 61671 8192000000 10855938960 11314954240 1847583008 18.402 96 14 28 1 1863303248 11899712 3820528
15:33:58 41280 8192000000 10869740528 11314655232 1876699536 18.638 97 35 69 2 1899617168 13305520 9612112
15:34:49 79386 8192000000 10846155552 11325988864 1891229760 18.756 98 19 38 1 1908917552 12751072 4936720
15:36:15 82820 8192000000 10852483728 11303264256 1816360944 18.148 94 15 30 0 1831312240 10609008 4342288
15:37:44 72253 8192000000 10847209248 11314135040 1871328768 18.595 97 18 36 1 1886852352 10660560 4863024
15:39:03 68947 8192000000 10873363584 11331186688 1861028240 18.512 96 13 26 0 1872242432 8047504 3166688
15:40:20 37997 8192000000 10859770928 11320737792 1894509008 18.782 98 26 51 2 1913417600 11486640 7421952
15:41:04 58092 8192000000 10869890304 11334328320 1934621424 19.104 100 18 36 0 1953658112 14081712 4954976
15:42:14 51411 8192000000 10878628144 11344089088 1927753184 19.049 99 18 36 0 1944032336 11797728 4481424
15:43:12 58300 8192000000 10891754256 11349094400 1935616016 19.112 99 35 70 0 1955341392 9819216 9906160
15:44:26 39448 8192000000 10892034000 11351851008 1942806400 19.169 99 38 76 1 1963157120 10157520 10193200
15:45:13 80950 8192000000 10873594928 11342098432 1943656704 19.176 99 21 42 1 1959499968 9438448 6404816
15:46:55 108559 8192000000 10881164000 11357429760 1929643824 19.064 98 15 30 0 1942897552 9234000 4019728
15:48:50 31272 8192000000 10908538912 11360165888 1966563360 19.358 100 25 50 0 1988701744 14898208 7240176
15:49:28 56197 8192000000 10890129120 11371552768 1952554352 19.247 99 11 22 1 1962742784 6520992 3667440
15:50:31 53998 8192000000 10898945056 11375939584 1977976784 19.449 100 10 20 0 1989107664 8381008 2749872
15:51:40 65662 8192000000 10887512752 11369332736 1924486544 19.023 97 18 36 1 1939828720 9810352 5531824
15:53:48 63894 8192000000 10876512176 11361587200 1944559696 19.183 99 9 18 0 1959867104 12872064 2435344
15:55:00 73779 8192000000 10890450720 11373699072 1962879344 19.329 100 16 34 2 1984301408 16819728 4602336
15:56:25 18248 8192000000 10882254096 11354124288 1948408160 19.214 99 24 48 0 1961394368 6301472 6684736
15:56:53 33338 8192000000 10903143264 11371896832 1955213072 19.268 99 18 36 0 1967374880 7608240 4553568
15:57:43 55251 8192000000 10908229536 11386662912 1987462400 19.524 100 25 50 1 2003893328 9641008 6789920
15:58:50 61625 8192000000 10887832304 11368706048 1892448160 18.766 95 17 33 2 1906512400 8774816 5289424
16:00:00 66256 8192000000 10907222512 11379998720 1905090992 18.867 96 16 32 0 1920403280 10844208 4468080
16:01:22 70690 8192000000 10924384256 11419660288 1984660048 19.502 100 15 30 0 2008470640 19512656 4297936
16:02:41 86061 8192000000 10899724448 11385044992 1891942496 18.761 95 16 32 0 1918542192 22616192 3983504
16:04:20 81721 8192000000 10919759104 11388542976 1915911376 18.954 97 24 48 1 1942380256 18850928 7617952
16:05:52 116277 8192000000 10886475248 11365195776 1850695920 18.428 94 3 6 0 1869351056 18095792 559344
16:08:33 37588 8192000000 10893249952 11335168000 1925735152 19.033 98 36 72 0 1945340432 8914080 10691200
16:09:24 87999 8192000000 10884473888 11363053568 1963542112 19.334 100 38 76 1 1983050944 9272080 10236752
16:11:12 48192 8192000000 10897085520 11357343744 1909874352 18.906 97 14 28 0 1926944400 13585600 3484448
16:12:13 67181 8192000000 10862653840 11341479936 1895082368 18.787 97 13 26 0 1917784816 18867952 3834496
16:13:48 39736 8192000000 10842733344 11315695616 1858834624 18.494 96 19 36 1 1872151296 8183776 5132896
16:14:40 74407 8192000000 10870886512 11340374016 1904385968 18.862 98 12 24 1 1918669632 10843728 3439936
16:16:54 95848 8192000000 10834142288 11316662272 1849389072 18.417 95 13 26 0 1874986976 21513136 4084768
16:18:36 80956 8192000000 10818156448 11274469376 1840431200 18.344 96 16 32 1 1868330816 22540000 5359616
16:21:37 85722 8192000000 10838786128 11309232128 1876437952 18.636 97 14 28 3 1893312672 13283264 3591456
16:23:15 30365 8192000000 10884702496 11334275072 1937316464 19.125 100 22 44 0 1950941696 7578016 6047216
16:23:52 25841 8192000000 10862238592 11323478016 1909684976 18.904 98 32 64 1 1927580624 8675008 9220640
16:24:29 34270 8192000000 10878170624 11344441344 1937776464 19.129 100 19 37 1 1952162480 8844000 5542016
16:25:26 65760 8192000000 10847074464 11315941376 1869355936 18.579 96 15 30 1 1888406000 15027360 4022704
16:26:38 35743 8192000000 9037532960 9244844032 204051296 2.430 11 3 6 0 209486032 4724400 710336

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 113 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-11-2020 16:28:53 to 11-11-2020 16:28:55.

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          251169
MON$OLDEST_ACTIVE               251170
MON$OLDEST_SNAPSHOT             251170
MON$NEXT_TRANSACTION            251170
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                       2067936
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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 ---
:262: 
:263: mscs-test-161.budzdorov.ru    Wed Nov 11 16:27:19 2020
:264:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:265: 
--- end of diff output ---

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

11.11.20 16:28:56. 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-11 16:28:58 No severe PSQL-related problems occured
11.11.20 16:28:59. End of report.