explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tBw2

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

XN Hash Left Join DS_BCAST_INNER (cost=537,322,985.16..92,971,294,230.55 rows=16,677,605 width=129) (actual rows= loops=)

  • Hash Cond: ("outer".idvendacarne = "inner".idvendacarne)
2. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=537,321,969.23..66,962,985,921.81 rows=16,677,605 width=120) (actual rows= loops=)

  • Hash Cond: (("outer".idpontodevenda = "inner".idpontodevenda) AND ("outer".idformapgtocarne = "inner".idformapgtocarne))
3. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=1,684.70..64,613,769,073.71 rows=132,396 width=141) (actual rows= loops=)

  • Hash Cond: ("outer".idformapgtocarne = "inner".idformapgtocarne)
4. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=1,678.55..64,456,326,088.65 rows=132,396 width=120) (actual rows= loops=)

  • Hash Cond: ("outer".idcarnenovo = "inner".idcarnenovo)
5. 0.000 0.000 ↓ 0.0

XN Seq Scan on t_vendacarne vc (cost=0.00..1,371.62 rows=137,162 width=94) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Hash (cost=1,342.84..1,342.84 rows=134,284 width=37) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

XN Seq Scan on t_carnenovo cn (cost=0.00..1,342.84 rows=134,284 width=37) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

XN Hash (cost=4.92..4.92 rows=492 width=21) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

XN Seq Scan on t_formapgtocarne fpc (cost=0.00..4.92 rows=492 width=21) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

XN Hash (cost=537,320,259.36..537,320,259.36 rows=5,033 width=28) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=268,520,045.65..537,320,259.36 rows=5,033 width=28) (actual rows= loops=)

  • Hash Cond: ("outer".idacordopagamentoloja = "inner".idacordopagamentoloja)
12. 0.000 0.000 ↓ 0.0

XN Seq Scan on t_acordoformapagcarne afpc (cost=0.00..50.27 rows=5,027 width=29) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

XN Hash (cost=268,520,043.25..268,520,043.25 rows=960 width=19) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=11.99..268,520,043.25 rows=960 width=19) (actual rows= loops=)

  • Hash Cond: ("outer".idloja = "inner".idloja)
15. 0.000 0.000 ↓ 0.0

XN Seq Scan on t_pontodevenda pv (cost=0.00..9.63 rows=963 width=18) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

XN Hash (cost=9.59..9.59 rows=959 width=20) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

XN Seq Scan on t_acordopagamentoloja apj (cost=0.00..9.59 rows=959 width=20) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

XN Hash (cost=812.75..812.75 rows=81,275 width=21) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

XN Seq Scan on t_calciofcarne b (cost=0.00..812.75 rows=81,275 width=21) (actual rows= loops=)