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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17492828 kB
MemAvailable 31520360 kB
Buffers 0 kB
Cached 14221092 kB
SwapCached 3696 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-19 19:27:06
DTS_END                         2020-12-19 19:27:06.2340
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/43144
TRN_ID                          247978
ATT_ID                          728
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: 9526.13 18654 1143136
customer order: creation 178.36 361 21403
customer order: refuse 14.86 266 1783
order to supplier: creation 47.08 1148 5649
order to supplier: removal 3.43 86393 412
invoice (draft): creation 46.38 2716 5566
invoice (draft): removal 53.01 666 6361
invoice accept: apply 42.72 16546 5126
invoice accept: cancel 48.37 606 5804
customer reserve: creation 3966.68 164 476001
customer reserve: removal 4823.78 49 578854
realization accept: apply 85.49 161 10259
realization accept: cancel 82.78 94 9934
payment from customer: creation 60.63 104 7276
payment from customer: removal 5.78 59 693
payment to supplier: creation 49.83 122 5980
payment to supplier: removal 3.80 95 456
service: total inventory turnovers 5.52 897 662
service: total monetary turnovers 6.71 26 805
service: aggregate perf. data 0.90 20332 108
service: refresh index statistics 0.03 242267 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-12-2020 19:28:55 to 19-12-2020 19:28:57.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10883
TEST_TIME 2 7707
TEST_TIME 3 7088
TEST_TIME 4 6708
TEST_TIME 5 6459
TEST_TIME 6 6874
TEST_TIME 7 6950
TEST_TIME 8 7127
TEST_TIME 9 7258
TEST_TIME 10 7419
TEST_TIME 11 7959
TEST_TIME 12 8731
TEST_TIME 13 8735
TEST_TIME 14 9395
TEST_TIME 15 9747
TEST_TIME 16 9621
TEST_TIME 17 9621
TEST_TIME 18 9944
TEST_TIME 19 9746
TEST_TIME 20 9642
TEST_TIME 21 10228
TEST_TIME 22 10553
TEST_TIME 23 11274
TEST_TIME 24 11820
TEST_TIME 25 11991
TEST_TIME 26 11623
TEST_TIME 27 11500
TEST_TIME 28 11212
TEST_TIME 29 11114
TEST_TIME 30 10830
TEST_TIME 31 10920
TEST_TIME 32 10797
TEST_TIME 33 10763
TEST_TIME 34 10586
TEST_TIME 35 10466
TEST_TIME 36 10433
TEST_TIME 37 10328
TEST_TIME 38 10190
TEST_TIME 39 10020
TEST_TIME 40 9885
TEST_TIME 41 9749
TEST_TIME 42 9847
TEST_TIME 43 9764
TEST_TIME 44 9803
TEST_TIME 45 9938
TEST_TIME 46 9873
TEST_TIME 47 9923
TEST_TIME 48 9952
TEST_TIME 49 10002
TEST_TIME 50 9976
TEST_TIME 51 10076
TEST_TIME 52 10029
TEST_TIME 53 10084
TEST_TIME 54 10071
TEST_TIME 55 9928
TEST_TIME 56 9886
TEST_TIME 57 9792
TEST_TIME 58 9779
TEST_TIME 59 9690
TEST_TIME 60 9584
TEST_TIME 61 9627
TEST_TIME 62 9658
TEST_TIME 63 9665
TEST_TIME 64 9690
TEST_TIME 65 9639
TEST_TIME 66 9708
TEST_TIME 67 9690
TEST_TIME 68 9679
TEST_TIME 69 9708
TEST_TIME 70 9758
TEST_TIME 71 9741
TEST_TIME 72 9746
TEST_TIME 73 9809
TEST_TIME 74 9782
TEST_TIME 75 9718
TEST_TIME 76 9678
TEST_TIME 77 9634
TEST_TIME 78 9601
TEST_TIME 79 9598
TEST_TIME 80 9669
TEST_TIME 81 9612
TEST_TIME 82 9581
TEST_TIME 83 9550
TEST_TIME 84 9517
TEST_TIME 85 9483
TEST_TIME 86 9522
TEST_TIME 87 9489
TEST_TIME 88 9531
TEST_TIME 89 9505
TEST_TIME 90 9569
TEST_TIME 91 9569
TEST_TIME 92 9561
TEST_TIME 93 9624
TEST_TIME 94 9599
TEST_TIME 95 9687
TEST_TIME 96 9672
TEST_TIME 97 9718
TEST_TIME 98 9773
TEST_TIME 99 9688
TEST_TIME 100 9640
TEST_TIME 101 9642
TEST_TIME 102 9596
TEST_TIME 103 9553
TEST_TIME 104 9497
TEST_TIME 105 9464
TEST_TIME 106 9410
TEST_TIME 107 9491
TEST_TIME 108 9472
TEST_TIME 109 9467
TEST_TIME 110 9477
TEST_TIME 111 9539
TEST_TIME 112 9594
TEST_TIME 113 9576
TEST_TIME 114 9609
TEST_TIME 115 9585
TEST_TIME 116 9654
TEST_TIME 117 9639
TEST_TIME 118 9661
TEST_TIME 119 9615
TEST_TIME 120 9537

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 19-12-2020 19:28:59 to 19-12-2020 19:29:02.

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 1584613 1584613 0 0.00 0 35470 6 0 0
doc_list_biud 1584613 1584613 0 0.00 0 76484 23 0 0
sp_add_invoice_to_stock 5277 5126 151 2.86 41 145177 16546 0 151
sp_cancel_adding_invoice 5804 5804 0 0.00 5 72068 607 0 0
sp_cancel_client_order 1783 1783 0 0.00 4 11176 266 0 0
sp_cancel_customer_reserve 578854 578854 0 0.00 1 76486 49 0 0
sp_cancel_pay_from_customer 693 693 0 0.00 3 2718 59 0 0
sp_cancel_pay_to_supplier 456 456 0 0.00 3 6299 95 0 0
sp_cancel_supplier_invoice 6381 6361 20 0.31 2 25669 667 0 20
sp_cancel_supplier_order 412 412 0 0.00 10 748313 86394 0 0
sp_cancel_write_off 9934 9934 0 0.00 1 13940 95 0 0
sp_client_order 21403 21403 0 0.00 4 19315 362 0 0
sp_customer_reserve 476001 476001 0 0.00 0 43278 164 0 0
sp_fill_shopping_cart 32613 32613 0 0.00 1 15464 34 0 0
sp_fill_shopping_cart_clo_res 475985 475985 0 0.00 0 18056 13 0 0
sp_get_clo_for_invoice 5110 5110 0 0.00 0 27422 313 0 0
sp_kill_cost_storno 16887 16887 0 0.00 0 6514 44 0 0
sp_kill_qstorno_ret_qs2qd 1174415 1174415 0 0.00 0 76475 27 0 0
sp_kill_qty_storno 618517 618517 0 0.00 0 76483 57 0 0
sp_lock_selected_doc 21229 21229 0 0.00 0 7578 6 0 0
sp_make_cost_storno 28625 28625 0 0.00 0 35464 53 0 0
sp_multiply_rows_for_pdistr 28625 28625 0 0.00 0 8071 26 0 0
sp_multiply_rows_for_qdistr 21403 21403 0 0.00 0 19281 170 0 0
sp_pay_from_customer 7276 7276 0 0.00 4 14805 104 0 0
sp_pay_to_supplier 5980 5980 0 0.00 4 35482 122 0 0
sp_payment_common 13256 13256 0 0.00 1 10757 24 0 0
sp_qd_handle_on_cancel_clo 1783 1783 0 0.00 0 11167 240 0 0
sp_qd_handle_on_invoice_upd_sts 10914 10914 0 0.00 0 17639 257 0 0
sp_qd_handle_on_reserve_upd_sts 10259 10259 0 0.00 0 17912 49 0 0
sp_reserve_write_off 10259 10259 0 0.00 6 19777 162 0 0
sp_supplier_invoice 5566 5566 0 0.00 6 90540 2717 0 0
sp_supplier_order 5649 5649 0 0.00 5 37852 1149 0 0
srv_aggregate_perf_data 108 108 0 0.00 2667 438273 20332 0 0
srv_fill_mon_cache_memory 146 146 0 0.00 939 150398 36944 0 0
srv_find_qd_qs_mism 1094373 1094373 0 0.00 0 14906 5 0 0
srv_make_invnt_saldo 662 662 0 0.00 27 47365 898 0 0
srv_make_money_saldo 805 805 0 0.00 0 4503 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 183319 292840 242268 0 0
t$perf-abend:sp_add_invoice_to_stock 151 151 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 20 20 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5126 5126 0 0.00 0 9446 140 0 0
t$perf-norm:sp_cancel_adding_invoice 412 412 0 0.00 0 4220 99 0 0
t$perf-norm:sp_cancel_client_order 1783 1783 0 0.00 0 5511 16 0 0
t$perf-norm:sp_cancel_customer_reserve 729 729 0 0.00 0 1363 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 693 693 0 0.00 0 442 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 456 456 0 0.00 0 499 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 433 433 0 0.00 0 488 9 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 31403 1359 0 0
t$perf-norm:sp_cancel_write_off 942 942 0 0.00 0 4594 8 0 0
t$perf-norm:sp_client_order 21403 21403 0 0.00 0 10137 14 0 0
t$perf-norm:sp_customer_reserve 1031 1031 0 0.00 0 5320 21 0 0
t$perf-norm:sp_pay_from_customer 7276 7276 0 0.00 0 4625 9 0 0
t$perf-norm:sp_pay_to_supplier 5980 5980 0 0.00 0 3880 8 0 0
t$perf-norm:sp_reserve_write_off 10259 10259 0 0.00 0 4689 11 0 0
t$perf-norm:sp_supplier_invoice 5566 5566 0 0.00 0 5501 11 0 0
t$perf-norm:sp_supplier_order 5649 5649 0 0.00 0 4505 15 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 404 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 146 146 0 0.00 0 8100 61 0 0
t$perf-norm:srv_make_invnt_saldo 662 662 0 0.00 0 1639 18 0 0
t$perf-norm:srv_make_money_saldo 805 805 0 0.00 0 1916 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10522 10220 302 2.87 0 4975 18 0 302
v_all_customers 38672 38672 0 0.00 0 25 0 0 0
v_all_suppliers 30770 30770 0 0.00 0 26 1 0 0
v_all_wares 42806 42806 0 0.00 0 228 1 0 0
v_cancel_adding_invoice 824 824 0 0.00 0 1673 9 0 0
v_cancel_client_order 3566 3566 0 0.00 0 5543 6 0 0
v_cancel_customer_prepayment 1386 1386 0 0.00 0 2709 8 0 0
v_cancel_customer_reserve 1458 1458 0 0.00 0 2829 8 0 0
v_cancel_payment_to_supplier 912 912 0 0.00 0 3972 9 0 0
v_cancel_supplier_invoice 906 866 40 4.41 0 5101 19 0 40
v_cancel_supplier_order 824 824 0 0.00 0 3163 7 0 0
v_cancel_write_off 1884 1884 0 0.00 0 2239 14 0 0
v_max_id_clo_ord 5649 5649 0 0.00 0 494 1 0 0
v_max_id_clo_res 1031 1031 0 0.00 0 1861 13 0 0
v_max_id_ord_sup 5561 5561 0 0.00 0 6377 6 0 0
v_max_non_paid_invoice 1805 1805 0 0.00 0 215 2 0 0
v_max_non_paid_realizn 3958 3958 0 0.00 0 2315 4 0 0
v_min_id_clo_ord 5649 5649 0 0.00 0 4461 8 0 0
v_min_id_clo_res 1031 1031 0 0.00 0 8144 20 0 0
v_min_id_ord_sup 5561 5561 0 0.00 0 4302 8 0 0
v_min_non_paid_invoice 5980 5980 0 0.00 0 5501 17 0 0
v_min_non_paid_realizn 7276 7276 0 0.00 0 7142 14 0 0
v_our_firm 10770 10770 0 0.00 0 31 1 0 0
v_reserve_write_off 20518 20518 0 0.00 0 5178 7 0 0
x_lock_depdocs_on_canc_invoice 11732 11732 0 0.00 0 15470 94 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 14465 294 0 0
x_make_qstorno_1000_1200 5649 5649 0 0.00 2 37845 1074 0 0
x_make_qstorno_1200_2000 5566 5566 0 0.00 3 90527 2595 0 0
x_make_qstorno_2100_3300 476001 476001 0 0.00 0 43250 149 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:07 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:14 14285 8192000000 10249441904 10558095360 955319536 10.443 77 48 94 1 974964464 2748464 16896464
16:57:36 24748 8192000000 10352435232 10673164288 1395597904 14.556 100 92 184 0 1431088832 4547744 30943184
16:58:15 27058 8192000000 10389283296 10717417472 1442468992 14.971 100 83 166 0 1475280960 6192368 26619600
16:58:57 12755 8192000000 10421102864 10752741376 1480431424 15.305 100 88 176 0 1516047056 7356160 28259472
16:59:24 28027 8192000000 10459169424 10793672704 1499710256 15.474 100 84 168 0 1534074608 7810272 26554080
17:00:07 21039 8192000000 10476129440 10816638976 1532194656 15.756 100 84 168 1 1568045904 9061216 26790032
17:00:36 24798 8192000000 10505937712 10851241984 1561983248 16.013 100 90 180 1 1600286832 10283648 28019936
17:01:10 13930 8192000000 10517616272 10866745344 1570956160 16.090 100 84 166 0 1607216928 10659920 25600848
17:01:30 17492 8192000000 10531434464 10887733248 1589840192 16.252 100 81 162 3 1625597952 11166608 24591152
17:01:57 6736 8192000000 10555854608 10911694848 1610827888 16.432 100 76 152 0 1645016848 11145472 23043488
17:02:12 12964 8192000000 10575204608 10932711424 1627958096 16.578 100 84 168 1 1665053776 11534560 25561120
17:02:33 12081 8192000000 10592557328 10954104832 1648682624 16.753 100 86 172 0 1686487408 11807040 25997744
17:02:53 8788 8192000000 10606072880 10967138304 1662433808 16.869 100 81 160 0 1698033968 12242288 23357872
17:03:11 11589 8192000000 10614527936 10983084032 1675856880 16.982 100 80 159 1 1712647472 12230256 24560336
17:03:31 6157 8192000000 10638386192 11005714432 1692589040 17.123 100 82 162 1 1728400416 12033552 23777824
17:03:45 6080 8192000000 10647037408 11018625024 1705435552 17.231 100 75 150 0 1740072464 12781504 21855408
17:03:59 6498 8192000000 10659375344 11033014272 1717997184 17.336 100 82 162 1 1755527984 13971952 23558848
17:04:13 7449 8192000000 10667284512 11044700160 1734381024 17.472 100 83 166 0 1772135120 13231104 24522992
17:04:28 4403 8192000000 10697889184 11072700416 1756969792 17.659 100 82 162 0 1792557920 12461984 23126144
17:04:40 5234 8192000000 10701761760 11080044544 1758716992 17.674 100 83 163 1 1795515712 13519392 23279328
17:04:53 3765 8192000000 10710869056 11090333696 1771224160 17.777 100 85 168 2 1808564816 13405792 23934864
17:05:04 4250 8192000000 10709560832 11093241856 1776782336 17.823 100 82 162 1 1812153168 12265280 23105552
17:05:15 2975 8192000000 10726098432 11107315712 1789380880 17.927 100 85 170 1 1825254976 11700000 24174096
17:05:26 2418 8192000000 10734240128 11112136704 1796873904 17.988 100 85 169 1 1833311936 12497456 23940576
17:05:36 3785 8192000000 10743196688 11123359744 1805192208 18.056 100 82 165 0 1841046560 13082080 22772272
17:05:46 4656 8192000000 10741886928 11130527744 1807428608 18.075 100 77 153 4 1842477376 13841824 21206944
17:05:57 4861 8192000000 10748164800 11139809280 1814824832 18.135 100 81 158 2 1849840784 12981760 22034192
17:06:09 1952 8192000000 10771967968 11156353024 1831320256 18.270 100 89 178 2 1869291424 13286544 24684624
17:06:17 2460 8192000000 10787096640 11174494208 1842147584 18.358 100 89 178 1 1881054976 14215904 24691488
17:06:26 2016 8192000000 10783031136 11171442688 1843374160 18.368 100 88 176 1 1880407440 12893360 24139920
17:06:35 1069 8192000000 10793918128 11178921984 1850175872 18.424 100 93 180 1 1890134208 13768064 26190272
17:06:42 1328 8192000000 10805261536 11189796864 1855850720 18.470 100 92 177 1 1894501344 13635824 25014800
17:06:50 1901 8192000000 10799617824 11187331072 1856667856 18.476 100 88 176 1 1896124128 14207648 25248624
17:06:58 2001 8192000000 10802849040 11189743616 1858308336 18.490 100 86 168 0 1895361104 13740816 23311952
17:07:06 1320 8192000000 10802686896 11193577472 1864027824 18.536 100 90 177 0 1903231920 13433664 25770432
17:07:14 1180 8192000000 10809190672 11200659456 1866771072 18.558 100 91 182 1 1906093616 13719696 25602848
17:07:21 1416 8192000000 10810779008 11202342912 1872768112 18.607 100 94 188 1 1912547488 13091184 26688192
17:07:29 2376 8192000000 10801422512 11204546560 1873146736 18.610 100 88 176 0 1910868816 13527152 24194928
17:07:38 9286 8192000000 10811237168 11204845568 1871787808 18.599 100 74 148 0 1904090640 12001808 20301024
17:07:53 1685 8192000000 10813848336 11214008320 1878020288 18.649 100 80 160 1 1913241136 12118992 23101856
17:08:02 4043 8192000000 10797705168 11209916416 1879278144 18.659 100 59 119 1 1906099600 10745504 16075952
17:08:12 7314 8192000000 10796752000 11208454144 1873911472 18.616 100 48 97 1 1897927168 10204432 13811264
17:08:26 4607 8192000000 10801001024 11208065024 1873459760 18.612 100 46 93 0 1893410656 7713632 12237264
17:08:37 3379 8192000000 10808541952 11215290368 1879858608 18.664 100 56 113 0 1903988560 8915104 15214848
17:08:47 57626 8192000000 10797453984 11226419200 1879394608 18.660 100 30 58 3 1897486672 10046272 8045792
17:09:54 7482 8192000000 10785989440 11222745088 1881644640 18.678 100 26 52 1 1896621152 7843600 7132912
17:10:11 10574 8192000000 10798756176 11227590656 1883917072 18.697 100 18 36 1 1894632128 5683648 5031408
17:10:29 7076 8192000000 10805053120 11230527488 1889997360 18.746 100 27 53 3 1903136864 5874608 7264896
17:10:43 6650 8192000000 10810486624 11234246656 1891583776 18.759 100 17 34 4 1901733440 5902256 4247408
17:10:56 7824 8192000000 10802622800 11239313408 1894147888 18.779 100 19 39 0 1905862352 5449376 6265088
17:11:11 11937 8192000000 10800654432 11236888576 1895324160 18.789 100 18 36 2 1905830656 5457168 5049328
17:11:30 8178 8192000000 10812554544 11245518848 1898361552 18.813 100 22 44 2 1911888960 6726864 6800544
17:11:44 12788 8192000000 10798591264 11242156032 1897005632 18.802 100 18 34 2 1907943408 6250736 4687040
17:12:06 10870 8192000000 10806592384 11246002176 1902471744 18.846 100 24 48 0 1919624976 11020256 6132976
17:12:26 7959 8192000000 10811714864 11249827840 1903013408 18.851 100 20 38 1 1914598944 6261232 5324304
17:12:41 12245 8192000000 10813695344 11254378496 1903250992 18.852 100 12 24 2 1916884368 9995744 3637632
17:13:05 15650 8192000000 10809503632 11251355648 1910149728 18.908 100 32 65 1 1925327648 5949504 9228416
17:13:30 65228 8192000000 10851986624 11266142208 1910144576 18.908 100 27 54 0 1923341824 5354736 7842512
17:14:41 5067 8192000000 10826167056 11264069632 1911140048 18.916 100 29 58 2 1927765344 7945872 8679424
17:14:53 12205 8192000000 10818040416 11251908608 1885849328 18.712 99 17 34 1 1896475824 5461360 5165136
17:15:14 10162 8192000000 10817915392 11256954880 1903782208 18.857 100 15 30 0 1913678832 5964752 3931872
17:15:31 5709 8192000000 10808924528 11240857600 1884006640 18.697 99 22 44 3 1896220448 6083904 6129904
17:15:44 6311 8192000000 10795281248 11233660928 1875597568 18.630 99 27 53 2 1889772272 6652240 7522464
17:15:59 6547 8192000000 10804508480 11237531648 1888842128 18.736 100 22 42 3 1900688832 5656880 6189824
17:16:13 13138 8192000000 10804784496 11238891520 1874342512 18.619 99 17 33 1 1884831168 5815712 4672944
17:16:34 13978 8192000000 10771526000 11199860736 1795717648 17.979 95 14 28 1 1804830768 5204240 3908880
17:16:54 6864 8192000000 10757628720 11188641792 1808445056 18.083 97 19 38 2 1819072576 5482608 5144912
17:17:07 10393 8192000000 10734942896 11166748672 1793321776 17.959 98 19 38 0 1804372224 5280416 5770032
17:17:28 11149 8192000000 10707749392 11119345664 1711908960 17.285 94 12 24 1 1720179456 4639968 3630528
17:17:45 10146 8192000000 10693019040 11100368896 1676014704 16.984 92 24 48 1 1688536080 5841072 6680304
17:18:04 8229 8192000000 10663063696 11075248128 1663034160 16.874 93 23 46 2 1675454432 5483264 6937008
17:18:19 37669 8192000000 10694845072 11101388800 1737898720 17.501 98 28 54 0 1751409392 4895392 8615280
17:19:02 30760 8192000000 10680251120 11106848768 1713350560 17.297 96 23 46 2 1725367184 5961264 6055360
17:19:39 11074 8192000000 10693824896 11106656256 1718443600 17.339 96 25 49 0 1734906016 9443120 7019296
17:19:59 8281 8192000000 10712997488 11122909184 1773627872 17.797 99 41 81 1 1793098752 8384624 11086256
17:20:14 8141 8192000000 10742528032 11150356480 1790991728 17.940 99 30 60 0 1806386272 6551424 8843120
17:20:31 8117 8192000000 10729889856 11135868928 1802975808 18.038 99 32 63 3 1818260976 5561552 9723616
17:20:47 7127 8192000000 10706023440 11117907968 1783872752 17.881 99 18 36 0 1794947232 5367040 5707440
17:21:04 10077 8192000000 10715158864 11139944448 1780625936 17.855 98 22 44 2 1791858240 4983728 6248576
17:21:22 8716 8192000000 10707724512 11132190720 1788812912 17.922 99 19 38 2 1799855856 5263392 5779552
17:21:41 7538 8192000000 10732545408 11149942784 1795711792 17.979 99 25 50 0 1808516224 5501856 7302576
17:21:55 6777 8192000000 10743729280 11165310976 1826632656 18.232 100 22 45 0 1839281888 5674448 6974784
17:22:08 16657 8192000000 10746754976 11177721856 1835125248 18.301 100 8 16 0 1842722960 5206512 2391200
17:22:30 10500 8192000000 10757890000 11186147328 1848006832 18.406 100 24 48 1 1860734736 5352784 7375120
17:22:55 50753 8192000000 10772261056 11199094784 1857558192 18.483 100 31 61 2 1871637472 5454816 8624464
17:24:01 8770 8192000000 10784618864 11209007104 1866108256 18.553 100 39 78 0 1884086784 7503936 10474592
17:24:20 7081 8192000000 10782726240 11208912896 1868515024 18.572 100 29 58 4 1883291312 6272976 8503312
17:24:36 5304 8192000000 10792392576 11220652032 1872640720 18.606 100 34 68 1 1894191376 12578288 8972368
17:24:48 8635 8192000000 10788295024 11214577664 1871682064 18.598 100 25 50 0 1884450800 5885440 6883296
17:25:05 8834 8192000000 10788114608 11214991360 1871416384 18.596 100 23 46 0 1883562160 5596592 6549184
17:25:22 7811 8192000000 10787146672 11211059200 1871798768 18.599 100 24 46 3 1884418048 6136688 6482592
17:25:36 8610 8192000000 10791681680 11218964480 1872997056 18.609 100 21 40 1 1885224096 6315520 5911520
17:25:52 9012 8192000000 10793310112 11220164608 1877285904 18.643 100 22 45 1 1889780768 6093872 6400992
17:26:09 11154 8192000000 10788714752 11222663168 1881168240 18.675 100 21 42 1 1892912144 5620544 6123360
17:26:26 8983 8192000000 10807309472 11235639296 1883166704 18.691 100 18 36 1 1897781632 9942352 4672576
17:26:41 9260 8192000000 10789196304 11225145344 1883281328 18.692 100 18 36 1 1893874304 5053488 5539488
17:26:58 6353 8192000000 10807840496 11231780864 1886287536 18.716 100 22 44 1 1898525968 5814752 6423680
17:27:12 9199 8192000000 10841238848 11252658176 1910213024 18.908 100 50 101 1 1930294272 5855152 14226096
17:27:34 10246 8192000000 10845372320 11261988864 1904608752 18.863 99 64 126 0 1931525888 8948240 17968896
17:27:53 20919 8192000000 10855419680 11270152192 1921724112 19.001 100 54 106 3 1946079856 10090176 14265568
17:28:24 11217 8192000000 10865801024 11279147008 1929646208 19.064 100 61 121 0 1956145312 10079232 16419872
17:28:53 86714 8192000000 10860275168 11293298688 1935032960 19.107 100 31 62 1 1952343072 8683648 8626464
17:30:26 31302 8192000000 10855277552 11289550848 1906563632 18.879 98 30 59 2 1926818688 11944416 8310640
17:31:13 11026 8192000000 10872639648 11299061760 1925604160 19.032 99 48 96 2 1952334160 12545376 14184624
17:31:41 5545 8192000000 10874213104 11310804992 1948277856 19.213 100 43 86 3 1972698560 11995504 12425200
17:31:56 11921 8192000000 10881379264 11315023872 1953282176 19.253 100 42 82 2 1977408800 12433008 11693616
17:32:35 11912 8192000000 10898454368 11334746112 1967896112 19.369 100 55 110 0 2000092064 15576784 16619168
17:32:53 13287 8192000000 10913232912 11339726848 1974927392 19.425 100 52 104 0 2006183984 15533184 15723408
17:33:21 7405 8192000000 10917533088 11344592896 1973295360 19.412 100 55 108 0 2005849104 16397104 16156640
17:33:41 9353 8192000000 10930527872 11355463680 1981864880 19.479 100 67 132 0 2021770064 20583040 19322144
17:33:59 3356 8192000000 10930421520 11350282240 1981301920 19.475 100 63 126 4 2015417744 15965600 18150224
17:34:10 2944 8192000000 10932383920 11354451968 1982631072 19.486 100 56 112 0 2015794736 15836304 17327360
17:34:21 5884 8192000000 10909119248 11332407296 1962161296 19.323 100 62 123 0 1997537248 17134304 18241648
17:34:41 9725 8192000000 10909250544 11335987200 1952046672 19.243 99 56 111 1 1986390176 17600592 16742912
17:35:06 9645 8192000000 10917965952 11344003072 1959030352 19.298 99 50 100 0 1991384416 17345072 15008992
17:35:31 8132 8192000000 10914836976 11348189184 1977524832 19.445 100 49 97 0 2008353424 16831904 13996688
17:35:46 7786 8192000000 10924800736 11359068160 1961289264 19.316 99 47 94 1 1995633152 20820528 13523360
17:36:05 5842 8192000000 10935173760 11363557376 1981051408 19.473 100 58 116 1 2024090592 25894208 17144976
17:36:19 5507 8192000000 10951347040 11367374848 1971503056 19.397 99 73 146 2 2017179392 23884224 21792112
17:36:32 9641 8192000000 10945476400 11364290560 1988067056 19.529 100 69 137 0 2031817840 23473568 20277216
17:36:49 3970 8192000000 10936975856 11363684352 1985774960 19.510 100 69 136 2 2031323440 25298416 20250064
17:37:01 3811 8192000000 10945613248 11371184128 1991300128 19.554 100 61 122 1 2037528160 28427616 17800416
17:37:12 3014 8192000000 10944330368 11367428096 1987001184 19.520 100 70 138 0 2036507520 29073440 20432896
17:37:22 3269 8192000000 10940918192 11362054144 1970093248 19.386 99 59 119 3 2012625680 24590992 17941440
17:37:33 3395 8192000000 10928355024 11355766784 1975063472 19.426 100 63 125 0 2018947984 24651552 19232960
17:37:43 5963 8192000000 10906081296 11327877120 1921831536 19.002 97 67 134 1 1968919680 26368960 20719184
17:37:56 3575 8192000000 10925788384 11341750272 1933712816 19.097 98 78 154 2 1984119920 27577008 22830096
17:38:08 4469 8192000000 10933854064 11345018880 1964972400 19.346 100 73 142 3 2013622848 27923840 20726608
17:38:19 3500 8192000000 10928873680 11350982656 1969640464 19.383 100 67 134 1 2018068160 28179616 20248080
17:38:32 3047 8192000000 10931713216 11345408000 1963875968 19.337 100 80 160 1 2016636080 28007056 24753056
17:38:42 5346 8192000000 10912772096 11327848448 1944713280 19.184 99 69 136 1 1997741376 32053872 20974224
17:38:54 2227 8192000000 10920945328 11343364096 1956020736 19.274 100 65 128 1 2006753616 31114176 19618704
17:39:03 2760 8192000000 10923283984 11342020608 1953431712 19.254 100 77 153 1 2008763072 31814208 23517152
17:39:12 1180 8192000000 10931301280 11339059200 1957061552 19.283 100 93 181 1 2019568864 32252096 30255216
17:39:21 938 8192000000 10933569200 11336658944 1952035648 19.243 100 89 178 0 2013922272 34824176 27062448
17:39:28 2220 8192000000 10934111696 11350138880 1963075728 19.330 100 77 152 0 2021576656 34884576 23616352
17:39:37 1863 8192000000 10931725008 11350138880 1951295680 19.237 99 78 156 0 2016224400 41120720 23808000
17:39:46 10550 8192000000 10932735216 11351363584 1959207312 19.300 100 65 129 2 2016141776 36860160 20074304
17:40:06 4234 8192000000 10937950896 11366879232 1971297616 19.396 100 63 125 2 2026680768 36072048 19311104
17:40:17 2249 8192000000 10953714960 11376947200 1981796304 19.479 100 71 142 0 2041395664 38383824 21215536
17:40:28 1484 8192000000 10949403712 11353858048 1963894256 19.337 100 84 167 0 2025975104 36009696 26071152
17:40:36 2206 8192000000 10946100928 11359375360 1966656784 19.359 100 74 148 0 2027250992 37694576 22899632
17:40:46 4073 8192000000 10913902400 11323617280 1931072384 19.075 99 70 139 1 1990517808 37664224 21781200
17:40:57 4500 8192000000 10932301408 11342331904 1950510928 19.231 100 74 149 0 2013047312 38962368 23574016
17:41:09 2505 8192000000 10946158192 11353546752 1962906336 19.329 100 82 163 2 2029593968 41057792 25629840
17:41:18 4250 8192000000 10918096272 11334443008 1934638912 19.104 99 84 167 1 2001054128 40870784 25544432
17:41:31 3145 8192000000 10922067776 11347554304 1951450032 19.238 100 63 125 2 2010275904 38575728 20250144
17:41:41 11434 8192000000 10906163888 11343970304 1932717152 19.089 99 40 80 1 1982615360 36367840 13530368
17:41:59 5978 8192000000 10908263616 11347779584 1950764080 19.233 100 38 76 3 1999774304 35093184 13917040
17:42:24 3882 8192000000 10938541520 11362242560 1960306336 19.308 100 55 110 1 2019560208 41603952 17649920
17:42:35 3002 8192000000 10939069152 11358928896 1946950256 19.202 99 74 148 0 2010823776 39619328 24254192
17:42:46 7022 8192000000 10922644192 11361783808 1963790192 19.336 100 61 122 0 2030486576 47020192 19676192
17:43:14 8353 8192000000 10904494416 11334766592 1938419120 19.134 99 40 80 2 1985422640 34227424 12776096
17:43:30 10722 8192000000 10921136944 11352158208 1955202592 19.268 100 38 76 0 2002281392 34861744 12217056
17:43:50 4569 8192000000 10926155488 11352829952 1942968240 19.170 99 55 111 0 2000566976 40098912 17499824
17:44:02 4550 8192000000 10916465600 11353149440 1953612304 19.255 100 37 74 1 2006992832 40741104 12639424
17:44:31 23768 8192000000 10883861504 11316350976 1895190256 18.788 97 30 60 1 1943657776 38298864 10168656
17:45:16 3578 8192000000 10919108144 11342131200 1925812096 19.033 99 48 94 2 1984002000 43093808 15096096
17:45:31 18921 8192000000 10912870336 11358584832 1944163584 19.180 100 31 62 1 2001430240 46553408 10713248
17:46:07 23600 8192000000 10923986144 11364839424 1952585632 19.247 100 23 46 2 2002778624 42572624 7620368
17:47:10 13128 8192000000 10923357184 11363262464 1934432704 19.102 99 29 58 2 1991902720 47469136 10000880
17:47:38 23694 8192000000 10923483424 11373006848 1934134816 19.100 99 25 50 1 1994013424 51236816 8641792
17:48:09 13060 8192000000 10920634560 11363561472 1933332304 19.094 99 29 59 3 1992129696 48761184 10036208
17:48:29 29763 8192000000 10910308624 11362537472 1930012544 19.067 99 16 32 0 1980858608 44735712 6110352
17:49:05 37710 8192000000 10900684256 11354841088 1900537056 18.831 98 19 38 1 1958156656 50899728 6719872
17:49:51 31843 8192000000 10910381168 11361865728 1935806976 19.113 100 18 36 1 1993371376 51038304 6526096
17:50:29 16469 8192000000 10921325536 11373850624 1943030064 19.171 100 22 44 1 2005491792 54819648 7642080
17:51:01 55969 8192000000 10881518976 11339583488 1903410704 18.854 98 13 26 1 1936517472 28548464 4558304
17:52:04 66039 8192000000 10870641072 11322351616 1870970432 18.592 97 9 18 0 1887190464 13851840 2368192
17:53:16 32673 8192000000 10885943680 11312308224 1934888112 19.106 100 48 92 0 1953666000 6651520 12126368
17:53:56 74680 8192000000 10865650640 11335917568 1926584960 19.040 99 21 42 0 1944659632 12256576 5818096
17:55:16 45829 8192000000 10871433648 11337605120 1924578160 19.024 99 6 12 0 1939551168 13423408 1549600
17:56:10 21990 8192000000 10859588144 11329916928 1924919472 19.026 99 10 20 2 1943717760 15827840 2970448
17:58:59 63121 8192000000 10890447808 11355504640 1963210080 19.332 100 32 63 0 1983976496 11207200 9559216
18:00:10 59720 8192000000 10903499248 11370405888 1974107680 19.418 100 13 26 0 1989234400 11637520 3489200
18:01:24 49788 8192000000 10897041024 11367612416 1961309072 19.316 99 18 36 2 1980081280 13762288 5009920
18:02:23 122472 8192000000 10896293216 11369603072 1935637056 19.112 98 21 41 1 1950918208 9794960 5486192
18:04:34 46834 8192000000 10897839680 11376492544 1975937712 19.433 100 21 42 0 1994835008 13246848 5650448
18:05:28 33104 8192000000 10895927248 11373305856 1978809824 19.455 100 7 14 1 1987298560 6165744 2322992
18:06:42 54251 8192000000 10904821280 11373514752 1963563440 19.334 99 27 54 0 1981770096 10347008 7859648
18:07:50 106077 8192000000 10887897408 11378040832 1961056992 19.314 99 12 24 1 1977135184 12368320 3709872
18:09:42 65536 8192000000 10914760464 11388309504 1980836176 19.471 100 11 22 1 1997940944 13723392 3381376
18:10:55 60920 8192000000 10900804736 11378429952 1950805120 19.233 98 10 21 0 1969395536 15370448 3219968
18:12:06 82171 8192000000 10910178080 11386847232 1976033344 19.433 100 13 27 0 1994031632 14568480 3429808
18:13:34 51296 8192000000 10944078896 11398303744 1995168304 19.585 100 33 66 1 2014549584 10216288 9164992
18:14:39 40354 8192000000 10939458640 11387420672 1957486096 19.286 98 29 58 2 1978490768 12706304 8298368
18:15:30 52172 8192000000 10923228656 11390136320 1984477424 19.500 100 24 48 1 2001348256 10281536 6589296
18:17:15 34212 8192000000 10935837968 11398881280 1998039360 19.607 100 34 68 1 2018562976 10948304 9575312
18:18:01 76130 8192000000 10922884800 11405996032 1988734048 19.534 99 21 42 1 2006339008 11577696 6027264
18:19:33 136246 8192000000 10860462800 11323461632 1641943888 16.696 83 11 22 0 1653021968 8660656 2417424
18:21:57 75198 8192000000 10877177200 11321540608 1934473616 19.103 100 38 76 3 1954515936 9192992 10849328
18:23:28 50653 8192000000 10904889232 11355533312 1963295248 19.332 100 42 83 1 1985367376 10260192 11811936
18:24:27 40261 8192000000 10890702240 11348963328 1927969616 19.051 98 53 106 0 1954124336 11142096 15012624
18:25:13 39355 8192000000 10854921872 11319844864 1916818704 18.961 98 29 58 0 1935480048 10062096 8599248
18:26:06 56649 8192000000 10852487200 11330220032 1919604608 18.984 99 11 22 0 1932917664 10187744 3125312
18:27:57 58798 8192000000 10877662128 11359264768 1936498576 19.119 99 11 22 2 1953902192 13801184 3602432
18:29:08 57725 8192000000 10871016688 11330154496 1846673984 18.395 94 18 36 1 1861510272 9754752 5081536
18:30:11 57313 8192000000 10865198016 11342663680 1930006640 19.067 99 13 26 0 1944161296 10169536 3985120
18:31:15 53212 8192000000 10855288720 11327664128 1827226480 18.237 94 17 30 3 1842963648 12102880 3634288
18:32:24 32849 8192000000 10853450304 11313790976 1880062864 18.666 97 38 76 1 1898581760 7125824 11393072
18:33:03 41504 8192000000 10838334336 11310698496 1871631456 18.597 97 17 34 0 1886290480 9749408 4909616
18:33:54 47049 8192000000 10836473472 11302010880 1869232784 18.578 97 11 21 1 1882917648 10429248 3255616
18:34:47 26718 8192000000 10869723584 11318829056 1889552192 18.742 98 18 36 1 1903050304 7536240 5961872
18:35:21 77440 8192000000 10856460624 11318816768 1869820336 18.583 97 22 44 0 1887189680 11806608 5562736
18:36:57 51758 8192000000 10859268480 11323752448 1924753776 19.025 100 18 36 2 1942554288 12687376 5113136
18:37:55 54442 8192000000 10864914032 11330797568 1904088432 18.859 98 20 40 0 1922875184 13422624 5364128
18:39:01 40739 8192000000 10877250656 11323338752 1899739104 18.824 98 38 76 1 1926623984 16259408 10625472
18:39:48 103237 8192000000 10850068848 11313778688 1835926624 18.308 95 18 36 1 1853134480 12176272 5031584
18:41:38 41889 8192000000 10867157760 11312414720 1892342048 18.765 98 15 30 0 1903675280 7127168 4206064
18:42:27 127639 8192000000 10875131360 11328167936 1920800144 18.993 99 24 49 0 1936537888 8773168 6964576
18:44:43 89536 8192000000 10869373184 11330895872 1871187520 18.594 96 22 44 0 1887818832 9809520 6821792
18:46:28 82292 8192000000 10849361712 11329761280 1917952432 18.970 99 15 29 1 1934148528 11719040 4477056
18:47:56 39279 8192000000 10860299264 11338088448 1939086576 19.139 100 14 28 0 1953308576 10219216 4002784
18:48:41 65221 8192000000 10865482288 11340918784 1945175312 19.188 100 13 25 0 1957163536 8579472 3408752
18:49:53 59016 8192000000 10864881872 11346968576 1951174992 19.236 100 8 16 1 1962318112 8892304 2250816
18:51:08 72327 8192000000 10878195440 11354181632 1922288208 19.005 98 11 22 0 1934611776 9748496 2575072
18:52:32 41753 8192000000 10883965552 11359125504 1967650608 19.367 100 36 72 1 1989685520 11314240 10720672
18:53:25 135628 8192000000 10928916144 11387424768 1952048720 19.243 99 16 32 0 1969613504 13217744 4347040
18:55:52 46532 8192000000 10900322656 11373559808 1958059344 19.291 99 11 22 1 1972329920 11533648 2736928
18:56:48 79334 8192000000 10921758832 11376250880 1976751024 19.439 100 13 26 0 1992259840 12050896 3457920
18:58:15 46109 8192000000 10893931024 11360464896 1930278048 19.069 97 38 76 0 1949021216 7982528 10760640
18:59:12 88173 8192000000 10881805472 11346624512 1860150160 18.504 94 16 32 1 1871840896 7757344 3933392
19:00:47 46294 8192000000 10921035872 11364761600 1952642880 19.248 99 25 50 4 1972947600 12568720 7736000
19:01:42 40152 8192000000 10905211856 11373101056 1941435408 19.158 98 34 68 0 1964302928 13264192 9603328
19:03:34 52059 8192000000 10925105856 11384545280 1957893776 19.289 99 39 76 0 1991577552 23621968 10061808
19:04:36 67404 8192000000 10902732080 11383148544 1954524640 19.262 100 12 24 0 1978338400 20636704 3177056
19:05:59 80680 8192000000 10891503072 11351109632 1912146880 18.924 97 26 52 1 1930056544 10625536 7284128
19:08:04 66592 8192000000 10884463664 11362750464 1921151024 18.996 97 21 41 1 1941542368 14685584 5705760
19:09:20 17310 8192000000 10873628864 11358547968 1936117152 19.116 99 3 6 0 1951781360 14778752 885456
19:09:44 28394 8192000000 10851907264 11324559360 1917549712 18.967 98 3 6 0 1932653472 14045472 1058288
19:10:38 78829 8192000000 10886024256 11356098560 1937412576 19.126 99 6 12 0 1947411664 8508800 1490288
19:12:03 81130 8192000000 10883374016 11351580672 1928077760 19.052 98 10 20 0 1944183568 13251808 2854000
19:13:47 58801 8192000000 10860746432 11352297472 1883493680 18.693 97 8 16 0 1903396144 17140048 2762416
19:14:53 61729 8192000000 10857742272 11324456960 1861475904 18.515 95 15 30 0 1877212272 11760448 3975920
19:16:01 51832 8192000000 10855044208 11325722624 1913212256 18.932 99 29 58 1 1935436816 13239760 8984800
19:17:04 98876 8192000000 10877432368 11347075072 1865343376 18.547 96 19 38 0 1884462960 13629360 5490224
19:18:49 150398 8192000000 10873848592 11332026368 1846548432 18.394 95 19 38 2 1864971472 12436064 5986976
19:21:35 79373 8192000000 10876358512 11344310272 1889997168 18.746 97 14 28 1 1919482720 25232816 4252736
19:23:04 63033 8192000000 10869264384 11323703296 1856427232 18.474 96 26 52 0 1890984016 27411760 7145024
19:24:13 19605 8192000000 10860908240 11306795008 1898210368 18.812 99 43 86 1 1923784400 12858656 12715376
19:24:49 46237 8192000000 10843225680 11306090496 1861634624 18.517 97 33 66 0 1886119312 15268784 9215904
19:25:41 90131 8192000000 10653894400 11097862144 1729052464 17.428 90 28 56 2 1747047584 10090944 7904176

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 19-12-2020 19:29:09 to 19-12-2020 19:29:39.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 151 v_add_invoice_to_stock 335544517
except 20 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 19-12-2020 19:29:40 to 19-12-2020 19:29:41.

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          248109
MON$OLDEST_ACTIVE               249093
MON$OLDEST_SNAPSHOT             249093
MON$NEXT_TRANSACTION            249093
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                       2020992
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:107: 
:108: mscs-test-161.budzdorov.ru    Sat Dec 19 19:27:48 2020
:109:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:110: 
:111: 
:112: mscs-test-161.budzdorov.ru    Sat Dec 19 19:27:48 2020
:113:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:114: 
--- end of diff output ---

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

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