Rearranged slow query

slow-postgresql-query.sql

sql> SELECT lab_name, COUNT(*)
FROM (
  SELECT (record ->> 'scientist_id')::BIGINT AS scientist_id
  FROM measurements
  WHERE
    (record ->> 'value_1')::INTEGER = 0 AND
    (record ->> 'value_2')::INTEGER = 0 AND
    (record ->> 'value_3')::INTEGER = 0
) m
JOIN scientist_labs AS s
  ON (m.scientist_id = s.scientist_id)
GROUP BY lab_name
[2016-11-24 00:59:16] 3 rows retrieved starting from 1 in 6m 15s 346ms (execution: 6m 15s 338ms, fetching: 8ms)


sql> SELECT lab_name, SUM(counter)
FROM (
  SELECT COUNT(*) counter, (record ->> 'scientist_id')::BIGINT AS scientist_id
  FROM measurements
  WHERE
    (record ->> 'value_1')::INTEGER = 0 AND
    (record ->> 'value_2')::INTEGER = 0 AND
    (record ->> 'value_3')::INTEGER = 0
  GROUP BY (record ->> 'scientist_id')
) m
JOIN scientist_labs AS s
  ON (m.scientist_id = s.scientist_id)
GROUP BY lab_name
[2016-11-24 00:52:23] 3 rows retrieved starting from 1 in 1s 30ms (execution: 1s 20ms, fetching: 10ms)