explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pme7

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 42.951 ↓ 0.0 0 1

Sort (cost=5,872.27..5,872.29 rows=5 width=40) (actual time=42.951..42.951 rows=0 loops=1)

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

GroupAggregate (cost=5,872.11..5,872.21 rows=5 width=40) (actual time=42.931..42.931 rows=0 loops=1)

  • Group Key: aliassincronizacaoaplicalimitseparado.codigotransacionador, transdependente.cpf
3. 0.005 42.930 ↓ 0.0 0 1

Sort (cost=5,872.11..5,872.13 rows=5 width=40) (actual time=42.930..42.930 rows=0 loops=1)

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

Nested Loop (cost=5,829.40..5,872.06 rows=5 width=40) (actual time=42.925..42.925 rows=0 loops=1)

5. 0.185 42.924 ↓ 0.0 0 1

Hash Anti Join (cost=5,829.11..5,841.46 rows=5 width=46) (actual time=42.924..42.924 rows=0 loops=1)

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

Hash Join (cost=2,097.82..2,109.17 rows=10 width=46) (actual time=5.937..6.049 rows=3 loops=1)

  • Hash Cond: (aliassincronizacaoaplicalimitseparado.codigotransacionador = transdependente.cod)
7. 0.024 2.025 ↑ 1.7 289 1

Limit (cost=81.07..82.32 rows=500 width=57) (actual time=1.971..2.025 rows=289 loops=1)

8. 0.272 2.001 ↑ 1.9 289 1

Sort (cost=81.07..82.43 rows=546 width=57) (actual time=1.970..2.001 rows=289 loops=1)

  • Sort Key: aliassincronizacaoaplicalimitseparado.sincronizacaoversao
  • Sort Method: quicksort Memory: 38kB
9. 0.026 1.729 ↑ 1.9 289 1

Subquery Scan on aliassincronizacaoaplicalimitseparado (cost=45.32..56.24 rows=546 width=57) (actual time=1.637..1.729 rows=289 loops=1)

10. 0.947 1.703 ↑ 1.9 289 1

HashAggregate (cost=45.32..50.78 rows=546 width=73) (actual time=1.636..1.703 rows=289 loops=1)

  • Group Key: sincronizacaotransacionadordebito.cd_transacionador, sincronizacaotransacionadordebito.tx_cpfcnpj
11. 0.756 0.756 ↓ 3.3 1,796 1

Index Scan using tb_sinc_transdebito_idx01 on tb_sinc_transacionadordebito sincronizacaotransacionadordebito (cost=0.29..41.21 rows=548 width=15) (actual time=0.011..0.756 rows=1,796 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.184 3.953 ↓ 1.0 717 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 41kB
13. 3.769 3.769 ↓ 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.011..3.769 rows=717 loops=1)

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

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

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

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

  • Index Cond: (cod IS NOT NULL)
  • 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)