Muhasebe hesaplama deneyi

Ölçümler

Satırlar, hareket sayısı ve ölçüm türüne göre karşılaştırılır. Oran, aynı boyuttaki son B ve C raporlarının ortalama süresinden hesaplanır.

5.000.000 hareket

ÖlçümMimariOrtalama / medyan / p95 msCPU msPHP tepe bellekSorguReconcile farkıHız oranı
new_voucherA2,62 / 2,42 / 3,05 0,8926,0 MiB8,00,0 ölçülemedi
new_voucherB5,13 / 5,14 / 5,25 1,7630,0 MiB17,00,0 ölçülemedi
new_voucherC5,72 / 5,71 / 5,85 1,9332,0 MiB19,00,0B, C’den 1,1× hızlı
party_balanceA1.286,04 / 1.273,22 / 1.338,39 0,5528,0 MiB1,00,0 ölçülemedi
party_balanceB0,67 / 0,66 / 0,75 0,3130,0 MiB1,00,0 ölçülemedi
party_balanceC0,50 / 0,50 / 0,50 0,2132,0 MiB1,00,0C, B’den 1,3× hızlı
sequential_1000A2.663,74 / 2.674,11 / 2.699,12 902,7828,0 MiB8.000,00,0 ölçülemedi
sequential_1000B4.717,74 / 4.725,35 / 4.738,07 1.599,4930,0 MiB17.000,00,0 ölçülemedi
sequential_1000C5.260,44 / 5.266,37 / 5.278,55 1.774,3032,0 MiB19.000,00,0B, C’den 1,1× hızlı
batch_1000A2.057,42 / 2.060,31 / 2.067,20 727,1230,0 MiB7.001,00,0 ölçülemedi
batch_1000B4.059,43 / 4.080,49 / 4.164,69 1.327,4932,0 MiB15.002,00,0 ölçülemedi
batch_1000C2.036,90 / 2.057,10 / 2.063,23 726,5932,0 MiB7.012,00,0C, B’den 2,0× hızlı
trial_balanceA436,09 / 435,86 / 438,38 0,5730,0 MiB1,00,0 ölçülemedi
trial_balanceB0,70 / 0,70 / 0,72 0,2232,0 MiB1,00,0 ölçülemedi
trial_balanceC0,52 / 0,49 / 0,57 0,2132,0 MiB1,00,0C, B’den 1,4× hızlı
historical_reversalA3,01 / 3,01 / 3,04 1,1630,0 MiB10,00,0 ölçülemedi
historical_reversalB5,13 / 5,10 / 5,28 1,8532,0 MiB19,00,0 ölçülemedi
historical_reversalC5,67 / 5,63 / 5,79 2,0632,0 MiB21,00,0B, C’den 1,1× hızlı
concurrent_8x250A750,03 / 751,49 / 755,48 1.946,90240,0 MiB16.000,00,0 ölçülemedi
concurrent_8x250B9.524,16 / 9.545,44 / 9.593,02 3.562,22256,0 MiB34.000,00,0 ölçülemedi
concurrent_8x250C5.743,44 / 5.733,44 / 5.792,20 3.816,34256,0 MiB38.000,00,0C, B’den 1,7× hızlı

1.000.000 hareket

