explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J7gR

Settings
# exclusive inclusive rows x rows loops node
1. 0.111 2,629.973 ↓ 1.2 266 1

Group (cost=52,530.30..52,532.43 rows=213 width=21) (actual time=2,629.811..2,629.973 rows=266 loops=1)

  • Group Key: cashier_id
2. 4.892 2,629.862 ↓ 1.7 740 1

Sort (cost=52,530.30..52,531.37 rows=426 width=21) (actual time=2,629.810..2,629.862 rows=740 loops=1)

  • Sort Key: cashier_id
  • Sort Method: quicksort Memory: 82kB
3. 5.359 2,624.970 ↓ 1.7 740 1

Gather (cost=52,466.97..52,511.70 rows=426 width=21) (actual time=2,624.701..2,624.970 rows=740 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 214.690 2,619.611 ↓ 1.2 247 3

Partial HashAggregate (cost=51,466.97..51,469.10 rows=213 width=21) (actual time=2,619.574..2,619.611 rows=247 loops=3)

  • Group Key: cashier_id
5. 2,404.921 2,404.921 ↑ 1.2 624,713 3

Parallel Seq Scan on transactions (cost=0.00..49,514.89 rows=780,830 width=21) (actual time=135.773..2,404.921 rows=624,713 loops=3)

  • Filter: ((NOT archived) AND (created_at > '1525773979247'::bigint) AND (created_at < '1559901979247'::bigint))
  • Rows Removed by Filter: 78169
Planning time : 0.179 ms
Execution time : 2,630.061 ms