explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hmA9

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 45.157 ↓ 0.0 0 1

Sort (cost=5,722.57..5,722.58 rows=5 width=40) (actual time=45.157..45.157 rows=0 loops=1)

  • Sort Key: (max(aliassincronizacaoaplicalimitseparado.sincronizacaoversao))
  • Sort Method: quicksort Memory: 25kB
2. 0.002 45.128 ↓ 0.0 0 1

GroupAggregate (cost=5,722.41..5,722.51 rows=5 width=40) (actual time=45.128..45.128 rows=0 loops=1)

  • Group Key: aliassincronizacaoaplicalimitseparado.codigotransacionador, transdependente.cpf
3. 0.041 45.126 ↓ 0.0 0 1

Sort (cost=5,722.41..5,722.42 rows=5 width=40) (actual time=45.126..45.126 rows=0 loops=1)

  • Sort Key: aliassincronizacaoaplicalimitseparado.codigotransacionador, transdependente.cpf
  • Sort Method: quicksort Memory: 25kB
4. 0.001 45.085 ↓ 0.0 0 1

Nested Loop (cost=5,679.69..5,722.35 rows=5 width=40) (actual time=45.085..45.085 rows=0 loops=1)

5. 0.208 45.084 ↓ 0.0 0 1

Hash Anti Join (cost=5,679.40..5,691.75 rows=5 width=46) (actual time=45.084..45.084 rows=0 loops=1)

  • Hash Cond: (transdependente.cpf = ((trstra01.cgc)::bigint)::numeric)
6. 0.064 5.691 ↑ 3.3 3 1

Hash Join (cost=2,097.69..2,109.04 rows=10 width=46) (actual time=5.601..5.691 rows=3 loops=1)

  • Hash Cond: (aliassincronizacaoaplicalimitseparado.codigotransacionador = transdependente.cod)
7. 0.016 0.703 ↑ 1.9 268 1

Limit (cost=80.93..82.18 rows=500 width=57) (actual time=0.660..0.703 rows=268 loops=1)

8. 0.269 0.687 ↑ 2.0 268 1

Sort (cost=80.93..82.29 rows=545 width=57) (actual time=0.659..0.687 rows=268 loops=1)

  • Sort Key: aliassincronizacaoaplicalimitseparado.sincronizacaoversao
  • Sort Method: quicksort Memory: 37kB
9. 0.026 0.418 ↑ 2.0 268 1

Subquery Scan on aliassincronizacaoaplicalimitseparado (cost=45.26..56.16 rows=545 width=57) (actual time=0.340..0.418 rows=268 loops=1)

10. 0.181 0.392 ↑ 2.0 268 1

HashAggregate (cost=45.26..50.71 rows=545 width=73) (actual time=0.339..0.392 rows=268 loops=1)

  • Group Key: sincronizacaotransacionadordebito.cd_transacionador, sincronizacaotransacionadordebito.tx_cpfcnpj
11. 0.211 0.211 ↑ 2.0 268 1

Index Scan using tb_sinc_transdebito_idx01 on tb_sinc_transacionadordebito sincronizacaotransacionadordebito (cost=0.29..41.16 rows=547 width=15) (actual time=0.017..0.211 rows=268 loops=1)

  • Index Cond: ((nr_sincronizacaoversao >= '175825'::numeric) AND (nr_sincronizacaoversao <= '183088'::numeric))
  • Filter: ((cd_transacionador <> '0'::numeric) OR (((tx_cpfcnpj)::text <> ''::text) AND ((tx_cpfcnpj)::text <> '0'::text)))
12. 0.272 4.924 ↓ 1.0 717 1

Hash (cost=2,007.88..2,007.88 rows=710 width=9) (actual time=4.924..4.924 rows=717 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 41kB
13. 4.652 4.652 ↓ 1.0 717 1

Index Scan using trsccv01_idx02 on trsccv01 transdependente (cost=0.29..2,007.88 rows=710 width=9) (actual time=3.365..4.652 rows=717 loops=1)

  • Index Cond: (cad > '0'::numeric)
14. 25.298 39.185 ↑ 1.0 59,829 1

Hash (cost=2,833.85..2,833.85 rows=59,829 width=9) (actual time=39.185..39.185 rows=59,829 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2920kB
15. 13.887 13.887 ↑ 1.0 59,829 1

Index Only Scan using trstra01_004 on trstra01 (cost=0.41..2,833.85 rows=59,829 width=9) (actual time=0.228..13.887 rows=59,829 loops=1)

  • Heap Fetches: 684
16. 0.000 0.000 ↓ 0.0 0

Index Scan using trstra01_pkey on trstra01 transacionadorcodigo (cost=0.29..6.11 rows=1 width=6) (never executed)

  • Index Cond: (cod = transdependente.cod)
  • Filter: (dtx IS NULL)