explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lPJ4

Settings
# exclusive inclusive rows x rows loops node
1. 0.149 78,708.506 ↓ 1.4 63 1

Subquery Scan on feature (cost=33,308,562.91..33,308,850.89 rows=44 width=53) (actual time=78,708.170..78,708.506 rows=63 loops=1)

  • Filter: (feature.rank = 1)
2. 0.199 78,708.357 ↑ 140.7 63 1

WindowAgg (cost=33,308,562.91..33,308,740.13 rows=8,861 width=53) (actual time=78,708.167..78,708.357 rows=63 loops=1)

3. 0.000 78,708.158 ↑ 140.7 63 1

Sort (cost=33,308,562.91..33,308,585.06 rows=8,861 width=29) (actual time=78,708.108..78,708.158 rows=63 loops=1)

  • Sort Key: feature_1.id, feature_1.version DESC
  • Sort Method: quicksort Memory: 29kB
4. 7.604 78,710.810 ↑ 140.7 63 1

Gather (cost=1,000.00..33,307,981.93 rows=8,861 width=29) (actual time=70,596.950..78,710.810 rows=63 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 78,703.206 78,703.206 ↑ 175.8 21 3 / 3

Parallel Seq Scan on feature feature_1 (cost=0.00..33,306,095.83 rows=3,692 width=29) (actual time=70,593.298..78,703.206 rows=21 loops=3)

  • Filter: ((feature_type = 28) AND ((version + 0) > 0) AND ((version + 0) <= 1) AND ((((branch)::text || ''::text))::uuid = 'dc4bfa6a-c459-45b4-bd09-f8fe3a5e5d54'::uuid))
  • Rows Removed by Filter: 207,868,854