ÖlçümMimariOrtalama / medyan / p95 msCPU msPHP tepe bellekSorguReconcile farkıHız oranı
new_voucherA2,61 / 2,43 / 3,01 0,8926,0 MiB8,00,0 ölçülemedi
new_voucherB4,99 / 4,98 / 5,10 1,7630,0 MiB17,00,0 ölçülemedi
new_voucherC5,73 / 5,74 / 6,11 1,8932,0 MiB19,00,0B, C’den 1,1× hızlı
party_balanceA60,12 / 58,93 / 63,12 0,4328,0 MiB1,00,0 ölçülemedi
party_balanceB0,61 / 0,61 / 0,67 0,3030,0 MiB1,00,0 ölçülemedi
party_balanceC0,44 / 0,44 / 0,50 0,2032,0 MiB1,00,0C, B’den 1,4× hızlı
sequential_1000A2.694,07 / 2.697,26 / 2.728,47 896,6428,0 MiB8.000,00,0 ölçülemedi
sequential_1000B4.711,23 / 4.739,16 / 4.780,45 1.605,1930,0 MiB17.000,00,0 ölçülemedi
sequential_1000C5.287,02 / 5.285,39 / 5.302,02 1.790,7032,0 MiB19.000,00,0B, C’den 1,1× hızlı
batch_1000A2.053,36 / 2.056,02 / 2.077,80 731,2530,0 MiB7.001,00,0 ölçülemedi
batch_1000B4.067,60 / 4.082,84 / 4.134,34 1.332,9732,0 MiB15.002,00,0 ölçülemedi
batch_1000C2.064,59 / 2.064,59 / 2.068,84 738,7732,0 MiB7.012,00,0C, B’den 2,0× hızlı
trial_balanceA78,83 / 79,48 / 80,15 0,5330,0 MiB1,00,0 ölçülemedi
trial_balanceB0,63 / 0,62 / 0,66 0,2132,0 MiB1,00,0 ölçülemedi
trial_balanceC0,50 / 0,50 / 0,52 0,2232,0 MiB1,00,0C, B’den 1,3× hızlı
historical_reversalA3,07 / 2,98 / 3,42 1,1230,0 MiB10,00,0 ölçülemedi
historical_reversalB5,08 / 5,06 / 5,16 1,8532,0 MiB19,00,0 ölçülemedi
historical_reversalC5,38 / 5,64 / 5,66 1,9332,0 MiB21,00,0B, C’den 1,1× hızlı
concurrent_8x250A771,28 / 766,96 / 796,86 2.000,55240,0 MiB16.000,00,0 ölçülemedi
concurrent_8x250B9.487,32 / 9.478,77 / 9.626,74 3.549,35256,0 MiB34.000,00,0 ölçülemedi
concurrent_8x250C5.678,34 / 5.687,37 / 5.711,35 3.800,40256,0 MiB38.000,00,0C, B’den 1,7× hızlı

100.000 hareket

ÖlçümMimariOrtalama / medyan / p95 msCPU msPHP tepe bellekSorguReconcile farkıHız oranı
new_voucherA2,63 / 2,44 / 3,06 0,9026,0 MiB8,00,0 ölçülemedi
new_voucherB4,97 / 4,93 / 5,17 1,7930,0 MiB17,00,0 ölçülemedi
new_voucherC5,58 / 5,55 / 5,85 1,9932,0 MiB19,00,0B, C’den 1,1× hızlı
party_balanceA0,49 / 0,49 / 0,53 0,2228,0 MiB1,00,0 ölçülemedi
party_balanceB0,62 / 0,60 / 0,67 0,3130,0 MiB1,00,0 ölçülemedi
party_balanceC0,44 / 0,44 / 0,45 0,2132,0 MiB1,00,0C, B’den 1,4× hızlı
sequential_1000A2.593,00 / 2.634,22 / 2.652,95 877,5528,0 MiB8.000,00,0 ölçülemedi
sequential_1000B4.679,08 / 4.709,79 / 4.727,79 1.592,0430,0 MiB17.000,00,0 ölçülemedi
sequential_1000C5.189,37 / 5.237,69 / 5.280,25 1.759,2932,0 MiB19.000,00,0B, C’den 1,1× hızlı
batch_1000A2.038,54 / 2.036,76 / 2.056,21 729,9030,0 MiB7.001,00,0 ölçülemedi
batch_1000B3.946,45 / 3.907,24 / 4.054,20 1.333,2732,0 MiB15.002,00,0 ölçülemedi
batch_1000C2.050,47 / 2.047,97 / 2.062,24 736,1732,0 MiB7.012,00,0C, B’den 1,9× hızlı
trial_balanceA21,29 / 21,11 / 21,93 0,3830,0 MiB1,00,0 ölçülemedi
trial_balanceB0,61 / 0,62 / 0,64 0,2132,0 MiB1,00,0 ölçülemedi
trial_balanceC0,49 / 0,50 / 0,50 0,2232,0 MiB1,00,0C, B’den 1,2× hızlı
historical_reversalA2,64 / 2,61 / 2,71 1,0030,0 MiB10,00,0 ölçülemedi
historical_reversalB5,18 / 5,12 / 5,42 1,9232,0 MiB19,00,0 ölçülemedi
historical_reversalC5,72 / 5,73 / 5,77 2,0632,0 MiB21,00,0B, C’den 1,1× hızlı
concurrent_8x250A769,32 / 760,56 / 795,61 2.021,89240,0 MiB16.000,00,0 ölçülemedi
concurrent_8x250B9.591,52 / 9.658,73 / 9.712,25 3.564,38256,0 MiB34.000,00,0 ölçülemedi
concurrent_8x250C5.763,26 / 5.761,12 / 5.807,59 3.813,14256,0 MiB38.000,00,0C, B’den 1,7× hızlı
Donanım, PostgreSQL ve indeksler

