explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fa4H

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 478.940 ↑ 34.0 1 1

Sort (cost=25,405.59..25,405.67 rows=34 width=26) (actual time=478.939..478.94 rows=1 loops=1)

  • Sort Key: (count(s.*))
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=49 read=21145
2. 0.012 478.923 ↑ 34.0 1 1

GroupAggregate (cost=25,403.87..25,404.72 rows=34 width=26) (actual time=478.923..478.923 rows=1 loops=1)

  • Group Key: c.client_name
  • Buffers: shared hit=46 read=21145
3. 0.000 478.911 ↑ 22.7 3 1

Sort (cost=25,403.87..25,404.04 rows=68 width=26) (actual time=478.911..478.911 rows=3 loops=1)

  • Sort Key: c.client_name
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=46 read=21145
4. 20.901 483.263 ↑ 22.7 3 1

Gather (cost=25,394.66..25,401.8 rows=68 width=26) (actual time=478.625..483.263 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=43 read=21145
5. 57.319 462.362 ↑ 34.0 1 3 / 3

HashAggregate (cost=24,394.66..24,395 rows=34 width=26) (actual time=462.361..462.362 rows=1 loops=3)

  • Group Key: c.client_name
  • Buffers: shared hit=35 read=21145
6. 60.357 405.043 ↓ 2.6 186,328 3 / 3

Hash Join (cost=3.76..24,037.71 rows=71,391 width=311) (actual time=25.264..405.043 rows=186,328 loops=3)

  • Buffers: shared hit=35 read=21145
7. 344.618 344.618 ↓ 2.6 186,328 3 / 3

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

  • Filter: upper_inf(s.active_range)
  • Buffers: shared hit=1 read=21145
8. 0.023 0.068 ↑ 1.0 34 3 / 3

Hash (cost=3.34..3.34 rows=34 width=34) (actual time=0.067..0.068 rows=34 loops=3)

  • Buffers: shared hit=9
9. 0.045 0.045 ↑ 1.0 34 3 / 3

Seq Scan on client c (cost=0..3.34 rows=34 width=34) (actual time=0.026..0.045 rows=34 loops=3)

  • Buffers: shared hit=9
Planning time : 1.335 ms
Execution time : 483.405 ms