explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a4iD

Settings
# exclusive inclusive rows x rows loops node
1. 2.454 51.843 ↑ 1.0 1 1

Subquery Scan on article (cost=63,424.80..64,003.56 rows=1 width=84) (actual time=30.322..51.843 rows=1 loops=1)

  • Filter: (article.article_id = 'LEGIARTI000006581613'::text)
  • Rows Removed by Filter: 19460
2. 15.768 49.389 ↓ 1.1 19,461 1

WindowAgg (cost=63,424.80..63,780.96 rows=17,808 width=88) (actual time=30.309..49.389 rows=19,461 loops=1)

3. 10.183 33.621 ↓ 1.1 19,461 1

Sort (cost=63,424.80..63,469.32 rows=17,808 width=24) (actual time=30.300..33.621 rows=19,461 loops=1)

  • Sort Key: structure.global_order
  • Sort Method: quicksort Memory: 2289kB
4. 20.639 23.438 ↓ 1.1 19,461 1

Bitmap Heap Scan on articles structure (cost=1,418.44..62,167.54 rows=17,808 width=24) (actual time=3.948..23.438 rows=19,461 loops=1)

  • Recheck Cond: (parent_text_id = 'LEGITEXT000006071367'::text)
  • Heap Blocks: exact=6500
5. 2.799 2.799 ↓ 1.1 19,461 1

Bitmap Index Scan on articles_parent_text_id_idx (cost=0.00..1,413.99 rows=17,808 width=0) (actual time=2.799..2.799 rows=19,461 loops=1)

  • Index Cond: (parent_text_id = 'LEGITEXT000006071367'::text)