explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hD6R : test

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.753 109,284.163 ↓ 467.0 2,335 1

Append (cost=14,800.29..100,759.92 rows=5 width=7,436) (actual time=163.303..109,284.163 rows=2,335 loops=1)

  • Buffers: shared hit=10409419 read=12095
2. 4.122 107,297.282 ↓ 1,145.0 2,290 1

Result (cost=14,800.29..61,769.04 rows=2 width=7,498) (actual time=163.302..107,297.282 rows=2,290 loops=1)

  • Buffers: shared hit=10232211 read=12095
3. 0.835 107,293.160 ↓ 1,145.0 2,290 1

Append (cost=14,800.29..61,768.99 rows=2 width=7,486) (actual time=163.300..107,293.160 rows=2,290 loops=1)

  • Buffers: shared hit=10232211 read=12095
4. 3.435 94,082.602 ↓ 2,273.0 2,273 1

Subquery Scan on *SELECT* 1" (cost=14,800.29..36,106.27 rows=1 width=3,707) (actual time=163.299..94,082.602 rows=2,273 loops=1)

  • Buffers: shared hit=7793409 read=12095
5. 44.959 94,079.167 ↓ 2,273.0 2,273 1

Nested Loop (cost=14,800.29..36,106.25 rows=1 width=3,701) (actual time=163.297..94,079.167 rows=2,273 loops=1)

  • Join Filter: ((ttotcargo.numinterno = ttotcargoint.numintot) AND (ttotcargo.cargo = ttotcargoint.numintcargo))
  • Buffers: shared hit=7793409 read=12095
6. 10.545 93,936.469 ↓ 2,273.0 2,273 1

Nested Loop (cost=14,800.00..36,078.63 rows=1 width=2,581) (actual time=163.157..93,936.469 rows=2,273 loops=1)

  • Join Filter: ((ttotcargo.numinterno = ttotcargolinea.numintot) AND (ttotcargo.cargo = ttotcargolinea.numintcargo))
  • Rows Removed by Join Filter: 1361
  • Buffers: shared hit=7758465 read=12095
7. 2,199.266 93,904.984 ↓ 3,490.0 3,490 1

Nested Loop (cost=14,799.58..36,078.07 rows=1 width=2,535) (actual time=163.125..93,904.984 rows=3,490 loops=1)

  • Join Filter: (ttotcab.numinterno = ttotcargo.numinterno)
  • Rows Removed by Join Filter: 24210310
  • Buffers: shared hit=7744383 read=12095
8. 20.444 280.553 ↓ 9,035.0 9,035 1

Nested Loop (cost=9,500.91..27,941.03 rows=1 width=1,763) (actual time=111.585..280.553 rows=9,035 loops=1)

  • Buffers: shared hit=52214 read=12095
9. 12.618 233.004 ↓ 9,035.0 9,035 1

Nested Loop (cost=9,500.78..27,940.88 rows=1 width=1,675) (actual time=111.568..233.004 rows=9,035 loops=1)

  • Buffers: shared hit=34144 read=12095
10. 23.079 202.316 ↓ 9,035.0 9,035 1

Nested Loop (cost=9,500.78..27,939.83 rows=1 width=1,551) (actual time=111.565..202.316 rows=9,035 loops=1)

  • Buffers: shared hit=25109 read=12095
11. 0.000 161.167 ↓ 9,035.0 9,035 1

