explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wZKo

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 609.623 ↑ 1.0 1 1

Sort (cost=12,196.81..12,196.82 rows=1 width=405) (actual time=609.623..609.623 rows=1 loops=1)

  • Sort Key: ord_cliente_rows.n_riga
2. 0.007 609.612 ↑ 1.0 1 1

Nested Loop (cost=0.00..12,196.80 rows=1 width=405) (actual time=609.610..609.612 rows=1 loops=1)

3. 609.590 609.590 ↑ 1.0 1 1

Seq Scan on ord_cliente (cost=0.00..12,167.54 rows=1 width=40) (actual time=609.589..609.590 rows=1 loops=1)

  • Filter: ((num_ord = satol('2019/2620'::text)) AND ((stato)::text = 'I'::text))
4. 0.015 0.015 ↑ 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.015 rows=1 loops=1)

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