explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ErCQ

Settings
# exclusive inclusive rows x rows loops node
1. 4.531 1,568.077 ↓ 1.2 10,000 1

Limit (cost=43,619.49..44,779.79 rows=8,621 width=62) (actual time=1,543.348..1,568.077 rows=10,000 loops=1)

2. 10.105 1,563.546 ↓ 1.2 10,000 1

Finalize GroupAggregate (cost=43,619.49..44,779.79 rows=8,621 width=62) (actual time=1,543.347..1,563.546 rows=10,000 loops=1)

  • Group Key: (date_trunc('minute'::text, inserted_at)), body
3. 60.465 1,553.441 ↓ 1.4 10,001 1

Gather Merge (cost=43,619.49..44,531.81 rows=7,202 width=38) (actual time=1,543.323..1,553.441 rows=10,001 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 2.403 1,492.976 ↓ 1.1 3,782 3 / 3

Partial GroupAggregate (cost=42,619.47..42,700.49 rows=3,601 width=38) (actual time=1,490.227..1,492.976 rows=3,782 loops=3)

  • Group Key: (date_trunc('minute'::text, inserted_at)), body
5. 864.818 1,490.573 ↓ 1.1 3,788 3 / 3

Sort (cost=42,619.47..42,628.47 rows=3,601 width=30) (actual time=1,490.215..1,490.573 rows=3,788 loops=3)

  • Sort Key: (date_trunc('minute'::text, inserted_at)) DESC, body
  • Sort Method: quicksort Memory: 31991kB
  • Worker 0: Sort Method: quicksort Memory: 24649kB
  • Worker 1: Sort Method: quicksort Memory: 31243kB
6. 625.755 625.755 ↓ 79.3 285,728 3 / 3

Parallel Seq Scan on messages (cost=0.00..42,406.76 rows=3,601 width=30) (actual time=0.015..625.755 rows=285,728 loops=3)

  • Filter: ((("user")::text = 'bashboard'::text) AND ((dash)::text = 'system'::text) AND ((widget)::text = 'Uptime-(hours)'::text) AND ((jsonb_typeof(body) = 'number'::text) OR (jsonb_typeof(body) = 'string'::text)))
  • Rows Removed by Filter: 286130
Planning time : 0.154 ms
Execution time : 1,568.686 ms