explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xlWa : Updating versions which have changed

Settings
# exclusive inclusive rows x rows loops node
1. 67.110 10,268.421 ↓ 0.0 0 1

Update on packages p (cost=167,148.08..182,342.20 rows=386,647 width=70) (actual time=10,268.421..10,268.421 rows=0 loops=1)

2. 286.688 10,201.311 ↑ 150.9 2,562 1

Merge Join (cost=167,148.08..182,342.20 rows=386,647 width=70) (actual time=8,069.738..10,201.311 rows=2,562 loops=1)

  • Merge Cond: ((p.abi_id = pr.abi_id) AND (p.package_set = pr.package_set) AND (p.package_name = pr.package_name))
  • Join Filter: (p.package_version <> pr.package_version)
  • Rows Removed by Join Filter: 455,631
3. 2,956.841 4,058.659 ↑ 1.0 459,029 1

Sort (cost=81,069.86..82,223.65 rows=461,518 width=48) (actual time=2,558.070..4,058.659 rows=459,029 loops=1)

  • Sort Key: p.abi_id, p.package_set, p.package_name
  • Sort Method: external merge Disk: 26,824kB
4. 1,101.818 1,101.818 ↑ 1.0 459,029 1

Seq Scan on packages p (cost=0.00..9,251.18 rows=461,518 width=48) (actual time=0.362..1,101.818 rows=459,029 loops=1)

5. 69.643 5,855.964 ↑ 1.0 459,496 1

Materialize (cost=86,078.22..88,376.89 rows=459,733 width=36) (actual time=5,511.556..5,855.964 rows=459,496 loops=1)

6. 2,224.504 5,786.321 ↑ 1.0 459,496 1

Sort (cost=86,078.22..87,227.55 rows=459,733 width=36) (actual time=5,511.547..5,786.321 rows=459,496 loops=1)

  • Sort Key: pr.abi_id, pr.package_set, pr.package_name
  • Sort Method: external merge Disk: 21,408kB
7. 3,561.817 3,561.817 ↑ 1.0 459,733 1

Seq Scan on packages_raw pr (cost=0.00..17,695.33 rows=459,733 width=36) (actual time=0.418..3,561.817 rows=459,733 loops=1)

Planning time : 0.464 ms
Execution time : 10,279.285 ms