5000000-C-20261017-004227-9e54c7c94a5dd59181dc07c1.json

Donanım: {"cpu":"AMD EPYC 9454P","vcpus":16,"ram_gb":31,"database_colocated":true}

PostgreSQL: PostgreSQL 16.15 (Ubuntu 16.15-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit

  • CREATE UNIQUE INDEX deney_accounts_pkey ON public.deney_accounts USING btree (code)
  • CREATE UNIQUE INDEX deney_aggregates_pkey ON public.deney_aggregates USING btree (architecture, node, key)
  • CREATE UNIQUE INDEX deney_branches_pkey ON public.deney_branches USING btree (id)
  • CREATE UNIQUE INDEX deney_companies_pkey ON public.deney_companies USING btree (id)
  • CREATE UNIQUE INDEX deney_currencies_pkey ON public.deney_currencies USING btree (code)
  • CREATE INDEX deney_lines_account_voucher ON public.deney_lines USING btree (account, voucher_id)
  • CREATE INDEX deney_lines_party_voucher ON public.deney_lines USING btree (party_id, voucher_id) WHERE (party_id IS NOT NULL)
  • CREATE UNIQUE INDEX deney_lines_pkey ON public.deney_lines USING btree (id)
  • CREATE INDEX deney_lines_voucher ON public.deney_lines USING btree (voucher_id)
  • CREATE UNIQUE INDEX deney_outbox_pkey ON public.deney_outbox USING btree (id)
  • CREATE INDEX deney_parties_company ON public.deney_parties USING btree (company_id)
  • CREATE UNIQUE INDEX deney_parties_pkey ON public.deney_parties USING btree (id)
  • CREATE UNIQUE INDEX deney_periods_pkey ON public.deney_periods USING btree (id)
  • CREATE UNIQUE INDEX deney_trial_balance_key ON public.deney_trial_balance USING btree (company_id, period_id, account)
  • CREATE INDEX deney_vouchers_company_period_date ON public.deney_vouchers USING btree (company_id, period_id, date) WHERE ((status)::text = 'posted'::text)
  • CREATE INDEX deney_vouchers_date ON public.deney_vouchers USING btree (date) WHERE ((status)::text = 'posted'::text)
  • CREATE UNIQUE INDEX deney_vouchers_idempotency_key_key ON public.deney_vouchers USING btree (idempotency_key)
  • CREATE UNIQUE INDEX deney_vouchers_pkey ON public.deney_vouchers USING btree (id)
  • CREATE UNIQUE INDEX deney_vouchers_reversal_of_key ON public.deney_vouchers USING btree (reversal_of)

5000000-B-20261017-003349-9e54c7c94a5dd59181dc07c1.json

Donanım: {"cpu":"AMD EPYC 9454P","vcpus":16,"ram_gb":31,"database_colocated":true}

PostgreSQL: PostgreSQL 16.15 (Ubuntu 16.15-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit

  • CREATE UNIQUE INDEX deney_accounts_pkey ON public.deney_accounts USING btree (code)
  • CREATE UNIQUE INDEX deney_aggregates_pkey ON public.deney_aggregates USING btree (architecture, node, key)
  • CREATE UNIQUE INDEX deney_branches_pkey ON public.deney_branches USING btree (id)
  • CREATE UNIQUE INDEX deney_companies_pkey ON public.deney_companies USING btree (id)
  • CREATE UNIQUE INDEX deney_currencies_pkey ON public.deney_currencies USING btree (code)
  • CREATE INDEX deney_lines_account_voucher ON public.deney_lines USING btree (account, voucher_id)
  • CREATE INDEX deney_lines_party_voucher ON public.deney_lines USING btree (party_id, voucher_id) WHERE (party_id IS NOT NULL)
  • CREATE UNIQUE INDEX deney_lines_pkey ON public.deney_lines USING btree (id)
  • CREATE INDEX deney_lines_voucher ON public.deney_lines USING btree (voucher_id)
  • CREATE UNIQUE INDEX deney_outbox_pkey ON public.deney_outbox USING btree (id)
  • CREATE INDEX deney_parties_company ON public.deney_parties USING btree (company_id)
  • CREATE UNIQUE INDEX deney_parties_pkey ON public.deney_parties USING btree (id)
  • CREATE UNIQUE INDEX deney_periods_pkey ON public.deney_periods USING btree (id)
  • CREATE UNIQUE INDEX deney_trial_balance_key ON public.deney_trial_balance USING btree (company_id, period_id, account)
  • CREATE INDEX deney_vouchers_company_period_date ON public.deney_vouchers USING btree (company_id, period_id, date) WHERE ((status)::text = 'posted'::text)
  • CREATE INDEX deney_vouchers_date ON public.deney_vouchers USING btree (date) WHERE ((status)::text = 'posted'::text)
  • CREATE UNIQUE INDEX deney_vouchers_idempotency_key_key ON public.deney_vouchers USING btree (idempotency_key)
  • CREATE UNIQUE INDEX deney_vouchers_pkey ON public.deney_vouchers USING btree (id)
  • CREATE UNIQUE INDEX deney_vouchers_reversal_of_key ON public.deney_vouchers USING btree (reversal_of)

5000000-A-20261017-002503-9e54c7c94a5dd59181dc07c1.json

Donanım: {"cpu":"AMD EPYC 9454P","vcpus":16,"ram_gb":31,"database_colocated":true}

PostgreSQL: PostgreSQL 16.15 (Ubuntu 16.15-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit

  • CREATE UNIQUE INDEX deney_accounts_pkey ON public.deney_accounts USING btree (code)
  • CREATE UNIQUE INDEX deney_aggregates_pkey ON public.deney_aggregates USING btree (architecture, node, key)
  • CREATE UNIQUE INDEX deney_branches_pkey ON public.deney_branches USING btree (id)
  • CREATE UNIQUE INDEX deney_companies_pkey ON public.deney_companies USING btree (id)
  • CREATE UNIQUE INDEX deney_currencies_pkey ON public.deney_currencies USING btree (code)
  • CREATE INDEX deney_lines_account_voucher ON public.deney_lines USING btree (account, voucher_id)
  • CREATE INDEX deney_lines_party_voucher ON public.deney_lines USING btree (party_id, voucher_id) WHERE (party_id IS NOT NULL)
  • CREATE UNIQUE INDEX deney_lines_pkey ON public.deney_lines USING btree (id)
  • CREATE INDEX deney_lines_voucher ON public.deney_lines USING btree (voucher_id)
  • CREATE UNIQUE INDEX deney_outbox_pkey ON public.deney_outbox USING btree (id)
  • CREATE INDEX deney_parties_company ON public.deney_parties USING btree (company_id)
  • CREATE UNIQUE INDEX deney_parties_pkey ON public.deney_parties USING btree (id)
  • CREATE UNIQUE INDEX deney_periods_pkey ON public.deney_periods USING btree (id)
  • CREATE UNIQUE INDEX deney_trial_balance_key ON public.deney_trial_balance USING btree (company_id, period_id, account)
  • CREATE INDEX deney_vouchers_company_period_date ON public.deney_vouchers USING btree (company_id, period_id, date) WHERE ((status)::text = 'posted'::text)
  • CREATE INDEX deney_vouchers_date ON public.deney_vouchers USING btree (date) WHERE ((status)::text = 'posted'::text)
  • CREATE UNIQUE INDEX deney_vouchers_idempotency_key_key ON public.deney_vouchers USING btree (idempotency_key)
  • CREATE UNIQUE INDEX deney_vouchers_pkey ON public.deney_vouchers USING btree (id)
  • CREATE UNIQUE INDEX deney_vouchers_reversal_of_key ON public.deney_vouchers USING btree (reversal_of)

1000000-C-20261016-232451-e5af45c4e1136815c4fa1687.json

Donanım: {"cpu":"AMD EPYC 9454P","vcpus":16,"ram_gb":31,"database_colocated":true}

PostgreSQL: PostgreSQL 16.15 (Ubuntu 16.15-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit

  • CREATE UNIQUE INDEX deney_accounts_pkey ON public.deney_accounts USING btree (code)
  • CREATE UNIQUE INDEX deney_aggregates_pkey ON public.deney_aggregates USING btree (architecture, node, key)
  • CREATE UNIQUE INDEX deney_branches_pkey ON public.deney_branches USING btree (id)
  • CREATE UNIQUE INDEX deney_companies_pkey ON public.deney_companies USING btree (id)
  • CREATE UNIQUE INDEX deney_currencies_pkey ON public.deney_currencies USING btree (code)
  • CREATE INDEX deney_lines_account_voucher ON public.deney_lines USING btree (account, voucher_id)
  • CREATE INDEX deney_lines_party_voucher ON public.deney_lines USING btree (party_id, voucher_id) WHERE (party_id IS NOT NULL)
  • CREATE UNIQUE INDEX deney_lines_pkey ON public.deney_lines USING btree (id)
  • CREATE INDEX deney_lines_voucher ON public.deney_lines USING btree (voucher_id)
  • CREATE UNIQUE INDEX deney_outbox_pkey ON public.deney_outbox USING btree (id)
  • CREATE INDEX deney_parties_company ON public.deney_parties USING btree (company_id)
  • CREATE UNIQUE INDEX deney_parties_pkey ON public.deney_parties USING btree (id)
  • CREATE UNIQUE INDEX deney_periods_pkey ON public.deney_periods USING btree (id)
  • CREATE UNIQUE INDEX deney_trial_balance_key ON public.deney_trial_balance USING btree (company_id, period_id, account)
  • CREATE INDEX deney_vouchers_company_period_date ON public.deney_vouchers USING btree (company_id, period_id, date) WHERE ((status)::text = 'posted'::text)
  • CREATE INDEX deney_vouchers_date ON public.deney_vouchers USING btree (date) WHERE ((status)::text = 'posted'::text)
  • CREATE UNIQUE INDEX deney_vouchers_idempotency_key_key ON public.deney_vouchers USING btree (idempotency_key)
  • CREATE UNIQUE INDEX deney_vouchers_pkey ON public.deney_vouchers USING btree (id)
  • CREATE UNIQUE INDEX deney_vouchers_reversal_of_key ON public.deney_vouchers USING btree (reversal_of)

1000000-B-20261016-232015-e5af45c4e1136815c4fa1687.json

Donanım: {"cpu":"AMD EPYC 9454P","vcpus":16,"ram_gb":31,"database_colocated":true}

PostgreSQL: PostgreSQL 16.15 (Ubuntu 16.15-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit

  • CREATE UNIQUE INDEX deney_accounts_pkey ON public.deney_accounts USING btree (code)
  • CREATE UNIQUE INDEX deney_aggregates_pkey ON public.deney_aggregates USING btree (architecture, node, key)
  • CREATE UNIQUE INDEX deney_branches_pkey ON public.deney_branches USING btree (id)
  • CREATE UNIQUE INDEX deney_companies_pkey ON public.deney_companies USING btree (id)
  • CREATE UNIQUE INDEX deney_currencies_pkey ON public.deney_currencies USING btree (code)
  • CREATE INDEX deney_lines_account_voucher ON public.deney_lines USING btree (account, voucher_id)
  • CREATE INDEX deney_lines_party_voucher ON public.deney_lines USING btree (party_id, voucher_id) WHERE (party_id IS NOT NULL)
  • CREATE UNIQUE INDEX deney_lines_pkey ON public.deney_lines USING btree (id)
  • CREATE INDEX deney_lines_voucher ON public.deney_lines USING btree (voucher_id)
  • CREATE UNIQUE INDEX deney_outbox_pkey ON public.deney_outbox USING btree (id)
  • CREATE INDEX deney_parties_company ON public.deney_parties USING btree (company_id)
  • CREATE UNIQUE INDEX deney_parties_pkey ON public.deney_parties USING btree (id)
  • CREATE UNIQUE INDEX deney_periods_pkey ON public.deney_periods USING btree (id)
  • CREATE UNIQUE INDEX deney_trial_balance_key ON public.deney_trial_balance USING btree (company_id, period_id, account)
  • CREATE INDEX deney_vouchers_company_period_date ON public.deney_vouchers USING btree (company_id, period_id, date) WHERE ((status)::text = 'posted'::text)
  • CREATE INDEX deney_vouchers_date ON public.deney_vouchers USING btree (date) WHERE ((status)::text = 'posted'::text)
  • CREATE UNIQUE INDEX deney_vouchers_idempotency_key_key ON public.deney_vouchers USING btree (idempotency_key)
  • CREATE UNIQUE INDEX deney_vouchers_pkey ON public.deney_vouchers USING btree (id)
  • CREATE UNIQUE INDEX deney_vouchers_reversal_of_key ON public.deney_vouchers USING btree (reversal_of)

1000000-A-20261016-231526-e5af45c4e1136815c4fa1687.json

Donanım: {"cpu":"AMD EPYC 9454P","vcpus":16,"ram_gb":31,"database_colocated":true}

PostgreSQL: PostgreSQL 16.15 (Ubuntu 16.15-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit

  • CREATE UNIQUE INDEX deney_accounts_pkey ON public.deney_accounts USING btree (code)
  • CREATE UNIQUE INDEX deney_aggregates_pkey ON public.deney_aggregates USING btree (architecture, node, key)
  • CREATE UNIQUE INDEX deney_branches_pkey ON public.deney_branches USING btree (id)
  • CREATE UNIQUE INDEX deney_companies_pkey ON public.deney_companies USING btree (id)
  • CREATE UNIQUE INDEX deney_currencies_pkey ON public.deney_currencies USING btree (code)
  • CREATE INDEX deney_lines_account_voucher ON public.deney_lines USING btree (account, voucher_id)
  • CREATE INDEX deney_lines_party_voucher ON public.deney_lines USING btree (party_id, voucher_id) WHERE (party_id IS NOT NULL)
  • CREATE UNIQUE INDEX deney_lines_pkey ON public.deney_lines USING btree (id)
  • CREATE INDEX deney_lines_voucher ON public.deney_lines USING btree (voucher_id)
  • CREATE UNIQUE INDEX deney_outbox_pkey ON public.deney_outbox USING btree (id)
  • CREATE INDEX deney_parties_company ON public.deney_parties USING btree (company_id)
  • CREATE UNIQUE INDEX deney_parties_pkey ON public.deney_parties USING btree (id)
  • CREATE UNIQUE INDEX deney_periods_pkey ON public.deney_periods USING btree (id)
  • CREATE UNIQUE INDEX deney_trial_balance_key ON public.deney_trial_balance USING btree (company_id, period_id, account)
  • CREATE INDEX deney_vouchers_company_period_date ON public.deney_vouchers USING btree (company_id, period_id, date) WHERE ((status)::text = 'posted'::text)
  • CREATE INDEX deney_vouchers_date ON public.deney_vouchers USING btree (date) WHERE ((status)::text = 'posted'::text)
  • CREATE UNIQUE INDEX deney_vouchers_idempotency_key_key ON public.deney_vouchers USING btree (idempotency_key)
  • CREATE UNIQUE INDEX deney_vouchers_pkey ON public.deney_vouchers USING btree (id)
  • CREATE UNIQUE INDEX deney_vouchers_reversal_of_key ON public.deney_vouchers USING btree (reversal_of)

100000-C-20261016-231233-3c8b8e20929c721e1c9d7627.json

Donanım: {"cpu":"AMD EPYC 9454P","vcpus":16,"ram_gb":31,"database_colocated":true}

PostgreSQL: PostgreSQL 16.15 (Ubuntu 16.15-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit

  • CREATE UNIQUE INDEX deney_accounts_pkey ON public.deney_accounts USING btree (code)
  • CREATE UNIQUE INDEX deney_aggregates_pkey ON public.deney_aggregates USING btree (architecture, node, key)
  • CREATE UNIQUE INDEX deney_branches_pkey ON public.deney_branches USING btree (id)
  • CREATE UNIQUE INDEX deney_companies_pkey ON public.deney_companies USING btree (id)
  • CREATE UNIQUE INDEX deney_currencies_pkey ON public.deney_currencies USING btree (code)
  • CREATE INDEX deney_lines_account_voucher ON public.deney_lines USING btree (account, voucher_id)
  • CREATE INDEX deney_lines_party_voucher ON public.deney_lines USING btree (party_id, voucher_id) WHERE (party_id IS NOT NULL)
  • CREATE UNIQUE INDEX deney_lines_pkey ON public.deney_lines USING btree (id)
  • CREATE INDEX deney_lines_voucher ON public.deney_lines USING btree (voucher_id)
  • CREATE UNIQUE INDEX deney_outbox_pkey ON public.deney_outbox USING btree (id)
  • CREATE INDEX deney_parties_company ON public.deney_parties USING btree (company_id)
  • CREATE UNIQUE INDEX deney_parties_pkey ON public.deney_parties USING btree (id)
  • CREATE UNIQUE INDEX deney_periods_pkey ON public.deney_periods USING btree (id)
  • CREATE UNIQUE INDEX deney_trial_balance_key ON public.deney_trial_balance USING btree (company_id, period_id, account)
  • CREATE INDEX deney_vouchers_company_period_date ON public.deney_vouchers USING btree (company_id, period_id, date) WHERE ((status)::text = 'posted'::text)
  • CREATE INDEX deney_vouchers_date ON public.deney_vouchers USING btree (date) WHERE ((status)::text = 'posted'::text)
  • CREATE UNIQUE INDEX deney_vouchers_idempotency_key_key ON public.deney_vouchers USING btree (idempotency_key)
  • CREATE UNIQUE INDEX deney_vouchers_pkey ON public.deney_vouchers USING btree (id)
  • CREATE UNIQUE INDEX deney_vouchers_reversal_of_key ON public.deney_vouchers USING btree (reversal_of)

100000-B-20261016-230857-3c8b8e20929c721e1c9d7627.json

Donanım: {"cpu":"AMD EPYC 9454P","vcpus":16,"ram_gb":31,"database_colocated":true}

PostgreSQL: PostgreSQL 16.15 (Ubuntu 16.15-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit

  • CREATE UNIQUE INDEX deney_accounts_pkey ON public.deney_accounts USING btree (code)
  • CREATE UNIQUE INDEX deney_aggregates_pkey ON public.deney_aggregates USING btree (architecture, node, key)
  • CREATE UNIQUE INDEX deney_branches_pkey ON public.deney_branches USING btree (id)
  • CREATE UNIQUE INDEX deney_companies_pkey ON public.deney_companies USING btree (id)
  • CREATE UNIQUE INDEX deney_currencies_pkey ON public.deney_currencies USING btree (code)
  • CREATE INDEX deney_lines_account_voucher ON public.deney_lines USING btree (account, voucher_id)
  • CREATE INDEX deney_lines_party_voucher ON public.deney_lines USING btree (party_id, voucher_id) WHERE (party_id IS NOT NULL)
  • CREATE UNIQUE INDEX deney_lines_pkey ON public.deney_lines USING btree (id)
  • CREATE INDEX deney_lines_voucher ON public.deney_lines USING btree (voucher_id)
  • CREATE UNIQUE INDEX deney_outbox_pkey ON public.deney_outbox USING btree (id)
  • CREATE INDEX deney_parties_company ON public.deney_parties USING btree (company_id)
  • CREATE UNIQUE INDEX deney_parties_pkey ON public.deney_parties USING btree (id)
  • CREATE UNIQUE INDEX deney_periods_pkey ON public.deney_periods USING btree (id)
  • CREATE UNIQUE INDEX deney_trial_balance_key ON public.deney_trial_balance USING btree (company_id, period_id, account)
  • CREATE INDEX deney_vouchers_company_period_date ON public.deney_vouchers USING btree (company_id, period_id, date) WHERE ((status)::text = 'posted'::text)
  • CREATE INDEX deney_vouchers_date ON public.deney_vouchers USING btree (date) WHERE ((status)::text = 'posted'::text)
  • CREATE UNIQUE INDEX deney_vouchers_idempotency_key_key ON public.deney_vouchers USING btree (idempotency_key)
  • CREATE UNIQUE INDEX deney_vouchers_pkey ON public.deney_vouchers USING btree (id)
  • CREATE UNIQUE INDEX deney_vouchers_reversal_of_key ON public.deney_vouchers USING btree (reversal_of)

100000-A-20261016-230507-3c8b8e20929c721e1c9d7627.json

Donanım: {"cpu":"AMD EPYC 9454P","vcpus":16,"ram_gb":31,"database_colocated":true}

PostgreSQL: PostgreSQL 16.15 (Ubuntu 16.15-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit

  • CREATE UNIQUE INDEX deney_accounts_pkey ON public.deney_accounts USING btree (code)
  • CREATE UNIQUE INDEX deney_aggregates_pkey ON public.deney_aggregates USING btree (architecture, node, key)
  • CREATE UNIQUE INDEX deney_branches_pkey ON public.deney_branches USING btree (id)
  • CREATE UNIQUE INDEX deney_companies_pkey ON public.deney_companies USING btree (id)
  • CREATE UNIQUE INDEX deney_currencies_pkey ON public.deney_currencies USING btree (code)
  • CREATE INDEX deney_lines_account_voucher ON public.deney_lines USING btree (account, voucher_id)
  • CREATE INDEX deney_lines_party_voucher ON public.deney_lines USING btree (party_id, voucher_id) WHERE (party_id IS NOT NULL)
  • CREATE UNIQUE INDEX deney_lines_pkey ON public.deney_lines USING btree (id)
  • CREATE INDEX deney_lines_voucher ON public.deney_lines USING btree (voucher_id)
  • CREATE UNIQUE INDEX deney_outbox_pkey ON public.deney_outbox USING btree (id)
  • CREATE INDEX deney_parties_company ON public.deney_parties USING btree (company_id)
  • CREATE UNIQUE INDEX deney_parties_pkey ON public.deney_parties USING btree (id)
  • CREATE UNIQUE INDEX deney_periods_pkey ON public.deney_periods USING btree (id)
  • CREATE UNIQUE INDEX deney_trial_balance_key ON public.deney_trial_balance USING btree (company_id, period_id, account)
  • CREATE INDEX deney_vouchers_company_period_date ON public.deney_vouchers USING btree (company_id, period_id, date) WHERE ((status)::text = 'posted'::text)
  • CREATE INDEX deney_vouchers_date ON public.deney_vouchers USING btree (date) WHERE ((status)::text = 'posted'::text)
  • CREATE UNIQUE INDEX deney_vouchers_idempotency_key_key ON public.deney_vouchers USING btree (idempotency_key)
  • CREATE UNIQUE INDEX deney_vouchers_pkey ON public.deney_vouchers USING btree (id)
  • CREATE UNIQUE INDEX deney_vouchers_reversal_of_key ON public.deney_vouchers USING btree (reversal_of)

100000-A-20261016-225128-43e0491f041c58fb814a9953.json

Donanım: {"cpu":"AMD EPYC 9454P","vcpus":16,"ram_gb":31,"database_colocated":true}

PostgreSQL: PostgreSQL 16.15 (Ubuntu 16.15-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit

  • CREATE UNIQUE INDEX deney_accounts_pkey ON public.deney_accounts USING btree (code)
  • CREATE UNIQUE INDEX deney_aggregates_pkey ON public.deney_aggregates USING btree (architecture, node, key)
  • CREATE UNIQUE INDEX deney_branches_pkey ON public.deney_branches USING btree (id)
  • CREATE UNIQUE INDEX deney_companies_pkey ON public.deney_companies USING btree (id)
  • CREATE UNIQUE INDEX deney_currencies_pkey ON public.deney_currencies USING btree (code)
  • CREATE INDEX deney_lines_account_voucher ON public.deney_lines USING btree (account, voucher_id)
  • CREATE INDEX deney_lines_party_voucher ON public.deney_lines USING btree (party_id, voucher_id) WHERE (party_id IS NOT NULL)
  • CREATE UNIQUE INDEX deney_lines_pkey ON public.deney_lines USING btree (id)
  • CREATE INDEX deney_lines_voucher ON public.deney_lines USING btree (voucher_id)
  • CREATE UNIQUE INDEX deney_outbox_pkey ON public.deney_outbox USING btree (id)
  • CREATE INDEX deney_parties_company ON public.deney_parties USING btree (company_id)
  • CREATE UNIQUE INDEX deney_parties_pkey ON public.deney_parties USING btree (id)
  • CREATE UNIQUE INDEX deney_periods_pkey ON public.deney_periods USING btree (id)
  • CREATE UNIQUE INDEX deney_trial_balance_key ON public.deney_trial_balance USING btree (company_id, period_id, account)
  • CREATE INDEX deney_vouchers_company_period_date ON public.deney_vouchers USING btree (company_id, period_id, date) WHERE ((status)::text = 'posted'::text)
  • CREATE INDEX deney_vouchers_date ON public.deney_vouchers USING btree (date) WHERE ((status)::text = 'posted'::text)
  • CREATE UNIQUE INDEX deney_vouchers_idempotency_key_key ON public.deney_vouchers USING btree (idempotency_key)
  • CREATE UNIQUE INDEX deney_vouchers_pkey ON public.deney_vouchers USING btree (id)
  • CREATE UNIQUE INDEX deney_vouchers_reversal_of_key ON public.deney_vouchers USING btree (reversal_of)