explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZYJ9

Settings
# exclusive inclusive rows x rows loops node
1. 15.099 54.190 ↓ 1.1 19,461 1

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

2. 15.231 39.091 ↓ 1.1 19,461 1

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

  • Sort Key: global_order
  • Sort Method: quicksort Memory: 2289kB
3. 20.746 23.860 ↓ 1.1 19,461 1

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

  • Recheck Cond: (parent_text_id = 'LEGITEXT000006071367'::text)
  • Heap Blocks: exact=6500
4. 3.114 3.114 ↓ 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=3.114..3.114 rows=19,461 loops=1)

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