explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RfGv

Settings
# exclusive inclusive rows x rows loops node
1. 114.528 1,175.582 ↓ 307.1 184,288 1

Sort (cost=174,472.38..174,473.88 rows=600 width=53) (actual time=1,130.259..1,175.582 rows=184,288 loops=1)

  • Sort Key: ur.child_id
  • Sort Method: external merge Disk: 13,400kB
2. 511.887 1,061.054 ↓ 307.1 184,288 1

HashAggregate (cost=167,213.20..174,444.70 rows=600 width=53) (actual time=715.361..1,061.054 rows=184,288 loops=1)

  • Group Key: ur.child_id, u.name
  • Planned Partitions: 4 Batches: 133 Memory Usage: 4,217kB Disk Usage: 32,912kB
3. 64.194 549.167 ↓ 1.2 564,521 1

Gather (cost=18,382.98..125,602.96 rows=462,336 width=34) (actual time=460.922..549.167 rows=564,521 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 141.882 484.973 ↑ 1.0 188,174 3 / 3

Parallel Hash Join (cost=17,382.98..78,369.36 rows=192,640 width=34) (actual time=406.275..484.973 rows=188,174 loops=3)

  • Hash Cond: (ur.child_id = a.id)
5. 62.877 221.732 ↑ 1.3 238,384 3 / 3

Hash Join (cost=4.59..54,463.35 rows=312,998 width=34) (actual time=14.649..221.732 rows=238,384 loops=3)

  • Hash Cond: (ua_1.universe_id = u.id)
6. 20.008 158.787 ↑ 3.9 238,384 3 / 3

Parallel Append (cost=0.00..51,975.73 rows=926,288 width=20) (actual time=14.542..158.787 rows=238,384 loops=3)

7. 57.218 96.378 ↑ 12.9 21,161 3 / 3

Parallel Hash Join (cost=4,901.28..27,999.42 rows=272,816 width=20) (actual time=14.964..96.378 rows=21,161 loops=3)

  • Hash Cond: (ua_1.asset_id = ur.parent_id)
8. 24.910 24.910 ↑ 1.3 217,223 3 / 3

Parallel Seq Scan on universe_assets ua_1 (cost=0.00..12,797.29 rows=271,529 width=20) (actual time=0.517..24.910 rows=217,223 loops=3)

9. 8.714 14.250 ↑ 1.2 35,452 3 / 3

Parallel Hash (cost=4,347.35..4,347.35 rows=44,315 width=32) (actual time=14.250..14.250 rows=35,452 loops=3)

  • Buckets: 131,072 Batches: 1 Memory Usage: 7,712kB
10. 5.536 5.536 ↓ 2.4 106,356 1 / 3

Parallel Index Only Scan using underlying_relationships_pkey on underlying_relationships ur (cost=0.42..4,347.35 rows=44,315 width=32) (actual time=0.039..16.607 rows=106,356 loops=1)

  • Heap Fetches: 0
11. 42.401 42.401 ↓ 1.2 325,834 2 / 3

Parallel Seq Scan on universe_assets ua (cost=0.00..12,797.29 rows=271,529 width=20) (actual time=0.202..63.602 rows=325,834 loops=2)

12. 0.029 0.068 ↑ 1.0 115 3 / 3

Hash (cost=3.15..3.15 rows=115 width=22) (actual time=0.068..0.068 rows=115 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
13. 0.039 0.039 ↑ 1.0 115 3 / 3

Seq Scan on universes u (cost=0.00..3.15 rows=115 width=22) (actual time=0.019..0.039 rows=115 loops=3)

14. 40.475 121.359 ↑ 1.2 133,700 3 / 3

Parallel Hash (cost=14,482.17..14,482.17 rows=166,578 width=16) (actual time=121.359..121.359 rows=133,700 loops=3)

  • Buckets: 131,072 Batches: 8 Memory Usage: 3,424kB
15. 80.884 80.884 ↑ 1.2 133,700 3 / 3

Parallel Seq Scan on assets a (cost=0.00..14,482.17 rows=166,578 width=16) (actual time=29.468..80.884 rows=133,700 loops=3)

  • Filter: (discovery_status = 200)
  • Rows Removed by Filter: 82,822