explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jlpM

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 2.788 ↑ 5.0 9 1

Sort (cost=183.97..184.08 rows=45 width=24) (actual time=2.786..2.788 rows=9 loops=1)

  • Sort Key: global_order
  • Sort Method: quicksort Memory: 25kB
2. 2.776 2.776 ↑ 5.0 9 1

Index Scan using articles_parent_text_id_idx on articles (cost=0.43..182.74 rows=45 width=24) (actual time=1.462..2.776 rows=9 loops=1)

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