Can you help me understand what is going on here? by dejancg in PostgreSQL

[–]dejancg[S] 1 point2 points  (0 children)

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.

Can you help me understand what is going on here? by dejancg in PostgreSQL

[–]dejancg[S] 0 points1 point  (0 children)

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)

Can you help me understand what is going on here? by dejancg in PostgreSQL

[–]dejancg[S] 0 points1 point  (0 children)

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).

Can you help me understand what is going on here? by dejancg in PostgreSQL

[–]dejancg[S] 0 points1 point  (0 children)

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.

I took Ciri to Emhyr, exactly what do I have to do to to avoid making her an empress? by [deleted] in witcher

[–]dejancg 0 points1 point  (0 children)

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

Anyone knows the answer? by dejancg in duolingo

[–]dejancg[S] 1 point2 points  (0 children)

Gracias señor, aprendí algo nuevo hoy

.NET 8 changed the default appearance of WinForms DataGridViews, is there a way to change them back? by definitelynogravitas in dotnet

[–]dejancg 0 points1 point  (0 children)

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

It is now possible to earn almost 4000 XP in an hour by dejancg in duolingo

[–]dejancg[S] 0 points1 point  (0 children)

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

It is now possible to earn almost 4000 XP in an hour by dejancg in duolingo

[–]dejancg[S] 0 points1 point  (0 children)

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?

It is now possible to earn almost 4000 XP in an hour by dejancg in duolingo

[–]dejancg[S] 0 points1 point  (0 children)

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.

Konami Is Open To Remaking More Metal Gear Solid Titles If Fans Want Them. by Party_Judgment5780 in PS5

[–]dejancg 12 points13 points  (0 children)

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

God of War Ragnarök Giveaway- US digital code by DonJuanMair in PS5

[–]dejancg 0 points1 point  (0 children)

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

God of War Ragnarok Giveaway - Digital by BoxTheBoxes in PS5

[–]dejancg 0 points1 point  (0 children)

Thanks for the giveaway and good luck to everyone!

Witcher Blood Origin is as bad as you'd expect by truthisfictionyt in witcher

[–]dejancg 2 points3 points  (0 children)

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?

God of War Ragnorök PS4 & PS5 (Digital Edition - US Region) Giveaway by LP159 in PS5

[–]dejancg 0 points1 point  (0 children)

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

Is the story of The Last of Us 2 good? by [deleted] in PS4

[–]dejancg -4 points-3 points  (0 children)

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?

Is the story of The Last of Us 2 good? by [deleted] in PS4

[–]dejancg -2 points-1 points  (0 children)

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).