explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5Q0n

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 96,817.887 ↑ 1.0 10 1

Limit (cost=234,191.16..234,192.37 rows=10 width=328) (actual time=96,723.781..96,817.887 rows=10 loops=1)

2. 97.478 96,817.883 ↑ 404,253.0 10 1

Gather Merge (cost=234,191.16..723,033.34 rows=4,042,530 width=328) (actual time=96,723.780..96,817.883 rows=10 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
3. 438.031 96,720.405 ↑ 80,850.6 10 6 / 6

Sort (cost=233,191.08..235,212.35 rows=808,506 width=328) (actual time=96,720.404..96,720.405 rows=10 loops=6)

  • Sort Key: (((tweet ->> 'timestamp_ms'::text))::bigint)
  • Sort Method: top-N heapsort Memory: 33kB
  • Worker 0: Sort Method: top-N heapsort Memory: 30kB
  • Worker 1: Sort Method: top-N heapsort Memory: 32kB
  • Worker 2: Sort Method: top-N heapsort Memory: 31kB
  • Worker 3: Sort Method: top-N heapsort Memory: 32kB
  • Worker 4: Sort Method: top-N heapsort Memory: 30kB
4. 96,282.374 96,282.374 ↑ 1.2 673,755 6 / 6

Parallel Seq Scan on tweets_jsonb (cost=0.00..215,719.56 rows=808,506 width=328) (actual time=0.131..96,282.374 rows=673,755 loops=6)

Planning time : 0.057 ms
Execution time : 96,817.941 ms