explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GJue

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 0.108 ↑ 1.0 1 1

Nested Loop (cost=17.15..50.14 rows=1 width=72) (actual time=0.108..0.108 rows=1 loops=1)

2. 0.000 0.067 ↑ 1.0 1 1

Limit (cost=8.58..25.05 rows=1 width=24) (actual time=0.067..0.067 rows=1 loops=1)

3.          

Initplan (forLimit)

4. 0.018 0.018 ↑ 1.0 1 1

Index Scan using articles_pkey on articles (cost=0.28..8.30 rows=1 width=4) (actual time=0.017..0.018 rows=1 loops=1)

  • Index Cond: (article_id = 'LEGIARTI000006309324'::text)
5. 0.066 0.066 ↑ 19.0 1 1

Index Scan using articles_parent_text_id_global_order_idx on articles structure (cost=0.28..313.32 rows=19 width=24) (actual time=0.066..0.066 rows=1 loops=1)

  • Index Cond: ((parent_text_id = 'LEGITEXT000006069577'::text) AND (global_order > $0))
  • Filter: (((initial_version <> 'LEGIARTI000006309322'::text) AND (state = 'VIGUEUR'::text)) OR ((state = 'ABROGE_DIFF'::text) AND (ending_date > now())))
  • Rows Removed by Filter: 17
6. 0.000 0.029 ↑ 1.0 1 1

Limit (cost=8.58..25.05 rows=1 width=24) (actual time=0.029..0.029 rows=1 loops=1)

7.          

Initplan (forLimit)

8. 0.009 0.009 ↑ 1.0 1 1

Index Scan using articles_pkey on articles articles_1 (cost=0.28..8.30 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (article_id = 'LEGIARTI000006309324'::text)
9. 0.029 0.029 ↑ 19.0 1 1

Index Scan using articles_parent_text_id_global_order_idx on articles structure_1 (cost=0.28..313.32 rows=19 width=24) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((parent_text_id = 'LEGITEXT000006069577'::text) AND (global_order < $1))
  • Filter: (((initial_version <> 'LEGIARTI000006309322'::text) AND (state = 'VIGUEUR'::text)) OR ((state = 'ABROGE_DIFF'::text) AND (ending_date > now())))
  • Rows Removed by Filter: 16
Planning time : 0.408 ms
Execution time : 0.147 ms