explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9vrI

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

Unique (cost=112,761.55..116,783.92 rows=45,970 width=1,365) (never executed)

2. 0.000 0.000 ↓ 0.0

Sort (cost=112,761.55..112,876.47 rows=45,970 width=1,365) (never executed)

  • Sort Key: enttes.descripcionbusquedas, enttes.tipoentidadtesoreria, fcobropago.descripcion, movtes.fecha, movtes.conceptotesoreria, movtes.importe, docbase.numeroexpediente, docbase.numerodocumento, inggasbas.importependienteliquidacion, inggasbas.importetotal, fac.totaliva, fac.totalretencion, fac.totalsuplidos, fac.totalbaseexenta, fac.totalbaseimponible, fac.numerodocumentoidentificativo, client.nombrecompleto, inggasbas.numeradorinforme, ingsinfac.informeconceptoingresosinfactura, fac.conceptofacturacionparabasico, cobr.id, inggasbas.id, fac.numerofacturanormalizado, inggasbas.fecha, serfac.descripcion, serfac.codigo, inggasbas.tipoig, fac.proforma, inggasbas.idnotario, inggasbas.idempresa, inggasbas.importecondonado, inggasbas.idcentrocostevalor, asicob.idejercicio, asicrea.idejercicio
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=29,133.55..93,186.94 rows=45,970 width=1,365) (never executed)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=29,133.13..32,653.03 rows=45,970 width=1,346) (never executed)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=29,131.32..32,516.35 rows=45,970 width=1,260) (never executed)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=29,130.14..32,342.49 rows=45,970 width=752) (never executed)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=29,067.61..32,158.89 rows=45,970 width=735) (never executed)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=26,321.68..29,292.29 rows=45,970 width=735) (never executed)

9. 0.000 0.000 ↓ 0.0

Hash Join (cost=24,174.78..27,024.72 rows=45,970 width=697) (never executed)

10. 0.000 0.000 ↓ 0.0

Hash Join (cost=24,173.6..26,902.85 rows=45,970 width=181) (never executed)

11. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,246.44..10,855.02 rows=45,970 width=165) (never executed)

12. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,997.06..9,484.95 rows=45,970 width=157) (never executed)

13. 0.000 0.000 ↓ 0.0

Hash Join (cost=5,733.2..8,100.41 rows=45,970 width=149) (never executed)

14. 0.000 0.000 ↓ 0.0

Seq Scan on asientobase asicrea (cost=0..1,557.08 rows=95,108 width=16) (never executed)

15. 0.000 0.000 ↓ 0.0

Hash (cost=5,158.57..5,158.57 rows=45,970 width=149) (never executed)

16. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,151.62..5,158.57 rows=45,970 width=149) (never executed)

17. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,934.33..2,820.6 rows=45,970 width=72) (never executed)

18. 0.000 0.000 ↓ 0.0

Seq Scan on cobro cobr (cost=0..784.95 rows=38,595 width=16) (never executed)

19. 0.000 0.000 ↓ 0.0

Hash (cost=1,359.7..1,359.7 rows=45,970 width=64) (never executed)

20. 0.000 0.000 ↓ 0.0

Seq Scan on ingresogastobase inggasbas (cost=0..1,359.7 rows=45,970 width=64) (never executed)

21. 0.000 0.000 ↓ 0.0

Hash (cost=1,657.13..1,657.13 rows=44,813 width=85) (never executed)

22. 0.000 0.000 ↓ 0.0

Seq Scan on factura fac (cost=0..1,657.13 rows=44,813 width=85) (never executed)

23. 0.000 0.000 ↓ 0.0

Hash (cost=752.27..752.27 rows=40,927 width=16) (never executed)

24. 0.000 0.000 ↓ 0.0

Seq Scan on facturaingreso facing (cost=0..752.27 rows=40,927 width=16) (never executed)

25. 0.000 0.000 ↓ 0.0

Hash (cost=738.06..738.06 rows=40,906 width=16) (never executed)

26. 0.000 0.000 ↓ 0.0

Seq Scan on facturaservicios facser (cost=0..738.06 rows=40,906 width=16) (never executed)

27. 0.000 0.000 ↓ 0.0

Hash (cost=13,309.85..13,309.85 rows=209,385 width=32) (never executed)

28. 0.000 0.000 ↓ 0.0

Seq Scan on documentobase docbase (cost=0..13,309.85 rows=209,385 width=32) (never executed)

29. 0.000 0.000 ↓ 0.0

Hash (cost=1.08..1.08 rows=8 width=524) (never executed)

30. 0.000 0.000 ↓ 0.0

Seq Scan on ingresosinfactura ingsinfac (cost=0..1.08 rows=8 width=524) (never executed)

31. 0.000 0.000 ↓ 0.0

Hash (cost=1,464.73..1,464.73 rows=54,573 width=46) (never executed)

32. 0.000 0.000 ↓ 0.0

Seq Scan on movimientotesoreria movtes (cost=0..1,464.73 rows=54,573 width=46) (never executed)

33. 0.000 0.000 ↓ 0.0

Hash (cost=1,557.08..1,557.08 rows=95,108 width=16) (never executed)

34. 0.000 0.000 ↓ 0.0

Seq Scan on asientobase asicob (cost=0..1,557.08 rows=95,108 width=16) (never executed)

35. 0.000 0.000 ↓ 0.0

Hash (cost=46.68..46.68 rows=1,268 width=33) (never executed)

36. 0.000 0.000 ↓ 0.0

Seq Scan on entidadtesoreria enttes (cost=0..46.68 rows=1,268 width=33) (never executed)

37. 0.000 0.000 ↓ 0.0

Hash (cost=1.08..1.08 rows=8 width=524) (never executed)

38. 0.000 0.000 ↓ 0.0

Seq Scan on formacobropago fcobropago (cost=0..1.08 rows=8 width=524) (never executed)

39. 0.000 0.000 ↓ 0.0

Hash (cost=1.36..1.36 rows=36 width=102) (never executed)

40. 0.000 0.000 ↓ 0.0

Seq Scan on seriefacturacion serfac (cost=0..1.36 rows=36 width=102) (never executed)

41. 0.000 0.000 ↓ 0.0

Index Scan using sujeto_pkey on sujeto client (cost=0.43..1.32 rows=1 width=35) (never executed)

  • Index Cond: (facing.idcliente = id)