explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ozn9

Settings
# exclusive inclusive rows x rows loops node
1. 2.080 2.151 ↓ 0.0 1 1

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

  • Output: remote_scan.user_id, remote_scan.score
  • Task Count: 1
  • Tasks Shown: All
  • -> Task
  • Node: host=192.168.100.179 port=5,432 dbname=postgres
2. 0.012 0.071 ↑ 184.0 1 1

GroupAggregate (cost=12.21..694.87 rows=184 width=16) (actual time=0.071..0.071 rows=1 loops=1)

  • Output: user_id, sum(score)
  • Group Key: user_scores.user_id
3. 0.034 0.059 ↑ 50.5 10 1

Bitmap Heap Scan on public.user_scores_102392 user_scores (cost=12.21..690.50 rows=505 width=12) (actual time=0.036..0.059 rows=10 loops=1)

  • Output: user_id, event_id, score, inserted_at
  • Recheck Cond: (user_scores.user_id = 100,427)
  • Heap Blocks: exact=10
4. 0.025 0.025 ↑ 50.5 10 1

Bitmap Index Scan on user_scores_user_id_index_102392 (cost=0.00..12.08 rows=505 width=0) (actual time=0.025..0.025 rows=10 loops=1)

  • Index Cond: (user_scores.user_id = 100,427)
Planning time : 0.112 ms
Execution time : 2.182 ms