explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YkJ

Settings
# exclusive inclusive rows x rows loops node
1. 1,344.301 11,389.509 ↓ 1.5 604,752 1

GroupAggregate (cost=1,434,604.24..1,492,401.50 rows=406,363 width=85) (actual time=9,554.813..11,389.509 rows=604,752 loops=1)

  • Group Key: t.user_hash, t.id_segment, t.id_campaign
  • Buffers: shared hit=46662 read=601502
2. 7,227.454 10,045.208 ↑ 1.3 1,549,184 1

Sort (cost=1,434,604.24..1,439,489.12 rows=1,953,950 width=81) (actual time=9,554.747..10,045.208 rows=1,549,184 loops=1)

  • Sort Key: t.user_hash, t.id_segment, t.id_campaign
  • Sort Method: quicksort Memory: 267007kB
  • Buffers: shared hit=46662 read=601502
3. 3.565 2,817.754 ↑ 1.3 1,549,184 1

Gather (cost=1,000.00..1,230,436.38 rows=1,953,950 width=81) (actual time=0.398..2,817.754 rows=1,549,184 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=46662 read=601502
4. 59.392 2,814.189 ↑ 1.6 516,395 3

Result (cost=0.00..1,042,182.84 rows=814,146 width=81) (actual time=0.060..2,814.189 rows=516,395 loops=3)

  • Buffers: shared hit=46662 read=601502
5. 46.024 2,754.797 ↑ 1.6 516,395 3

Append (cost=0.00..1,034,041.38 rows=814,146 width=81) (actual time=0.060..2,754.797 rows=516,395 loops=3)

  • Buffers: shared hit=46662 read=601502
6. 2,708.773 2,708.773 ↑ 1.6 516,395 3

Parallel Seq Scan on tracking_display_201907 t (cost=0.00..1,034,041.38 rows=814,146 width=81) (actual time=0.059..2,708.773 rows=516,395 loops=3)

  • Filter: ((date >= '2019-07-03 17:10:06.087498'::timestamp without time zone) AND (date <= '2019-07-10 17:10:06.087498'::timestamp without time zone) AND (id_campaign = ANY ('{613,620,682,820,895,929,977,996,1015,1029}'::integer[])))
  • Rows Removed by Filter: 10710641
  • Buffers: shared hit=46662 read=601502