explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5mAq

Settings
# 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