explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mCSR

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,421.737 ↓ 7.8 344 1

Limit (cost=386,076.98..386,082.12 rows=44 width=20) (actual time=2,421.694..2,421.737 rows=344 loops=1)

  • Buffers: shared hit=1 read=121,500
2. 5.921 2,421.750 ↓ 7.8 344 1

Gather Merge (cost=386,076.98..386,082.12 rows=44 width=20) (actual time=2,421.693..2,421.750 rows=344 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=2,335 read=359,528
3. 0.126 2,415.829 ↓ 5.2 115 3 / 3

Sort (cost=385,076.96..385,077.01 rows=22 width=20) (actual time=2,415.825..2,415.829 rows=115 loops=3)

  • Sort Key: score DESC
  • Sort Method: quicksort Memory: 29kB
  • Worker 0: Sort Method: quicksort Memory: 44kB
  • Worker 1: Sort Method: quicksort Memory: 28kB
  • Buffers: shared hit=2,335 read=359,528
4. 2,415.703 2,415.703 ↓ 5.2 115 3 / 3

Parallel Seq Scan on posts p (cost=0.00..385,076.47 rows=22 width=20) (actual time=1,921.691..2,415.703 rows=115 loops=3)

  • Filter: ((lastactivitydate >= '2012-01-01 00:00:00'::timestamp without time zone) AND (posttypeid = 4))
  • Rows Removed by Filter: 1,242,950
  • Buffers: shared hit=2,241 read=359,528
Planning time : 0.052 ms
Execution time : 2,421.791 ms