explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1U75

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 0.374 ↓ 2.0 2 1

Sort (cost=1.24..1.25 rows=1 width=64) (actual time=0.357..0.374 rows=2 loops=1)

  • Sort Key: (min(created_at))
  • Sort Method: quicksort Memory: 25kB
2. 0.058 0.337 ↓ 2.0 2 1

HashAggregate (cost=1.22..1.23 rows=1 width=64) (actual time=0.325..0.337 rows=2 loops=1)

  • Group Key: entity_id, short_code
3. 0.279 0.279 ↓ 8.0 8 1

Seq Scan on reactions_spike_1 (cost=0.00..1.21 rows=1 width=56) (actual time=0.235..0.279 rows=8 loops=1)

  • Filter: (entity_id = 'efdada9a-f25a-4135-9735-47cb5102632e'::uuid)
  • Rows Removed by Filter: 10
Planning time : 0.967 ms
Execution time : 0.468 ms