Gather (cost=9,500.78..27,938.76 rows=1 width=1,431) (actual time=111.555..161.167 rows=9,035 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=16074 read=12095
12. 17.939 340.281 ↓ 3,012.0 3,012 3

Hash Join (cost=8,500.78..26,938.66 rows=1 width=1,431) (actual time=163.459..340.281 rows=3,012 loops=3)

  • Hash Cond: ((ttotlinea.numintot = ttotcargo.numinterno) AND (ttotlinea.numintintervencion = ttotintervencion.intervencion))
  • Buffers: shared hit=16074 read=12095
13. 18.773 159.143 ↑ 1.3 84,262 3

Hash Left Join (cost=9.86..17,657.42 rows=105,375 width=307) (actual time=0.248..159.143 rows=84,262 loops=3)

  • Hash Cond: (ttotlinea.numintrefer = ttsubcontratado.numintsubcont)
  • Join Filter: (ttotlinea.tipolinea = 3)
  • Rows Removed by Join Filter: 38
  • Buffers: shared hit=1957 read=12095
14. 25.058 140.360 ↑ 1.3 84,262 3

Hash Left Join (cost=8.63..17,379.59 rows=105,375 width=295) (actual time=0.213..140.360 rows=84,262 loops=3)

  • Hash Cond: ((ttotlinea.grupocont)::text = (tggrupocont.grupocont)::text)
  • Buffers: shared hit=1923 read=12095
15. 22.347 115.289 ↑ 1.3 84,262 3

Hash Left Join (cost=7.21..17,057.24 rows=105,375 width=207) (actual time=0.193..115.289 rows=84,262 loops=3)

  • Hash Cond: (((ttotlinea.marca)::text = (tacategoriapieza.marca)::text) AND ((ttotlinea.codigocategoria)::text = (tacategoriapieza.codigo)::text))
  • Buffers: shared hit=1920 read=12095
16. 23.101 92.882 ↑ 1.3 84,262 3

Hash Left Join (cost=3.06..16,496.94 rows=105,375 width=198) (actual time=0.126..92.882 rows=84,262 loops=3)

  • Hash Cond: ((ttotlinea.marca)::text = (tgmarca.marca)::text)
  • Buffers: shared hit=1917 read=12095
17. 69.750 69.750 ↑ 1.3 84,262 3

Parallel Seq Scan on ttotlinea (cost=0.00..16,200.14 rows=105,375 width=110) (actual time=0.014..69.750 rows=84,262 loops=3)

  • Filter: ((tipocab <> 2) AND ((emp)::text = '1'::text) AND (anulada = 0) AND (estasaconsigna = 0))
  • Rows Removed by Filter: 7384
  • Buffers: shared hit=1814 read=12095
18. 0.014 0.031 ↑ 1.0 47 3

Hash (cost=2.47..2.47 rows=47 width=108) (actual time=0.031..0.031 rows=47 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=6
19. 0.017 0.017 ↑ 1.0 47 3

Seq Scan on tgmarca (cost=0.00..2.47 rows=47 width=108) (actual time=0.009..0.017 rows=47 loops=3)

  • Buffers: shared hit=6
20. 0.034 0.060 ↑ 1.0 126 3

Hash (cost=2.26..2.26 rows=126 width=16) (actual time=0.060..0.060 rows=126 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=3
21. 0.026 0.026 ↑ 1.0 126 3

Seq Scan on tacategoriapieza (cost=0.00..2.26 rows=126 width=16) (actual time=0.008..0.026 rows=126 loops=3)

  • Buffers: shared hit=3
22. 0.006 0.013 ↑ 1.0 19 3

Hash (cost=1.19..1.19 rows=19 width=126) (actual time=0.013..0.013 rows=19 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
23. 0.007 0.007 ↑ 1.0 19 3

Seq Scan on tggrupocont (cost=0.00..1.19 rows=19 width=126) (actual time=0.005..0.007 rows=19 loops=3)

  • Buffers: shared hit=3
24. 0.003 0.010 ↑ 1.0 10 3

Hash (cost=1.10..1.10 rows=10 width=20) (actual time=0.010..0.010 rows=10 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
25. 0.007 0.007 ↑ 1.0 10 3

Seq Scan on ttsubcontratado (cost=0.00..1.10 rows=10 width=20) (actual time=0.005..0.007 rows=10 loops=3)

  • Buffers: shared hit=3
26. 2.053 163.199 ↓ 2,123.0 2,123 3

Hash (cost=8,490.90..8,490.90 rows=1 width=1,124) (actual time=163.199..163.199 rows=2,123 loops=3)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 615kB
  • Buffers: shared hit=14117
27. 8.490 161.146 ↓ 2,123.0 2,123 3

Hash Join (cost=6,147.56..8,490.90 rows=1 width=1,124) (actual time=113.339..161.146 rows=2,123 loops=3)

  • Hash Cond: (ttotintervencion.numinterno = ttotcargo.numinterno)
  • Buffers: shared hit=14117
28. 28.088 39.354 ↑ 1.0 60,956 3

Hash Left Join (cost=1.18..2,115.91 rows=60,956 width=135) (actual time=0.022..39.354 rows=60,956 loops=3)

  • Hash Cond: ((ttotintervencion.seccion)::text = (seccionint.seccion)::text)
  • Buffers: shared hit=3327
29. 11.256 11.256 ↑ 1.0 60,956 3

Seq Scan on ttotintervencion (cost=0.00..1,869.95 rows=60,956 width=47) (actual time=0.005..11.256 rows=60,956 loops=3)

  • Filter: ((emp)::text = '1'::text)
  • Buffers: shared hit=3324
30. 0.004 0.010 ↑ 1.0 8 3

Hash (cost=1.08..1.08 rows=8 width=104) (actual time=0.010..0.010 rows=8 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
31. 0.006 0.006 ↑ 1.0 8 3

Seq Scan on ttseccion seccionint (cost=0.00..1.08 rows=8 width=104) (actual time=0.005..0.006 rows=8 loops=3)

  • Buffers: shared hit=3
32. 0.658 113.302 ↓ 857.0 857 3

Hash (cost=6,146.37..6,146.37 rows=1 width=989) (actual time=113.302..113.302 rows=857 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 192kB
  • Buffers: shared hit=10790
33. 6.437 112.644 ↓ 857.0 857 3

Hash Join (cost=3,019.39..6,146.37 rows=1 width=989) (actual time=33.752..112.644 rows=857 loops=3)

  • Hash Cond: ((ttotcargo.numinterno = ttotfac.numinterno) AND (ttotcargo.cargo = ttotfac.numintcargo))
  • Buffers: shared hit=10790
34. 19.280 105.142 ↑ 1.0 40,882 3

Hash Left Join (cost=2,429.68..5,147.83 rows=40,882 width=219) (actual time=32.677..105.142 rows=40,882 loops=3)

  • Hash Cond: (ttotcargo.cliente = tgcliente.codigo)
  • Buffers: shared hit=10677
35. 43.785 53.389 ↑ 1.0 40,882 3

Hash Left Join (cost=1.32..2,612.14 rows=40,882 width=188) (actual time=0.029..53.389 rows=40,882 loops=3)

  • Hash Cond: ((ttotcargo.tallagrupcliente)::text = (tgagrupcliente.codigo)::text)
  • Buffers: shared hit=5883
36. 9.592 9.592 ↑ 1.0 40,882 3

Seq Scan on ttotcargo (cost=0.00..2,471.03 rows=40,882 width=87) (actual time=0.006..9.592 rows=40,882 loops=3)

  • Filter: ((emp)::text = '1'::text)
  • Buffers: shared hit=5880
37. 0.006 0.012 ↑ 1.0 14 3

Hash (cost=1.14..1.14 rows=14 width=104) (actual time=0.012..0.012 rows=14 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
38. 0.006 0.006 ↑ 1.0 14 3

Seq Scan on tgagrupcliente (cost=0.00..1.14 rows=14 width=104) (actual time=0.004..0.006 rows=14 loops=3)

  • Buffers: shared hit=3
39. 11.953 32.473 ↑ 1.0 36,905 3

Hash (cost=1,967.05..1,967.05 rows=36,905 width=35) (actual time=32.473..32.473 rows=36,905 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 3073kB
  • Buffers: shared hit=4794
40. 20.520 20.520 ↑ 1.0 36,905 3

Seq Scan on tgcliente (cost=0.00..1,967.05 rows=36,905 width=35) (actual time=0.009..20.520 rows=36,905 loops=3)

  • Buffers: shared hit=4794
41. 0.254 1.065 ↓ 1.0 857 3

Hash (cost=577.02..577.02 rows=846 width=770) (actual time=1.065..1.065 rows=857 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 72kB
  • Buffers: shared hit=113
42. 0.172 0.811 ↓ 1.0 857 3

Hash Left Join (cost=89.92..577.02 rows=846 width=770) (actual time=0.161..0.811 rows=857 loops=3)

  • Hash Cond: ((ttotfac.actividadcan)::text = (tmcanactividad.actividad)::text)
  • Buffers: shared hit=113
43. 0.249 0.636 ↓ 1.0 857 3

Hash Left Join (cost=65.75..550.63 rows=846 width=692) (actual time=0.152..0.636 rows=857 loops=3)

  • Hash Cond: ((ttotfac.aseguradoracan)::text = (tmcanaseguradora.aseguradora)::text)
  • Buffers: shared hit=113
44. 0.265 0.375 ↓ 1.0 857 3

Bitmap Heap Scan on ttotfac (cost=31.24..512.93 rows=846 width=86) (actual time=0.123..0.375 rows=857 loops=3)

  • Recheck Cond: (((emp)::text = '1'::text) AND (fechafactura >= '2018-06-01 00:00:00'::timestamp without time zone) AND (fechafactura <= '2019-01-31 23:59:59'::timestamp without time zone))
  • Filter: (franquiciarecibo = 0)
  • Rows Removed by Filter: 5
  • Heap Blocks: exact=31
  • Buffers: shared hit=113
45. 0.110 0.110 ↓ 1.0 862 3

Bitmap Index Scan on ix_ttotfac_fechafactura (cost=0.00..31.03 rows=859 width=0) (actual time=0.110..0.110 rows=862 loops=3)

  • Index Cond: (((emp)::text = '1'::text) AND (fechafactura >= '2018-06-01 00:00:00'::timestamp without time zone) AND (fechafactura <= '2019-01-31 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=20
46. 0.000 0.012 ↓ 0.0 0 3

Hash (cost=32.89..32.89 rows=130 width=626) (actual time=0.012..0.012 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
47. 0.008 0.012 ↓ 0.0 0 3

Hash Right Join (cost=12.93..32.89 rows=130 width=626) (actual time=0.012..0.012 rows=0 loops=3)

  • Hash Cond: ((tmcangrupo.grupo)::text = (tmcanaseguradora.grupo)::text)
48. 0.000 0.000 ↓ 0.0 0

Seq Scan on tmcangrupo (cost=0.00..16.30 rows=630 width=90) (never executed)

49. 0.000 0.004 ↓ 0.0 0 3

Hash (cost=11.30..11.30 rows=130 width=548) (actual time=0.004..0.004 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
50. 0.004 0.004 ↓ 0.0 0 3

Seq Scan on tmcanaseguradora (cost=0.00..11.30 rows=130 width=548) (actual time=0.004..0.004 rows=0 loops=3)

51. 0.000 0.003 ↓ 0.0 0 3

Hash (cost=16.30..16.30 rows=630 width=86) (actual time=0.003..0.003 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
52. 0.003 0.003 ↓ 0.0 0 3

Seq Scan on tmcanactividad (cost=0.00..16.30 rows=630 width=86) (actual time=0.003..0.003 rows=0 loops=3)

53. 18.070 18.070 ↑ 1.0 1 9,035

Seq Scan on tgtaller (cost=0.00..1.06 rows=1 width=120) (actual time=0.002..0.002 rows=1 loops=9,035)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=9035
54. 18.070 18.070 ↑ 1.0 1 9,035

Seq Scan on tgempresa (cost=0.00..1.04 rows=1 width=124) (actual time=0.001..0.002 rows=1 loops=9,035)

  • Filter: ((emp)::text = '1'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=9035
55. 27.105 27.105 ↑ 1.0 1 9,035

Index Scan using pk_ttgrupocargo on ttgrupocargo (cost=0.14..0.15 rows=1 width=104) (actual time=0.003..0.003 rows=1 loops=9,035)

  • Index Cond: ((grupo)::text = (ttotcargo.grupocargo)::text)
  • Buffers: shared hit=18070
56. 8,601.313 91,425.165 ↑ 1.0 2,680 9,035

Hash Join (cost=5,298.67..8,103.54 rows=2,680 width=820) (actual time=0.286..10.119 rows=2,680 loops=9,035)

  • Hash Cond: ((ttotcab.seccion)::text = (ttseccion.seccion)::text)
  • Buffers: shared hit=7692169
57. 10,805.462 82,823.845 ↑ 1.0 2,680 9,035

Hash Left Join (cost=5,297.49..8,091.60 rows=2,680 width=732) (actual time=0.285..9.167 rows=2,680 loops=9,035)

  • Hash Cond: (ttotcab.clientecond = clientecond.codigo)
  • Buffers: shared hit=7692168
58. 10,516.731 71,990.880 ↑ 1.0 2,680 9,035

Hash Left Join (cost=2,869.12..5,656.20 rows=2,680 width=683) (actual time=0.282..7.968 rows=2,680 loops=9,035)

  • Hash Cond: (((ttotcab.emp)::text = (tttallermarca.emp)::text) AND ((ttotcab.taller)::text = (tttallermarca.taller)::text) AND ((ttotcab.marca)::text = (tttallermarca.marca)::text))
  • Buffers: shared hit=7690570
59. 9,436.665 61,474.140 ↑ 1.0 2,680 9,035

Hash Left Join (cost=2,868.06..5,632.75 rows=2,680 width=649) (actual time=0.281..6.804 rows=2,680 loops=9,035)

  • Hash Cond: (ttotcab.vehiculo = ttveh.numinterno)
  • Buffers: shared hit=7690569
60. 7,995.970 52,014.495 ↑ 1.0 2,680 9,035

Hash Left Join (cost=75.48..2,833.13 rows=2,680 width=637) (actual time=0.278..5.757 rows=2,680 loops=9,035)

  • Hash Cond: ((ttotcab.categoria)::text = (tgcategoria.categoria)::text)
  • Buffers: shared hit=7688788
61. 7,020.188 44,018.520 ↑ 1.0 2,680 9,035

Hash Left Join (cost=74.39..2,819.05 rows=2,680 width=549) (actual time=0.277..4.872 rows=2,680 loops=9,035)

  • Hash Cond: (((ttotcab.emp)::text = (ttrecepcionista2.emp)::text) AND ((ttotcab.taller)::text = (ttrecepcionista2.taller)::text) AND ((ttotcab.secretaria)::text = (ttrecepcionista2.recepcionista)::text))
  • Buffers: shared hit=7688787
62. 27,123.060 36,998.325 ↑ 1.0 2,680 9,035

Hash Left Join (cost=73.07..2,796.25 rows=2,680 width=431) (actual time=0.277..4.095 rows=2,680 loops=9,035)

  • Hash Cond: (((ttotcab.emp)::text = (ttrecepcionista.emp)::text) AND ((ttotcab.taller)::text = (ttrecepcionista.taller)::text) AND ((ttotcab.recepcionista)::text = (ttrecepcionista.recepcionista)::text))
  • Buffers: shared hit=7688786
63. 8,050.185 9,875.255 ↑ 1.0 2,680 9,035

Bitmap Heap Scan on ttotcab (cost=71.76..2,772.03 rows=2,680 width=313) (actual time=0.274..1.093 rows=2,680 loops=9,035)

  • Recheck Cond: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Heap Blocks: exact=7580365
  • Buffers: shared hit=7688785
64. 1,825.070 1,825.070 ↑ 1.0 2,680 9,035

Bitmap Index Scan on ix_ttotcab_status_anulada (cost=0.00..71.09 rows=2,680 width=0) (actual time=0.202..0.202 rows=2,680 loops=9,035)

  • Index Cond: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Buffers: shared hit=108420
65. 0.005 0.010 ↓ 7.0 7 1

Hash (cost=1.30..1.30 rows=1 width=218) (actual time=0.010..0.010 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
66. 0.005 0.005 ↓ 7.0 7 1

Seq Scan on ttrecepcionista (cost=0.00..1.30 rows=1 width=218) (actual time=0.004..0.005 rows=7 loops=1)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 13
  • Buffers: shared hit=1
67. 0.003 0.007 ↓ 7.0 7 1

Hash (cost=1.30..1.30 rows=1 width=218) (actual time=0.007..0.007 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
68. 0.004 0.004 ↓ 7.0 7 1

Seq Scan on ttrecepcionista ttrecepcionista2 (cost=0.00..1.30 rows=1 width=218) (actual time=0.003..0.004 rows=7 loops=1)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 13
  • Buffers: shared hit=1
69. 0.003 0.005 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=104) (actual time=0.005..0.005 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
70. 0.002 0.002 ↑ 1.0 4 1

Seq Scan on tgcategoria (cost=0.00..1.04 rows=4 width=104) (actual time=0.002..0.002 rows=4 loops=1)

  • Buffers: shared hit=1
71. 6.081 22.980 ↑ 1.0 44,959 1

Hash (cost=2,230.59..2,230.59 rows=44,959 width=20) (actual time=22.980..22.980 rows=44,959 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2606kB
  • Buffers: shared hit=1781
72. 16.899 16.899 ↑ 1.0 44,959 1

Seq Scan on ttveh (cost=0.00..2,230.59 rows=44,959 width=20) (actual time=0.004..16.899 rows=44,959 loops=1)

  • Buffers: shared hit=1781
73. 0.003 0.009 ↑ 1.0 1 1

Hash (cost=1.04..1.04 rows=1 width=86) (actual time=0.009..0.009 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
74. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on tttallermarca (cost=0.00..1.04 rows=1 width=86) (actual time=0.006..0.006 rows=1 loops=1)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=1
75. 9.311 27.503 ↑ 1.0 36,905 1

Hash (cost=1,967.05..1,967.05 rows=36,905 width=53) (actual time=27.503..27.503 rows=36,905 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3580kB
  • Buffers: shared hit=1598
76. 18.192 18.192 ↑ 1.0 36,905 1

Seq Scan on tgcliente clientecond (cost=0.00..1,967.05 rows=36,905 width=53) (actual time=0.005..18.192 rows=36,905 loops=1)

  • Buffers: shared hit=1598
77. 0.003 0.007 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=104) (actual time=0.007..0.007 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
78. 0.004 0.004 ↑ 1.0 8 1

Seq Scan on ttseccion (cost=0.00..1.08 rows=8 width=104) (actual time=0.003..0.004 rows=8 loops=1)

  • Buffers: shared hit=1
79. 20.940 20.940 ↑ 1.0 1 3,490

Index Scan using ix_ttotcargolinea_item on ttotcargolinea (cost=0.42..0.55 rows=1 width=48) (actual time=0.006..0.006 rows=1 loops=3,490)

  • Index Cond: (((emp)::text = '1'::text) AND (lineaitem = ttotlinea.lineaitem))
  • Filter: ((ttotlinea.numintot = numintot) AND (ttotlinea.numintintervencion = numintintervencion))
  • Buffers: shared hit=14082
80. 9.092 9.092 ↑ 1.0 1 2,273

Index Scan using ix_ttotcargoint_interv on ttotcargoint (cost=0.29..0.33 rows=1 width=33) (actual time=0.004..0.004 rows=1 loops=2,273)

  • Index Cond: (numintintervencion = ttotcargolinea.numintintervencion)
  • Filter: (((emp)::text = '1'::text) AND (ttotcargolinea.numintot = numintot) AND (ttotcargolinea.numintcargo = numintcargo))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=6831
81.          

SubPlan (forNested Loop)

82. 13.638 54.552 ↑ 1.0 1 2,273

Aggregate (cost=9.93..9.94 rows=1 width=32) (actual time=0.024..0.024 rows=1 loops=2,273)

  • Buffers: shared hit=10323
83. 17.837 40.914 ↓ 2.0 2 2,273

Hash Join (cost=8.46..9.92 rows=1 width=21) (actual time=0.016..0.018 rows=2 loops=2,273)

  • Hash Cond: ((ttmecanico.mecanico)::text = (ttotfichado.mecanico)::text)
  • Buffers: shared hit=10323
84. 4.893 4.893 ↑ 1.0 33 1,631

Seq Scan on ttmecanico (cost=0.00..1.33 rows=33 width=84) (actual time=0.002..0.003 rows=33 loops=1,631)

  • Buffers: shared hit=1631
85. 4.546 18.184 ↓ 2.0 2 2,273

Hash (cost=8.45..8.45 rows=1 width=8) (actual time=0.008..0.008 rows=2 loops=2,273)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=8692
86. 13.638 13.638 ↓ 2.0 2 2,273

Index Scan using pk_ttotfichado on ttotfichado (cost=0.42..8.45 rows=1 width=8) (actual time=0.006..0.006 rows=2 loops=2,273)

  • Index Cond: (((ttotintervencion.emp)::text = (emp)::text) AND (ttotintervencion.numinterno = numinterno) AND (ttotintervencion.intervencion = intervencion))
  • Filter: ((repartopendiente <> 0) OR (fichajecontraot <= 0) OR (repartopendiente IS NULL))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=8692
87. 6.819 13.638 ↑ 1.0 1 2,273

Aggregate (cost=8.45..8.46 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=2,273)

  • Buffers: shared hit=8692
88. 6.819 6.819 ↓ 2.0 2 2,273

Index Scan using pk_ttotfichado on ttotfichado ttotfichado_1 (cost=0.42..8.45 rows=1 width=5) (actual time=0.003..0.003 rows=2 loops=2,273)

  • Index Cond: (((ttotintervencion.emp)::text = (emp)::text) AND (ttotintervencion.numinterno = numinterno) AND (ttotintervencion.intervencion = intervencion))
  • Filter: ((repartopendiente <> 0) OR (fichajecontraot <= 0) OR (repartopendiente IS NULL))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=8692
89. 4.546 20.457 ↑ 1.0 1 2,273

Result (cost=8.44..8.45 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=2,273)

  • Buffers: shared hit=9098
90.          

Initplan (forResult)

91. 4.546 15.911 ↑ 1.0 1 2,273

Limit (cost=0.41..8.44 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=2,273)

  • Buffers: shared hit=9098
92. 11.365 11.365 ↑ 1.0 1 2,273

Index Only Scan using pk_ttotcargoint on ttotcargoint cargofac_4 (cost=0.41..8.44 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=2,273)

  • Index Cond: ((emp = (ttotfac.emp)::text) AND (numintot = ttotfac.numinterno) AND (numintcargo = ttotfac.numintcargo) AND (numintintervencion IS NOT NULL))
  • Heap Fetches: 2273
  • Buffers: shared hit=9098
93. 0.054 13,209.723 ↓ 17.0 17 1

Subquery Scan on *SELECT* 2" (cost=8,327.85..25,662.72 rows=1 width=3,767) (actual time=191.788..13,209.723 rows=17 loops=1)

  • Buffers: shared hit=2438802
94. 0.255 13,209.669 ↓ 17.0 17 1

Nested Loop (cost=8,327.85..25,662.69 rows=1 width=3,487) (actual time=191.784..13,209.669 rows=17 loops=1)

  • Buffers: shared hit=2438802
95. 0.041 13,209.176 ↓ 17.0 17 1

Nested Loop (cost=8,327.71..25,653.79 rows=1 width=2,322) (actual time=191.746..13,209.176 rows=17 loops=1)

  • Buffers: shared hit=2438700
96. 0.071 13,209.101 ↓ 17.0 17 1

Nested Loop (cost=8,327.71..25,652.74 rows=1 width=2,214) (actual time=191.743..13,209.101 rows=17 loops=1)

  • Buffers: shared hit=2438683
97. 0.059 13,208.996 ↓ 17.0 17 1

Nested Loop (cost=8,327.71..25,651.67 rows=1 width=2,126) (actual time=191.737..13,208.996 rows=17 loops=1)

  • Buffers: shared hit=2438666
98. 0.102 13,208.886 ↓ 17.0 17 1

Nested Loop (cost=8,327.58..25,651.51 rows=1 width=2,038) (actual time=191.726..13,208.886 rows=17 loops=1)

  • Join Filter: ((ttotcab_1.numinterno = ttotcargolinea_1.numintot) AND (ttotlinea_1.lineaitem = ttotcargolinea_1.lineaitem))
  • Rows Removed by Join Filter: 6
  • Buffers: shared hit=2438632
99. 21.586 13,208.581 ↓ 29.0 29 1

Nested Loop (cost=8,327.16..25,650.37 rows=1 width=2,021) (actual time=191.709..13,208.581 rows=29 loops=1)

  • Join Filter: (ttotfac_1.numinterno = ttotcab_1.numinterno)
  • Rows Removed by Join Filter: 278691
  • Buffers: shared hit=2438526
100. 119.519 12,155.315 ↓ 104.0 104 1

Nested Loop (cost=3,029.67..17,525.27 rows=1 width=1,289) (actual time=36.898..12,155.315 rows=104 loops=1)

  • Join Filter: (ttotfac_1.numinterno = ttotlinea_1.numintot)
  • Rows Removed by Join Filter: 1604200
  • Buffers: shared hit=2346639
101. 5.619 78.075 ↓ 857.0 857 1

Hash Join (cost=3,019.39..6,146.37 rows=1 width=982) (actual time=21.704..78.075 rows=857 loops=1)

  • Hash Cond: ((ttotcargo_1.numinterno = ttotfac_1.numinterno) AND (ttotcargo_1.cargo = ttotfac_1.numintcargo))
  • Buffers: shared hit=3596
102. 13.981 71.751 ↑ 1.0 40,882 1

Hash Left Join (cost=2,429.68..5,147.83 rows=40,882 width=214) (actual time=20.981..71.751 rows=40,882 loops=1)

  • Hash Cond: (ttotcargo_1.cliente = tgcliente_1.codigo)
  • Buffers: shared hit=3559
103. 30.180 36.974 ↑ 1.0 40,882 1

Hash Left Join (cost=1.32..2,612.14 rows=40,882 width=183) (actual time=0.023..36.974 rows=40,882 loops=1)

  • Hash Cond: ((ttotcargo_1.tallagrupcliente)::text = (tgagrupcliente_1.codigo)::text)
  • Buffers: shared hit=1961
104. 6.786 6.786 ↑ 1.0 40,882 1

Seq Scan on ttotcargo ttotcargo_1 (cost=0.00..2,471.03 rows=40,882 width=82) (actual time=0.004..6.786 rows=40,882 loops=1)

  • Filter: ((emp)::text = '1'::text)
  • Buffers: shared hit=1960
105. 0.004 0.008 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=104) (actual time=0.008..0.008 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
106. 0.004 0.004 ↑ 1.0 14 1

Seq Scan on tgagrupcliente tgagrupcliente_1 (cost=0.00..1.14 rows=14 width=104) (actual time=0.002..0.004 rows=14 loops=1)

  • Buffers: shared hit=1
107. 7.720 20.796 ↑ 1.0 36,905 1

Hash (cost=1,967.05..1,967.05 rows=36,905 width=35) (actual time=20.796..20.796 rows=36,905 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3073kB
  • Buffers: shared hit=1598
108. 13.076 13.076 ↑ 1.0 36,905 1

Seq Scan on tgcliente tgcliente_1 (cost=0.00..1,967.05 rows=36,905 width=35) (actual time=0.005..13.076 rows=36,905 loops=1)

  • Buffers: shared hit=1598
109. 0.167 0.705 ↓ 1.0 857 1

Hash (cost=577.02..577.02 rows=846 width=770) (actual time=0.705..0.705 rows=857 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 72kB
  • Buffers: shared hit=37
110. 0.121 0.538 ↓ 1.0 857 1

Hash Left Join (cost=89.92..577.02 rows=846 width=770) (actual time=0.107..0.538 rows=857 loops=1)

  • Hash Cond: ((ttotfac_1.actividadcan)::text = (tmcanactividad_1.actividad)::text)
  • Buffers: shared hit=37
111. 0.160 0.415 ↓ 1.0 857 1

Hash Left Join (cost=65.75..550.63 rows=846 width=692) (actual time=0.095..0.415 rows=857 loops=1)

  • Hash Cond: ((ttotfac_1.aseguradoracan)::text = (tmcanaseguradora_1.aseguradora)::text)
  • Buffers: shared hit=37
112. 0.174 0.239 ↓ 1.0 857 1

Bitmap Heap Scan on ttotfac ttotfac_1 (cost=31.24..512.93 rows=846 width=86) (actual time=0.072..0.239 rows=857 loops=1)

  • Recheck Cond: (((emp)::text = '1'::text) AND (fechafactura >= '2018-06-01 00:00:00'::timestamp without time zone) AND (fechafactura <= '2019-01-31 23:59:59'::timestamp without time zone))
  • Filter: (franquiciarecibo = 0)
  • Rows Removed by Filter: 5
  • Heap Blocks: exact=31
  • Buffers: shared hit=37
113. 0.065 0.065 ↓ 1.0 862 1

Bitmap Index Scan on ix_ttotfac_fechafactura (cost=0.00..31.03 rows=859 width=0) (actual time=0.065..0.065 rows=862 loops=1)

  • Index Cond: (((emp)::text = '1'::text) AND (fechafactura >= '2018-06-01 00:00:00'::timestamp without time zone) AND (fechafactura <= '2019-01-31 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=6
114. 0.000 0.016 ↓ 0.0 0 1

Hash (cost=32.89..32.89 rows=130 width=626) (actual time=0.016..0.016 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
115. 0.013 0.016 ↓ 0.0 0 1

Hash Right Join (cost=12.93..32.89 rows=130 width=626) (actual time=0.016..0.016 rows=0 loops=1)

  • Hash Cond: ((tmcangrupo_1.grupo)::text = (tmcanaseguradora_1.grupo)::text)
116. 0.000 0.000 ↓ 0.0 0

Seq Scan on tmcangrupo tmcangrupo_1 (cost=0.00..16.30 rows=630 width=90) (never executed)

117. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=11.30..11.30 rows=130 width=548) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
118. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on tmcanaseguradora tmcanaseguradora_1 (cost=0.00..11.30 rows=130 width=548) (actual time=0.002..0.002 rows=0 loops=1)

119. 0.001 0.002 ↓ 0.0 0 1

Hash (cost=16.30..16.30 rows=630 width=86) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
120. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on tmcanactividad tmcanactividad_1 (cost=0.00..16.30 rows=630 width=86) (actual time=0.001..0.001 rows=0 loops=1)

121. 338.509 11,957.721 ↓ 1.1 1,872 857

Hash Left Join (cost=10.28..11,357.72 rows=1,694 width=307) (actual time=0.023..13.953 rows=1,872 loops=857)

  • Hash Cond: (ttotlinea_1.numintrefer = ttsubcontratado_1.numintsubcont)
  • Join Filter: (ttotlinea_1.tipolinea = 3)
  • Buffers: shared hit=2343043
122. 285.372 11,619.206 ↓ 1.1 1,872 857

Hash Left Join (cost=9.06..11,352.05 rows=1,694 width=295) (actual time=0.023..13.558 rows=1,872 loops=857)

  • Hash Cond: ((ttotlinea_1.grupocont)::text = (tggrupocont_1.grupocont)::text)
  • Buffers: shared hit=2343042
123. 302.483 11,333.825 ↓ 1.1 1,872 857

Hash Left Join (cost=7.63..11,345.46 rows=1,694 width=207) (actual time=0.022..13.225 rows=1,872 loops=857)

  • Hash Cond: (((ttotlinea_1.marca)::text = (tacategoriapieza_1.marca)::text) AND ((ttotlinea_1.codigocategoria)::text = (tacategoriapieza_1.codigo)::text))
  • Buffers: shared hit=2343041
124. 287.934 11,031.304 ↓ 1.1 1,872 857

Hash Left Join (cost=3.48..11,332.37 rows=1,694 width=198) (actual time=0.022..12.872 rows=1,872 loops=857)

  • Hash Cond: ((ttotlinea_1.marca)::text = (tgmarca_1.marca)::text)
  • Buffers: shared hit=2343040
125. 10,743.352 10,743.352 ↓ 1.1 1,872 857

Index Scan using pk_ttotlinea on ttotlinea ttotlinea_1 (cost=0.42..11,324.59 rows=1,694 width=110) (actual time=0.022..12.536 rows=1,872 loops=857)

  • Index Cond: (((emp)::text = '1'::text) AND (numintintervencion = 0))
  • Filter: ((tipocab <> 2) AND (anulada = 0) AND (estasaconsigna = 0))
  • Buffers: shared hit=2343038
126. 0.008 0.018 ↑ 1.0 47 1

Hash (cost=2.47..2.47 rows=47 width=108) (actual time=0.018..0.018 rows=47 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=2
127. 0.010 0.010 ↑ 1.0 47 1

Seq Scan on tgmarca tgmarca_1 (cost=0.00..2.47 rows=47 width=108) (actual time=0.005..0.010 rows=47 loops=1)

  • Buffers: shared hit=2
128. 0.023 0.038 ↑ 1.0 126 1

Hash (cost=2.26..2.26 rows=126 width=16) (actual time=0.038..0.038 rows=126 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=1
129. 0.015 0.015 ↑ 1.0 126 1

Seq Scan on tacategoriapieza tacategoriapieza_1 (cost=0.00..2.26 rows=126 width=16) (actual time=0.005..0.015 rows=126 loops=1)

  • Buffers: shared hit=1
130. 0.004 0.009 ↑ 1.0 19 1

Hash (cost=1.19..1.19 rows=19 width=126) (actual time=0.009..0.009 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
131. 0.005 0.005 ↑ 1.0 19 1

Seq Scan on tggrupocont tggrupocont_1 (cost=0.00..1.19 rows=19 width=126) (actual time=0.003..0.005 rows=19 loops=1)

  • Buffers: shared hit=1
132. 0.002 0.006 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=20) (actual time=0.006..0.006 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
133. 0.004 0.004 ↑ 1.0 10 1

Seq Scan on ttsubcontratado ttsubcontratado_1 (cost=0.00..1.10 rows=10 width=20) (actual time=0.002..0.004 rows=10 loops=1)

  • Buffers: shared hit=1
134. 129.764 1,031.680 ↑ 1.0 2,680 104

Hash Left Join (cost=5,297.49..8,091.60 rows=2,680 width=732) (actual time=0.768..9.920 rows=2,680 loops=104)

  • Hash Cond: (ttotcab_1.clientecond = clientecond_1.codigo)
  • Buffers: shared hit=91887
135. 120.529 874.952 ↑ 1.0 2,680 104

Hash Left Join (cost=2,869.12..5,656.20 rows=2,680 width=683) (actual time=0.506..8.413 rows=2,680 loops=104)

  • Hash Cond: (((ttotcab_1.emp)::text = (tttallermarca_1.emp)::text) AND ((ttotcab_1.taller)::text = (tttallermarca_1.taller)::text) AND ((ttotcab_1.marca)::text = (tttallermarca_1.marca)::text))
  • Buffers: shared hit=90289
136. 121.458 754.416 ↑ 1.0 2,680 104

Hash Left Join (cost=2,868.06..5,632.75 rows=2,680 width=649) (actual time=0.505..7.254 rows=2,680 loops=104)

  • Hash Cond: (ttotcab_1.vehiculo = ttveh_1.numinterno)
  • Buffers: shared hit=90288
137. 94.843 610.584 ↑ 1.0 2,680 104

Hash Left Join (cost=75.48..2,833.13 rows=2,680 width=637) (actual time=0.287..5.871 rows=2,680 loops=104)

  • Hash Cond: ((ttotcab_1.categoria)::text = (tgcategoria_1.categoria)::text)
  • Buffers: shared hit=88507
138. 81.321 515.736 ↑ 1.0 2,680 104

Hash Left Join (cost=74.39..2,819.05 rows=2,680 width=549) (actual time=0.286..4.959 rows=2,680 loops=104)

  • Hash Cond: (((ttotcab_1.emp)::text = (ttrecepcionista2_1.emp)::text) AND ((ttotcab_1.taller)::text = (ttrecepcionista2_1.taller)::text) AND ((ttotcab_1.secretaria)::text = (ttrecepcionista2_1.recepcionista)::text))
  • Buffers: shared hit=88506
139. 312.925 434.408 ↑ 1.0 2,680 104

Hash Left Join (cost=73.07..2,796.25 rows=2,680 width=431) (actual time=0.285..4.177 rows=2,680 loops=104)

  • Hash Cond: (((ttotcab_1.emp)::text = (ttrecepcionista_1.emp)::text) AND ((ttotcab_1.taller)::text = (ttrecepcionista_1.taller)::text) AND ((ttotcab_1.recepcionista)::text = (ttrecepcionista_1.recepcionista)::text))
  • Buffers: shared hit=88505
140. 99.944 121.472 ↑ 1.0 2,680 104

Bitmap Heap Scan on ttotcab ttotcab_1 (cost=71.76..2,772.03 rows=2,680 width=313) (actual time=0.281..1.168 rows=2,680 loops=104)

  • Recheck Cond: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Heap Blocks: exact=87256
  • Buffers: shared hit=88504
141. 21.528 21.528 ↑ 1.0 2,680 104

Bitmap Index Scan on ix_ttotcab_status_anulada (cost=0.00..71.09 rows=2,680 width=0) (actual time=0.207..0.207 rows=2,680 loops=104)

  • Index Cond: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Buffers: shared hit=1248
142. 0.004 0.011 ↓ 7.0 7 1

Hash (cost=1.30..1.30 rows=1 width=218) (actual time=0.011..0.011 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
143. 0.007 0.007 ↓ 7.0 7 1

Seq Scan on ttrecepcionista ttrecepcionista_1 (cost=0.00..1.30 rows=1 width=218) (actual time=0.006..0.007 rows=7 loops=1)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 13
  • Buffers: shared hit=1
144. 0.003 0.007 ↓ 7.0 7 1

Hash (cost=1.30..1.30 rows=1 width=218) (actual time=0.007..0.007 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
145. 0.004 0.004 ↓ 7.0 7 1

Seq Scan on ttrecepcionista ttrecepcionista2_1 (cost=0.00..1.30 rows=1 width=218) (actual time=0.003..0.004 rows=7 loops=1)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 13
  • Buffers: shared hit=1
146. 0.002 0.005 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=104) (actual time=0.005..0.005 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
147. 0.003 0.003 ↑ 1.0 4 1

Seq Scan on tgcategoria tgcategoria_1 (cost=0.00..1.04 rows=4 width=104) (actual time=0.002..0.003 rows=4 loops=1)

  • Buffers: shared hit=1
148. 5.858 22.374 ↑ 1.0 44,959 1

Hash (cost=2,230.59..2,230.59 rows=44,959 width=20) (actual time=22.374..22.374 rows=44,959 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2606kB
  • Buffers: shared hit=1781
149. 16.516 16.516 ↑ 1.0 44,959 1

Seq Scan on ttveh ttveh_1 (cost=0.00..2,230.59 rows=44,959 width=20) (actual time=0.005..16.516 rows=44,959 loops=1)

  • Buffers: shared hit=1781
150. 0.002 0.007 ↑ 1.0 1 1

Hash (cost=1.04..1.04 rows=1 width=86) (actual time=0.007..0.007 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
151. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on tttallermarca tttallermarca_1 (cost=0.00..1.04 rows=1 width=86) (actual time=0.005..0.005 rows=1 loops=1)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=1
152. 8.781 26.964 ↑ 1.0 36,905 1

Hash (cost=1,967.05..1,967.05 rows=36,905 width=53) (actual time=26.964..26.964 rows=36,905 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3580kB
  • Buffers: shared hit=1598
153. 18.183 18.183 ↑ 1.0 36,905 1

Seq Scan on tgcliente clientecond_1 (cost=0.00..1,967.05 rows=36,905 width=53) (actual time=0.005..18.183 rows=36,905 loops=1)

  • Buffers: shared hit=1598
154. 0.203 0.203 ↑ 1.0 1 29

Index Scan using pk_ttotcargolinea on ttotcargolinea ttotcargolinea_1 (cost=0.42..1.13 rows=1 width=45) (actual time=0.007..0.007 rows=1 loops=29)

  • Index Cond: (((emp)::text = '1'::text) AND (numintot = ttotcargo_1.numinterno) AND (numintcargo = ttotcargo_1.cargo) AND (numintintervencion = 0))
  • Buffers: shared hit=106
155. 0.051 0.051 ↑ 1.0 1 17

Index Scan using pk_ttseccion on ttseccion ttseccion_1 (cost=0.13..0.15 rows=1 width=104) (actual time=0.003..0.003 rows=1 loops=17)

  • Index Cond: ((seccion)::text = (ttotcab_1.seccion)::text)
  • Buffers: shared hit=34
156. 0.034 0.034 ↑ 1.0 1 17

Seq Scan on tgtaller tgtaller_1 (cost=0.00..1.06 rows=1 width=120) (actual time=0.002..0.002 rows=1 loops=17)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=17
157. 0.034 0.034 ↑ 1.0 1 17

Seq Scan on tgempresa tgempresa_1 (cost=0.00..1.04 rows=1 width=124) (actual time=0.001..0.002 rows=1 loops=17)

  • Filter: ((emp)::text = '1'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=17
158. 0.034 0.034 ↑ 1.0 1 17

Index Scan using pk_ttgrupocargo on ttgrupocargo ttgrupocargo_1 (cost=0.14..0.15 rows=1 width=104) (actual time=0.002..0.002 rows=1 loops=17)

  • Index Cond: ((grupo)::text = (ttotcargo_1.grupocargo)::text)
  • Buffers: shared hit=34
159.          

SubPlan (forNested Loop)

160. 0.034 0.204 ↑ 1.0 1 17

Result (cost=8.44..8.45 rows=1 width=4) (actual time=0.012..0.012 rows=1 loops=17)

  • Buffers: shared hit=68
161.          

Initplan (forResult)

162. 0.051 0.170 ↑ 1.0 1 17

Limit (cost=0.41..8.44 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=17)

  • Buffers: shared hit=68
163. 0.119 0.119 ↑ 1.0 1 17

Index Only Scan using pk_ttotcargoint on ttotcargoint cargofac_3 (cost=0.41..8.44 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=17)

  • Index Cond: ((emp = (ttotfac_1.emp)::text) AND (numintot = ttotfac_1.numinterno) AND (numintcargo = ttotfac_1.numintcargo) AND (numintintervencion IS NOT NULL))
  • Heap Fetches: 17
  • Buffers: shared hit=68
164. 0.203 612.106 ↓ 45.0 45 1

Subquery Scan on *SELECT* 3" (cost=8,317.14..13,764.11 rows=1 width=4,048) (actual time=73.616..612.106 rows=45 loops=1)

  • Buffers: shared hit=55085
165. 0.339 611.903 ↓ 45.0 45 1

Nested Loop (cost=8,317.14..13,764.02 rows=1 width=3,208) (actual time=73.608..611.903 rows=45 loops=1)

  • Buffers: shared hit=55085
166. 0.103 611.069 ↓ 45.0 45 1

Nested Loop (cost=8,317.01..13,755.31 rows=1 width=1,982) (actual time=73.571..611.069 rows=45 loops=1)

  • Buffers: shared hit=54815
167. 0.102 610.921 ↓ 45.0 45 1

Nested Loop (cost=8,317.01..13,754.27 rows=1 width=1,874) (actual time=73.566..610.921 rows=45 loops=1)

  • Buffers: shared hit=54770
168. 0.102 610.729 ↓ 45.0 45 1

Nested Loop (cost=8,317.01..13,753.20 rows=1 width=1,786) (actual time=73.559..610.729 rows=45 loops=1)

  • Buffers: shared hit=54725
169. 11.138 610.492 ↓ 45.0 45 1

Nested Loop (cost=8,316.88..13,753.04 rows=1 width=1,698) (actual time=73.541..610.492 rows=45 loops=1)

  • Join Filter: (ttotfac_2.numinterno = ttotcab_2.numinterno)
  • Rows Removed by Join Filter: 150035
  • Buffers: shared hit=54635
170. 0.454 35.154 ↓ 56.0 56 1

Hash Join (cost=3,019.39..5,627.94 rows=1 width=978) (actual time=21.673..35.154 rows=56 loops=1)

  • Hash Cond: ((ttotcargo_2.numinterno = ttotfac_2.numinterno) AND (ttotcargo_2.cargo = ttotfac_2.numintcargo))
  • Buffers: shared hit=3596
171. 1.127 33.986 ↑ 1.0 2,188 1

Hash Left Join (cost=2,429.68..5,016.21 rows=2,201 width=214) (actual time=20.946..33.986 rows=2,188 loops=1)

  • Hash Cond: (ttotcargo_2.cliente = tgcliente_2.codigo)
  • Buffers: shared hit=3559
172. 1.428 12.110 ↑ 1.0 2,188 1

Hash Left Join (cost=1.32..2,582.07 rows=2,201 width=183) (actual time=0.034..12.110 rows=2,188 loops=1)

  • Hash Cond: ((ttotcargo_2.tallagrupcliente)::text = (tgagrupcliente_2.codigo)::text)
  • Buffers: shared hit=1961
173. 10.674 10.674 ↑ 1.0 2,188 1

Seq Scan on ttotcargo ttotcargo_2 (cost=0.00..2,573.23 rows=2,201 width=82) (actual time=0.017..10.674 rows=2,188 loops=1)

  • Filter: ((impdtocargopie > '0'::numeric) AND ((emp)::text = '1'::text))
  • Rows Removed by Filter: 38694
  • Buffers: shared hit=1960
174. 0.004 0.008 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=104) (actual time=0.008..0.008 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
175. 0.004 0.004 ↑ 1.0 14 1

Seq Scan on tgagrupcliente tgagrupcliente_2 (cost=0.00..1.14 rows=14 width=104) (actual time=0.003..0.004 rows=14 loops=1)

  • Buffers: shared hit=1
176. 7.680 20.749 ↑ 1.0 36,905 1

Hash (cost=1,967.05..1,967.05 rows=36,905 width=35) (actual time=20.749..20.749 rows=36,905 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3073kB
  • Buffers: shared hit=1598
177. 13.069 13.069 ↑ 1.0 36,905 1

Seq Scan on tgcliente tgcliente_2 (cost=0.00..1,967.05 rows=36,905 width=35) (actual time=0.004..13.069 rows=36,905 loops=1)

  • Buffers: shared hit=1598
178. 0.174 0.714 ↓ 1.0 857 1

Hash (cost=577.02..577.02 rows=846 width=770) (actual time=0.714..0.714 rows=857 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 72kB
  • Buffers: shared hit=37
179. 0.119 0.540 ↓ 1.0 857 1

Hash Left Join (cost=89.92..577.02 rows=846 width=770) (actual time=0.109..0.540 rows=857 loops=1)

  • Hash Cond: ((ttotfac_2.actividadcan)::text = (tmcanactividad_2.actividad)::text)
  • Buffers: shared hit=37
180. 0.167 0.419 ↓ 1.0 857 1

Hash Left Join (cost=65.75..550.63 rows=846 width=692) (actual time=0.100..0.419 rows=857 loops=1)

  • Hash Cond: ((ttotfac_2.aseguradoracan)::text = (tmcanaseguradora_2.aseguradora)::text)
  • Buffers: shared hit=37
181. 0.175 0.242 ↓ 1.0 857 1

Bitmap Heap Scan on ttotfac ttotfac_2 (cost=31.24..512.93 rows=846 width=86) (actual time=0.076..0.242 rows=857 loops=1)

  • Recheck Cond: (((emp)::text = '1'::text) AND (fechafactura >= '2018-06-01 00:00:00'::timestamp without time zone) AND (fechafactura <= '2019-01-31 23:59:59'::timestamp without time zone))
  • Filter: (franquiciarecibo = 0)
  • Rows Removed by Filter: 5
  • Heap Blocks: exact=31
  • Buffers: shared hit=37
182. 0.067 0.067 ↓ 1.0 862 1

Bitmap Index Scan on ix_ttotfac_fechafactura (cost=0.00..31.03 rows=859 width=0) (actual time=0.067..0.067 rows=862 loops=1)

  • Index Cond: (((emp)::text = '1'::text) AND (fechafactura >= '2018-06-01 00:00:00'::timestamp without time zone) AND (fechafactura <= '2019-01-31 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=6
183. 0.000 0.010 ↓ 0.0 0 1

Hash (cost=32.89..32.89 rows=130 width=626) (actual time=0.010..0.010 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
184. 0.006 0.010 ↓ 0.0 0 1

Hash Right Join (cost=12.93..32.89 rows=130 width=626) (actual time=0.010..0.010 rows=0 loops=1)

  • Hash Cond: ((tmcangrupo_2.grupo)::text = (tmcanaseguradora_2.grupo)::text)
185. 0.000 0.000 ↓ 0.0 0

Seq Scan on tmcangrupo tmcangrupo_2 (cost=0.00..16.30 rows=630 width=90) (never executed)

186. 0.000 0.004 ↓ 0.0 0 1

Hash (cost=11.30..11.30 rows=130 width=548) (actual time=0.004..0.004 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
187. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on tmcanaseguradora tmcanaseguradora_2 (cost=0.00..11.30 rows=130 width=548) (actual time=0.004..0.004 rows=0 loops=1)

188. 0.001 0.002 ↓ 0.0 0 1

Hash (cost=16.30..16.30 rows=630 width=86) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
189. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on tmcanactividad tmcanactividad_2 (cost=0.00..16.30 rows=630 width=86) (actual time=0.001..0.001 rows=0 loops=1)

190. 64.586 564.200 ↑ 1.0 2,680 56

Hash Left Join (cost=5,297.49..8,091.60 rows=2,680 width=724) (actual time=1.184..10.075 rows=2,680 loops=56)

  • Hash Cond: (ttotcab_2.clientecond = clientecond_2.codigo)
  • Buffers: shared hit=51039
191. 67.025 471.744 ↑ 1.0 2,680 56

Hash Left Join (cost=2,869.12..5,656.20 rows=2,680 width=675) (actual time=0.683..8.424 rows=2,680 loops=56)

  • Hash Cond: (((ttotcab_2.emp)::text = (tttallermarca_2.emp)::text) AND ((ttotcab_2.taller)::text = (tttallermarca_2.taller)::text) AND ((ttotcab_2.marca)::text = (tttallermarca_2.marca)::text))
  • Buffers: shared hit=49441
192. 58.075 404.712 ↑ 1.0 2,680 56

Hash Left Join (cost=2,868.06..5,632.75 rows=2,680 width=641) (actual time=0.682..7.227 rows=2,680 loops=56)

  • Hash Cond: (ttotcab_2.vehiculo = ttveh_2.numinterno)
  • Buffers: shared hit=49440
193. 50.171 324.296 ↑ 1.0 2,680 56

Hash Left Join (cost=75.48..2,833.13 rows=2,680 width=629) (actual time=0.280..5.791 rows=2,680 loops=56)

  • Hash Cond: ((ttotcab_2.categoria)::text = (tgcategoria_2.categoria)::text)
  • Buffers: shared hit=47659
194. 43.281 274.120 ↑ 1.0 2,680 56

Hash Left Join (cost=74.39..2,819.05 rows=2,680 width=541) (actual time=0.279..4.895 rows=2,680 loops=56)

  • Hash Cond: (((ttotcab_2.emp)::text = (ttrecepcionista2_2.emp)::text) AND ((ttotcab_2.taller)::text = (ttrecepcionista2_2.taller)::text) AND ((ttotcab_2.secretaria)::text = (ttrecepcionista2_2.recepcionista)::text))
  • Buffers: shared hit=47658
195. 169.555 230.832 ↑ 1.0 2,680 56

Hash Left Join (cost=73.07..2,796.25 rows=2,680 width=423) (actual time=0.278..4.122 rows=2,680 loops=56)

  • Hash Cond: (((ttotcab_2.emp)::text = (ttrecepcionista_2.emp)::text) AND ((ttotcab_2.taller)::text = (ttrecepcionista_2.taller)::text) AND ((ttotcab_2.recepcionista)::text = (ttrecepcionista_2.recepcionista)::text))
  • Buffers: shared hit=47657
196. 49.840 61.264 ↑ 1.0 2,680 56

Bitmap Heap Scan on ttotcab ttotcab_2 (cost=71.76..2,772.03 rows=2,680 width=305) (actual time=0.276..1.094 rows=2,680 loops=56)

  • Recheck Cond: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Heap Blocks: exact=46984
  • Buffers: shared hit=47656
197. 11.424 11.424 ↑ 1.0 2,680 56

Bitmap Index Scan on ix_ttotcab_status_anulada (cost=0.00..71.09 rows=2,680 width=0) (actual time=0.204..0.204 rows=2,680 loops=56)

  • Index Cond: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Buffers: shared hit=672
198. 0.006 0.013 ↓ 7.0 7 1

Hash (cost=1.30..1.30 rows=1 width=218) (actual time=0.013..0.013 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
199. 0.007 0.007 ↓ 7.0 7 1

Seq Scan on ttrecepcionista ttrecepcionista_2 (cost=0.00..1.30 rows=1 width=218) (actual time=0.005..0.007 rows=7 loops=1)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 13
  • Buffers: shared hit=1
200. 0.003 0.007 ↓ 7.0 7 1

Hash (cost=1.30..1.30 rows=1 width=218) (actual time=0.007..0.007 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
201. 0.004 0.004 ↓ 7.0 7 1

Seq Scan on ttrecepcionista ttrecepcionista2_2 (cost=0.00..1.30 rows=1 width=218) (actual time=0.003..0.004 rows=7 loops=1)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 13
  • Buffers: shared hit=1
202. 0.002 0.005 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=104) (actual time=0.005..0.005 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
203. 0.003 0.003 ↑ 1.0 4 1

Seq Scan on tgcategoria tgcategoria_2 (cost=0.00..1.04 rows=4 width=104) (actual time=0.002..0.003 rows=4 loops=1)

  • Buffers: shared hit=1
204. 5.865 22.341 ↑ 1.0 44,959 1

Hash (cost=2,230.59..2,230.59 rows=44,959 width=20) (actual time=22.341..22.341 rows=44,959 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2606kB
  • Buffers: shared hit=1781
205. 16.476 16.476 ↑ 1.0 44,959 1

Seq Scan on ttveh ttveh_2 (cost=0.00..2,230.59 rows=44,959 width=20) (actual time=0.004..16.476 rows=44,959 loops=1)

  • Buffers: shared hit=1781
206. 0.002 0.007 ↑ 1.0 1 1

Hash (cost=1.04..1.04 rows=1 width=86) (actual time=0.007..0.007 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
207. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on tttallermarca tttallermarca_2 (cost=0.00..1.04 rows=1 width=86) (actual time=0.005..0.005 rows=1 loops=1)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=1
208. 9.567 27.870 ↑ 1.0 36,905 1

Hash (cost=1,967.05..1,967.05 rows=36,905 width=53) (actual time=27.870..27.870 rows=36,905 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3580kB
  • Buffers: shared hit=1598
209. 18.303 18.303 ↑ 1.0 36,905 1

Seq Scan on tgcliente clientecond_2 (cost=0.00..1,967.05 rows=36,905 width=53) (actual time=0.005..18.303 rows=36,905 loops=1)

  • Buffers: shared hit=1598
210. 0.135 0.135 ↑ 1.0 1 45

Index Scan using pk_ttseccion on ttseccion ttseccion_2 (cost=0.13..0.15 rows=1 width=104) (actual time=0.003..0.003 rows=1 loops=45)

  • Index Cond: ((seccion)::text = (ttotcab_2.seccion)::text)
  • Buffers: shared hit=90
211. 0.090 0.090 ↑ 1.0 1 45

Seq Scan on tgtaller tgtaller_2 (cost=0.00..1.06 rows=1 width=120) (actual time=0.002..0.002 rows=1 loops=45)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=45
212. 0.045 0.045 ↑ 1.0 1 45

Seq Scan on tgempresa tgempresa_2 (cost=0.00..1.04 rows=1 width=124) (actual time=0.001..0.001 rows=1 loops=45)

  • Filter: ((emp)::text = '1'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=45
213. 0.090 0.090 ↑ 1.0 1 45

Index Scan using pk_ttgrupocargo on ttgrupocargo ttgrupocargo_2 (cost=0.14..0.16 rows=1 width=104) (actual time=0.002..0.002 rows=1 loops=45)

  • Index Cond: ((grupo)::text = (ttotcargo_2.grupocargo)::text)
  • Buffers: shared hit=90
214.          

SubPlan (forNested Loop)

215. 0.045 0.405 ↑ 1.0 1 45

Result (cost=8.44..8.45 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=45)

  • Buffers: shared hit=180
216.          

Initplan (forResult)

217. 0.090 0.360 ↑ 1.0 1 45

Limit (cost=0.41..8.44 rows=1 width=4) (actual time=0.007..0.008 rows=1 loops=45)

  • Buffers: shared hit=180
218. 0.270 0.270 ↑ 1.0 1 45

Index Only Scan using pk_ttotcargoint on ttotcargoint cargofac_2 (cost=0.41..8.44 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=45)

  • Index Cond: ((emp = (ttotfac_2.emp)::text) AND (numintot = ttotfac_2.numinterno) AND (numintcargo = ttotfac_2.numintcargo) AND (numintintervencion IS NOT NULL))
  • Heap Fetches: 45
  • Buffers: shared hit=180
219. 0.001 1,356.148 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4" (cost=8,318.57..13,915.57 rows=1 width=4,044) (actual time=1,356.148..1,356.148 rows=0 loops=1)

  • Buffers: shared hit=120163
220. 0.001 1,356.147 ↓ 0.0 0 1

Nested Loop (cost=8,318.57..13,915.49 rows=1 width=3,204) (actual time=1,356.147..1,356.147 rows=0 loops=1)

  • Buffers: shared hit=120163
221. 0.000 1,356.146 ↓ 0.0 0 1

Nested Loop (cost=8,318.44..13,906.79 rows=1 width=2,071) (actual time=1,356.146..1,356.146 rows=0 loops=1)

  • Buffers: shared hit=120163
222. 0.000 1,356.146 ↓ 0.0 0 1

Nested Loop (cost=8,318.44..13,905.74 rows=1 width=1,963) (actual time=1,356.146..1,356.146 rows=0 loops=1)

  • Buffers: shared hit=120163
223. 0.001 1,356.146 ↓ 0.0 0 1

Nested Loop (cost=8,318.44..13,904.67 rows=1 width=1,875) (actual time=1,356.145..1,356.146 rows=0 loops=1)

  • Buffers: shared hit=120163
224. 28.075 1,356.145 ↓ 0.0 0 1

Nested Loop (cost=8,318.30..13,904.51 rows=1 width=1,787) (actual time=1,356.145..1,356.145 rows=0 loops=1)

  • Join Filter: (ttotfac_3.numinterno = ttotcab_3.numinterno)
  • Rows Removed by Join Filter: 356440
  • Buffers: shared hit=120163
225. 1.455 53.132 ↓ 133.0 133 1

Hash Join (cost=3,020.82..5,779.42 rows=1 width=1,067) (actual time=21.650..53.132 rows=133 loops=1)

  • Hash Cond: ((ttotcargo_3.numinterno = ttotfac_3.numinterno) AND (ttotcargo_3.cargo = ttotfac_3.numintcargo))
  • Buffers: shared hit=3597
226. 2.785 50.963 ↓ 1.0 9,700 1

Hash Left Join (cost=2,431.11..5,093.43 rows=9,626 width=303) (actual time=20.904..50.963 rows=9,700 loops=1)

  • Hash Cond: ((ttotcargo_3.grupocontecotasa)::text = (tggrupocont_2.grupocont)::text)
  • Buffers: shared hit=3560
227. 4.147 48.166 ↓ 1.0 9,700 1

Hash Left Join (cost=2,429.68..5,061.10 rows=9,626 width=215) (actual time=20.879..48.166 rows=9,700 loops=1)

  • Hash Cond: (ttotcargo_3.cliente = tgcliente_3.codigo)
  • Buffers: shared hit=3559
228. 4.132 23.337 ↓ 1.0 9,700 1

Hash Left Join (cost=1.32..2,607.47 rows=9,626 width=184) (actual time=0.039..23.337 rows=9,700 loops=1)

  • Hash Cond: ((ttotcargo_3.tallagrupcliente)::text = (tgagrupcliente_3.codigo)::text)
  • Buffers: shared hit=1961
229. 19.196 19.196 ↓ 1.0 9,700 1

Seq Scan on ttotcargo ttotcargo_3 (cost=0.00..2,573.23 rows=9,626 width=83) (actual time=0.018..19.196 rows=9,700 loops=1)

  • Filter: ((importeecotasa > '0'::numeric) AND ((emp)::text = '1'::text))
  • Rows Removed by Filter: 31182
  • Buffers: shared hit=1960
230. 0.004 0.009 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=104) (actual time=0.009..0.009 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
231. 0.005 0.005 ↑ 1.0 14 1

Seq Scan on tgagrupcliente tgagrupcliente_3 (cost=0.00..1.14 rows=14 width=104) (actual time=0.003..0.005 rows=14 loops=1)

  • Buffers: shared hit=1
232. 7.605 20.682 ↑ 1.0 36,905 1

Hash (cost=1,967.05..1,967.05 rows=36,905 width=35) (actual time=20.682..20.682 rows=36,905 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3073kB
  • Buffers: shared hit=1598
233. 13.077 13.077 ↑ 1.0 36,905 1

Seq Scan on tgcliente tgcliente_3 (cost=0.00..1,967.05 rows=36,905 width=35) (actual time=0.004..13.077 rows=36,905 loops=1)

  • Buffers: shared hit=1598
234. 0.006 0.012 ↑ 1.0 19 1

Hash (cost=1.19..1.19 rows=19 width=126) (actual time=0.012..0.012 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
235. 0.006 0.006 ↑ 1.0 19 1

Seq Scan on tggrupocont tggrupocont_2 (cost=0.00..1.19 rows=19 width=126) (actual time=0.004..0.006 rows=19 loops=1)

  • Buffers: shared hit=1
236. 0.171 0.714 ↓ 1.0 857 1

Hash (cost=577.02..577.02 rows=846 width=770) (actual time=0.714..0.714 rows=857 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 72kB
  • Buffers: shared hit=37
237. 0.124 0.543 ↓ 1.0 857 1

Hash Left Join (cost=89.92..577.02 rows=846 width=770) (actual time=0.105..0.543 rows=857 loops=1)

  • Hash Cond: ((ttotfac_3.actividadcan)::text = (tmcanactividad_3.actividad)::text)
  • Buffers: shared hit=37
238. 0.170 0.417 ↓ 1.0 857 1

Hash Left Join (cost=65.75..550.63 rows=846 width=692) (actual time=0.093..0.417 rows=857 loops=1)

  • Hash Cond: ((ttotfac_3.aseguradoracan)::text = (tmcanaseguradora_3.aseguradora)::text)
  • Buffers: shared hit=37
239. 0.176 0.240 ↓ 1.0 857 1

Bitmap Heap Scan on ttotfac ttotfac_3 (cost=31.24..512.93 rows=846 width=86) (actual time=0.071..0.240 rows=857 loops=1)

  • Recheck Cond: (((emp)::text = '1'::text) AND (fechafactura >= '2018-06-01 00:00:00'::timestamp without time zone) AND (fechafactura <= '2019-01-31 23:59:59'::timestamp without time zone))
  • Filter: (franquiciarecibo = 0)
  • Rows Removed by Filter: 5
  • Heap Blocks: exact=31
  • Buffers: shared hit=37
240. 0.064 0.064 ↓ 1.0 862 1

Bitmap Index Scan on ix_ttotfac_fechafactura (cost=0.00..31.03 rows=859 width=0) (actual time=0.064..0.064 rows=862 loops=1)

  • Index Cond: (((emp)::text = '1'::text) AND (fechafactura >= '2018-06-01 00:00:00'::timestamp without time zone) AND (fechafactura <= '2019-01-31 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=6
241. 0.000 0.007 ↓ 0.0 0 1

Hash (cost=32.89..32.89 rows=130 width=626) (actual time=0.007..0.007 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
242. 0.004 0.007 ↓ 0.0 0 1

Hash Right Join (cost=12.93..32.89 rows=130 width=626) (actual time=0.007..0.007 rows=0 loops=1)

  • Hash Cond: ((tmcangrupo_3.grupo)::text = (tmcanaseguradora_3.grupo)::text)
243. 0.000 0.000 ↓ 0.0 0

Seq Scan on tmcangrupo tmcangrupo_3 (cost=0.00..16.30 rows=630 width=90) (never executed)

244. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=11.30..11.30 rows=130 width=548) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
245. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on tmcanaseguradora tmcanaseguradora_3 (cost=0.00..11.30 rows=130 width=548) (actual time=0.003..0.003 rows=0 loops=1)

246. 0.001 0.002 ↓ 0.0 0 1

Hash (cost=16.30..16.30 rows=630 width=86) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
247. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on tmcanactividad tmcanactividad_3 (cost=0.00..16.30 rows=630 width=86) (actual time=0.001..0.001 rows=0 loops=1)

248. 155.591 1,274.938 ↑ 1.0 2,680 133

Hash Left Join (cost=5,297.49..8,091.60 rows=2,680 width=724) (actual time=0.658..9.586 rows=2,680 loops=133)

  • Hash Cond: (ttotcab_3.clientecond = clientecond_3.codigo)
  • Buffers: shared hit=116566
249. 153.075 1,092.329 ↑ 1.0 2,680 133

Hash Left Join (cost=2,869.12..5,656.20 rows=2,680 width=675) (actual time=0.453..8.213 rows=2,680 loops=133)

  • Hash Cond: (((ttotcab_3.emp)::text = (tttallermarca_3.emp)::text) AND ((ttotcab_3.taller)::text = (tttallermarca_3.taller)::text) AND ((ttotcab_3.marca)::text = (tttallermarca_3.marca)::text))
  • Buffers: shared hit=114968
250. 141.470 939.246 ↑ 1.0 2,680 133

Hash Left Join (cost=2,868.06..5,632.75 rows=2,680 width=641) (actual time=0.452..7.062 rows=2,680 loops=133)

  • Hash Cond: (ttotcab_3.vehiculo = ttveh_3.numinterno)
  • Buffers: shared hit=114967
251. 122.088 775.523 ↑ 1.0 2,680 133

Hash Left Join (cost=75.48..2,833.13 rows=2,680 width=629) (actual time=0.283..5.831 rows=2,680 loops=133)

  • Hash Cond: ((ttotcab_3.categoria)::text = (tgcategoria_3.categoria)::text)
  • Buffers: shared hit=113186
252. 104.398 653.429 ↑ 1.0 2,680 133

Hash Left Join (cost=74.39..2,819.05 rows=2,680 width=541) (actual time=0.282..4.913 rows=2,680 loops=133)

  • Hash Cond: (((ttotcab_3.emp)::text = (ttrecepcionista2_3.emp)::text) AND ((ttotcab_3.taller)::text = (ttrecepcionista2_3.taller)::text) AND ((ttotcab_3.secretaria)::text = (ttrecepcionista2_3.recepcionista)::text))
  • Buffers: shared hit=113185
253. 404.842 549.024 ↑ 1.0 2,680 133

Hash Left Join (cost=73.07..2,796.25 rows=2,680 width=423) (actual time=0.281..4.128 rows=2,680 loops=133)

  • Hash Cond: (((ttotcab_3.emp)::text = (ttrecepcionista_3.emp)::text) AND ((ttotcab_3.taller)::text = (ttrecepcionista_3.taller)::text) AND ((ttotcab_3.recepcionista)::text = (ttrecepcionista_3.recepcionista)::text))
  • Buffers: shared hit=113184
254. 116.641 144.172 ↑ 1.0 2,680 133

Bitmap Heap Scan on ttotcab ttotcab_3 (cost=71.76..2,772.03 rows=2,680 width=305) (actual time=0.279..1.084 rows=2,680 loops=133)

  • Recheck Cond: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Heap Blocks: exact=111587
  • Buffers: shared hit=113183
255. 27.531 27.531 ↑ 1.0 2,680 133

Bitmap Index Scan on ix_ttotcab_status_anulada (cost=0.00..71.09 rows=2,680 width=0) (actual time=0.207..0.207 rows=2,680 loops=133)

  • Index Cond: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Buffers: shared hit=1596
256. 0.004 0.010 ↓ 7.0 7 1

Hash (cost=1.30..1.30 rows=1 width=218) (actual time=0.010..0.010 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
257. 0.006 0.006 ↓ 7.0 7 1

Seq Scan on ttrecepcionista ttrecepcionista_3 (cost=0.00..1.30 rows=1 width=218) (actual time=0.005..0.006 rows=7 loops=1)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 13
  • Buffers: shared hit=1
258. 0.003 0.007 ↓ 7.0 7 1

Hash (cost=1.30..1.30 rows=1 width=218) (actual time=0.007..0.007 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
259. 0.004 0.004 ↓ 7.0 7 1

Seq Scan on ttrecepcionista ttrecepcionista2_3 (cost=0.00..1.30 rows=1 width=218) (actual time=0.003..0.004 rows=7 loops=1)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 13
  • Buffers: shared hit=1
260. 0.003 0.006 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=104) (actual time=0.006..0.006 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
261. 0.003 0.003 ↑ 1.0 4 1

Seq Scan on tgcategoria tgcategoria_3 (cost=0.00..1.04 rows=4 width=104) (actual time=0.002..0.003 rows=4 loops=1)

  • Buffers: shared hit=1
262. 5.818 22.253 ↑ 1.0 44,959 1

Hash (cost=2,230.59..2,230.59 rows=44,959 width=20) (actual time=22.253..22.253 rows=44,959 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2606kB
  • Buffers: shared hit=1781
263. 16.435 16.435 ↑ 1.0 44,959 1

Seq Scan on ttveh ttveh_3 (cost=0.00..2,230.59 rows=44,959 width=20) (actual time=0.004..16.435 rows=44,959 loops=1)

  • Buffers: shared hit=1781
264. 0.003 0.008 ↑ 1.0 1 1

Hash (cost=1.04..1.04 rows=1 width=86) (actual time=0.008..0.008 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
265. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on tttallermarca tttallermarca_3 (cost=0.00..1.04 rows=1 width=86) (actual time=0.005..0.005 rows=1 loops=1)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=1
266. 8.782 27.018 ↑ 1.0 36,905 1

Hash (cost=1,967.05..1,967.05 rows=36,905 width=53) (actual time=27.018..27.018 rows=36,905 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3580kB
  • Buffers: shared hit=1598
267. 18.236 18.236 ↑ 1.0 36,905 1

Seq Scan on tgcliente clientecond_3 (cost=0.00..1,967.05 rows=36,905 width=53) (actual time=0.005..18.236 rows=36,905 loops=1)

  • Buffers: shared hit=1598
268. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ttseccion on ttseccion ttseccion_3 (cost=0.13..0.15 rows=1 width=104) (never executed)

  • Index Cond: ((seccion)::text = (ttotcab_3.seccion)::text)
269. 0.000 0.000 ↓ 0.0 0

Seq Scan on tgtaller tgtaller_3 (cost=0.00..1.06 rows=1 width=120) (never executed)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
270. 0.000 0.000 ↓ 0.0 0

Seq Scan on tgempresa tgempresa_3 (cost=0.00..1.04 rows=1 width=124) (never executed)

  • Filter: ((emp)::text = '1'::text)
271. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ttgrupocargo on ttgrupocargo ttgrupocargo_3 (cost=0.14..0.15 rows=1 width=104) (never executed)

  • Index Cond: ((grupo)::text = (ttotcargo_3.grupocargo)::text)
272.          

SubPlan (forNested Loop)

273. 0.000 0.000 ↓ 0.0 0

Result (cost=8.44..8.45 rows=1 width=4) (never executed)

274.          

Initplan (forResult)

275. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.41..8.44 rows=1 width=4) (never executed)

276. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_ttotcargoint on ttotcargoint cargofac_1 (cost=0.41..8.44 rows=1 width=4) (never executed)

  • Index Cond: ((emp = (ttotfac_3.emp)::text) AND (numintot = ttotfac_3.numinterno) AND (numintcargo = ttotfac_3.numintcargo) AND (numintintervencion IS NOT NULL))
  • Heap Fetches: 0
277. 0.000 17.874 ↓ 0.0 0 1

Subquery Scan on *SELECT* 5" (cost=5,387.83..11,311.20 rows=1 width=4,044) (actual time=17.874..17.874 rows=0 loops=1)

  • Buffers: shared hit=1960
278. 0.001 17.874 ↓ 0.0 0 1

Nested Loop (cost=5,387.83..11,311.11 rows=1 width=3,204) (actual time=17.874..17.874 rows=0 loops=1)

  • Join Filter: ((ttotcargo_4.grupocargo)::text = (ttgrupocargo_4.grupo)::text)
  • Buffers: shared hit=1960
279. 0.000 17.873 ↓ 0.0 0 1

Nested Loop (cost=5,387.83..11,301.37 rows=1 width=2,071) (actual time=17.873..17.873 rows=0 loops=1)

  • Buffers: shared hit=1960
280. 0.001 17.873 ↓ 0.0 0 1

Nested Loop (cost=5,387.83..11,300.32 rows=1 width=1,963) (actual time=17.873..17.873 rows=0 loops=1)

  • Buffers: shared hit=1960
281. 0.000 17.872 ↓ 0.0 0 1

Nested Loop (cost=5,387.83..11,299.25 rows=1 width=1,875) (actual time=17.872..17.872 rows=0 loops=1)

  • Buffers: shared hit=1960
282. 0.000 17.872 ↓ 0.0 0 1

Nested Loop (cost=5,387.70..11,299.09 rows=1 width=1,787) (actual time=17.872..17.872 rows=0 loops=1)

  • Join Filter: ((ttotcab_4.numinterno = ttotfac_4.numinterno) AND (ttotcargo_4.cargo = ttotfac_4.numintcargo))
  • Buffers: shared hit=1960
283. 0.001 17.872 ↓ 0.0 0 1

Nested Loop (cost=5,297.78..10,709.38 rows=1 width=1,027) (actual time=17.872..17.872 rows=0 loops=1)

  • Join Filter: (ttotcab_4.numinterno = ttotcargo_4.numinterno)
  • Buffers: shared hit=1960
284. 0.000 17.871 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..2,584.28 rows=1 width=303) (actual time=17.871..17.871 rows=0 loops=1)

  • Join Filter: ((ttotcargo_4.grupocontpeqmat)::text = (tggrupocont_3.grupocont)::text)
  • Buffers: shared hit=1960
285. 0.001 17.871 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..2,582.85 rows=1 width=215) (actual time=17.871..17.871 rows=0 loops=1)

  • Buffers: shared hit=1960
286. 0.000 17.870 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..2,574.55 rows=1 width=184) (actual time=17.870..17.870 rows=0 loops=1)

  • Join Filter: ((ttotcargo_4.tallagrupcliente)::text = (tgagrupcliente_4.codigo)::text)
  • Buffers: shared hit=1960
287. 17.870 17.870 ↓ 0.0 0 1

Seq Scan on ttotcargo ttotcargo_4 (cost=0.00..2,573.23 rows=1 width=83) (actual time=17.870..17.870 rows=0 loops=1)

  • Filter: ((importepeqmaterial > '0'::numeric) AND ((emp)::text = '1'::text))
  • Rows Removed by Filter: 40882
  • Buffers: shared hit=1960
288. 0.000 0.000 ↓ 0.0 0

Seq Scan on tgagrupcliente tgagrupcliente_4 (cost=0.00..1.14 rows=14 width=104) (never executed)

289. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_tgcliente on tgcliente tgcliente_4 (cost=0.29..8.31 rows=1 width=35) (never executed)

  • Index Cond: (ttotcargo_4.cliente = codigo)
290. 0.000 0.000 ↓ 0.0 0

Seq Scan on tggrupocont tggrupocont_3 (cost=0.00..1.19 rows=19 width=126) (never executed)

291. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=5,297.49..8,091.60 rows=2,680 width=724) (never executed)

  • Hash Cond: (ttotcab_4.clientecond = clientecond_4.codigo)
292. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,869.12..5,656.20 rows=2,680 width=675) (never executed)

  • Hash Cond: (((ttotcab_4.emp)::text = (tttallermarca_4.emp)::text) AND ((ttotcab_4.taller)::text = (tttallermarca_4.taller)::text) AND ((ttotcab_4.marca)::text = (tttallermarca_4.marca)::text))
293. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,868.06..5,632.75 rows=2,680 width=641) (never executed)

  • Hash Cond: (ttotcab_4.vehiculo = ttveh_4.numinterno)
294. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=75.48..2,833.13 rows=2,680 width=629) (never executed)

  • Hash Cond: ((ttotcab_4.categoria)::text = (tgcategoria_4.categoria)::text)
295. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=74.39..2,819.05 rows=2,680 width=541) (never executed)

  • Hash Cond: (((ttotcab_4.emp)::text = (ttrecepcionista2_4.emp)::text) AND ((ttotcab_4.taller)::text = (ttrecepcionista2_4.taller)::text) AND ((ttotcab_4.secretaria)::text = (ttrecepcionista2_4.recepcionista)::text))
296. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=73.07..2,796.25 rows=2,680 width=423) (never executed)

  • Hash Cond: (((ttotcab_4.emp)::text = (ttrecepcionista_4.emp)::text) AND ((ttotcab_4.taller)::text = (ttrecepcionista_4.taller)::text) AND ((ttotcab_4.recepcionista)::text = (ttrecepcionista_4.recepcionista)::text))
297. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on ttotcab ttotcab_4 (cost=71.76..2,772.03 rows=2,680 width=305) (never executed)

  • Recheck Cond: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
298. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix_ttotcab_status_anulada (cost=0.00..71.09 rows=2,680 width=0) (never executed)

  • Index Cond: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
299. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.30..1.30 rows=1 width=218) (never executed)

300. 0.000 0.000 ↓ 0.0 0

Seq Scan on ttrecepcionista ttrecepcionista_4 (cost=0.00..1.30 rows=1 width=218) (never executed)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
301. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.30..1.30 rows=1 width=218) (never executed)

302. 0.000 0.000 ↓ 0.0 0

Seq Scan on ttrecepcionista ttrecepcionista2_4 (cost=0.00..1.30 rows=1 width=218) (never executed)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
303. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.04..1.04 rows=4 width=104) (never executed)

304. 0.000 0.000 ↓ 0.0 0

Seq Scan on tgcategoria tgcategoria_4 (cost=0.00..1.04 rows=4 width=104) (never executed)

305. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,230.59..2,230.59 rows=44,959 width=20) (never executed)

306. 0.000 0.000 ↓ 0.0 0

Seq Scan on ttveh ttveh_4 (cost=0.00..2,230.59 rows=44,959 width=20) (never executed)

307. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.04..1.04 rows=1 width=86) (never executed)

308. 0.000 0.000 ↓ 0.0 0

Seq Scan on tttallermarca tttallermarca_4 (cost=0.00..1.04 rows=1 width=86) (never executed)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
309. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,967.05..1,967.05 rows=36,905 width=53) (never executed)

310. 0.000 0.000 ↓ 0.0 0

Seq Scan on tgcliente clientecond_4 (cost=0.00..1,967.05 rows=36,905 width=53) (never executed)

311. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=89.92..577.02 rows=846 width=770) (never executed)

  • Hash Cond: ((ttotfac_4.actividadcan)::text = (tmcanactividad_4.actividad)::text)
312. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=65.75..550.63 rows=846 width=692) (never executed)

  • Hash Cond: ((ttotfac_4.aseguradoracan)::text = (tmcanaseguradora_4.aseguradora)::text)
313. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on ttotfac ttotfac_4 (cost=31.24..512.93 rows=846 width=86) (never executed)

  • Recheck Cond: (((emp)::text = '1'::text) AND (fechafactura >= '2018-06-01 00:00:00'::timestamp without time zone) AND (fechafactura <= '2019-01-31 23:59:59'::timestamp without time zone))
  • Filter: (franquiciarecibo = 0)
314. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix_ttotfac_fechafactura (cost=0.00..31.03 rows=859 width=0) (never executed)

  • Index Cond: (((emp)::text = '1'::text) AND (fechafactura >= '2018-06-01 00:00:00'::timestamp without time zone) AND (fechafactura <= '2019-01-31 23:59:59'::timestamp without time zone))
315. 0.000 0.000 ↓ 0.0 0

Hash (cost=32.89..32.89 rows=130 width=626) (never executed)

316. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=12.93..32.89 rows=130 width=626) (never executed)

  • Hash Cond: ((tmcangrupo_4.grupo)::text = (tmcanaseguradora_4.grupo)::text)
317. 0.000 0.000 ↓ 0.0 0

Seq Scan on tmcangrupo tmcangrupo_4 (cost=0.00..16.30 rows=630 width=90) (never executed)

318. 0.000 0.000 ↓ 0.0 0

Hash (cost=11.30..11.30 rows=130 width=548) (never executed)

319. 0.000 0.000 ↓ 0.0 0

Seq Scan on tmcanaseguradora tmcanaseguradora_4 (cost=0.00..11.30 rows=130 width=548) (never executed)

320. 0.000 0.000 ↓ 0.0 0

Hash (cost=16.30..16.30 rows=630 width=86) (never executed)

321. 0.000 0.000 ↓ 0.0 0

Seq Scan on tmcanactividad tmcanactividad_4 (cost=0.00..16.30 rows=630 width=86) (never executed)

322. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ttseccion on ttseccion ttseccion_4 (cost=0.13..0.15 rows=1 width=104) (never executed)

  • Index Cond: ((seccion)::text = (ttotcab_4.seccion)::text)
323. 0.000 0.000 ↓ 0.0 0

Seq Scan on tgtaller tgtaller_4 (cost=0.00..1.06 rows=1 width=120) (never executed)

  • Filter: (((emp)::text = '1'::text) AND ((taller)::text = '6'::text))
324. 0.000 0.000 ↓ 0.0 0

Seq Scan on tgempresa tgempresa_4 (cost=0.00..1.04 rows=1 width=124) (never executed)

  • Filter: ((emp)::text = '1'::text)
325. 0.000 0.000 ↓ 0.0 0

Seq Scan on ttgrupocargo ttgrupocargo_4 (cost=0.00..1.09 rows=9 width=104) (never executed)

326.          

SubPlan (forNested Loop)

327. 0.000 0.000 ↓ 0.0 0

Result (cost=8.44..8.45 rows=1 width=4) (never executed)

328.          

Initplan (forResult)

329. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.41..8.44 rows=1 width=4) (never executed)

330. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_ttotcargoint on ttotcargoint cargofac (cost=0.41..8.44 rows=1 width=4) (never executed)

  • Index Cond: ((emp = (ttotfac_4.emp)::text) AND (numintot = ttotfac_4.numinterno) AND (numintcargo = ttotfac_4.numintcargo) AND (numintintervencion IS NOT NULL))
  • Heap Fetches: 0