explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pBSX

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,715.85..1,715.89 rows=4 width=25) (actual rows= loops=)

  • Group Key: j.ent_id, j.int_juz_id, e.exp_id
2. 0.000 0.000 ↓ 0.0

Append (cost=1.13..1,715.82 rows=4 width=25) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..849.75 rows=1 width=25) (actual rows= loops=)

  • Join Filter: (m.org_id = e.org_idradactual)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..742.34 rows=122 width=33) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..229.11 rows=122 width=29) (actual rows= loops=)

  • Join Filter: (j.hora_creacion >= o.org_fechaimpl)
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..14.14 rows=1 width=20) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on mig_equiv_ics_org m (cost=0.00..5.83 rows=1 width=4) (actual rows= loops=)

  • Filter: ((interface_default = 1) AND ((org_codigo)::text = 'J06'::text))
8. 0.000 0.000 ↓ 0.0

Index Scan using idx_org_idcod on org o (cost=0.28..8.29 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (org_id = m.org_id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on interfaz_juzgado j (cost=0.00..210.38 rows=367 width=25) (actual rows= loops=)

  • Filter: ((fue_id = 1) AND ((ent_tipo)::text = 'exp'::text) AND (estado_bf = 0))
10. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_mig_exp_01_exp_id on mig_exp_01_exp_id me (cost=0.43..4.20 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (exp_id = (j.ent_id)::integer)
11. 0.000 0.000 ↓ 0.0

Index Scan using idx_exp on exp e (cost=0.43..0.87 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (exp_id = me.exp_id)
12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..279.98 rows=1 width=25) (actual rows= loops=)

  • Join Filter: (m_1.org_id = e_1.org_idcontrol)
13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..271.18 rows=10 width=33) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..229.11 rows=10 width=29) (actual rows= loops=)

  • Join Filter: (j_1.hora_creacion >= o_1.org_fechaimpl)
15. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..14.14 rows=1 width=20) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on mig_equiv_ics_org m_1 (cost=0.00..5.83 rows=1 width=4) (actual rows= loops=)

  • Filter: ((interface_default = 1) AND ((org_codigo)::text = 'J06'::text))
17. 0.000 0.000 ↓ 0.0

Index Scan using idx_org_idcod on org o_1 (cost=0.28..8.29 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (org_id = m_1.org_id)
  • Filter: ((org_clase)::text = 'J'::text)
18. 0.000 0.000 ↓ 0.0

Seq Scan on interfaz_juzgado j_1 (cost=0.00..210.38 rows=367 width=25) (actual rows= loops=)

  • Filter: ((fue_id = 1) AND ((ent_tipo)::text = 'exp'::text) AND (estado_bf = 0))
19. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_mig_exp_01_exp_id on mig_exp_01_exp_id me_1 (cost=0.43..4.20 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (exp_id = (j_1.ent_id)::integer)
20. 0.000 0.000 ↓ 0.0

Index Scan using idx_exp on exp e_1 (cost=0.43..0.87 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (exp_id = me_1.exp_id)
21. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.14..406.06 rows=1 width=25) (actual rows= loops=)

  • Join Filter: (m_2.org_id = e_2.org_idradactual)
22. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..376.13 rows=34 width=33) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..225.81 rows=34 width=29) (actual rows= loops=)

  • Join Filter: (j_2.hora_creacion >= o_2.org_fechaimpl)