explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JgtL

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 204.099 ↑ 1.0 1 1

Sort (cost=25,180.39..25,180.39 rows=1 width=24) (actual time=204.099..204.099 rows=1 loops=1)

  • Sort Key: (count(s.*))
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=21146
2. 0.004 204.091 ↑ 1.0 1 1

GroupAggregate (cost=25,180.35..25,180.38 rows=1 width=24) (actual time=204.091..204.091 rows=1 loops=1)

  • Group Key: s.client_id
  • Buffers: shared hit=21146
3. 0.000 204.087 ↓ 1.5 3 1

Sort (cost=25,180.35..25,180.36 rows=2 width=24) (actual time=204.086..204.087 rows=3 loops=1)

  • Sort Key: s.client_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=21146
4. 12.711 206.500 ↓ 1.5 3 1

Gather (cost=25,180.13..25,180.34 rows=2 width=24) (actual time=204.006..206.5 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=21146
5. 43.857 193.789 ↑ 1.0 1 3 / 3

HashAggregate (cost=24,180.13..24,180.14 rows=1 width=24) (actual time=193.788..193.789 rows=1 loops=3)

  • Group Key: s.client_id
  • Buffers: shared hit=21146
6. 149.932 149.932 ↓ 2.6 186,328 3 / 3

Seq Scan on sale s (cost=0..23,823.18 rows=71,391 width=309) (actual time=0.303..149.932 rows=186,328 loops=3)

  • Filter: upper_inf(s.active_range)
  • Buffers: shared hit=21146
Planning time : 0.209 ms
Execution time : 206.614 ms