explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fl0

Settings
# exclusive inclusive rows x rows loops node
1. 650.113 2,564.731 ↑ 192.3 1,853 1

HashAggregate (cost=247,145.17..254,270.53 rows=356,268 width=12) (actual time=2,564.201..2,564.731 rows=1,853 loops=1)

2. 1,914.618 1,914.618 ↓ 1.0 3,729,876 1

Seq Scan on posts (cost=0.00..220,425.11 rows=3,562,675 width=12) (actual time=32.916..1,914.618 rows=3,729,876 loops=1)

  • Filter: (((moderation)::text <> ALL ('{junk,spam}'::text[])) AND (social_creation_time >= 1,391,716,800) AND (social_creation_time <= 1,392,839,999) AND (project_id = 7))
  • Rows Removed by Filter: 501,865
Total runtime : 2,566.071 ms