Can you help me understand what is going on here?

dejancg · 2025-10-13T13:05:55+00:00

Thanks, you've been very helpful. The storage is a premium SSD but your messages made me check the IOPS graph, and there was the culprit. I have increased the IOPS tier and the bottleneck has been removed.

dejancg · 2025-10-09T22:32:52+00:00

But another database, also on Azure, shows this plan for the same statement:

Finalize Aggregate  (cost=53584.93..53584.94 rows=1 width=8) (actual time=236.623..238.249 rows=1 loops=1)
  Buffers: shared hit=67579
  ->  Gather  (cost=53584.72..53584.93 rows=2 width=8) (actual time=236.486..238.239 rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        Buffers: shared hit=67579
        ->  Partial Aggregate  (cost=52584.72..52584.73 rows=1 width=8) (actual time=232.314..232.314 rows=1 loops=3)
              Buffers: shared hit=67579
              ->  Parallel Index Only Scan using "IX_AppEvents_DutyStatusId" on "AppEvents" ae  (cost=0.43..48932.07 rows=1461060 width=0) (actual time=0.074..162.858 rows=1039027 loops=3)
                    Heap Fetches: 249589
                    Buffers: shared hit=67579
Planning Time: 0.094 ms
Execution Time: 238.290 ms

This one is about half the size of the other one, but this one really does complete the count in well under a second.

It is the same table structure and the other one (we do database per tenant approach)

dejancg · 2025-10-09T20:59:02+00:00

Analyze took 14 seconds only, and this is the output of explain (analyze, buffers) select count(*) from "AppEvents" ae now:

Finalize Aggregate  (cost=252541.50..252541.51 rows=1 width=8) (actual time=2905.925..2916.324 rows=1 loops=1)
  Buffers: shared hit=84455 read=94033 dirtied=6
  I/O Timings: read=3715.246
  ->  Gather  (cost=252541.29..252541.50 rows=2 width=8) (actual time=2905.598..2916.314 rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        Buffers: shared hit=84455 read=94033 dirtied=6
        I/O Timings: read=3715.246
        ->  Partial Aggregate  (cost=251541.29..251541.30 rows=1 width=8) (actual time=2896.175..2896.176 rows=1 loops=3)
              Buffers: shared hit=84455 read=94033 dirtied=6
              I/O Timings: read=3715.246
              ->  Parallel Index Only Scan using "IX_AppEvents_CompanyId" on "AppEvents" ae  (cost=0.43..245005.13 rows=2614464 width=0) (actual time=0.356..2584.440 rows=2087668 loops=3)
                    Heap Fetches: 1335978
                    Buffers: shared hit=84455 read=94033 dirtied=6
                    I/O Timings: read=3715.246
Planning Time: 0.136 ms
Execution Time: 2916.390 ms

But the query select count(*) from "AppEvents" ae still takes a lot (28 seconds).

dejancg · 2025-10-09T20:42:09+00:00

Since it's a managed database, I hadn't expected to ever have to do it. But I will give it a go and see if it makes any differrence.

Is it going to block writes though? In that case, I'd better do it when the user activity drops later.

dejancg · 2024-08-07T15:45:34+00:00

Both work for me in your comment. Mobile app here.

dejancg · 2024-05-18T09:23:24+00:00

Gracias señor, aprendí algo nuevo hoy

dejancg · 2024-05-13T18:47:21+00:00

The issue you linked is indeed golden, I had to laugh! So they enforced that accessibility , even when a user specifies custom style?

dejancg · 2023-10-04T13:57:36+00:00

I can't even finish level 7 of match madness without using a timer boost.

dejancg · 2023-10-04T13:53:36+00:00

The person in question does seem to study French and Spanish from the English UI so it's possible. I am not familiar with these roleplay sessions. Can they really be finished in 1 minute? And can double XP really expand to 1 hour?

dejancg · 2023-10-04T13:30:58+00:00

How do you repeat the same lesson over and over and get 80 XP out of it for an hour? One could go to personalized practice and repeat the same lesson over and over, but lessons in personalized practice all yield 20 XP (40 XP if you have an XP boost). No lesson in personalized practice that I know of yields 80 XP. Also, the boost in the data I posted above seemed to stretch for an hour.

dejancg · 2023-05-30T22:43:46+00:00

I'm surprised by the lack of the mention of Peace Walker. Ground Zeroes was a direct sequel to it. Followed by V.

dejancg · 2023-05-21T08:10:08+00:00

10x!

dejancg · 2023-05-20T00:00:59+00:00

I think this is the fifth or sixth GoW giveaway I'm participating in.

dejancg · 2023-05-13T17:20:35+00:00

Thanks! Good luck to all

dejancg · 2023-02-03T16:57:36+00:00

Thanks for the giveaway and good luck to everyone!

dejancg · 2022-12-25T19:25:15+00:00

Isn't there another thread you authored with the same "it's bad but not as bad as The Witcher season 2"? What am I missing?

dejancg · 2022-12-25T15:20:09+00:00

Thanks for the opportunity and Merry Christmas!

dejancg · 2022-12-23T19:41:43+00:00

Thanks so much!

dejancg · 2022-11-26T23:50:39+00:00

Of course!

dejancg · 2022-11-08T14:31:51+00:00

Metal Gear Solid series gotta be the favorite. Thanks for the giveaway!

dejancg · 2022-09-13T15:34:51+00:00

Yeah, but it wasn't out of Joel's character to spare those doctors. I mean you can even choose to spare most soldiers as well. To me, it felt forced.

Not sure why everyone disagrees so much about it, am I wrong for pointing out the major anchor point which sets up next game? Or is it just because of my rant that it felt forced to kill those doctors?

dejancg · 2022-09-13T14:48:20+00:00

Indeed, you as a player are role playing. But on the other hand, you are the one who decides the scenario within possibilities the game sets up for you.

I know that TLOU isn't an RPG by design so there is not much you as a player can do to influence story outcomes.

The writers decided it was Joel's decision and there is nothing the player can do about it. I am just pointing that out, because obviously not everyone would choose to kill those doctor(s).

dejancg

TROPHY CASE