How Many Database Queries Do NSA Analysts Perform Each Day?

Let our journalists help you make sense of the noise: Subscribe to the Mother Jones Daily newsletter and get a recap of news that matters.


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.

IT'S NOT THAT WE'RE SCREWED WITHOUT TRUMP:

"It's that we're screwed with or without him if we can't show the public that what we do matters for the long term," writes Mother Jones CEO Monika Bauerlein as she kicks off our drive to raise $350,000 in donations from readers by July 17.

This is a big one for us. It's our first time asking for an outpouring of support since screams of FAKE NEWS and so much of what Trump stood for made everything we do so visceral. Like most newsrooms, we face incredibly hard budget realities, and it's unnerving needing to raise big money when traffic is down.

So, as we ask you to consider supporting our team's journalism, we thought we'd slow down and check in about where Mother Jones is and where we're going after the chaotic last several years. This comparatively slow moment is also an urgent one for Mother Jones: You can read more in "Slow News Is Good News," and if you're able to, please support our team's hard-hitting journalism and help us reach our big $350,000 goal with a donation today.

payment methods

IT'S NOT THAT WE'RE SCREWED WITHOUT TRUMP:

"It's that we're screwed with or without him if we can't show the public that what we do matters for the long term," writes Mother Jones CEO Monika Bauerlein as she kicks off our drive to raise $350,000 in donations from readers by July 17.

This is a big one for us. So, as we ask you to consider supporting our team's journalism, we thought we'd slow down and check in about where Mother Jones is and where we're going after the chaotic last several years. This comparatively slow moment is also an urgent one for Mother Jones: You can read more in "Slow News Is Good News," and if you're able to, please support our team's hard-hitting journalism and help us reach our big $350,000 goal with a 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