#	exclusive	inclusive	rows x	rows	loops	node
1.	5.275	1,271.158	↑ 1.0	1	1	→ Aggregate (cost=845,110.21..845,110.22 rows=1 width=8) (actual time=1,271.157..1,271.158 rows=1 loops=1) Buffers: shared hit=202662
2.	1,265.883	1,265.883	↑ 1.1	51,833	1	→ Seq Scan on users (cost=0.00..844,969.99 rows=56,087 width=0) (actual time=0.019..1,265.883 rows=51,833 loops=1) Filter: ((twitter)::text <> ''::text) Rows Removed by Filter: 2487813 Buffers: shared hit=202662

Planning time	:	0.390 ms
Execution time	:	1,271.180 ms

Aggregate  (cost=845110.21..845110.22 rows=1 width=8) (actual time=1271.157..1271.158 rows=1 loops=1)
  Buffers: shared hit=202662
  ->  Seq Scan on users  (cost=0.00..844969.99 rows=56087 width=0) (actual time=0.019..1265.883 rows=51833 loops=1)
        Filter: ((twitter)::text <> ''::text)
        Rows Removed by Filter: 2487813
        Buffers: shared hit=202662
Planning time: 0.390 ms
Execution time: 1271.180 ms

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	5.275 ms	0.4 %
Seq Scan	1	1,265.883 ms	99.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
users	1	1,265.883 ms	99.6 %
Seq Scan	1	1,265.883 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5mAq

Color mode:

Visible columns:

Per node type stats

Per table stats