« first day (4288 days earlier)      last day (572 days later) » 

12:24 AM
I can safely say that I don’t get it
 
 
2 hours later…
2:24 AM
Have you tried getting it
 
2:55 AM
Yeah you just keep playing hard to get
 
3:24 AM
'Morning all.
From the "life imitates art" department twitter.com/chrisapplegate/status/1572996484983037952
 
 
4 hours later…
7:33 AM
@ErikDarling buying plates for my plate carrier
Morning
 
8:05 AM
@JohnK.N. Why do you need bullet-proof armour? Is your SQL so bad you get threats?
A bulletproof vest, also known as a ballistic vest or a bullet-resistant vest, is an item of body armor that helps absorb the impact and reduce or stop penetration to the torso from firearm-fired projectiles and fragmentation from explosions. The vest may come in a soft form, as worn by many police officers, prison guards, security guards and some private citizens. Prison guards and police may wear soft vests designed to resist stabbing attacks, using metallic or para-aramid components. Soldiers, SWAT teams, marines and special operations forces wear hard armors, either in conjunction with soft...
 
@PaulWhite maybe he is starting his rap group ;)
JEAGL:
Sep 18 at 15:16, by Erik Darling
i'm just trying to figure out what kind of jewelry you can wear when i start my rap group
Sep 18 at 15:17, by ypercubeᵀᴹ
mithril
 
@PaulWhite Part time security job.
 
@ypercubeᵀᴹ 🙂
 
8:31 AM
Morning
 
@JohnK.N. I think you are right, in that the table is likely very wide. But still, 20 min. Having no indexes at all might explain the slowness.
 
9:00 AM
@ypercubeᵀᴹ I think the select count(*) ... is competing with the inserts of the rows. When the question was first posted, OP mentioned 80 Mio rows. Now OP's at 94 Mio rows.
 
A chairde - Morning all!
 
 
1 hour later…
10:06 AM
@JohnK.N. yeah, that could contribute as well.
Also, I believe the table scan can be avoided if vacuum is working OK and there is some smaller index.
If there is no index and high insert/update load, then the table scan is much more slower.
 
 
1 hour later…
11:23 AM
Maybe those 12 million rows added in a day are one long running transaction ;)
 
11:42 AM
Must be a pathological situation of some type
Maybe the database files are hosted on a USB stick
2
 
 
2 hours later…
1:19 PM
on a Raspberry Pi
 
2:09 PM
hosted at AWS via dial-up
 
2:40 PM
Colder than their Glacier Storage
 
3:22 PM
variable is variable-ing again
2
 
@ypercubeᵀᴹ There are some additional details in the question now
 
3:41 PM
yeah, noticed. I don't think it's enough for a definitive answer.
they need an Erik to consult them ;)
 
did someone say invoice
 
4:28 PM
if you say invoice 3 times, Erik appears
 
 
3 hours later…
7:48 PM
or an invoice appears
 
 
4 hours later…
11:50 PM
> variable is variable-ing again
invariably
quite constant
 

« first day (4288 days earlier)      last day (572 days later) »