explain.depesz.com

PostgreSQL's explain analyze made readable

Result: unnr

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.099 ↑ 1.0 1 1

Subquery Scan on lol (cost=8.45..8.49 rows=1 width=85) (actual time=0.098..0.099 rows=1 loops=1)

  • Filter: (lol.article_id = 'LEGIARTI000006594341'::text)
2. 0.009 0.094 ↑ 1.0 1 1

WindowAgg (cost=8.45..8.47 rows=1 width=89) (actual time=0.093..0.094 rows=1 loops=1)

3. 0.015 0.085 ↑ 1.0 1 1

Sort (cost=8.45..8.46 rows=1 width=25) (actual time=0.085..0.085 rows=1 loops=1)

  • Sort Key: structure.global_order
  • Sort Method: quicksort Memory: 25kB
4. 0.070 0.070 ↑ 1.0 1 1

Index Scan using articles_legislations_structure_pkey on articles_legislations_structure structure (cost=0.42..8.44 rows=1 width=25) (actual time=0.069..0.070 rows=1 loops=1)

  • Index Cond: (article_id = 'LEGIARTI000006594341'::text)