explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K1UO

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

GroupAggregate (cost=1,487,844.76..1,545,636.63 rows=406,363 width=85) (actual time=9,767.060..11,445.021 rows=604,752 loops=1)

  • Group Key: t.user_hash, t.id_segment, t.id_campaign
  • Buffers: shared hit=46477 read=601598, temp read=18570 written=18571
2. 7,286.144 10,178.308 ↑ 1.3 1,549,184 1

Sort (cost=1,487,844.76..1,492,729.15 rows=1,953,754 width=81) (actual time=9,767.006..10,178.308 rows=1,549,184 loops=1)

  • Sort Key: t.user_hash, t.id_segment, t.id_campaign
  • Sort Method: external merge Disk: 148560kB
  • Buffers: shared hit=46477 read=601598, temp read=18570 written=18571
3. 21.199 2,892.164 ↑ 1.3 1,549,184 1

Gather (cost=1,000.00..1,230,274.79 rows=1,953,754 width=81) (actual time=0.340..2,892.164 rows=1,549,184 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=46477 read=601598
4. 58.762 2,870.965 ↑ 1.6 516,395 3

Result (cost=0.00..1,042,040.03 rows=814,064 width=81) (actual time=0.049..2,870.965 rows=516,395 loops=3)

  • Buffers: shared hit=46477 read=601598
5. 46.550 2,812.203 ↑ 1.6 516,395 3

Append (cost=0.00..1,033,899.39 rows=814,064 width=81) (actual time=0.049..2,812.203 rows=516,395 loops=3)

  • Buffers: shared hit=46477 read=601598
6. 2,765.653 2,765.653 ↑ 1.6 516,395 3

Parallel Seq Scan on tracking_display_201907 t (cost=0.00..1,033,899.39 rows=814,064 width=81) (actual time=0.048..2,765.653 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: 10709114
  • Buffers: shared hit=46477 read=601598