explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yZPu

Settings
# exclusive inclusive rows x rows loops node
1. 0.725 0.861 ↓ 0.0 1 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=0.860..0.861 rows=1 loops=1)

  • Output: remote_scan.user_id, remote_scan.score
  • Task Count: 1
  • Tasks Shown: All
  • -> Task
  • Node: host=192.168.100.180 port=5,432 dbname=postgres
2. 0.010 0.136 ↑ 29.0 1 1

GroupAggregate (cost=4.65..118.39 rows=29 width=16) (actual time=0.136..0.136 rows=1 loops=1)

  • Output: user_id, sum(score)
  • Group Key: user_scores.user_id
3. 0.048 0.126 ↓ 1.0 30 1

Bitmap Heap Scan on public.user_scores_102201 user_scores (cost=4.65..117.95 rows=29 width=12) (actual time=0.090..0.126 rows=30 loops=1)

  • Output: id, user_id, event_id, score, inserted_at
  • Recheck Cond: (user_scores.user_id = 1,000,124)
  • Heap Blocks: exact=30
4. 0.078 0.078 ↓ 1.0 30 1

Bitmap Index Scan on user_scores_user_id_index_102201 (cost=0.00..4.65 rows=29 width=0) (actual time=0.078..0.078 rows=30 loops=1)

  • Index Cond: (user_scores.user_id = 1,000,124)
Planning time : 0.072 ms
Execution time : 0.882 ms