How Many Database Queries Do NSA Analysts Perform Each Day?

Facts matter: Sign up for the free Mother Jones Daily newsletter. Support our nonprofit reporting. Subscribe to our print magazine.


Last night, based on a statement from the NSA’s director of compliance, I wrote that NSA analysts performed about 600,000 database queries per day. This prompted several suggestions on Twitter that perhaps I was unfamiliar with SQL and had no idea how databases work. For example, this one:

@ggreenwald @kdrum select * from news.articles where technical_literacy < 0 limit 600000

Snark aside, this tweet is pointing out that a single query can return many records from a database, so perhaps the NSA’s estimate referred to the total number of records they retrieved, not the actual number of queries they made. Maybe! But according to the New York Times, the NSA guy said “the agency performs about 20 million such queries each month.” Is it possible that he misspoke? Or that the reporter misinterpreted him? Sure. But it doesn’t sound like it. There’s nothing there about the number of records retrieved. He said the agency “performs” 20 million queries per month.

As I mentioned last night, it’s possible that many of these are automated queries for one purpose or another. Actual human beings might perform only a fraction of them. Until there’s some clarification from NSA, though, there’s no particular reason to think that. For now, anyway, it sounds like he’s talking about actual queries from NSA analysts.

We've never been very good at being conservative.

And usually, that serves us well in doing the ambitious, hard-hitting journalism that you turn to Mother Jones for. But it also means we can't afford to come up short when it comes to scratching together the funds it takes to keep our team firing on all cylinders, and the truth is, we finished our budgeting cycle on June 30 about $100,000 short of our online goal.

This is no time to come up short. It's time to fight like hell, as our namesake would tell us to do, for a democracy where minority rule cannot impose an extreme agenda, where facts matter, and where accountability has a chance at the polls and in the press. If you value our reporting and you can right now, please help us dig out of the $100,000 hole we're starting our new budgeting cycle in with an always-needed and always-appreciated donation today.

payment methods

We've never been very good at being conservative.

And usually, that serves us well in doing the ambitious, hard-hitting journalism that you turn to Mother Jones for. But it also means we can't afford to come up short when it comes to scratching together the funds it takes to keep our team firing on all cylinders, and the truth is, we finished our budgeting cycle on June 30 about $100,000 short of our online goal.

This is no time to come up short. It's time to fight like hell, as our namesake would tell us to do, for a democracy where minority rule cannot impose an extreme agenda, where facts matter, and where accountability has a chance at the polls and in the press. If you value our reporting and you can right now, please help us dig out of the $100,000 hole we're starting our new budgeting cycle in with an always-needed and always-appreciated donation today.

payment methods

We Recommend

Latest

Sign up for our free newsletter

Subscribe to the Mother Jones Daily to have our top stories delivered directly to your inbox.

Get our award-winning magazine

Save big on a full year of investigations, ideas, and insights.

Subscribe

Support our journalism

Help Mother Jones' reporters dig deep with a tax-deductible donation.

Donate