explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xTPv

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 1,245.281 ↓ 0.0 0 1

Subquery Scan on lol (cost=7,154.68..7,180.16 rows=1 width=85) (actual time=1,245.281..1,245.281 rows=0 loops=1)

  • Filter: (lol.article_id = 'LEGIARTI000006594341'::text)
  • Rows Removed by Filter: 10
2. 0.023 1,245.275 ↑ 78.4 10 1

WindowAgg (cost=7,154.68..7,170.36 rows=784 width=89) (actual time=1,245.266..1,245.275 rows=10 loops=1)

3. 0.013 1,245.252 ↑ 78.4 10 1

Sort (cost=7,154.68..7,156.64 rows=784 width=25) (actual time=1,245.251..1,245.252 rows=10 loops=1)

  • Sort Key: structure.global_order
  • Sort Method: quicksort Memory: 25kB
4. 0.010 1,245.239 ↑ 78.4 10 1

Bitmap Heap Scan on articles_legislations_structure structure (cost=4,589.54..7,116.99 rows=784 width=25) (actual time=1,245.236..1,245.239 rows=10 loops=1)

  • Recheck Cond: ((global_order < 10) AND (legislation_id = 'LEGITEXT000006071367'::text))
  • Heap Blocks: exact=2
5. 1,245.229 1,245.229 ↑ 78.4 10 1

Bitmap Index Scan on get_previous_and_next_article_optimization_index (cost=0.00..4,589.35 rows=784 width=0) (actual time=1,245.229..1,245.229 rows=10 loops=1)

  • Index Cond: ((global_order < 10) AND (legislation_id = 'LEGITEXT000006071367'::text))