explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ejfS

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 0.060 ↑ 1.0 1 1

Sort (cost=32.36..32.36 rows=1 width=405) (actual time=0.060..0.060 rows=1 loops=1)

  • Sort Key: ord_cliente_rows.n_riga
2. 0.005 0.042 ↑ 1.0 1 1

Nested Loop (cost=0.00..32.35 rows=1 width=405) (actual time=0.039..0.042 rows=1 loops=1)

3. 0.021 0.021 ↑ 1.0 1 1

Index Scan using ord_cliente_num_ord_key on ord_cliente (cost=0.00..3.09 rows=1 width=40) (actual time=0.020..0.021 rows=1 loops=1)

  • Index Cond: (num_ord = 2900002620::bigint)
  • Filter: ((stato)::text = 'I'::text)
4. 0.016 0.016 ↑ 9.0 1 1

Index Scan using idx_ordcli_rows_stato_riga on ord_cliente_rows (cost=0.00..29.15 rows=9 width=405) (actual time=0.014..0.016 rows=1 loops=1)

  • Index Cond: (((ord_cliente_rows.parent_id)::text = ("outer".id)::text) AND ((ord_cliente_rows.stato_riga)::text = 'A'::text))