explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tTWn

Settings
# exclusive inclusive rows x rows loops node
1. 4.037 183.642 ↑ 1.0 1 1

Subquery Scan on lol (cost=24,571.72..24,731.72 rows=1 width=85) (actual time=171.711..183.642 rows=1 loops=1)

  • Filter: (lol.article_id = 'LEGIARTI000006594341'::text)
  • Rows Removed by Filter: 29267
2. 23.738 179.605 ↓ 5.9 29,268 1

WindowAgg (cost=24,571.72..24,670.18 rows=4,923 width=89) (actual time=152.424..179.605 rows=29,268 loops=1)

3. 12.540 155.867 ↓ 5.9 29,268 1

Sort (cost=24,571.72..24,584.03 rows=4,923 width=25) (actual time=152.408..155.867 rows=29,268 loops=1)

  • Sort Key: structure.global_order
  • Sort Method: quicksort Memory: 3055kB
4. 143.327 143.327 ↓ 5.9 29,268 1

Seq Scan on articles_legislations_structure structure (cost=0.00..24,269.81 rows=4,923 width=25) (actual time=0.149..143.327 rows=29,268 loops=1)

  • Filter: (legislation_id = 'LEGITEXT000006071367'::text)
  • Rows Removed by Filter: 800401