explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QOHA

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

Unique (cost=5,544.19..5,544.20 rows=2 width=4) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Sort (cost=5,544.19..5,544.20 rows=2 width=4) (actual rows= loops=)

  • Sort Key: iptubase.j01_idbql
3. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=2,722.46..5,544.18 rows=2 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=2,722.17..5,543.55 rows=2 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=2,722.03..5,543.22 rows=2 width=12) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=2,721.60..5,067.39 rows=921 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=2,721.16..4,996.49 rows=19 width=16) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=2,720.74..4,990.66 rows=10 width=20) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=2,720.32..4,985.06 rows=12 width=12) (actual rows= loops=)

  • Hash Cond: ((testada.j36_idbql = testpri.j49_idbql) AND (testada.j36_face = testpri.j49_face))
10. 0.000 0.000 ↓ 0.0
→

Seq Scan on testada (cost=0.00..1,607.35 rows=87,635 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0
→

Hash (cost=1,419.93..1,419.93 rows=86,693 width=12) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0
→

Seq Scan on testpri (cost=0.00..1,419.93 rows=86,693 width=12) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0
→

Index Scan using lote_idbq_pk on lote (cost=0.42..0.46 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (j34_idbql = testada.j36_idbql)
14. 0.000 0.000 ↓ 0.0
→

Index Scan using iptubase_idbql_in on iptubase (cost=0.42..0.53 rows=5 width=8) (actual rows= loops=)

  • Index Cond: (j01_idbql = lote.j34_idbql)
  • Filter: (j01_baixa IS NULL)
15. 0.000 0.000 ↓ 0.0
→

Index Scan using histocorrenciamatric_iptubase_in on histocorrenciamatric (cost=0.43..2.73 rows=100 width=8) (actual rows= loops=)

  • Index Cond: (ar25_matric = iptubase.j01_matric)
16. 0.000 0.000 ↓ 0.0
→

Index Scan using histocorrencia_sequ_pk on histocorrencia (cost=0.44..0.51 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (ar23_sequencial = histocorrenciamatric.ar25_histocorrencia)
  • Filter: (ar23_data > '2018-08-01'::date)
17. 0.000 0.000 ↓ 0.0
→

Index Only Scan using bairro_codi_pk on bairro (cost=0.14..0.16 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (j13_codi = lote.j34_bairro)
18. 0.000 0.000 ↓ 0.0
→

Index Only Scan using ruas_codi_pk on ruas (cost=0.29..0.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (j14_codigo = testpri.j49_codigo)