explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GbL

Settings
# exclusive inclusive rows x rows loops node
1. 1,221.274 9,070.739 ↓ 1.5 604,752 1

GroupAggregate (cost=1,487,547.46..1,545,330.97 rows=406,363 width=85) (actual time=6,383.043..9,070.739 rows=604,752 loops=1)

  • Group Key: t.user_hash, t.id_segment, t.id_campaign
  • Buffers: shared hit=46240 read=601694, temp read=20147 written=20178
2. 5,052.753 7,849.465 ↑ 1.3 1,549,184 1

Sort (cost=1,487,547.46..1,492,431.09 rows=1,953,450 width=81) (actual time=6,383.017..7,849.465 rows=1,549,184 loops=1)

  • Sort Key: t.user_hash, t.id_segment, t.id_campaign
  • Sort Method: external merge Disk: 148632kB
  • Buffers: shared hit=46240 read=601694, temp read=20147 written=20178
3. 0.000 2,796.712 ↑ 1.3 1,549,184 1

Gather (cost=1,000.00..1,230,019.45 rows=1,953,450 width=81) (actual time=0.375..2,796.712 rows=1,549,184 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=46240 read=601694
4. 63.130 2,872.835 ↑ 1.6 516,395 3

Result (cost=0.00..1,041,813.83 rows=813,938 width=81) (actual time=0.064..2,872.835 rows=516,395 loops=3)

  • Buffers: shared hit=46240 read=601694
5. 47.031 2,809.705 ↑ 1.6 516,395 3

Append (cost=0.00..1,033,674.45 rows=813,938 width=81) (actual time=0.064..2,809.705 rows=516,395 loops=3)

  • Buffers: shared hit=46240 read=601694
6. 2,762.674 2,762.674 ↑ 1.6 516,395 3

Parallel Seq Scan on tracking_display_201907 t (cost=0.00..1,033,674.45 rows=813,938 width=81) (actual time=0.063..2,762.674 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: 10706651
  • Buffers: shared hit=46240 read=601694