explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xh5R

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

HashAggregate (cost=1,826,886.09..1,826,904.69 rows=1,860 width=26) (actual rows= loops=)

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

Append (cost=340,292.66..1,826,872.14 rows=1,860 width=26) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=340,292.66..840,851.99 rows=1,694 width=26) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=340,292.24..838,646.01 rows=4,834 width=26) (actual rows= loops=)

  • Hash Cond: ((j.ent_id)::integer = e.exp_id)
  • Join Filter: (j.hora_creacion >= o.org_fechaimpl)
5. 0.000 0.000 ↓ 0.0

Seq Scan on interfaz_juzgado j (cost=0.00..491,426.97 rows=1,079,284 width=26) (actual rows= loops=)

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

Hash (cost=339,814.41..339,814.41 rows=38,226 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=14.15..339,814.41 rows=38,226 width=16) (actual rows= loops=)

  • Hash Cond: (e.org_idradactual = m.org_id)
8. 0.000 0.000 ↓ 0.0

Seq Scan on exp e (cost=0.00..328,749.73 rows=2,844,873 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=14.14..14.14 rows=1 width=20) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

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

11. 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))
12. 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)
13. 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.42..0.45 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (exp_id = e.exp_id)
14. 0.000 0.000 ↓ 0.0

Nested Loop (cost=18,537.70..516,880.13 rows=121 width=26) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash Join (cost=18,537.28..516,722.69 rows=345 width=26) (actual rows= loops=)

  • Hash Cond: ((j_1.ent_id)::integer = e_1.exp_id)
  • Join Filter: (j_1.hora_creacion >= o_1.org_fechaimpl)
16. 0.000 0.000 ↓ 0.0

Seq Scan on interfaz_juzgado j_1 (cost=0.00..491,426.97 rows=1,079,284 width=26) (actual rows= loops=)

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

Hash (cost=18,503.23..18,503.23 rows=2,724 width=16) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Nested Loop (cost=874.55..18,503.23 rows=2,724 width=16) (actual rows= loops=)

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

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

20. 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))
21. 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)
22. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on exp e_1 (cost=874.28..18,314.78 rows=13,945 width=16) (actual rows= loops=)

  • Recheck Cond: (org_idcontrol = o_1.org_id)
23. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_exp_om (cost=0.00..870.79 rows=13,945 width=0) (actual rows= loops=)

  • Index Cond: (org_idcontrol = o_1.org_id)