explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MBHx

Settings
# exclusive inclusive rows x rows loops node
1. 16.856 2,460,506.151 ↑ 1.7 158,438 1

Merge Left Join (cost=84,845.49..759,141,966.70 rows=262,228 width=1,774) (actual time=2,459,111.320..2,460,506.151 rows=158,438 loops=1)

  • Merge Cond: (pulp_2to3_migration_pulp2content.pulp3_content_id = core_content.pulp_id)
2. 110,314.261 2,460,489.295 ↑ 1.7 158,438 1

Gather Merge (cost=84,801.22..759,132,284.50 rows=262,228 width=1,714) (actual time=2,459,111.314..2,460,489.295 rows=158,438 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 123.747 2,350,175.034 ↑ 2.1 52,813 3 / 3

Nested Loop (cost=83,801.20..759,101,016.86 rows=109,262 width=1,714) (actual time=2,349,723.886..2,350,175.034 rows=52,813 loops=3)

4. 374,748.928 2,349,786.928 ↑ 1.4 264,359 3 / 3

Parallel Index Scan using pulp_2to3_migration_pulp2content_pulp3_content_id_6271a7bb on pulp_2to3_migration_pulp2content (cost=83,800.78..758,846,512.59 rows=362,843 width=254) (actual time=2,349,723.733..2,349,786.928 rows=264,359 loops=3)

  • Filter: ((pulp3_content_id IS NULL) OR (SubPlan 1))
  • Rows Removed by Filter: 39,000
5.          

SubPlan (for Parallel Index Scan)

6. 405,889.799 1,975,038.000 ↓ 1.1 156,771 117,000 / 3

Materialize (cost=83,800.35..87,433.51 rows=141,850 width=37) (actual time=30.741..50.642 rows=156,771 loops=117,000)

7. 46,852.559 1,569,148.201 ↓ 1.1 156,771 4,018 / 3

Unique (cost=83,800.35..85,615.26 rows=141,850 width=37) (actual time=895.096..1,171.589 rows=156,771 loops=4,018)

8. 1,362,707.379 1,522,295.642 ↑ 1.0 359,986 4,018 / 3

Sort (cost=83,800.35..84,707.81 rows=362,982 width=37) (actual time=895.095..1,136.607 rows=359,986 loops=4,018)

  • Sort Key: u0.pulp2_unit_id
  • Sort Method: external merge Disk: 16,600kB
  • Worker 0: Sort Method: external merge Disk: 16,600kB
  • Worker 1: Sort Method: external merge Disk: 16,600kB
9. 159,588.263 159,588.263 ↑ 1.0 359,986 4,018 / 3

Seq Scan on pulp_2to3_migration_pulp2lazycatalog u0 (cost=0.00..40,353.80 rows=362,982 width=37) (actual time=0.005..119.155 rows=359,986 loops=4,018)

  • Filter: (NOT is_migrated)
  • Rows Removed by Filter: 267,794
10. 264.359 264.359 ↓ 0.0 0 793,076 / 3

Index Scan using pulp_2to3_migration_pulp2rpm_pulp2content_id_508869c4 on pulp_2to3_migration_pulp2rpm (cost=0.42..0.69 rows=1 width=1,460) (actual time=0.001..0.001 rows=0 loops=793,076)

  • Index Cond: (pulp2content_id = pulp_2to3_migration_pulp2content.pulp_id)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using core_content_pkey on core_content (cost=0.42..8,490.91 rows=116,982 width=60) (never executed)

Planning time : 0.341 ms
Execution time : 2,460,523.694 ms