explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RXbq

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 387.639 23,826.124 ↑ 190.7 1,776 1

GroupAggregate (cost=631,282.11..671,932.05 rows=338,750 width=12) (actual time=22,576.318..23,826.124 rows=1,776 loops=1)

2. 21,483.620 23,438.485 ↓ 1.0 3,536,790 1

Sort (cost=631,282.11..639,750.85 rows=3,387,494 width=12) (actual time=22,576.188..23,438.485 rows=3,536,790 loops=1)

  • Sort Key: (date_trunc('hour'::text, ('1970-01-01 00:00:00'::timestamp without time zone + ((social_creation_time)::double precision * '00:00:01'::interval)))), network
  • Sort Method: external merge Disk: 92032kB
3. 1,954.865 1,954.865 ↓ 1.0 3,536,790 1

Seq Scan on posts (cost=0.00..205,984.62 rows=3,387,494 width=12) (actual time=29.542..1,954.865 rows=3,536,790 loops=1)

  • Filter: (((moderation)::text <> ALL ('{junk,spam}'::text[])) AND (social_creation_time >= 1391716800) AND (social_creation_time <= 1392839999) AND (project_id = 7))
  • Rows Removed by Filter: 404218
Total runtime : 23,842.532 ms