pgBadger-
Global information
- Generated on Sun Jul 19 23:00:05 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 59,531 log entries in 4s
- Log start from 2026-07-19 07:00:01 to 2026-07-19 21:59:52
-
Overview
Global Stats
- 11 Number of unique normalized queries
- 3,700 Number of queries
- 2h25m58s Total query duration
- 2026-07-19 07:03:01 First query
- 2026-07-19 21:59:35 Last query
- 2 queries/s at 2026-07-19 20:22:34 Query peak
- 2h25m58s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h25m58s Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 13,089 Total number of automatic vacuums
- 246 Total number of automatic analyzes
- 674 Number temporary file
- 74.84 MiB Max size of temporary file
- 38.84 MiB Average size of temporary file
- 3,838 Total number of sessions
- 5 sessions at 2026-07-19 07:37:59 Session peak
- 4d2h17m5s Total duration of sessions
- 1m32s Average duration of sessions
- 0 Average queries per session
- 2s282ms Average queries duration per session
- 1m29s Average idle time per session
- 3,840 Total number of connections
- 5 connections/s at 2026-07-19 11:00:01 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2026-07-19 20:22:34 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-07-19 20:22:34 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2026-07-19 20:53:28 Date
Queries duration
Key values
- 2h25m58s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 07 132 0ms 10s555ms 2s806ms 23s653ms 1m5s 1m6s 08 136 0ms 9s793ms 2s744ms 24s152ms 1m5s 1m6s 09 162 0ms 11s35ms 2s547ms 26s108ms 1m6s 1m7s 10 164 0ms 10s117ms 2s531ms 26s690ms 1m5s 1m7s 11 168 0ms 13s678ms 2s587ms 29s77ms 1m5s 1m6s 12 192 0ms 12s458ms 2s466ms 31s169ms 1m6s 1m8s 13 202 0ms 14s250ms 2s460ms 32s838ms 1m6s 1m7s 14 273 0ms 12s804ms 2s120ms 35s455ms 1m8s 1m10s 15 324 1s36ms 13s461ms 2s25ms 39s355ms 1m8s 1m10s 16 325 1s124ms 13s857ms 2s137ms 43s439ms 1m8s 1m12s 17 324 1s207ms 14s634ms 2s196ms 44s439ms 1m9s 1m12s 18 324 1s308ms 16s17ms 2s294ms 49s185ms 1m9s 1m13s 19 326 1s58ms 19s202ms 2s411ms 53s547ms 1m9s 1m13s 20 324 1s466ms 16s935ms 2s429ms 52s331ms 1m9s 1m13s 21 324 1s545ms 19s687ms 2s541ms 57s393ms 1m9s 1m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 07 120 0 2s179ms 1s701ms 3s922ms 57s781ms 08 120 0 2s191ms 1s780ms 4s28ms 58s25ms 09 120 0 2s207ms 1s799ms 6s110ms 56s872ms 10 120 0 2s193ms 1s717ms 6s52ms 57s97ms 11 120 0 2s192ms 1s715ms 6s331ms 55s959ms 12 124 0 2s169ms 1s723ms 9s390ms 55s888ms 13 130 0 2s126ms 1s753ms 8s155ms 54s395ms 14 185 0 1s804ms 3s972ms 10s582ms 56s94ms 15 222 0 1s709ms 4s962ms 13s398ms 55s913ms 16 223 0 1s775ms 5s232ms 16s125ms 54s846ms 17 222 0 1s807ms 5s563ms 14s624ms 55s28ms 18 222 0 1s857ms 5s670ms 16s375ms 54s329ms 19 224 0 1s917ms 5s983ms 17s244ms 53s367ms 20 222 0 1s927ms 6s303ms 18s637ms 52s202ms 21 222 0 1s979ms 6s571ms 19s980ms 50s934ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 07 0 8 0 0 8s948ms 0ms 0ms 8s878ms 08 0 8 4 0 6s14ms 0ms 1s20ms 9s105ms 09 0 8 30 0 2s910ms 1s102ms 1s181ms 10s355ms 10 0 10 30 0 2s850ms 1s265ms 1s317ms 9s824ms 11 0 14 30 0 3s34ms 1s415ms 1s484ms 10s439ms 12 0 34 30 0 2s581ms 1s572ms 1s638ms 12s254ms 13 0 38 30 0 2s661ms 1s728ms 1s788ms 12s583ms 14 0 38 46 0 2s442ms 2s849ms 3s56ms 12s642ms 15 0 38 60 0 2s409ms 3s150ms 3s262ms 13s998ms 16 0 38 60 0 2s555ms 3s381ms 3s457ms 14s442ms 17 0 38 60 0 2s663ms 3s596ms 3s698ms 14s925ms 18 0 38 60 0 2s863ms 3s839ms 3s977ms 16s162ms 19 0 38 60 0 3s98ms 4s41ms 4s152ms 17s660ms 20 0 38 60 0 3s126ms 4s275ms 4s369ms 17s262ms 21 0 38 60 0 3s355ms 4s450ms 4s546ms 19s687ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 19 07 0 132 132.00 0.00% 08 0 136 136.00 0.00% 09 0 162 162.00 0.00% 10 0 164 164.00 0.00% 11 0 168 168.00 0.00% 12 0 192 192.00 0.00% 13 0 202 202.00 0.00% 14 0 273 273.00 0.00% 15 0 324 324.00 0.00% 16 0 325 325.00 0.00% 17 0 324 324.00 0.00% 18 0 324 324.00 0.00% 19 0 326 326.00 0.00% 20 0 324 324.00 0.00% 21 0 324 324.00 0.00% Day Hour Count Average / Second Jul 19 07 257 0.07/s 08 256 0.07/s 09 255 0.07/s 10 257 0.07/s 11 255 0.07/s 12 256 0.07/s 13 259 0.07/s 14 256 0.07/s 15 255 0.07/s 16 257 0.07/s 17 257 0.07/s 18 255 0.07/s 19 256 0.07/s 20 254 0.07/s 21 255 0.07/s Day Hour Count Average Duration Average idle time Jul 19 07 257 1m26s 1m25s 08 255 57s726ms 56s262ms 09 255 1m30s 1m29s 10 257 2m 1m59s 11 255 55s461ms 53s756ms 12 256 1m41s 1m39s 13 257 1m13s 1m11s 14 256 52s524ms 50s263ms 15 255 2m33s 2m30s 16 257 55s977ms 53s273ms 17 257 1m22s 1m19s 18 255 1m51s 1m48s 19 258 3m53s 3m50s 20 254 1m7s 1m4s 21 254 37s254ms 34s13ms -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-19 11:00:01 Date
Connections per database
Key values
- etendo Main Database
- 3,840 connections Total
Connections per user
Key values
- tad Main User
- 3,840 connections Total
-
Sessions
Simultaneous sessions
Key values
- 5 sessions Session Peak
- 2026-07-19 07:37:59 Date
Histogram of session times
Key values
- 3,706 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 3,838 sessions Total
Sessions per user
Key values
- tad Main User
- 3,838 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 3,838 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 138,814 buffers Checkpoint Peak
- 2026-07-19 21:59:04 Date
- 270.044 seconds Highest write time
- 0.062 seconds Sync time
Checkpoints Wal files
Key values
- 59 files Wal files usage Peak
- 2026-07-19 21:29:04 Date
Checkpoints distance
Key values
- 1,866.72 Mo Distance Peak
- 2026-07-19 21:29:04 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 19 07 265,058 1,359.499s 0.013s 1,359.534s 08 290,901 1,398.056s 0.084s 1,398.168s 09 319,436 1,363.791s 0.053s 1,363.87s 10 340,383 1,353.996s 0.051s 1,354.071s 11 346,917 1,348.327s 0.049s 1,348.403s 12 370,368 1,352.197s 0.047s 1,352.274s 13 403,821 1,378.442s 0.016s 1,378.488s 14 416,928 1,468.967s 0.013s 1,469.01s 15 418,017 1,359.137s 0.054s 1,359.22s 16 422,058 1,568.369s 0.056s 1,568.451s 17 437,820 1,788.414s 0.07s 1,788.517s 18 447,799 1,868.41s 0.057s 1,868.499s 19 462,235 1,643.296s 0.066s 1,643.391s 20 509,363 1,869.346s 0.044s 1,869.427s 21 551,717 1,870.304s 0.047s 1,870.387s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 19 07 0 0 139 684 0.001s 0.011s 08 0 1 144 758 0.056s 0.013s 09 0 0 153 694 0.036s 0.012s 10 0 0 156 701 0.033s 0.012s 11 0 0 162 704 0.033s 0.012s 12 0 0 169 698 0.033s 0.012s 13 0 0 176 716 0.001s 0.012s 14 0 0 182 720 0.001s 0.012s 15 0 0 186 671 0.036s 0.011s 16 0 0 191 742 0.034s 0.012s 17 0 0 197 714 0.040s 0.012s 18 0 0 203 709 0.042s 0.012s 19 0 0 211 718 0.026s 0.012s 20 0 0 215 705 0.029s 0.012s 21 0 0 226 718 0.018s 0.012s Day Hour Count Avg time (sec) Jul 19 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s Day Hour Mean distance Mean estimate Jul 19 07 207,958.55 kB 509,697.27 kB 08 182,472.38 kB 529,809.85 kB 09 208,094.67 kB 557,909.83 kB 10 213,183.42 kB 573,374.25 kB 11 221,663.75 kB 594,290.75 kB 12 229,899.00 kB 618,343.42 kB 13 241,052.42 kB 647,845.50 kB 14 247,842.67 kB 661,682.83 kB 15 277,144.36 kB 682,962.45 kB 16 261,812.50 kB 701,187.67 kB 17 268,687.58 kB 721,561.33 kB 18 276,298.42 kB 743,006.17 kB 19 288,562.17 kB 772,799.17 kB 20 293,383.58 kB 788,483.92 kB 21 308,520.42 kB 827,088.50 kB -
Temporary Files
Size of temporary files
Key values
- 465.49 MiB Temp Files size Peak
- 2026-07-19 13:23:31 Date
Number of temporary files
Key values
- 12 per second Temp Files Peak
- 2026-07-19 13:23:31 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 19 07 48 1.82 GiB 38.79 MiB 08 48 1.82 GiB 38.79 MiB 09 48 1.82 GiB 38.79 MiB 10 48 1.82 GiB 38.79 MiB 11 48 1.82 GiB 38.79 MiB 12 48 1.82 GiB 38.79 MiB 13 48 1.82 GiB 38.79 MiB 14 48 1.82 GiB 38.79 MiB 15 48 1.82 GiB 38.79 MiB 16 42 1.60 GiB 38.92 MiB 17 40 1.52 GiB 38.97 MiB 18 40 1.52 GiB 38.97 MiB 19 40 1.52 GiB 38.95 MiB 20 40 1.52 GiB 38.88 MiB 21 40 1.52 GiB 38.88 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 674 25.56 GiB 1005.22 KiB 74.84 MiB 38.84 MiB with imgs_agrupadas as ( select vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ?) as imgs from public.opxdega_vehiculo_grupo_foto vgf cross join public.dlcmkp_marketplace dm where vgf.em_dlc_image_id is not null group by vgf.opxdes_vehiculo_id ), vehiculos_unicos as ( select distinct ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas from public.dlcmkp_marketplace_part dmp inner join public.opxdes_vehiculo ov on ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id where coalesce(ov.etiqueta, ?) != ? ) select vu.etiqueta as codvehiculo, to_char(vu.fecha_entrada, ?) as fechaentrada, null as fechasalida, dlceco_format_text_to_file (coalesce(mcv_marca.name, ?)) as marca, dlceco_format_text_to_file (coalesce(ma_modelo.name, ?)) as modelo, dlceco_format_text_to_file (ma_version.name) as motorversion, dlceco_format_text_to_file (ma_cajacambios.name) as cambioversion, null as anoversion, vu.bastidor as bastidor, replace(vu.matricula, ?, ?) as matricula, to_char(vu.fecha_matricula, ?) as fechamatriculacion, null as paismatriculacion, mcv_color.name as color, coalesce( case when ma_numpuertas.value ~ ? then ma_numpuertas.value else ? end, ?) as puertas, vu.km as kilometraje, null as notapublica, null as codigomotor, null as codigocambio, coalesce(ma_tipo_combustible.value, ?) as tipocombustible, mcv_estadoveh.name as estadovehiculo, null as localizacion, null as usuario, null as factualiza, img.imgs from vehiculos_unicos vu left join imgs_agrupadas img on img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id left join public.m_attributevalue ma_modelo on ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo left join public.m_attributevalue ma_tipo_combustible on ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb left join public.m_attributevalue mcv_marca on mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca left join public.m_attributevalue ma_version on ma_version.m_attributevalue_id = vu.em_opxpatr_version left join public.m_attributevalue ma_cajacambios on ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios left join public.m_ch_value mcv_color on mcv_color.m_ch_value_id = vu.color left join public.m_attributevalue ma_numpuertas on ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas left join public.m_ch_value mcv_estadoveh on mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;-
WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;
Date: 2026-07-19 19:38:47 Duration: 15s540ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;
Date: 2026-07-19 21:23:47 Duration: 13s890ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;
Date: 2026-07-19 21:53:45 Duration: 13s869ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
Queries generating the largest temporary files
Rank Size Query 1 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:08:17 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:08:18 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:08:18 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:08:18 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:23:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:23:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:23:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:23:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:38:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:38:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:38:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
12 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:38:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:53:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:53:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
15 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:53:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
16 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 07:53:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 08:08:18 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
18 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 08:08:18 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
19 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 08:08:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
20 74.84 MiB WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;[ Date: 2026-07-19 08:08:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 30.06 sec Highest CPU-cost vacuum
Table public.dlcmkp_marketplace_part
Database etendo - 2026-07-19 21:54:50 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 30.06 sec Highest CPU-cost vacuum
Table public.dlcmkp_marketplace_part
Database etendo - 2026-07-19 21:54:50 Date
Analyzes per table
Key values
- public.ad_process_request (82) Main table analyzed (database etendo)
- 246 analyzes Total
Table Number of analyzes etendo.public.ad_process_request 82 etendo.public.dlcmkp_marketplace_part 60 etendo.profile.last_stat_statements_srv1 15 etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_io 8 etendo.profile.tables_list 6 etendo.profile.last_extension_versions 5 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.last_stat_slru 3 etendo.profile.indexes_list 3 etendo.profile.stmt_list 2 etendo.profile.sample_stat_io 1 etendo.public.ad_process_run 1 etendo.profile.sample_statements 1 etendo.pg_catalog.pg_type 1 etendo.profile.sample_stat_database 1 etendo.profile.sample_stat_tables 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_stat_user_functions 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_stat_indexes 1 etendo.profile.sample_stat_tables_total 1 etendo.pg_catalog.pg_shdepend 1 etendo.public.dlc_conf 1 Total 246 Vacuums per table
Key values
- pg_catalog.pg_statistic (899) Main table vacuumed on database etendo
- 13,089 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples etendo.pg_catalog.pg_statistic 899 0 2,271,762 0 511 0 0 715 129 471,597 0 0 etendo.profile.last_stat_io 899 0 57,237 0 185 0 0 789 180 568,139 0 0 etendo.public.ad_process_request 898 0 1,702,142 0 565 0 0 866 179 651,446 0 0 etendo.public.dlcmkp_marketplace_part 898 0 1,338,562,740 0 50,320 0 0 875 179 608,040 0 0 etendo.profile.last_stat_tables_srv1 898 0 4,178,949 0 127 0 0 785 146 691,122 0 0 etendo.profile.last_stat_indexes_srv1 898 0 5,235,936 0 133 0 0 785 175 778,246 0 0 etendo.profile.tables_list 898 0 175,250 0 137 0 0 785 179 546,480 0 0 etendo.profile.last_stat_statements_srv1 898 0 918,083 0 133 0 0 786 175 710,766 0 0 etendo.profile.indexes_list 898 0 93,232 0 163 0 0 785 179 655,388 0 0 etendo.profile.last_stat_user_functions_srv1 898 0 366,119 0 0 0 0 785 0 371,305 0 0 etendo.pg_toast.pg_toast_2619 844 0 1,274,581 0 278 0 0 356 49 184,301 0 0 etendo.profile.last_extension_versions 779 0 36,654 0 167 0 0 681 146 489,321 0 0 etendo.profile.stmt_list 778 0 210,304 0 199 0 0 742 157 460,404 0 0 etendo.profile.last_stat_activity_count_srv1 718 0 17,953 0 143 0 0 623 144 561,656 0 0 etendo.profile.last_stat_slru 480 0 19,907 0 21 0 0 412 0 77,456 0 0 etendo.profile.last_stat_database_srv1 359 0 16,124 0 15 0 0 305 0 144,265 0 0 etendo.public.dlc_conf 80 0 3,173 0 29 0 0 68 16 52,567 0 0 etendo.public.m_stock_proposed 67 67 6,786 0 383 0 0 1,131 272 241,446 0 0 etendo.profile.sample_stat_io 1 0 85 0 32 0 0 28 2 4,299 0 0 etendo.profile.sample_stat_indexes 1 0 290 0 194 0 0 179 1 10,808 0 0 Total 13,089 67 1,355,147,307 1,427,301 53,735 0 0 12,481 2,308 8,279,052 0 0 Vacuum throughput per table
Key values
- public.dlcmkp_marketplace_part (15335.85) Max CPU elapsed for vacuum on database etendo
- unknown (0 ms) Max I/O read time for vacuum on database etendo
- unknown (0 ms) Max I/O write time for vacuum on database etendo
I/O timing (ms) CPU (s) Table read write elapsed etendo.pg_catalog.pg_statistic 0 0 23.6199999999998 etendo.profile.last_stat_io 0 0 0 etendo.public.ad_process_request 0 0 14.0199999999998 etendo.public.dlcmkp_marketplace_part 0 0 15,335.85 etendo.profile.last_stat_tables_srv1 0 0 51.7999999999999 etendo.profile.last_stat_indexes_srv1 0 0 66.0500000000003 etendo.profile.tables_list 0 0 0 etendo.profile.last_stat_statements_srv1 0 0 6.22999999999991 etendo.profile.indexes_list 0 0 0 etendo.profile.last_stat_user_functions_srv1 0 0 0 etendo.pg_toast.pg_toast_2619 0 0 9.68999999999984 etendo.profile.last_extension_versions 0 0 0 etendo.profile.stmt_list 0 0 0.01 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.last_stat_slru 0 0 0 etendo.profile.last_stat_database_srv1 0 0 0 etendo.public.dlc_conf 0 0 0 etendo.public.m_stock_proposed 0 0 0 etendo.profile.sample_stat_io 0 0 0 etendo.profile.sample_stat_indexes 0 0 0.04 Total 0 0 15,507.31 Tuples removed per table
Key values
- public.m_stock_proposed (3608) Main table with removed tuples on database etendo
- 3608 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.public.m_stock_proposed 67 67 3,608 0 0 243 0 etendo.pg_catalog.pg_statistic 899 0 0 19,472,466 8,073,067 0 1,151,921 etendo.profile.last_stat_activity_count_srv1 718 0 0 72,391 72,391 0 2,094 etendo.profile.stmt_list 778 0 0 1,109,050 325,545 0 88,267 etendo.profile.last_extension_versions 779 0 0 91,170 84,159 0 1,618 etendo.public.dlc_conf 80 0 0 4,281 4,201 0 240 etendo.pg_toast.pg_toast_2619 844 0 0 3,562,023 1,461,564 0 962,798 etendo.public.ad_process_request 898 0 0 8,181,155 7,419,651 0 821,565 etendo.profile.last_stat_database_srv1 359 0 0 23,684 22,248 0 1,136 etendo.public.dlcmkp_marketplace_part 898 0 0 10,851,595,338 10,368,965,744 0 669,247,042 etendo.profile.last_stat_tables_srv1 898 0 0 44,105,992 42,266,288 0 2,284,643 etendo.profile.last_stat_io 899 0 0 172,640 158,256 0 4,256 etendo.profile.last_stat_slru 480 0 0 37,200 34,800 0 780 etendo.profile.last_stat_indexes_srv1 898 0 0 70,616,429 67,571,311 0 2,868,896 etendo.profile.sample_stat_io 1 0 0 1,541 117 0 34 etendo.profile.tables_list 898 0 0 2,946,760 1,205,635 0 65,305 etendo.profile.last_stat_statements_srv1 898 0 0 8,582,116 8,107,915 0 465,315 etendo.profile.sample_stat_indexes 1 0 0 12,129 410 0 194 etendo.profile.indexes_list 898 0 0 595,465 251,405 0 13,528 etendo.profile.last_stat_user_functions_srv1 898 0 0 5,660,676 5,221,554 0 179,892 Total 13,089 67 3,608 11,016,842,506 10,511,246,261 243 678,159,524 Pages removed per table
Key values
- public.m_stock_proposed (243) Main table with removed pages on database etendo
- 243 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.public.m_stock_proposed 67 67 3608 243 etendo.pg_catalog.pg_statistic 899 0 0 0 etendo.profile.last_stat_activity_count_srv1 718 0 0 0 etendo.profile.stmt_list 778 0 0 0 etendo.profile.last_extension_versions 779 0 0 0 etendo.public.dlc_conf 80 0 0 0 etendo.pg_toast.pg_toast_2619 844 0 0 0 etendo.public.ad_process_request 898 0 0 0 etendo.profile.last_stat_database_srv1 359 0 0 0 etendo.public.dlcmkp_marketplace_part 898 0 0 0 etendo.profile.last_stat_tables_srv1 898 0 0 0 etendo.profile.last_stat_io 899 0 0 0 etendo.profile.last_stat_slru 480 0 0 0 etendo.profile.last_stat_indexes_srv1 898 0 0 0 etendo.profile.sample_stat_io 1 0 0 0 etendo.profile.tables_list 898 0 0 0 etendo.profile.last_stat_statements_srv1 898 0 0 0 etendo.profile.sample_stat_indexes 1 0 0 0 etendo.profile.indexes_list 898 0 0 0 etendo.profile.last_stat_user_functions_srv1 898 0 0 0 Total 13,089 67 3,608 243 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 19 07 611 16 08 664 14 09 784 17 10 834 15 11 845 15 12 841 16 13 845 19 14 905 14 15 904 20 16 966 15 17 964 16 18 965 18 19 965 17 20 985 15 21 1,011 19 - 30.06 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 2,596 Total read queries
- 1,104 Total write queries
Queries by database
Key values
- etendo Main database
- 3,700 Requests
- 2h25m58s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 3,700 Requests
User Request type Count Duration tad Total 3,700 2h25m58s cte 60 10m57s delete 620 18m10s select 2,596 1h24m40s update 424 32m9s Duration by user
Key values
- 2h25m58s (tad) Main time consuming user
User Request type Count Duration tad Total 3,700 2h25m58s cte 60 10m57s delete 620 18m10s select 2,596 1h24m40s update 424 32m9s Queries by host
Key values
- 127.0.0.1 Main host
- 3,700 Requests
- 2h25m58s (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 3,700 Requests
- 2h25m58s (openbravo)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-19 14:00:11 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,577 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 19s687ms UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';[ Date: 2026-07-19 21:22:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2 19s202ms UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');[ Date: 2026-07-19 19:23:30 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3 18s664ms UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');[ Date: 2026-07-19 21:08:31 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4 18s630ms UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');[ Date: 2026-07-19 21:23:33 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
5 18s391ms UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');[ Date: 2026-07-19 21:53:31 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6 17s725ms UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');[ Date: 2026-07-19 21:38:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7 17s660ms UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');[ Date: 2026-07-19 19:38:32 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8 17s621ms UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';[ Date: 2026-07-19 21:07:10 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
9 17s609ms UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';[ Date: 2026-07-19 19:37:10 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
10 17s360ms UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';[ Date: 2026-07-19 21:52:10 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11 16s935ms UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');[ Date: 2026-07-19 20:53:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
12 16s769ms UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');[ Date: 2026-07-19 19:08:27 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13 16s408ms UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');[ Date: 2026-07-19 20:38:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
14 16s378ms UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';[ Date: 2026-07-19 21:37:09 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
15 16s359ms UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');[ Date: 2026-07-19 20:23:27 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
16 16s268ms UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');[ Date: 2026-07-19 20:08:26 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
17 16s98ms UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';[ Date: 2026-07-19 19:22:09 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
18 16s17ms UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');[ Date: 2026-07-19 18:53:27 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19 15s885ms UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';[ Date: 2026-07-19 20:52:08 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
20 15s830ms UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';[ Date: 2026-07-19 20:22:08 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h1m20s 1,620 1s997ms 4s293ms 2s272ms select dcmp.sku as refid, dlceco_format_text_to_file (dc.name) as familia, dp."name" as articulo, dlceco_format_text_to_file (dcmp.marca) as marca, coalesce(dcmp.id_tecdoc_modelo, dlceco_format_text_to_file (dcmp.modelo)) as modelo, dcmp.anyo_cominezo_modelo as modeloinicio, dcmp.anyo_fin_modelo as modelofin, dlceco_format_text_to_file (dcmp.motor_code) as motorversion, null as cambioversion, dlceco_format_text_to_file (dcmp.referencias_oem) as refvisual, null as refcatalogo, null as attrib1, null as attrib2, replace(to_char(dcmp.precio_sin_iva, ?), ?, ?) as precio, null as estado, null as ubicacion, dcmp.anyo_comienzo_version as anopieza, null as nota, dlceco_format_text_to_file (dcmp.observaciones) as notapublica, null as ean, mp.weight as peso, to_char(dcmp.created, ?) as fechaentrada, ov.etiqueta as codvehiculo, null as ordenrevision, to_char(dcmp.updated, ?) as fecharevision, null as ordenextraccion, null as fechaextraccion, null as contenedor, null as codalmacen, dcmp.sku as almacen, null as fechalmacen, null as factualiza, ( select string_agg(s.urlfoto, ?) from ( select dm.url_image || dpi.ad_image_id as urlfoto from dlc_photo dph left join dlc_photo_image dpi on dpi.dlc_photo_id = dph.dlc_photo_id left join dlc_product_photo dpp on dpp.m_product_id = dph.m_product_id and dpp.dlc_photo_type_id = dpi.dlc_photo_type_id where dph.etiqueta = dcmp.sku group by dpp.dlc_product_photo_id, dpi.dlc_photo_image_id order by dpp.seqno) s) as imgs from dlcmkp_marketplace_part dcmp left join m_product mp on mp.m_product_id = dcmp.m_product_id left join dlceco_categories dc on dc.dlceco_categories_id = mp.em_dlceco_categories_id left join dlcmkp_marketplace dm on dm.dlcmkp_marketplace_id = dcmp.dlcmkp_marketplace_id left join opxdes_vehiculo ov on ov.opxdes_vehiculo_id = dcmp.opxdes_vehiculo_id left join dlceco_products dp on dp.dlceco_products_id = mp.em_dlceco_products_id where dcmp.dlcmkp_marketplace_id = ? and dcmp.estado in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 108 4m 2s229ms 08 108 4m1s 2s239ms 09 108 4m3s 2s258ms 10 108 4m2s 2s242ms 11 108 4m2s 2s242ms 12 108 4m3s 2s258ms 13 108 4m4s 2s265ms 14 108 4m4s 2s267ms 15 108 4m3s 2s257ms 16 108 4m9s 2s310ms 17 108 4m7s 2s295ms 18 108 4m9s 2s312ms 19 108 4m8s 2s299ms 20 108 4m8s 2s298ms 21 108 4m8s 2s302ms [ User: tad - Total duration: 1h1m20s - Times executed: 1620 ]
[ Application: openbravo - Total duration: 1h1m20s - Times executed: 1620 ]
-
SELECT dcmp.sku AS refid, dlceco_format_text_to_file (dc.name) AS familia, dp."name" AS articulo, dlceco_format_text_to_file (dcmp.marca) AS marca, coalesce(dcmp.id_tecdoc_modelo, dlceco_format_text_to_file (dcmp.modelo)) AS modelo, dcmp.anyo_cominezo_modelo AS modeloinicio, dcmp.anyo_fin_modelo AS modelofin, dlceco_format_text_to_file (dcmp.motor_code) AS motorversion, null AS cambioversion, dlceco_format_text_to_file (dcmp.referencias_oem) AS refvisual, null AS refcatalogo, null AS attrib1, null AS attrib2, REPLACE(TO_CHAR(dcmp.precio_sin_iva, 'FM999999990.00'), '.', ',') AS precio, null AS estado, null AS ubicacion, dcmp.anyo_comienzo_version AS anopieza, null AS nota, dlceco_format_text_to_file (dcmp.observaciones) AS notapublica, null AS ean, mp.weight AS peso, TO_CHAR(dcmp.created, 'DD-MM-YYYY') AS fechaentrada, ov.etiqueta AS codvehiculo, null AS ordenrevision, TO_CHAR(dcmp.updated, 'DD-MM-YYYY') AS fecharevision, null AS ordenextraccion, null AS fechaextraccion, null AS contenedor, null AS codalmacen, dcmp.sku AS almacen, null AS fechalmacen, null AS factualiza, ( SELECT string_agg(s.urlfoto, ',') FROM ( SELECT dm.url_image || dpi.ad_image_id AS urlfoto FROM dlc_photo dph LEFT JOIN dlc_photo_image dpi ON dpi.dlc_photo_id = dph.dlc_photo_id LEFT JOIN dlc_product_photo dpp ON dpp.m_product_id = dph.m_product_id AND dpp.dlc_photo_type_id = dpi.dlc_photo_type_id WHERE dph.etiqueta = dcmp.sku GROUP BY dpp.dlc_product_photo_id, dpi.dlc_photo_image_id ORDER BY dpp.seqno) s) AS imgs FROM dlcmkp_marketplace_part dcmp LEFT JOIN m_product mp ON mp.m_product_id = dcmp.m_product_id LEFT JOIN dlceco_categories dc ON dc.dlceco_categories_id = mp.em_dlceco_categories_id LEFT JOIN dlcmkp_marketplace dm ON dm.dlcmkp_marketplace_id = dcmp.dlcmkp_marketplace_id LEFT JOIN opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dcmp.opxdes_vehiculo_id LEFT JOIN dlceco_products dp ON dp.dlceco_products_id = mp.em_dlceco_products_id WHERE dcmp.dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND dcmp.estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 19:37:14 Duration: 4s293ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT dcmp.sku AS refid, dlceco_format_text_to_file (dc.name) AS familia, dp."name" AS articulo, dlceco_format_text_to_file (dcmp.marca) AS marca, coalesce(dcmp.id_tecdoc_modelo, dlceco_format_text_to_file (dcmp.modelo)) AS modelo, dcmp.anyo_cominezo_modelo AS modeloinicio, dcmp.anyo_fin_modelo AS modelofin, dlceco_format_text_to_file (dcmp.motor_code) AS motorversion, null AS cambioversion, dlceco_format_text_to_file (dcmp.referencias_oem) AS refvisual, null AS refcatalogo, null AS attrib1, null AS attrib2, REPLACE(TO_CHAR(dcmp.precio_sin_iva, 'FM999999990.00'), '.', ',') AS precio, null AS estado, null AS ubicacion, dcmp.anyo_comienzo_version AS anopieza, null AS nota, dlceco_format_text_to_file (dcmp.observaciones) AS notapublica, null AS ean, mp.weight AS peso, TO_CHAR(dcmp.created, 'DD-MM-YYYY') AS fechaentrada, ov.etiqueta AS codvehiculo, null AS ordenrevision, TO_CHAR(dcmp.updated, 'DD-MM-YYYY') AS fecharevision, null AS ordenextraccion, null AS fechaextraccion, null AS contenedor, null AS codalmacen, dcmp.sku AS almacen, null AS fechalmacen, null AS factualiza, ( SELECT string_agg(s.urlfoto, ',') FROM ( SELECT dm.url_image || dpi.ad_image_id AS urlfoto FROM dlc_photo dph LEFT JOIN dlc_photo_image dpi ON dpi.dlc_photo_id = dph.dlc_photo_id LEFT JOIN dlc_product_photo dpp ON dpp.m_product_id = dph.m_product_id AND dpp.dlc_photo_type_id = dpi.dlc_photo_type_id WHERE dph.etiqueta = dcmp.sku GROUP BY dpp.dlc_product_photo_id, dpi.dlc_photo_image_id ORDER BY dpp.seqno) s) AS imgs FROM dlcmkp_marketplace_part dcmp LEFT JOIN m_product mp ON mp.m_product_id = dcmp.m_product_id LEFT JOIN dlceco_categories dc ON dc.dlceco_categories_id = mp.em_dlceco_categories_id LEFT JOIN dlcmkp_marketplace dm ON dm.dlcmkp_marketplace_id = dcmp.dlcmkp_marketplace_id LEFT JOIN opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dcmp.opxdes_vehiculo_id LEFT JOIN dlceco_products dp ON dp.dlceco_products_id = mp.em_dlceco_products_id WHERE dcmp.dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND dcmp.estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 21:52:14 Duration: 3s903ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT dcmp.sku AS refid, dlceco_format_text_to_file (dc.name) AS familia, dp."name" AS articulo, dlceco_format_text_to_file (dcmp.marca) AS marca, coalesce(dcmp.id_tecdoc_modelo, dlceco_format_text_to_file (dcmp.modelo)) AS modelo, dcmp.anyo_cominezo_modelo AS modeloinicio, dcmp.anyo_fin_modelo AS modelofin, dlceco_format_text_to_file (dcmp.motor_code) AS motorversion, null AS cambioversion, dlceco_format_text_to_file (dcmp.referencias_oem) AS refvisual, null AS refcatalogo, null AS attrib1, null AS attrib2, REPLACE(TO_CHAR(dcmp.precio_sin_iva, 'FM999999990.00'), '.', ',') AS precio, null AS estado, null AS ubicacion, dcmp.anyo_comienzo_version AS anopieza, null AS nota, dlceco_format_text_to_file (dcmp.observaciones) AS notapublica, null AS ean, mp.weight AS peso, TO_CHAR(dcmp.created, 'DD-MM-YYYY') AS fechaentrada, ov.etiqueta AS codvehiculo, null AS ordenrevision, TO_CHAR(dcmp.updated, 'DD-MM-YYYY') AS fecharevision, null AS ordenextraccion, null AS fechaextraccion, null AS contenedor, null AS codalmacen, dcmp.sku AS almacen, null AS fechalmacen, null AS factualiza, ( SELECT string_agg(s.urlfoto, ',') FROM ( SELECT dm.url_image || dpi.ad_image_id AS urlfoto FROM dlc_photo dph LEFT JOIN dlc_photo_image dpi ON dpi.dlc_photo_id = dph.dlc_photo_id LEFT JOIN dlc_product_photo dpp ON dpp.m_product_id = dph.m_product_id AND dpp.dlc_photo_type_id = dpi.dlc_photo_type_id WHERE dph.etiqueta = dcmp.sku GROUP BY dpp.dlc_product_photo_id, dpi.dlc_photo_image_id ORDER BY dpp.seqno) s) AS imgs FROM dlcmkp_marketplace_part dcmp LEFT JOIN m_product mp ON mp.m_product_id = dcmp.m_product_id LEFT JOIN dlceco_categories dc ON dc.dlceco_categories_id = mp.em_dlceco_categories_id LEFT JOIN dlcmkp_marketplace dm ON dm.dlcmkp_marketplace_id = dcmp.dlcmkp_marketplace_id LEFT JOIN opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dcmp.opxdes_vehiculo_id LEFT JOIN dlceco_products dp ON dp.dlceco_products_id = mp.em_dlceco_products_id WHERE dcmp.dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND dcmp.estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 21:37:13 Duration: 3s823ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 17m50s 792 1s 2s28ms 1s351ms select dmp.dlcmkp_marketplace_part_id as id, dmp.estado as status from dlcmkp_marketplace_part dmp where dmp.dlcmkp_marketplace_id = ? and dmp.estado in (...) order by dmp.estado, dmp.updated;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 12 4 4s248ms 1s62ms 13 9 9s979ms 1s108ms 14 65 1m8s 1s51ms 15 102 1m54s 1s122ms 16 102 2m2s 1s203ms 17 102 2m11s 1s292ms 18 102 2m21s 1s390ms 19 102 2m30s 1s471ms 20 102 2m38s 1s553ms 21 102 2m48s 1s653ms [ User: tad - Total duration: 17m50s - Times executed: 792 ]
[ Application: openbravo - Total duration: 17m50s - Times executed: 792 ]
-
select dmp.dlcmkp_marketplace_part_id as id, dmp.estado as status from dlcmkp_marketplace_part dmp where dmp.dlcmkp_marketplace_id = '681DE6797F2B442DBDA481D7BDF299D7' and dmp.estado in ('PD', 'PP', 'PU') order by dmp.estado, dmp.updated;
Date: 2026-07-19 21:59:35 Duration: 2s28ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select dmp.dlcmkp_marketplace_part_id as id, dmp.estado as status from dlcmkp_marketplace_part dmp where dmp.dlcmkp_marketplace_id = '8B316F1811104D83B4DFB57E799813B6' and dmp.estado in ('PD', 'PP', 'PU') order by dmp.estado, dmp.updated;
Date: 2026-07-19 21:53:30 Duration: 1s962ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select dmp.dlcmkp_marketplace_part_id as id, dmp.estado as status from dlcmkp_marketplace_part dmp where dmp.dlcmkp_marketplace_id = '681DE6797F2B442DBDA481D7BDF299D7' and dmp.estado in ('PD', 'PP', 'PU') order by dmp.estado, dmp.updated;
Date: 2026-07-19 21:39:34 Duration: 1s962ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 13m6s 394 1s20ms 2s985ms 1s996ms delete from dlcmkp_marketplace_part dcmp where dlcmkp_marketplace_id = ? and not exists ( select ? from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > ? and not exists ( select ? from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = ?) and not exists ( select ? from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = ?) and msd.em_awobg_orderline is null);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 08 4 4s121ms 1s30ms 09 30 33s423ms 1s114ms 10 30 37s792ms 1s259ms 11 30 42s436ms 1s414ms 12 30 47s283ms 1s576ms 13 30 51s905ms 1s730ms 14 30 56s3ms 1s866ms 15 30 1m1s 2s41ms 16 30 1m5s 2s185ms 17 30 1m9s 2s302ms 18 30 1m14s 2s483ms 19 30 1m18s 2s610ms 20 30 1m22s 2s742ms 21 30 1m22s 2s761ms [ User: tad - Total duration: 13m6s - Times executed: 394 ]
[ Application: openbravo - Total duration: 13m6s - Times executed: 394 ]
-
delete from dlcmkp_marketplace_part dcmp where dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:31:28 Duration: 2s985ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
delete from dlcmkp_marketplace_part dcmp where dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:29:28 Duration: 2s930ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
delete from dlcmkp_marketplace_part dcmp where dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:23:28 Duration: 2s921ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 13m6s 60 8s688ms 19s202ms 13s102ms update dlcmkp_marketplace_part set estado = ?, updated = now() where dlcmkp_marketplace_id = ? and estado in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 07 4 38s255ms 9s563ms 08 4 36s918ms 9s229ms 09 4 41s260ms 10s315ms 10 4 39s685ms 9s921ms 11 4 45s804ms 11s451ms 12 4 48s78ms 12s19ms 13 4 50s662ms 12s665ms 14 4 50s286ms 12s571ms 15 4 52s766ms 13s191ms 16 4 55s87ms 13s771ms 17 4 57s447ms 14s361ms 18 4 1m1s 15s400ms 19 4 1m8s 17s226ms 20 4 1m5s 16s492ms 21 4 1m13s 18s353ms [ User: tad - Total duration: 13m6s - Times executed: 60 ]
[ Application: openbravo - Total duration: 13m6s - Times executed: 60 ]
-
UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 19:23:30 Duration: 19s202ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 21:08:31 Duration: 18s664ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 21:23:33 Duration: 18s630ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 11m55s 60 7s300ms 19s687ms 11s932ms update dlcmkp_marketplace_part set estado = ? where estado = ? and dlcmkp_marketplace_id = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 19 07 4 33s333ms 8s333ms 08 4 31s131ms 7s782ms 09 4 35s928ms 8s982ms 10 4 34s487ms 8s621ms 11 4 39s54ms 9s763ms 12 4 42s641ms 10s660ms 13 4 44s480ms 11s120ms 14 4 45s253ms 11s313ms 15 4 49s420ms 12s355ms 16 4 51s820ms 12s955ms 17 4 53s217ms 13s304ms 18 4 57s584ms 14s396ms 19 4 1m4s 16s30ms 20 4 1m2s 15s610ms 21 4 1m11s 17s761ms [ User: tad - Total duration: 11m55s - Times executed: 60 ]
[ Application: openbravo - Total duration: 11m55s - Times executed: 60 ]
-
UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';
Date: 2026-07-19 21:22:12 Duration: 19s687ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';
Date: 2026-07-19 21:07:10 Duration: 17s621ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';
Date: 2026-07-19 19:37:10 Duration: 17s609ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 10m57s 60 9s38ms 15s540ms 10s954ms with imgs_agrupadas as ( select vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ?) as imgs from public.opxdega_vehiculo_grupo_foto vgf cross join public.dlcmkp_marketplace dm where vgf.em_dlc_image_id is not null group by vgf.opxdes_vehiculo_id ), vehiculos_unicos as ( select distinct ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas from public.dlcmkp_marketplace_part dmp inner join public.opxdes_vehiculo ov on ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id where coalesce(ov.etiqueta, ?) != ? ) select vu.etiqueta as codvehiculo, to_char(vu.fecha_entrada, ?) as fechaentrada, null as fechasalida, dlceco_format_text_to_file (coalesce(mcv_marca.name, ?)) as marca, dlceco_format_text_to_file (coalesce(ma_modelo.name, ?)) as modelo, dlceco_format_text_to_file (ma_version.name) as motorversion, dlceco_format_text_to_file (ma_cajacambios.name) as cambioversion, null as anoversion, vu.bastidor as bastidor, replace(vu.matricula, ?, ?) as matricula, to_char(vu.fecha_matricula, ?) as fechamatriculacion, null as paismatriculacion, mcv_color.name as color, coalesce( case when ma_numpuertas.value ~ ? then ma_numpuertas.value else ? end, ?) as puertas, vu.km as kilometraje, null as notapublica, null as codigomotor, null as codigocambio, coalesce(ma_tipo_combustible.value, ?) as tipocombustible, mcv_estadoveh.name as estadovehiculo, null as localizacion, null as usuario, null as factualiza, img.imgs from vehiculos_unicos vu left join imgs_agrupadas img on img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id left join public.m_attributevalue ma_modelo on ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo left join public.m_attributevalue ma_tipo_combustible on ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb left join public.m_attributevalue mcv_marca on mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca left join public.m_attributevalue ma_version on ma_version.m_attributevalue_id = vu.em_opxpatr_version left join public.m_attributevalue ma_cajacambios on ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios left join public.m_ch_value mcv_color on mcv_color.m_ch_value_id = vu.color left join public.m_attributevalue ma_numpuertas on ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas left join public.m_ch_value mcv_estadoveh on mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 19 07 4 37s271ms 9s317ms 08 4 38s191ms 9s547ms 09 4 37s70ms 9s267ms 10 4 38s47ms 9s511ms 11 4 38s81ms 9s520ms 12 4 39s203ms 9s800ms 13 4 39s592ms 9s898ms 14 4 39s973ms 9s993ms 15 4 40s727ms 10s181ms 16 4 48s268ms 12s67ms 17 4 49s468ms 12s367ms 18 4 50s381ms 12s595ms 19 4 53s5ms 13s251ms 20 4 53s14ms 13s253ms 21 4 54s974ms 13s743ms [ User: tad - Total duration: 10m57s - Times executed: 60 ]
[ Application: openbravo - Total duration: 10m57s - Times executed: 60 ]
-
WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;
Date: 2026-07-19 19:38:47 Duration: 15s540ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;
Date: 2026-07-19 21:23:47 Duration: 13s890ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;
Date: 2026-07-19 21:53:45 Duration: 13s869ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
7 7m7s 304 1s2ms 1s948ms 1s407ms update dlcmkp_marketplace_part dcmp set estado = ?, updated = now(), updatedby = ? where estado in (...) and not exists ( select ? from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > ? and not exists ( select ? from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = ?) and not exists ( select ? from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = ?) and msd.em_awobg_orderline is null);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 19 10 2 2s39ms 1s19ms 11 6 6s210ms 1s35ms 12 26 27s224ms 1s47ms 13 30 33s911ms 1s130ms 14 30 36s917ms 1s230ms 15 30 39s586ms 1s319ms 16 30 42s92ms 1s403ms 17 30 43s58ms 1s435ms 18 30 45s703ms 1s523ms 19 30 48s680ms 1s622ms 20 30 49s748ms 1s658ms 21 30 52s645ms 1s754ms [ User: tad - Total duration: 7m7s - Times executed: 304 ]
[ Application: openbravo - Total duration: 7m7s - Times executed: 304 ]
-
update dlcmkp_marketplace_part dcmp set estado = 'PD', updated = now(), updatedby = '100' where estado in ('POSTED', 'PU') and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:41:23 Duration: 1s948ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update dlcmkp_marketplace_part dcmp set estado = 'PD', updated = now(), updatedby = '100' where estado in ('POSTED', 'PU') and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:31:23 Duration: 1s920ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update dlcmkp_marketplace_part dcmp set estado = 'PD', updated = now(), updatedby = '100' where estado in ('POSTED', 'PU') and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 19:23:23 Duration: 1s886ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
8 5m24s 180 1s551ms 9s285ms 1s804ms select f2.dlc_photo_id, f2.attrsetid as attrid from ( select ph.dlc_photo_id, ph.etiqueta, ph.m_product_id as producto_foto, sd.m_product_id as product_stock, ph.marca as marca_foto, ph.modelo as modelo_foto, sd.em_dlc_etiqueta, sd.m_attributesetinstance_id as attrsetid, ( select marca.value from m_attributeinstance marca where marca.m_attributesetinstance_id = sd.m_attributesetinstance_id and marca.m_attribute_id = ?) as marca_stock, ( select modelo.value from m_attributeinstance modelo where modelo.m_attributesetinstance_id = sd.m_attributesetinstance_id and modelo.m_attribute_id = ?) as modelo_stock from dlc_photo ph left join m_storage_detail sd on sd.em_dlc_etiqueta = ph.etiqueta where sd.qtyonhand > ?) as f2 where f2.em_dlc_etiqueta is null or f2.producto_foto <> f2.product_stock or f2.marca_foto <> f2.marca_stock or f2.modelo_foto <> f2.modelo_stock;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 19 07 12 20s824ms 1s735ms 08 12 21s53ms 1s754ms 09 12 21s19ms 1s751ms 10 12 20s997ms 1s749ms 11 12 20s867ms 1s738ms 12 12 20s952ms 1s746ms 13 12 20s604ms 1s717ms 14 12 20s519ms 1s709ms 15 12 21s180ms 1s765ms 16 12 22s536ms 1s878ms 17 12 21s439ms 1s786ms 18 12 20s808ms 1s734ms 19 12 28s635ms 2s386ms 20 12 21s217ms 1s768ms 21 12 22s169ms 1s847ms [ User: tad - Total duration: 5m24s - Times executed: 180 ]
[ Application: openbravo - Total duration: 5m24s - Times executed: 180 ]
-
SELECT f2.dlc_photo_id, f2.attrSetId as attrId FROM ( SELECT ph.dlc_photo_id, ph.etiqueta, ph.m_product_id as producto_foto, sd.m_product_id as product_stock, ph.marca as marca_foto, ph.modelo as modelo_foto, sd.em_dlc_etiqueta, sd.m_attributesetinstance_id as attrSetId, ( select marca.value from m_attributeinstance marca where marca.m_attributesetinstance_id = sd.m_attributesetinstance_id and marca.m_attribute_id = 'A9E9BBFFD7694A94A231C7DE00182355') as marca_stock, ( select modelo.value from m_attributeinstance modelo where modelo.m_attributesetinstance_id = sd.m_attributesetinstance_id and modelo.m_attribute_id = '32CA1D3AA6CC4C648E4AA76E58BC1886') as modelo_stock FROM dlc_photo ph LEFT JOIN m_storage_detail sd ON sd.em_dlc_etiqueta = ph.etiqueta WHERE sd.qtyonhand > 0) as f2 WHERE f2.em_dlc_etiqueta IS NULL OR f2.producto_foto <> f2.product_stock OR f2.marca_foto <> f2.marca_stock OR f2.modelo_foto <> f2.modelo_stock;
Date: 2026-07-19 19:28:09 Duration: 9s285ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT f2.dlc_photo_id, f2.attrSetId as attrId FROM ( SELECT ph.dlc_photo_id, ph.etiqueta, ph.m_product_id as producto_foto, sd.m_product_id as product_stock, ph.marca as marca_foto, ph.modelo as modelo_foto, sd.em_dlc_etiqueta, sd.m_attributesetinstance_id as attrSetId, ( select marca.value from m_attributeinstance marca where marca.m_attributesetinstance_id = sd.m_attributesetinstance_id and marca.m_attribute_id = 'A9E9BBFFD7694A94A231C7DE00182355') as marca_stock, ( select modelo.value from m_attributeinstance modelo where modelo.m_attributesetinstance_id = sd.m_attributesetinstance_id and modelo.m_attribute_id = '32CA1D3AA6CC4C648E4AA76E58BC1886') as modelo_stock FROM dlc_photo ph LEFT JOIN m_storage_detail sd ON sd.em_dlc_etiqueta = ph.etiqueta WHERE sd.qtyonhand > 0) as f2 WHERE f2.em_dlc_etiqueta IS NULL OR f2.producto_foto <> f2.product_stock OR f2.marca_foto <> f2.marca_stock OR f2.modelo_foto <> f2.modelo_stock;
Date: 2026-07-19 16:28:03 Duration: 3s135ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT f2.dlc_photo_id, f2.attrSetId as attrId FROM ( SELECT ph.dlc_photo_id, ph.etiqueta, ph.m_product_id as producto_foto, sd.m_product_id as product_stock, ph.marca as marca_foto, ph.modelo as modelo_foto, sd.em_dlc_etiqueta, sd.m_attributesetinstance_id as attrSetId, ( select marca.value from m_attributeinstance marca where marca.m_attributesetinstance_id = sd.m_attributesetinstance_id and marca.m_attribute_id = 'A9E9BBFFD7694A94A231C7DE00182355') as marca_stock, ( select modelo.value from m_attributeinstance modelo where modelo.m_attributesetinstance_id = sd.m_attributesetinstance_id and modelo.m_attribute_id = '32CA1D3AA6CC4C648E4AA76E58BC1886') as modelo_stock FROM dlc_photo ph LEFT JOIN m_storage_detail sd ON sd.em_dlc_etiqueta = ph.etiqueta WHERE sd.qtyonhand > 0) as f2 WHERE f2.em_dlc_etiqueta IS NULL OR f2.producto_foto <> f2.product_stock OR f2.marca_foto <> f2.marca_stock OR f2.modelo_foto <> f2.modelo_stock;
Date: 2026-07-19 21:28:02 Duration: 2s335ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
9 5m3s 226 1s 1s698ms 1s343ms delete from dlcmkp_marketplace_part dcmp where estado in (...) and dlcmkp_marketplace_id != ? and not exists ( select ? from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > ? and not exists ( select ? from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = ?) and not exists ( select ? from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = ?) and msd.em_awobg_orderline is null);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 19 14 16 16s706ms 1s44ms 15 30 33s129ms 1s104ms 16 30 35s870ms 1s195ms 17 30 38s231ms 1s274ms 18 30 41s254ms 1s375ms 19 30 43s635ms 1s454ms 20 30 45s922ms 1s530ms 21 30 48s923ms 1s630ms [ User: tad - Total duration: 5m3s - Times executed: 226 ]
[ Application: openbravo - Total duration: 5m3s - Times executed: 226 ]
-
delete from dlcmkp_marketplace_part dcmp where estado in ('PP') and dlcmkp_marketplace_id != '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:53:25 Duration: 1s698ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
delete from dlcmkp_marketplace_part dcmp where estado in ('PP') and dlcmkp_marketplace_id != '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:57:25 Duration: 1s693ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
delete from dlcmkp_marketplace_part dcmp where estado in ('PP') and dlcmkp_marketplace_id != '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:55:25 Duration: 1s688ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
10 3s602ms 3 1s117ms 1s266ms 1s200ms select dpv.etiqueta_rfid as etiqueta, dpv.dlc_piezas_v_id as sdid from dlc_piezas_v dpv left join opxdes_vehiculo_pieza ovp on ovp.etiqueta = dpv.etiqueta_rfid and dpv.m_product_id = ovp.m_product_id join m_storage_detail msd on msd.m_storage_detail_id = dpv.dlc_piezas_v_id where dpv.etiqueta_rfid is not null and not exists ( select ? from dlc_pieza_info dpi where dpi.etiqueta = dpv.etiqueta_rfid) and dpv.m_product_id = ? and exists ( select ? from dlcstck_movement_stock dms where dms.etiqueta = dpv.etiqueta_rfid and dms.m_product_id = dpv.m_product_id and dms.movement_qty >= ? and dms.movement_date <= ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 19 13 1 1s117ms 1s117ms 16 1 1s218ms 1s218ms 19 1 1s266ms 1s266ms [ User: tad - Total duration: 3s602ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 3s602ms - Times executed: 3 ]
-
select dpv.etiqueta_rfid as etiqueta, dpv.dlc_piezas_v_id as sdid from dlc_piezas_v dpv left join opxdes_vehiculo_pieza ovp on ovp.etiqueta = dpv.etiqueta_rfid and dpv.m_product_id = ovp.m_product_id join m_storage_detail msd on msd.m_storage_detail_id = dpv.dlc_piezas_v_id where dpv.etiqueta_rfid is not null AND NOT EXISTS ( SELECT 1 FROM dlc_pieza_info dpi WHERE dpi.etiqueta = dpv.etiqueta_rfid) and dpv.m_product_id = 'BC13C923A3CE449CA1998CAFECB9843F' AND EXISTS ( SELECT 1 FROM dlcstck_movement_stock dms WHERE dms.etiqueta = dpv.etiqueta_rfid AND dms.m_product_id = dpv.m_product_id AND dms.movement_qty >= 0 AND dms.movement_date <= '2026-03-01 00:00:00.00');
Date: 2026-07-19 19:27:58 Duration: 1s266ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select dpv.etiqueta_rfid as etiqueta, dpv.dlc_piezas_v_id as sdid from dlc_piezas_v dpv left join opxdes_vehiculo_pieza ovp on ovp.etiqueta = dpv.etiqueta_rfid and dpv.m_product_id = ovp.m_product_id join m_storage_detail msd on msd.m_storage_detail_id = dpv.dlc_piezas_v_id where dpv.etiqueta_rfid is not null AND NOT EXISTS ( SELECT 1 FROM dlc_pieza_info dpi WHERE dpi.etiqueta = dpv.etiqueta_rfid) and dpv.m_product_id = 'BC13C923A3CE449CA1998CAFECB9843F' AND EXISTS ( SELECT 1 FROM dlcstck_movement_stock dms WHERE dms.etiqueta = dpv.etiqueta_rfid AND dms.m_product_id = dpv.m_product_id AND dms.movement_qty >= 0 AND dms.movement_date <= '2026-03-01 00:00:00.00');
Date: 2026-07-19 16:27:58 Duration: 1s218ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select dpv.etiqueta_rfid as etiqueta, dpv.dlc_piezas_v_id as sdid from dlc_piezas_v dpv left join opxdes_vehiculo_pieza ovp on ovp.etiqueta = dpv.etiqueta_rfid and dpv.m_product_id = ovp.m_product_id join m_storage_detail msd on msd.m_storage_detail_id = dpv.dlc_piezas_v_id where dpv.etiqueta_rfid is not null AND NOT EXISTS ( SELECT 1 FROM dlc_pieza_info dpi WHERE dpi.etiqueta = dpv.etiqueta_rfid) and dpv.m_product_id = 'BC13C923A3CE449CA1998CAFECB9843F' AND EXISTS ( SELECT 1 FROM dlcstck_movement_stock dms WHERE dms.etiqueta = dpv.etiqueta_rfid AND dms.m_product_id = dpv.m_product_id AND dms.movement_qty >= 0 AND dms.movement_date <= '2026-03-01 00:00:00.00');
Date: 2026-07-19 13:27:57 Duration: 1s117ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
11 1s58ms 1 1s58ms 1s58ms 1s58ms select msd.m_storage_detail_id as stgid from m_storage_detail msd left join m_locator ml on ml.m_locator_id = msd.m_locator_id left join obawo_locator_group olg on olg.obawo_locator_group_id = ml.em_obawo_locator_group_id left join m_attributesetinstance ma on ma.m_attributesetinstance_id = msd.m_attributesetinstance_id left join m_attributesetinstance parent on parent.m_attributesetinstance_id = ma.parent_attributesetinstance_id where coalesce(msd.em_dlc_etiqueta, parent.em_dlc_etiqueta, ma.em_dlc_etiqueta, ?) != ? and msd.qtyonhand > ? and ml.m_warehouse_id = ? and exists ( select ? from dlcstck_mov_conf_loc_out dmclo where dmclo.dlcstck_mov_stock_conf_id = ? and (dmclo.m_locator_id = msd.m_locator_id or dmclo.obawo_locator_group_id = olg.obawo_locator_group_id or dmclo.obawo_internal_routing_area_id = olg.obawo_internal_routing_area_id)) and not exists ( select ? from dlcstck_mov_conf_product dmcp where dmcp.dlcstck_mov_stock_conf_id = ? and dmcp.m_product_id = msd.m_product_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 19 19 1 1s58ms 1s58ms [ User: tad - Total duration: 1s58ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 1s58ms - Times executed: 1 ]
-
select msd.m_storage_detail_id as stgid from m_storage_detail msd left join m_locator ml on ml.m_locator_id = msd.m_locator_id left join obawo_locator_group olg on olg.obawo_locator_group_id = ml.em_obawo_locator_group_id left join m_attributesetinstance ma on ma.m_attributesetinstance_id = msd.m_attributesetinstance_id left join m_attributesetinstance parent on parent.m_attributesetinstance_id = ma.parent_attributesetinstance_id where coalesce(msd.em_dlc_etiqueta, parent.em_dlc_etiqueta, ma.em_dlc_etiqueta, '') != '' and msd.qtyonhand > 0 and ml.m_warehouse_id = 'FCA81F56E9E643E096E86F5F379459FB' and exists ( select 1 from dlcstck_mov_conf_loc_out dmclo where dmclo.dlcstck_mov_stock_conf_id = 'A4CDC483529D4D32B9485310FB1D7900' and (dmclo.m_locator_id = msd.m_locator_id or dmclo.obawo_locator_group_id = olg.obawo_locator_group_id or dmclo.obawo_internal_routing_area_id = olg.obawo_internal_routing_area_id)) and not exists ( select 1 from dlcstck_mov_conf_product dmcp where dmcp.dlcstck_mov_stock_conf_id = 'A4CDC483529D4D32B9485310FB1D7900' and dmcp.m_product_id = msd.m_product_id);
Date: 2026-07-19 19:29:33 Duration: 1s58ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,620 1h1m20s 1s997ms 4s293ms 2s272ms select dcmp.sku as refid, dlceco_format_text_to_file (dc.name) as familia, dp."name" as articulo, dlceco_format_text_to_file (dcmp.marca) as marca, coalesce(dcmp.id_tecdoc_modelo, dlceco_format_text_to_file (dcmp.modelo)) as modelo, dcmp.anyo_cominezo_modelo as modeloinicio, dcmp.anyo_fin_modelo as modelofin, dlceco_format_text_to_file (dcmp.motor_code) as motorversion, null as cambioversion, dlceco_format_text_to_file (dcmp.referencias_oem) as refvisual, null as refcatalogo, null as attrib1, null as attrib2, replace(to_char(dcmp.precio_sin_iva, ?), ?, ?) as precio, null as estado, null as ubicacion, dcmp.anyo_comienzo_version as anopieza, null as nota, dlceco_format_text_to_file (dcmp.observaciones) as notapublica, null as ean, mp.weight as peso, to_char(dcmp.created, ?) as fechaentrada, ov.etiqueta as codvehiculo, null as ordenrevision, to_char(dcmp.updated, ?) as fecharevision, null as ordenextraccion, null as fechaextraccion, null as contenedor, null as codalmacen, dcmp.sku as almacen, null as fechalmacen, null as factualiza, ( select string_agg(s.urlfoto, ?) from ( select dm.url_image || dpi.ad_image_id as urlfoto from dlc_photo dph left join dlc_photo_image dpi on dpi.dlc_photo_id = dph.dlc_photo_id left join dlc_product_photo dpp on dpp.m_product_id = dph.m_product_id and dpp.dlc_photo_type_id = dpi.dlc_photo_type_id where dph.etiqueta = dcmp.sku group by dpp.dlc_product_photo_id, dpi.dlc_photo_image_id order by dpp.seqno) s) as imgs from dlcmkp_marketplace_part dcmp left join m_product mp on mp.m_product_id = dcmp.m_product_id left join dlceco_categories dc on dc.dlceco_categories_id = mp.em_dlceco_categories_id left join dlcmkp_marketplace dm on dm.dlcmkp_marketplace_id = dcmp.dlcmkp_marketplace_id left join opxdes_vehiculo ov on ov.opxdes_vehiculo_id = dcmp.opxdes_vehiculo_id left join dlceco_products dp on dp.dlceco_products_id = mp.em_dlceco_products_id where dcmp.dlcmkp_marketplace_id = ? and dcmp.estado in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 108 4m 2s229ms 08 108 4m1s 2s239ms 09 108 4m3s 2s258ms 10 108 4m2s 2s242ms 11 108 4m2s 2s242ms 12 108 4m3s 2s258ms 13 108 4m4s 2s265ms 14 108 4m4s 2s267ms 15 108 4m3s 2s257ms 16 108 4m9s 2s310ms 17 108 4m7s 2s295ms 18 108 4m9s 2s312ms 19 108 4m8s 2s299ms 20 108 4m8s 2s298ms 21 108 4m8s 2s302ms [ User: tad - Total duration: 1h1m20s - Times executed: 1620 ]
[ Application: openbravo - Total duration: 1h1m20s - Times executed: 1620 ]
-
SELECT dcmp.sku AS refid, dlceco_format_text_to_file (dc.name) AS familia, dp."name" AS articulo, dlceco_format_text_to_file (dcmp.marca) AS marca, coalesce(dcmp.id_tecdoc_modelo, dlceco_format_text_to_file (dcmp.modelo)) AS modelo, dcmp.anyo_cominezo_modelo AS modeloinicio, dcmp.anyo_fin_modelo AS modelofin, dlceco_format_text_to_file (dcmp.motor_code) AS motorversion, null AS cambioversion, dlceco_format_text_to_file (dcmp.referencias_oem) AS refvisual, null AS refcatalogo, null AS attrib1, null AS attrib2, REPLACE(TO_CHAR(dcmp.precio_sin_iva, 'FM999999990.00'), '.', ',') AS precio, null AS estado, null AS ubicacion, dcmp.anyo_comienzo_version AS anopieza, null AS nota, dlceco_format_text_to_file (dcmp.observaciones) AS notapublica, null AS ean, mp.weight AS peso, TO_CHAR(dcmp.created, 'DD-MM-YYYY') AS fechaentrada, ov.etiqueta AS codvehiculo, null AS ordenrevision, TO_CHAR(dcmp.updated, 'DD-MM-YYYY') AS fecharevision, null AS ordenextraccion, null AS fechaextraccion, null AS contenedor, null AS codalmacen, dcmp.sku AS almacen, null AS fechalmacen, null AS factualiza, ( SELECT string_agg(s.urlfoto, ',') FROM ( SELECT dm.url_image || dpi.ad_image_id AS urlfoto FROM dlc_photo dph LEFT JOIN dlc_photo_image dpi ON dpi.dlc_photo_id = dph.dlc_photo_id LEFT JOIN dlc_product_photo dpp ON dpp.m_product_id = dph.m_product_id AND dpp.dlc_photo_type_id = dpi.dlc_photo_type_id WHERE dph.etiqueta = dcmp.sku GROUP BY dpp.dlc_product_photo_id, dpi.dlc_photo_image_id ORDER BY dpp.seqno) s) AS imgs FROM dlcmkp_marketplace_part dcmp LEFT JOIN m_product mp ON mp.m_product_id = dcmp.m_product_id LEFT JOIN dlceco_categories dc ON dc.dlceco_categories_id = mp.em_dlceco_categories_id LEFT JOIN dlcmkp_marketplace dm ON dm.dlcmkp_marketplace_id = dcmp.dlcmkp_marketplace_id LEFT JOIN opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dcmp.opxdes_vehiculo_id LEFT JOIN dlceco_products dp ON dp.dlceco_products_id = mp.em_dlceco_products_id WHERE dcmp.dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND dcmp.estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 19:37:14 Duration: 4s293ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT dcmp.sku AS refid, dlceco_format_text_to_file (dc.name) AS familia, dp."name" AS articulo, dlceco_format_text_to_file (dcmp.marca) AS marca, coalesce(dcmp.id_tecdoc_modelo, dlceco_format_text_to_file (dcmp.modelo)) AS modelo, dcmp.anyo_cominezo_modelo AS modeloinicio, dcmp.anyo_fin_modelo AS modelofin, dlceco_format_text_to_file (dcmp.motor_code) AS motorversion, null AS cambioversion, dlceco_format_text_to_file (dcmp.referencias_oem) AS refvisual, null AS refcatalogo, null AS attrib1, null AS attrib2, REPLACE(TO_CHAR(dcmp.precio_sin_iva, 'FM999999990.00'), '.', ',') AS precio, null AS estado, null AS ubicacion, dcmp.anyo_comienzo_version AS anopieza, null AS nota, dlceco_format_text_to_file (dcmp.observaciones) AS notapublica, null AS ean, mp.weight AS peso, TO_CHAR(dcmp.created, 'DD-MM-YYYY') AS fechaentrada, ov.etiqueta AS codvehiculo, null AS ordenrevision, TO_CHAR(dcmp.updated, 'DD-MM-YYYY') AS fecharevision, null AS ordenextraccion, null AS fechaextraccion, null AS contenedor, null AS codalmacen, dcmp.sku AS almacen, null AS fechalmacen, null AS factualiza, ( SELECT string_agg(s.urlfoto, ',') FROM ( SELECT dm.url_image || dpi.ad_image_id AS urlfoto FROM dlc_photo dph LEFT JOIN dlc_photo_image dpi ON dpi.dlc_photo_id = dph.dlc_photo_id LEFT JOIN dlc_product_photo dpp ON dpp.m_product_id = dph.m_product_id AND dpp.dlc_photo_type_id = dpi.dlc_photo_type_id WHERE dph.etiqueta = dcmp.sku GROUP BY dpp.dlc_product_photo_id, dpi.dlc_photo_image_id ORDER BY dpp.seqno) s) AS imgs FROM dlcmkp_marketplace_part dcmp LEFT JOIN m_product mp ON mp.m_product_id = dcmp.m_product_id LEFT JOIN dlceco_categories dc ON dc.dlceco_categories_id = mp.em_dlceco_categories_id LEFT JOIN dlcmkp_marketplace dm ON dm.dlcmkp_marketplace_id = dcmp.dlcmkp_marketplace_id LEFT JOIN opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dcmp.opxdes_vehiculo_id LEFT JOIN dlceco_products dp ON dp.dlceco_products_id = mp.em_dlceco_products_id WHERE dcmp.dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND dcmp.estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 21:52:14 Duration: 3s903ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT dcmp.sku AS refid, dlceco_format_text_to_file (dc.name) AS familia, dp."name" AS articulo, dlceco_format_text_to_file (dcmp.marca) AS marca, coalesce(dcmp.id_tecdoc_modelo, dlceco_format_text_to_file (dcmp.modelo)) AS modelo, dcmp.anyo_cominezo_modelo AS modeloinicio, dcmp.anyo_fin_modelo AS modelofin, dlceco_format_text_to_file (dcmp.motor_code) AS motorversion, null AS cambioversion, dlceco_format_text_to_file (dcmp.referencias_oem) AS refvisual, null AS refcatalogo, null AS attrib1, null AS attrib2, REPLACE(TO_CHAR(dcmp.precio_sin_iva, 'FM999999990.00'), '.', ',') AS precio, null AS estado, null AS ubicacion, dcmp.anyo_comienzo_version AS anopieza, null AS nota, dlceco_format_text_to_file (dcmp.observaciones) AS notapublica, null AS ean, mp.weight AS peso, TO_CHAR(dcmp.created, 'DD-MM-YYYY') AS fechaentrada, ov.etiqueta AS codvehiculo, null AS ordenrevision, TO_CHAR(dcmp.updated, 'DD-MM-YYYY') AS fecharevision, null AS ordenextraccion, null AS fechaextraccion, null AS contenedor, null AS codalmacen, dcmp.sku AS almacen, null AS fechalmacen, null AS factualiza, ( SELECT string_agg(s.urlfoto, ',') FROM ( SELECT dm.url_image || dpi.ad_image_id AS urlfoto FROM dlc_photo dph LEFT JOIN dlc_photo_image dpi ON dpi.dlc_photo_id = dph.dlc_photo_id LEFT JOIN dlc_product_photo dpp ON dpp.m_product_id = dph.m_product_id AND dpp.dlc_photo_type_id = dpi.dlc_photo_type_id WHERE dph.etiqueta = dcmp.sku GROUP BY dpp.dlc_product_photo_id, dpi.dlc_photo_image_id ORDER BY dpp.seqno) s) AS imgs FROM dlcmkp_marketplace_part dcmp LEFT JOIN m_product mp ON mp.m_product_id = dcmp.m_product_id LEFT JOIN dlceco_categories dc ON dc.dlceco_categories_id = mp.em_dlceco_categories_id LEFT JOIN dlcmkp_marketplace dm ON dm.dlcmkp_marketplace_id = dcmp.dlcmkp_marketplace_id LEFT JOIN opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dcmp.opxdes_vehiculo_id LEFT JOIN dlceco_products dp ON dp.dlceco_products_id = mp.em_dlceco_products_id WHERE dcmp.dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND dcmp.estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 21:37:13 Duration: 3s823ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 792 17m50s 1s 2s28ms 1s351ms select dmp.dlcmkp_marketplace_part_id as id, dmp.estado as status from dlcmkp_marketplace_part dmp where dmp.dlcmkp_marketplace_id = ? and dmp.estado in (...) order by dmp.estado, dmp.updated;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 12 4 4s248ms 1s62ms 13 9 9s979ms 1s108ms 14 65 1m8s 1s51ms 15 102 1m54s 1s122ms 16 102 2m2s 1s203ms 17 102 2m11s 1s292ms 18 102 2m21s 1s390ms 19 102 2m30s 1s471ms 20 102 2m38s 1s553ms 21 102 2m48s 1s653ms [ User: tad - Total duration: 17m50s - Times executed: 792 ]
[ Application: openbravo - Total duration: 17m50s - Times executed: 792 ]
-
select dmp.dlcmkp_marketplace_part_id as id, dmp.estado as status from dlcmkp_marketplace_part dmp where dmp.dlcmkp_marketplace_id = '681DE6797F2B442DBDA481D7BDF299D7' and dmp.estado in ('PD', 'PP', 'PU') order by dmp.estado, dmp.updated;
Date: 2026-07-19 21:59:35 Duration: 2s28ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select dmp.dlcmkp_marketplace_part_id as id, dmp.estado as status from dlcmkp_marketplace_part dmp where dmp.dlcmkp_marketplace_id = '8B316F1811104D83B4DFB57E799813B6' and dmp.estado in ('PD', 'PP', 'PU') order by dmp.estado, dmp.updated;
Date: 2026-07-19 21:53:30 Duration: 1s962ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select dmp.dlcmkp_marketplace_part_id as id, dmp.estado as status from dlcmkp_marketplace_part dmp where dmp.dlcmkp_marketplace_id = '681DE6797F2B442DBDA481D7BDF299D7' and dmp.estado in ('PD', 'PP', 'PU') order by dmp.estado, dmp.updated;
Date: 2026-07-19 21:39:34 Duration: 1s962ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 394 13m6s 1s20ms 2s985ms 1s996ms delete from dlcmkp_marketplace_part dcmp where dlcmkp_marketplace_id = ? and not exists ( select ? from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > ? and not exists ( select ? from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = ?) and not exists ( select ? from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = ?) and msd.em_awobg_orderline is null);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 08 4 4s121ms 1s30ms 09 30 33s423ms 1s114ms 10 30 37s792ms 1s259ms 11 30 42s436ms 1s414ms 12 30 47s283ms 1s576ms 13 30 51s905ms 1s730ms 14 30 56s3ms 1s866ms 15 30 1m1s 2s41ms 16 30 1m5s 2s185ms 17 30 1m9s 2s302ms 18 30 1m14s 2s483ms 19 30 1m18s 2s610ms 20 30 1m22s 2s742ms 21 30 1m22s 2s761ms [ User: tad - Total duration: 13m6s - Times executed: 394 ]
[ Application: openbravo - Total duration: 13m6s - Times executed: 394 ]
-
delete from dlcmkp_marketplace_part dcmp where dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:31:28 Duration: 2s985ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
delete from dlcmkp_marketplace_part dcmp where dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:29:28 Duration: 2s930ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
delete from dlcmkp_marketplace_part dcmp where dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:23:28 Duration: 2s921ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 304 7m7s 1s2ms 1s948ms 1s407ms update dlcmkp_marketplace_part dcmp set estado = ?, updated = now(), updatedby = ? where estado in (...) and not exists ( select ? from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > ? and not exists ( select ? from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = ?) and not exists ( select ? from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = ?) and msd.em_awobg_orderline is null);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 10 2 2s39ms 1s19ms 11 6 6s210ms 1s35ms 12 26 27s224ms 1s47ms 13 30 33s911ms 1s130ms 14 30 36s917ms 1s230ms 15 30 39s586ms 1s319ms 16 30 42s92ms 1s403ms 17 30 43s58ms 1s435ms 18 30 45s703ms 1s523ms 19 30 48s680ms 1s622ms 20 30 49s748ms 1s658ms 21 30 52s645ms 1s754ms [ User: tad - Total duration: 7m7s - Times executed: 304 ]
[ Application: openbravo - Total duration: 7m7s - Times executed: 304 ]
-
update dlcmkp_marketplace_part dcmp set estado = 'PD', updated = now(), updatedby = '100' where estado in ('POSTED', 'PU') and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:41:23 Duration: 1s948ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update dlcmkp_marketplace_part dcmp set estado = 'PD', updated = now(), updatedby = '100' where estado in ('POSTED', 'PU') and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:31:23 Duration: 1s920ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update dlcmkp_marketplace_part dcmp set estado = 'PD', updated = now(), updatedby = '100' where estado in ('POSTED', 'PU') and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 19:23:23 Duration: 1s886ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 226 5m3s 1s 1s698ms 1s343ms delete from dlcmkp_marketplace_part dcmp where estado in (...) and dlcmkp_marketplace_id != ? and not exists ( select ? from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > ? and not exists ( select ? from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = ?) and not exists ( select ? from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = ?) and msd.em_awobg_orderline is null);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 19 14 16 16s706ms 1s44ms 15 30 33s129ms 1s104ms 16 30 35s870ms 1s195ms 17 30 38s231ms 1s274ms 18 30 41s254ms 1s375ms 19 30 43s635ms 1s454ms 20 30 45s922ms 1s530ms 21 30 48s923ms 1s630ms [ User: tad - Total duration: 5m3s - Times executed: 226 ]
[ Application: openbravo - Total duration: 5m3s - Times executed: 226 ]
-
delete from dlcmkp_marketplace_part dcmp where estado in ('PP') and dlcmkp_marketplace_id != '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:53:25 Duration: 1s698ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
delete from dlcmkp_marketplace_part dcmp where estado in ('PP') and dlcmkp_marketplace_id != '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:57:25 Duration: 1s693ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
delete from dlcmkp_marketplace_part dcmp where estado in ('PP') and dlcmkp_marketplace_id != '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:55:25 Duration: 1s688ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 180 5m24s 1s551ms 9s285ms 1s804ms select f2.dlc_photo_id, f2.attrsetid as attrid from ( select ph.dlc_photo_id, ph.etiqueta, ph.m_product_id as producto_foto, sd.m_product_id as product_stock, ph.marca as marca_foto, ph.modelo as modelo_foto, sd.em_dlc_etiqueta, sd.m_attributesetinstance_id as attrsetid, ( select marca.value from m_attributeinstance marca where marca.m_attributesetinstance_id = sd.m_attributesetinstance_id and marca.m_attribute_id = ?) as marca_stock, ( select modelo.value from m_attributeinstance modelo where modelo.m_attributesetinstance_id = sd.m_attributesetinstance_id and modelo.m_attribute_id = ?) as modelo_stock from dlc_photo ph left join m_storage_detail sd on sd.em_dlc_etiqueta = ph.etiqueta where sd.qtyonhand > ?) as f2 where f2.em_dlc_etiqueta is null or f2.producto_foto <> f2.product_stock or f2.marca_foto <> f2.marca_stock or f2.modelo_foto <> f2.modelo_stock;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 19 07 12 20s824ms 1s735ms 08 12 21s53ms 1s754ms 09 12 21s19ms 1s751ms 10 12 20s997ms 1s749ms 11 12 20s867ms 1s738ms 12 12 20s952ms 1s746ms 13 12 20s604ms 1s717ms 14 12 20s519ms 1s709ms 15 12 21s180ms 1s765ms 16 12 22s536ms 1s878ms 17 12 21s439ms 1s786ms 18 12 20s808ms 1s734ms 19 12 28s635ms 2s386ms 20 12 21s217ms 1s768ms 21 12 22s169ms 1s847ms [ User: tad - Total duration: 5m24s - Times executed: 180 ]
[ Application: openbravo - Total duration: 5m24s - Times executed: 180 ]
-
SELECT f2.dlc_photo_id, f2.attrSetId as attrId FROM ( SELECT ph.dlc_photo_id, ph.etiqueta, ph.m_product_id as producto_foto, sd.m_product_id as product_stock, ph.marca as marca_foto, ph.modelo as modelo_foto, sd.em_dlc_etiqueta, sd.m_attributesetinstance_id as attrSetId, ( select marca.value from m_attributeinstance marca where marca.m_attributesetinstance_id = sd.m_attributesetinstance_id and marca.m_attribute_id = 'A9E9BBFFD7694A94A231C7DE00182355') as marca_stock, ( select modelo.value from m_attributeinstance modelo where modelo.m_attributesetinstance_id = sd.m_attributesetinstance_id and modelo.m_attribute_id = '32CA1D3AA6CC4C648E4AA76E58BC1886') as modelo_stock FROM dlc_photo ph LEFT JOIN m_storage_detail sd ON sd.em_dlc_etiqueta = ph.etiqueta WHERE sd.qtyonhand > 0) as f2 WHERE f2.em_dlc_etiqueta IS NULL OR f2.producto_foto <> f2.product_stock OR f2.marca_foto <> f2.marca_stock OR f2.modelo_foto <> f2.modelo_stock;
Date: 2026-07-19 19:28:09 Duration: 9s285ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT f2.dlc_photo_id, f2.attrSetId as attrId FROM ( SELECT ph.dlc_photo_id, ph.etiqueta, ph.m_product_id as producto_foto, sd.m_product_id as product_stock, ph.marca as marca_foto, ph.modelo as modelo_foto, sd.em_dlc_etiqueta, sd.m_attributesetinstance_id as attrSetId, ( select marca.value from m_attributeinstance marca where marca.m_attributesetinstance_id = sd.m_attributesetinstance_id and marca.m_attribute_id = 'A9E9BBFFD7694A94A231C7DE00182355') as marca_stock, ( select modelo.value from m_attributeinstance modelo where modelo.m_attributesetinstance_id = sd.m_attributesetinstance_id and modelo.m_attribute_id = '32CA1D3AA6CC4C648E4AA76E58BC1886') as modelo_stock FROM dlc_photo ph LEFT JOIN m_storage_detail sd ON sd.em_dlc_etiqueta = ph.etiqueta WHERE sd.qtyonhand > 0) as f2 WHERE f2.em_dlc_etiqueta IS NULL OR f2.producto_foto <> f2.product_stock OR f2.marca_foto <> f2.marca_stock OR f2.modelo_foto <> f2.modelo_stock;
Date: 2026-07-19 16:28:03 Duration: 3s135ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT f2.dlc_photo_id, f2.attrSetId as attrId FROM ( SELECT ph.dlc_photo_id, ph.etiqueta, ph.m_product_id as producto_foto, sd.m_product_id as product_stock, ph.marca as marca_foto, ph.modelo as modelo_foto, sd.em_dlc_etiqueta, sd.m_attributesetinstance_id as attrSetId, ( select marca.value from m_attributeinstance marca where marca.m_attributesetinstance_id = sd.m_attributesetinstance_id and marca.m_attribute_id = 'A9E9BBFFD7694A94A231C7DE00182355') as marca_stock, ( select modelo.value from m_attributeinstance modelo where modelo.m_attributesetinstance_id = sd.m_attributesetinstance_id and modelo.m_attribute_id = '32CA1D3AA6CC4C648E4AA76E58BC1886') as modelo_stock FROM dlc_photo ph LEFT JOIN m_storage_detail sd ON sd.em_dlc_etiqueta = ph.etiqueta WHERE sd.qtyonhand > 0) as f2 WHERE f2.em_dlc_etiqueta IS NULL OR f2.producto_foto <> f2.product_stock OR f2.marca_foto <> f2.marca_stock OR f2.modelo_foto <> f2.modelo_stock;
Date: 2026-07-19 21:28:02 Duration: 2s335ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
7 60 13m6s 8s688ms 19s202ms 13s102ms update dlcmkp_marketplace_part set estado = ?, updated = now() where dlcmkp_marketplace_id = ? and estado in (...);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 19 07 4 38s255ms 9s563ms 08 4 36s918ms 9s229ms 09 4 41s260ms 10s315ms 10 4 39s685ms 9s921ms 11 4 45s804ms 11s451ms 12 4 48s78ms 12s19ms 13 4 50s662ms 12s665ms 14 4 50s286ms 12s571ms 15 4 52s766ms 13s191ms 16 4 55s87ms 13s771ms 17 4 57s447ms 14s361ms 18 4 1m1s 15s400ms 19 4 1m8s 17s226ms 20 4 1m5s 16s492ms 21 4 1m13s 18s353ms [ User: tad - Total duration: 13m6s - Times executed: 60 ]
[ Application: openbravo - Total duration: 13m6s - Times executed: 60 ]
-
UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 19:23:30 Duration: 19s202ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 21:08:31 Duration: 18s664ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 21:23:33 Duration: 18s630ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
8 60 11m55s 7s300ms 19s687ms 11s932ms update dlcmkp_marketplace_part set estado = ? where estado = ? and dlcmkp_marketplace_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 19 07 4 33s333ms 8s333ms 08 4 31s131ms 7s782ms 09 4 35s928ms 8s982ms 10 4 34s487ms 8s621ms 11 4 39s54ms 9s763ms 12 4 42s641ms 10s660ms 13 4 44s480ms 11s120ms 14 4 45s253ms 11s313ms 15 4 49s420ms 12s355ms 16 4 51s820ms 12s955ms 17 4 53s217ms 13s304ms 18 4 57s584ms 14s396ms 19 4 1m4s 16s30ms 20 4 1m2s 15s610ms 21 4 1m11s 17s761ms [ User: tad - Total duration: 11m55s - Times executed: 60 ]
[ Application: openbravo - Total duration: 11m55s - Times executed: 60 ]
-
UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';
Date: 2026-07-19 21:22:12 Duration: 19s687ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';
Date: 2026-07-19 21:07:10 Duration: 17s621ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';
Date: 2026-07-19 19:37:10 Duration: 17s609ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
9 60 10m57s 9s38ms 15s540ms 10s954ms with imgs_agrupadas as ( select vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ?) as imgs from public.opxdega_vehiculo_grupo_foto vgf cross join public.dlcmkp_marketplace dm where vgf.em_dlc_image_id is not null group by vgf.opxdes_vehiculo_id ), vehiculos_unicos as ( select distinct ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas from public.dlcmkp_marketplace_part dmp inner join public.opxdes_vehiculo ov on ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id where coalesce(ov.etiqueta, ?) != ? ) select vu.etiqueta as codvehiculo, to_char(vu.fecha_entrada, ?) as fechaentrada, null as fechasalida, dlceco_format_text_to_file (coalesce(mcv_marca.name, ?)) as marca, dlceco_format_text_to_file (coalesce(ma_modelo.name, ?)) as modelo, dlceco_format_text_to_file (ma_version.name) as motorversion, dlceco_format_text_to_file (ma_cajacambios.name) as cambioversion, null as anoversion, vu.bastidor as bastidor, replace(vu.matricula, ?, ?) as matricula, to_char(vu.fecha_matricula, ?) as fechamatriculacion, null as paismatriculacion, mcv_color.name as color, coalesce( case when ma_numpuertas.value ~ ? then ma_numpuertas.value else ? end, ?) as puertas, vu.km as kilometraje, null as notapublica, null as codigomotor, null as codigocambio, coalesce(ma_tipo_combustible.value, ?) as tipocombustible, mcv_estadoveh.name as estadovehiculo, null as localizacion, null as usuario, null as factualiza, img.imgs from vehiculos_unicos vu left join imgs_agrupadas img on img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id left join public.m_attributevalue ma_modelo on ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo left join public.m_attributevalue ma_tipo_combustible on ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb left join public.m_attributevalue mcv_marca on mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca left join public.m_attributevalue ma_version on ma_version.m_attributevalue_id = vu.em_opxpatr_version left join public.m_attributevalue ma_cajacambios on ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios left join public.m_ch_value mcv_color on mcv_color.m_ch_value_id = vu.color left join public.m_attributevalue ma_numpuertas on ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas left join public.m_ch_value mcv_estadoveh on mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 19 07 4 37s271ms 9s317ms 08 4 38s191ms 9s547ms 09 4 37s70ms 9s267ms 10 4 38s47ms 9s511ms 11 4 38s81ms 9s520ms 12 4 39s203ms 9s800ms 13 4 39s592ms 9s898ms 14 4 39s973ms 9s993ms 15 4 40s727ms 10s181ms 16 4 48s268ms 12s67ms 17 4 49s468ms 12s367ms 18 4 50s381ms 12s595ms 19 4 53s5ms 13s251ms 20 4 53s14ms 13s253ms 21 4 54s974ms 13s743ms [ User: tad - Total duration: 10m57s - Times executed: 60 ]
[ Application: openbravo - Total duration: 10m57s - Times executed: 60 ]
-
WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;
Date: 2026-07-19 19:38:47 Duration: 15s540ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;
Date: 2026-07-19 21:23:47 Duration: 13s890ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;
Date: 2026-07-19 21:53:45 Duration: 13s869ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
10 3 3s602ms 1s117ms 1s266ms 1s200ms select dpv.etiqueta_rfid as etiqueta, dpv.dlc_piezas_v_id as sdid from dlc_piezas_v dpv left join opxdes_vehiculo_pieza ovp on ovp.etiqueta = dpv.etiqueta_rfid and dpv.m_product_id = ovp.m_product_id join m_storage_detail msd on msd.m_storage_detail_id = dpv.dlc_piezas_v_id where dpv.etiqueta_rfid is not null and not exists ( select ? from dlc_pieza_info dpi where dpi.etiqueta = dpv.etiqueta_rfid) and dpv.m_product_id = ? and exists ( select ? from dlcstck_movement_stock dms where dms.etiqueta = dpv.etiqueta_rfid and dms.m_product_id = dpv.m_product_id and dms.movement_qty >= ? and dms.movement_date <= ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 19 13 1 1s117ms 1s117ms 16 1 1s218ms 1s218ms 19 1 1s266ms 1s266ms [ User: tad - Total duration: 3s602ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 3s602ms - Times executed: 3 ]
-
select dpv.etiqueta_rfid as etiqueta, dpv.dlc_piezas_v_id as sdid from dlc_piezas_v dpv left join opxdes_vehiculo_pieza ovp on ovp.etiqueta = dpv.etiqueta_rfid and dpv.m_product_id = ovp.m_product_id join m_storage_detail msd on msd.m_storage_detail_id = dpv.dlc_piezas_v_id where dpv.etiqueta_rfid is not null AND NOT EXISTS ( SELECT 1 FROM dlc_pieza_info dpi WHERE dpi.etiqueta = dpv.etiqueta_rfid) and dpv.m_product_id = 'BC13C923A3CE449CA1998CAFECB9843F' AND EXISTS ( SELECT 1 FROM dlcstck_movement_stock dms WHERE dms.etiqueta = dpv.etiqueta_rfid AND dms.m_product_id = dpv.m_product_id AND dms.movement_qty >= 0 AND dms.movement_date <= '2026-03-01 00:00:00.00');
Date: 2026-07-19 19:27:58 Duration: 1s266ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select dpv.etiqueta_rfid as etiqueta, dpv.dlc_piezas_v_id as sdid from dlc_piezas_v dpv left join opxdes_vehiculo_pieza ovp on ovp.etiqueta = dpv.etiqueta_rfid and dpv.m_product_id = ovp.m_product_id join m_storage_detail msd on msd.m_storage_detail_id = dpv.dlc_piezas_v_id where dpv.etiqueta_rfid is not null AND NOT EXISTS ( SELECT 1 FROM dlc_pieza_info dpi WHERE dpi.etiqueta = dpv.etiqueta_rfid) and dpv.m_product_id = 'BC13C923A3CE449CA1998CAFECB9843F' AND EXISTS ( SELECT 1 FROM dlcstck_movement_stock dms WHERE dms.etiqueta = dpv.etiqueta_rfid AND dms.m_product_id = dpv.m_product_id AND dms.movement_qty >= 0 AND dms.movement_date <= '2026-03-01 00:00:00.00');
Date: 2026-07-19 16:27:58 Duration: 1s218ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select dpv.etiqueta_rfid as etiqueta, dpv.dlc_piezas_v_id as sdid from dlc_piezas_v dpv left join opxdes_vehiculo_pieza ovp on ovp.etiqueta = dpv.etiqueta_rfid and dpv.m_product_id = ovp.m_product_id join m_storage_detail msd on msd.m_storage_detail_id = dpv.dlc_piezas_v_id where dpv.etiqueta_rfid is not null AND NOT EXISTS ( SELECT 1 FROM dlc_pieza_info dpi WHERE dpi.etiqueta = dpv.etiqueta_rfid) and dpv.m_product_id = 'BC13C923A3CE449CA1998CAFECB9843F' AND EXISTS ( SELECT 1 FROM dlcstck_movement_stock dms WHERE dms.etiqueta = dpv.etiqueta_rfid AND dms.m_product_id = dpv.m_product_id AND dms.movement_qty >= 0 AND dms.movement_date <= '2026-03-01 00:00:00.00');
Date: 2026-07-19 13:27:57 Duration: 1s117ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
11 1 1s58ms 1s58ms 1s58ms 1s58ms select msd.m_storage_detail_id as stgid from m_storage_detail msd left join m_locator ml on ml.m_locator_id = msd.m_locator_id left join obawo_locator_group olg on olg.obawo_locator_group_id = ml.em_obawo_locator_group_id left join m_attributesetinstance ma on ma.m_attributesetinstance_id = msd.m_attributesetinstance_id left join m_attributesetinstance parent on parent.m_attributesetinstance_id = ma.parent_attributesetinstance_id where coalesce(msd.em_dlc_etiqueta, parent.em_dlc_etiqueta, ma.em_dlc_etiqueta, ?) != ? and msd.qtyonhand > ? and ml.m_warehouse_id = ? and exists ( select ? from dlcstck_mov_conf_loc_out dmclo where dmclo.dlcstck_mov_stock_conf_id = ? and (dmclo.m_locator_id = msd.m_locator_id or dmclo.obawo_locator_group_id = olg.obawo_locator_group_id or dmclo.obawo_internal_routing_area_id = olg.obawo_internal_routing_area_id)) and not exists ( select ? from dlcstck_mov_conf_product dmcp where dmcp.dlcstck_mov_stock_conf_id = ? and dmcp.m_product_id = msd.m_product_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 19 19 1 1s58ms 1s58ms [ User: tad - Total duration: 1s58ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 1s58ms - Times executed: 1 ]
-
select msd.m_storage_detail_id as stgid from m_storage_detail msd left join m_locator ml on ml.m_locator_id = msd.m_locator_id left join obawo_locator_group olg on olg.obawo_locator_group_id = ml.em_obawo_locator_group_id left join m_attributesetinstance ma on ma.m_attributesetinstance_id = msd.m_attributesetinstance_id left join m_attributesetinstance parent on parent.m_attributesetinstance_id = ma.parent_attributesetinstance_id where coalesce(msd.em_dlc_etiqueta, parent.em_dlc_etiqueta, ma.em_dlc_etiqueta, '') != '' and msd.qtyonhand > 0 and ml.m_warehouse_id = 'FCA81F56E9E643E096E86F5F379459FB' and exists ( select 1 from dlcstck_mov_conf_loc_out dmclo where dmclo.dlcstck_mov_stock_conf_id = 'A4CDC483529D4D32B9485310FB1D7900' and (dmclo.m_locator_id = msd.m_locator_id or dmclo.obawo_locator_group_id = olg.obawo_locator_group_id or dmclo.obawo_internal_routing_area_id = olg.obawo_internal_routing_area_id)) and not exists ( select 1 from dlcstck_mov_conf_product dmcp where dmcp.dlcstck_mov_stock_conf_id = 'A4CDC483529D4D32B9485310FB1D7900' and dmcp.m_product_id = msd.m_product_id);
Date: 2026-07-19 19:29:33 Duration: 1s58ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 8s688ms 19s202ms 13s102ms 60 13m6s update dlcmkp_marketplace_part set estado = ?, updated = now() where dlcmkp_marketplace_id = ? and estado in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 4 38s255ms 9s563ms 08 4 36s918ms 9s229ms 09 4 41s260ms 10s315ms 10 4 39s685ms 9s921ms 11 4 45s804ms 11s451ms 12 4 48s78ms 12s19ms 13 4 50s662ms 12s665ms 14 4 50s286ms 12s571ms 15 4 52s766ms 13s191ms 16 4 55s87ms 13s771ms 17 4 57s447ms 14s361ms 18 4 1m1s 15s400ms 19 4 1m8s 17s226ms 20 4 1m5s 16s492ms 21 4 1m13s 18s353ms [ User: tad - Total duration: 13m6s - Times executed: 60 ]
[ Application: openbravo - Total duration: 13m6s - Times executed: 60 ]
-
UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 19:23:30 Duration: 19s202ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 21:08:31 Duration: 18s664ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE dlcmkp_marketplace_part SET estado = 'POSTED', updated = now() WHERE dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 21:23:33 Duration: 18s630ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 7s300ms 19s687ms 11s932ms 60 11m55s update dlcmkp_marketplace_part set estado = ? where estado = ? and dlcmkp_marketplace_id = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 07 4 33s333ms 8s333ms 08 4 31s131ms 7s782ms 09 4 35s928ms 8s982ms 10 4 34s487ms 8s621ms 11 4 39s54ms 9s763ms 12 4 42s641ms 10s660ms 13 4 44s480ms 11s120ms 14 4 45s253ms 11s313ms 15 4 49s420ms 12s355ms 16 4 51s820ms 12s955ms 17 4 53s217ms 13s304ms 18 4 57s584ms 14s396ms 19 4 1m4s 16s30ms 20 4 1m2s 15s610ms 21 4 1m11s 17s761ms [ User: tad - Total duration: 11m55s - Times executed: 60 ]
[ Application: openbravo - Total duration: 11m55s - Times executed: 60 ]
-
UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';
Date: 2026-07-19 21:22:12 Duration: 19s687ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';
Date: 2026-07-19 21:07:10 Duration: 17s621ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE dlcmkp_marketplace_part SET estado = 'PP' WHERE estado = 'POSTED' AND dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65';
Date: 2026-07-19 19:37:10 Duration: 17s609ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 9s38ms 15s540ms 10s954ms 60 10m57s with imgs_agrupadas as ( select vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ?) as imgs from public.opxdega_vehiculo_grupo_foto vgf cross join public.dlcmkp_marketplace dm where vgf.em_dlc_image_id is not null group by vgf.opxdes_vehiculo_id ), vehiculos_unicos as ( select distinct ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas from public.dlcmkp_marketplace_part dmp inner join public.opxdes_vehiculo ov on ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id where coalesce(ov.etiqueta, ?) != ? ) select vu.etiqueta as codvehiculo, to_char(vu.fecha_entrada, ?) as fechaentrada, null as fechasalida, dlceco_format_text_to_file (coalesce(mcv_marca.name, ?)) as marca, dlceco_format_text_to_file (coalesce(ma_modelo.name, ?)) as modelo, dlceco_format_text_to_file (ma_version.name) as motorversion, dlceco_format_text_to_file (ma_cajacambios.name) as cambioversion, null as anoversion, vu.bastidor as bastidor, replace(vu.matricula, ?, ?) as matricula, to_char(vu.fecha_matricula, ?) as fechamatriculacion, null as paismatriculacion, mcv_color.name as color, coalesce( case when ma_numpuertas.value ~ ? then ma_numpuertas.value else ? end, ?) as puertas, vu.km as kilometraje, null as notapublica, null as codigomotor, null as codigocambio, coalesce(ma_tipo_combustible.value, ?) as tipocombustible, mcv_estadoveh.name as estadovehiculo, null as localizacion, null as usuario, null as factualiza, img.imgs from vehiculos_unicos vu left join imgs_agrupadas img on img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id left join public.m_attributevalue ma_modelo on ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo left join public.m_attributevalue ma_tipo_combustible on ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb left join public.m_attributevalue mcv_marca on mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca left join public.m_attributevalue ma_version on ma_version.m_attributevalue_id = vu.em_opxpatr_version left join public.m_attributevalue ma_cajacambios on ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios left join public.m_ch_value mcv_color on mcv_color.m_ch_value_id = vu.color left join public.m_attributevalue ma_numpuertas on ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas left join public.m_ch_value mcv_estadoveh on mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 07 4 37s271ms 9s317ms 08 4 38s191ms 9s547ms 09 4 37s70ms 9s267ms 10 4 38s47ms 9s511ms 11 4 38s81ms 9s520ms 12 4 39s203ms 9s800ms 13 4 39s592ms 9s898ms 14 4 39s973ms 9s993ms 15 4 40s727ms 10s181ms 16 4 48s268ms 12s67ms 17 4 49s468ms 12s367ms 18 4 50s381ms 12s595ms 19 4 53s5ms 13s251ms 20 4 53s14ms 13s253ms 21 4 54s974ms 13s743ms [ User: tad - Total duration: 10m57s - Times executed: 60 ]
[ Application: openbravo - Total duration: 10m57s - Times executed: 60 ]
-
WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;
Date: 2026-07-19 19:38:47 Duration: 15s540ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;
Date: 2026-07-19 21:23:47 Duration: 13s890ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;
Date: 2026-07-19 21:53:45 Duration: 13s869ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 1s997ms 4s293ms 2s272ms 1,620 1h1m20s select dcmp.sku as refid, dlceco_format_text_to_file (dc.name) as familia, dp."name" as articulo, dlceco_format_text_to_file (dcmp.marca) as marca, coalesce(dcmp.id_tecdoc_modelo, dlceco_format_text_to_file (dcmp.modelo)) as modelo, dcmp.anyo_cominezo_modelo as modeloinicio, dcmp.anyo_fin_modelo as modelofin, dlceco_format_text_to_file (dcmp.motor_code) as motorversion, null as cambioversion, dlceco_format_text_to_file (dcmp.referencias_oem) as refvisual, null as refcatalogo, null as attrib1, null as attrib2, replace(to_char(dcmp.precio_sin_iva, ?), ?, ?) as precio, null as estado, null as ubicacion, dcmp.anyo_comienzo_version as anopieza, null as nota, dlceco_format_text_to_file (dcmp.observaciones) as notapublica, null as ean, mp.weight as peso, to_char(dcmp.created, ?) as fechaentrada, ov.etiqueta as codvehiculo, null as ordenrevision, to_char(dcmp.updated, ?) as fecharevision, null as ordenextraccion, null as fechaextraccion, null as contenedor, null as codalmacen, dcmp.sku as almacen, null as fechalmacen, null as factualiza, ( select string_agg(s.urlfoto, ?) from ( select dm.url_image || dpi.ad_image_id as urlfoto from dlc_photo dph left join dlc_photo_image dpi on dpi.dlc_photo_id = dph.dlc_photo_id left join dlc_product_photo dpp on dpp.m_product_id = dph.m_product_id and dpp.dlc_photo_type_id = dpi.dlc_photo_type_id where dph.etiqueta = dcmp.sku group by dpp.dlc_product_photo_id, dpi.dlc_photo_image_id order by dpp.seqno) s) as imgs from dlcmkp_marketplace_part dcmp left join m_product mp on mp.m_product_id = dcmp.m_product_id left join dlceco_categories dc on dc.dlceco_categories_id = mp.em_dlceco_categories_id left join dlcmkp_marketplace dm on dm.dlcmkp_marketplace_id = dcmp.dlcmkp_marketplace_id left join opxdes_vehiculo ov on ov.opxdes_vehiculo_id = dcmp.opxdes_vehiculo_id left join dlceco_products dp on dp.dlceco_products_id = mp.em_dlceco_products_id where dcmp.dlcmkp_marketplace_id = ? and dcmp.estado in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 07 108 4m 2s229ms 08 108 4m1s 2s239ms 09 108 4m3s 2s258ms 10 108 4m2s 2s242ms 11 108 4m2s 2s242ms 12 108 4m3s 2s258ms 13 108 4m4s 2s265ms 14 108 4m4s 2s267ms 15 108 4m3s 2s257ms 16 108 4m9s 2s310ms 17 108 4m7s 2s295ms 18 108 4m9s 2s312ms 19 108 4m8s 2s299ms 20 108 4m8s 2s298ms 21 108 4m8s 2s302ms [ User: tad - Total duration: 1h1m20s - Times executed: 1620 ]
[ Application: openbravo - Total duration: 1h1m20s - Times executed: 1620 ]
-
SELECT dcmp.sku AS refid, dlceco_format_text_to_file (dc.name) AS familia, dp."name" AS articulo, dlceco_format_text_to_file (dcmp.marca) AS marca, coalesce(dcmp.id_tecdoc_modelo, dlceco_format_text_to_file (dcmp.modelo)) AS modelo, dcmp.anyo_cominezo_modelo AS modeloinicio, dcmp.anyo_fin_modelo AS modelofin, dlceco_format_text_to_file (dcmp.motor_code) AS motorversion, null AS cambioversion, dlceco_format_text_to_file (dcmp.referencias_oem) AS refvisual, null AS refcatalogo, null AS attrib1, null AS attrib2, REPLACE(TO_CHAR(dcmp.precio_sin_iva, 'FM999999990.00'), '.', ',') AS precio, null AS estado, null AS ubicacion, dcmp.anyo_comienzo_version AS anopieza, null AS nota, dlceco_format_text_to_file (dcmp.observaciones) AS notapublica, null AS ean, mp.weight AS peso, TO_CHAR(dcmp.created, 'DD-MM-YYYY') AS fechaentrada, ov.etiqueta AS codvehiculo, null AS ordenrevision, TO_CHAR(dcmp.updated, 'DD-MM-YYYY') AS fecharevision, null AS ordenextraccion, null AS fechaextraccion, null AS contenedor, null AS codalmacen, dcmp.sku AS almacen, null AS fechalmacen, null AS factualiza, ( SELECT string_agg(s.urlfoto, ',') FROM ( SELECT dm.url_image || dpi.ad_image_id AS urlfoto FROM dlc_photo dph LEFT JOIN dlc_photo_image dpi ON dpi.dlc_photo_id = dph.dlc_photo_id LEFT JOIN dlc_product_photo dpp ON dpp.m_product_id = dph.m_product_id AND dpp.dlc_photo_type_id = dpi.dlc_photo_type_id WHERE dph.etiqueta = dcmp.sku GROUP BY dpp.dlc_product_photo_id, dpi.dlc_photo_image_id ORDER BY dpp.seqno) s) AS imgs FROM dlcmkp_marketplace_part dcmp LEFT JOIN m_product mp ON mp.m_product_id = dcmp.m_product_id LEFT JOIN dlceco_categories dc ON dc.dlceco_categories_id = mp.em_dlceco_categories_id LEFT JOIN dlcmkp_marketplace dm ON dm.dlcmkp_marketplace_id = dcmp.dlcmkp_marketplace_id LEFT JOIN opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dcmp.opxdes_vehiculo_id LEFT JOIN dlceco_products dp ON dp.dlceco_products_id = mp.em_dlceco_products_id WHERE dcmp.dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND dcmp.estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 19:37:14 Duration: 4s293ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT dcmp.sku AS refid, dlceco_format_text_to_file (dc.name) AS familia, dp."name" AS articulo, dlceco_format_text_to_file (dcmp.marca) AS marca, coalesce(dcmp.id_tecdoc_modelo, dlceco_format_text_to_file (dcmp.modelo)) AS modelo, dcmp.anyo_cominezo_modelo AS modeloinicio, dcmp.anyo_fin_modelo AS modelofin, dlceco_format_text_to_file (dcmp.motor_code) AS motorversion, null AS cambioversion, dlceco_format_text_to_file (dcmp.referencias_oem) AS refvisual, null AS refcatalogo, null AS attrib1, null AS attrib2, REPLACE(TO_CHAR(dcmp.precio_sin_iva, 'FM999999990.00'), '.', ',') AS precio, null AS estado, null AS ubicacion, dcmp.anyo_comienzo_version AS anopieza, null AS nota, dlceco_format_text_to_file (dcmp.observaciones) AS notapublica, null AS ean, mp.weight AS peso, TO_CHAR(dcmp.created, 'DD-MM-YYYY') AS fechaentrada, ov.etiqueta AS codvehiculo, null AS ordenrevision, TO_CHAR(dcmp.updated, 'DD-MM-YYYY') AS fecharevision, null AS ordenextraccion, null AS fechaextraccion, null AS contenedor, null AS codalmacen, dcmp.sku AS almacen, null AS fechalmacen, null AS factualiza, ( SELECT string_agg(s.urlfoto, ',') FROM ( SELECT dm.url_image || dpi.ad_image_id AS urlfoto FROM dlc_photo dph LEFT JOIN dlc_photo_image dpi ON dpi.dlc_photo_id = dph.dlc_photo_id LEFT JOIN dlc_product_photo dpp ON dpp.m_product_id = dph.m_product_id AND dpp.dlc_photo_type_id = dpi.dlc_photo_type_id WHERE dph.etiqueta = dcmp.sku GROUP BY dpp.dlc_product_photo_id, dpi.dlc_photo_image_id ORDER BY dpp.seqno) s) AS imgs FROM dlcmkp_marketplace_part dcmp LEFT JOIN m_product mp ON mp.m_product_id = dcmp.m_product_id LEFT JOIN dlceco_categories dc ON dc.dlceco_categories_id = mp.em_dlceco_categories_id LEFT JOIN dlcmkp_marketplace dm ON dm.dlcmkp_marketplace_id = dcmp.dlcmkp_marketplace_id LEFT JOIN opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dcmp.opxdes_vehiculo_id LEFT JOIN dlceco_products dp ON dp.dlceco_products_id = mp.em_dlceco_products_id WHERE dcmp.dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND dcmp.estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 21:52:14 Duration: 3s903ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT dcmp.sku AS refid, dlceco_format_text_to_file (dc.name) AS familia, dp."name" AS articulo, dlceco_format_text_to_file (dcmp.marca) AS marca, coalesce(dcmp.id_tecdoc_modelo, dlceco_format_text_to_file (dcmp.modelo)) AS modelo, dcmp.anyo_cominezo_modelo AS modeloinicio, dcmp.anyo_fin_modelo AS modelofin, dlceco_format_text_to_file (dcmp.motor_code) AS motorversion, null AS cambioversion, dlceco_format_text_to_file (dcmp.referencias_oem) AS refvisual, null AS refcatalogo, null AS attrib1, null AS attrib2, REPLACE(TO_CHAR(dcmp.precio_sin_iva, 'FM999999990.00'), '.', ',') AS precio, null AS estado, null AS ubicacion, dcmp.anyo_comienzo_version AS anopieza, null AS nota, dlceco_format_text_to_file (dcmp.observaciones) AS notapublica, null AS ean, mp.weight AS peso, TO_CHAR(dcmp.created, 'DD-MM-YYYY') AS fechaentrada, ov.etiqueta AS codvehiculo, null AS ordenrevision, TO_CHAR(dcmp.updated, 'DD-MM-YYYY') AS fecharevision, null AS ordenextraccion, null AS fechaextraccion, null AS contenedor, null AS codalmacen, dcmp.sku AS almacen, null AS fechalmacen, null AS factualiza, ( SELECT string_agg(s.urlfoto, ',') FROM ( SELECT dm.url_image || dpi.ad_image_id AS urlfoto FROM dlc_photo dph LEFT JOIN dlc_photo_image dpi ON dpi.dlc_photo_id = dph.dlc_photo_id LEFT JOIN dlc_product_photo dpp ON dpp.m_product_id = dph.m_product_id AND dpp.dlc_photo_type_id = dpi.dlc_photo_type_id WHERE dph.etiqueta = dcmp.sku GROUP BY dpp.dlc_product_photo_id, dpi.dlc_photo_image_id ORDER BY dpp.seqno) s) AS imgs FROM dlcmkp_marketplace_part dcmp LEFT JOIN m_product mp ON mp.m_product_id = dcmp.m_product_id LEFT JOIN dlceco_categories dc ON dc.dlceco_categories_id = mp.em_dlceco_categories_id LEFT JOIN dlcmkp_marketplace dm ON dm.dlcmkp_marketplace_id = dcmp.dlcmkp_marketplace_id LEFT JOIN opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dcmp.opxdes_vehiculo_id LEFT JOIN dlceco_products dp ON dp.dlceco_products_id = mp.em_dlceco_products_id WHERE dcmp.dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' AND dcmp.estado IN ('PP', 'PU', 'EP');
Date: 2026-07-19 21:37:13 Duration: 3s823ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 1s20ms 2s985ms 1s996ms 394 13m6s delete from dlcmkp_marketplace_part dcmp where dlcmkp_marketplace_id = ? and not exists ( select ? from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > ? and not exists ( select ? from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = ?) and not exists ( select ? from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = ?) and msd.em_awobg_orderline is null);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 19 08 4 4s121ms 1s30ms 09 30 33s423ms 1s114ms 10 30 37s792ms 1s259ms 11 30 42s436ms 1s414ms 12 30 47s283ms 1s576ms 13 30 51s905ms 1s730ms 14 30 56s3ms 1s866ms 15 30 1m1s 2s41ms 16 30 1m5s 2s185ms 17 30 1m9s 2s302ms 18 30 1m14s 2s483ms 19 30 1m18s 2s610ms 20 30 1m22s 2s742ms 21 30 1m22s 2s761ms [ User: tad - Total duration: 13m6s - Times executed: 394 ]
[ Application: openbravo - Total duration: 13m6s - Times executed: 394 ]
-
delete from dlcmkp_marketplace_part dcmp where dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:31:28 Duration: 2s985ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
delete from dlcmkp_marketplace_part dcmp where dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:29:28 Duration: 2s930ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
delete from dlcmkp_marketplace_part dcmp where dlcmkp_marketplace_id = '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:23:28 Duration: 2s921ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 1s551ms 9s285ms 1s804ms 180 5m24s select f2.dlc_photo_id, f2.attrsetid as attrid from ( select ph.dlc_photo_id, ph.etiqueta, ph.m_product_id as producto_foto, sd.m_product_id as product_stock, ph.marca as marca_foto, ph.modelo as modelo_foto, sd.em_dlc_etiqueta, sd.m_attributesetinstance_id as attrsetid, ( select marca.value from m_attributeinstance marca where marca.m_attributesetinstance_id = sd.m_attributesetinstance_id and marca.m_attribute_id = ?) as marca_stock, ( select modelo.value from m_attributeinstance modelo where modelo.m_attributesetinstance_id = sd.m_attributesetinstance_id and modelo.m_attribute_id = ?) as modelo_stock from dlc_photo ph left join m_storage_detail sd on sd.em_dlc_etiqueta = ph.etiqueta where sd.qtyonhand > ?) as f2 where f2.em_dlc_etiqueta is null or f2.producto_foto <> f2.product_stock or f2.marca_foto <> f2.marca_stock or f2.modelo_foto <> f2.modelo_stock;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 19 07 12 20s824ms 1s735ms 08 12 21s53ms 1s754ms 09 12 21s19ms 1s751ms 10 12 20s997ms 1s749ms 11 12 20s867ms 1s738ms 12 12 20s952ms 1s746ms 13 12 20s604ms 1s717ms 14 12 20s519ms 1s709ms 15 12 21s180ms 1s765ms 16 12 22s536ms 1s878ms 17 12 21s439ms 1s786ms 18 12 20s808ms 1s734ms 19 12 28s635ms 2s386ms 20 12 21s217ms 1s768ms 21 12 22s169ms 1s847ms [ User: tad - Total duration: 5m24s - Times executed: 180 ]
[ Application: openbravo - Total duration: 5m24s - Times executed: 180 ]
-
SELECT f2.dlc_photo_id, f2.attrSetId as attrId FROM ( SELECT ph.dlc_photo_id, ph.etiqueta, ph.m_product_id as producto_foto, sd.m_product_id as product_stock, ph.marca as marca_foto, ph.modelo as modelo_foto, sd.em_dlc_etiqueta, sd.m_attributesetinstance_id as attrSetId, ( select marca.value from m_attributeinstance marca where marca.m_attributesetinstance_id = sd.m_attributesetinstance_id and marca.m_attribute_id = 'A9E9BBFFD7694A94A231C7DE00182355') as marca_stock, ( select modelo.value from m_attributeinstance modelo where modelo.m_attributesetinstance_id = sd.m_attributesetinstance_id and modelo.m_attribute_id = '32CA1D3AA6CC4C648E4AA76E58BC1886') as modelo_stock FROM dlc_photo ph LEFT JOIN m_storage_detail sd ON sd.em_dlc_etiqueta = ph.etiqueta WHERE sd.qtyonhand > 0) as f2 WHERE f2.em_dlc_etiqueta IS NULL OR f2.producto_foto <> f2.product_stock OR f2.marca_foto <> f2.marca_stock OR f2.modelo_foto <> f2.modelo_stock;
Date: 2026-07-19 19:28:09 Duration: 9s285ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT f2.dlc_photo_id, f2.attrSetId as attrId FROM ( SELECT ph.dlc_photo_id, ph.etiqueta, ph.m_product_id as producto_foto, sd.m_product_id as product_stock, ph.marca as marca_foto, ph.modelo as modelo_foto, sd.em_dlc_etiqueta, sd.m_attributesetinstance_id as attrSetId, ( select marca.value from m_attributeinstance marca where marca.m_attributesetinstance_id = sd.m_attributesetinstance_id and marca.m_attribute_id = 'A9E9BBFFD7694A94A231C7DE00182355') as marca_stock, ( select modelo.value from m_attributeinstance modelo where modelo.m_attributesetinstance_id = sd.m_attributesetinstance_id and modelo.m_attribute_id = '32CA1D3AA6CC4C648E4AA76E58BC1886') as modelo_stock FROM dlc_photo ph LEFT JOIN m_storage_detail sd ON sd.em_dlc_etiqueta = ph.etiqueta WHERE sd.qtyonhand > 0) as f2 WHERE f2.em_dlc_etiqueta IS NULL OR f2.producto_foto <> f2.product_stock OR f2.marca_foto <> f2.marca_stock OR f2.modelo_foto <> f2.modelo_stock;
Date: 2026-07-19 16:28:03 Duration: 3s135ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT f2.dlc_photo_id, f2.attrSetId as attrId FROM ( SELECT ph.dlc_photo_id, ph.etiqueta, ph.m_product_id as producto_foto, sd.m_product_id as product_stock, ph.marca as marca_foto, ph.modelo as modelo_foto, sd.em_dlc_etiqueta, sd.m_attributesetinstance_id as attrSetId, ( select marca.value from m_attributeinstance marca where marca.m_attributesetinstance_id = sd.m_attributesetinstance_id and marca.m_attribute_id = 'A9E9BBFFD7694A94A231C7DE00182355') as marca_stock, ( select modelo.value from m_attributeinstance modelo where modelo.m_attributesetinstance_id = sd.m_attributesetinstance_id and modelo.m_attribute_id = '32CA1D3AA6CC4C648E4AA76E58BC1886') as modelo_stock FROM dlc_photo ph LEFT JOIN m_storage_detail sd ON sd.em_dlc_etiqueta = ph.etiqueta WHERE sd.qtyonhand > 0) as f2 WHERE f2.em_dlc_etiqueta IS NULL OR f2.producto_foto <> f2.product_stock OR f2.marca_foto <> f2.marca_stock OR f2.modelo_foto <> f2.modelo_stock;
Date: 2026-07-19 21:28:02 Duration: 2s335ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
7 1s2ms 1s948ms 1s407ms 304 7m7s update dlcmkp_marketplace_part dcmp set estado = ?, updated = now(), updatedby = ? where estado in (...) and not exists ( select ? from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > ? and not exists ( select ? from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = ?) and not exists ( select ? from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = ?) and msd.em_awobg_orderline is null);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 19 10 2 2s39ms 1s19ms 11 6 6s210ms 1s35ms 12 26 27s224ms 1s47ms 13 30 33s911ms 1s130ms 14 30 36s917ms 1s230ms 15 30 39s586ms 1s319ms 16 30 42s92ms 1s403ms 17 30 43s58ms 1s435ms 18 30 45s703ms 1s523ms 19 30 48s680ms 1s622ms 20 30 49s748ms 1s658ms 21 30 52s645ms 1s754ms [ User: tad - Total duration: 7m7s - Times executed: 304 ]
[ Application: openbravo - Total duration: 7m7s - Times executed: 304 ]
-
update dlcmkp_marketplace_part dcmp set estado = 'PD', updated = now(), updatedby = '100' where estado in ('POSTED', 'PU') and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:41:23 Duration: 1s948ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update dlcmkp_marketplace_part dcmp set estado = 'PD', updated = now(), updatedby = '100' where estado in ('POSTED', 'PU') and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:31:23 Duration: 1s920ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update dlcmkp_marketplace_part dcmp set estado = 'PD', updated = now(), updatedby = '100' where estado in ('POSTED', 'PU') and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 19:23:23 Duration: 1s886ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
8 1s 2s28ms 1s351ms 792 17m50s select dmp.dlcmkp_marketplace_part_id as id, dmp.estado as status from dlcmkp_marketplace_part dmp where dmp.dlcmkp_marketplace_id = ? and dmp.estado in (...) order by dmp.estado, dmp.updated;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 19 12 4 4s248ms 1s62ms 13 9 9s979ms 1s108ms 14 65 1m8s 1s51ms 15 102 1m54s 1s122ms 16 102 2m2s 1s203ms 17 102 2m11s 1s292ms 18 102 2m21s 1s390ms 19 102 2m30s 1s471ms 20 102 2m38s 1s553ms 21 102 2m48s 1s653ms [ User: tad - Total duration: 17m50s - Times executed: 792 ]
[ Application: openbravo - Total duration: 17m50s - Times executed: 792 ]
-
select dmp.dlcmkp_marketplace_part_id as id, dmp.estado as status from dlcmkp_marketplace_part dmp where dmp.dlcmkp_marketplace_id = '681DE6797F2B442DBDA481D7BDF299D7' and dmp.estado in ('PD', 'PP', 'PU') order by dmp.estado, dmp.updated;
Date: 2026-07-19 21:59:35 Duration: 2s28ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select dmp.dlcmkp_marketplace_part_id as id, dmp.estado as status from dlcmkp_marketplace_part dmp where dmp.dlcmkp_marketplace_id = '8B316F1811104D83B4DFB57E799813B6' and dmp.estado in ('PD', 'PP', 'PU') order by dmp.estado, dmp.updated;
Date: 2026-07-19 21:53:30 Duration: 1s962ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select dmp.dlcmkp_marketplace_part_id as id, dmp.estado as status from dlcmkp_marketplace_part dmp where dmp.dlcmkp_marketplace_id = '681DE6797F2B442DBDA481D7BDF299D7' and dmp.estado in ('PD', 'PP', 'PU') order by dmp.estado, dmp.updated;
Date: 2026-07-19 21:39:34 Duration: 1s962ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
9 1s 1s698ms 1s343ms 226 5m3s delete from dlcmkp_marketplace_part dcmp where estado in (...) and dlcmkp_marketplace_id != ? and not exists ( select ? from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > ? and not exists ( select ? from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = ?) and not exists ( select ? from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = ?) and msd.em_awobg_orderline is null);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 19 14 16 16s706ms 1s44ms 15 30 33s129ms 1s104ms 16 30 35s870ms 1s195ms 17 30 38s231ms 1s274ms 18 30 41s254ms 1s375ms 19 30 43s635ms 1s454ms 20 30 45s922ms 1s530ms 21 30 48s923ms 1s630ms [ User: tad - Total duration: 5m3s - Times executed: 226 ]
[ Application: openbravo - Total duration: 5m3s - Times executed: 226 ]
-
delete from dlcmkp_marketplace_part dcmp where estado in ('PP') and dlcmkp_marketplace_id != '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:53:25 Duration: 1s698ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
delete from dlcmkp_marketplace_part dcmp where estado in ('PP') and dlcmkp_marketplace_id != '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:57:25 Duration: 1s693ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
delete from dlcmkp_marketplace_part dcmp where estado in ('PP') and dlcmkp_marketplace_id != '406E665BA9914437A3CD26A035F36A65' and not exists ( select 1 from m_storage_detail msd where msd.em_dlc_etiqueta = dcmp.sku and msd.qtyonhand > 0 and not exists ( select 1 from m_refinventory mr where mr.m_refinventory_id = msd.m_refinventory_id and mr.em_dlcs_excluir_ventas = 'Y') and not exists ( select 1 from m_locator ml where ml.m_locator_id = msd.m_locator_id and ml.em_dlces_excluir_ventas_sugar = 'Y') and msd.em_awobg_orderline is null);
Date: 2026-07-19 21:55:25 Duration: 1s688ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
10 1s117ms 1s266ms 1s200ms 3 3s602ms select dpv.etiqueta_rfid as etiqueta, dpv.dlc_piezas_v_id as sdid from dlc_piezas_v dpv left join opxdes_vehiculo_pieza ovp on ovp.etiqueta = dpv.etiqueta_rfid and dpv.m_product_id = ovp.m_product_id join m_storage_detail msd on msd.m_storage_detail_id = dpv.dlc_piezas_v_id where dpv.etiqueta_rfid is not null and not exists ( select ? from dlc_pieza_info dpi where dpi.etiqueta = dpv.etiqueta_rfid) and dpv.m_product_id = ? and exists ( select ? from dlcstck_movement_stock dms where dms.etiqueta = dpv.etiqueta_rfid and dms.m_product_id = dpv.m_product_id and dms.movement_qty >= ? and dms.movement_date <= ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 19 13 1 1s117ms 1s117ms 16 1 1s218ms 1s218ms 19 1 1s266ms 1s266ms [ User: tad - Total duration: 3s602ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 3s602ms - Times executed: 3 ]
-
select dpv.etiqueta_rfid as etiqueta, dpv.dlc_piezas_v_id as sdid from dlc_piezas_v dpv left join opxdes_vehiculo_pieza ovp on ovp.etiqueta = dpv.etiqueta_rfid and dpv.m_product_id = ovp.m_product_id join m_storage_detail msd on msd.m_storage_detail_id = dpv.dlc_piezas_v_id where dpv.etiqueta_rfid is not null AND NOT EXISTS ( SELECT 1 FROM dlc_pieza_info dpi WHERE dpi.etiqueta = dpv.etiqueta_rfid) and dpv.m_product_id = 'BC13C923A3CE449CA1998CAFECB9843F' AND EXISTS ( SELECT 1 FROM dlcstck_movement_stock dms WHERE dms.etiqueta = dpv.etiqueta_rfid AND dms.m_product_id = dpv.m_product_id AND dms.movement_qty >= 0 AND dms.movement_date <= '2026-03-01 00:00:00.00');
Date: 2026-07-19 19:27:58 Duration: 1s266ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select dpv.etiqueta_rfid as etiqueta, dpv.dlc_piezas_v_id as sdid from dlc_piezas_v dpv left join opxdes_vehiculo_pieza ovp on ovp.etiqueta = dpv.etiqueta_rfid and dpv.m_product_id = ovp.m_product_id join m_storage_detail msd on msd.m_storage_detail_id = dpv.dlc_piezas_v_id where dpv.etiqueta_rfid is not null AND NOT EXISTS ( SELECT 1 FROM dlc_pieza_info dpi WHERE dpi.etiqueta = dpv.etiqueta_rfid) and dpv.m_product_id = 'BC13C923A3CE449CA1998CAFECB9843F' AND EXISTS ( SELECT 1 FROM dlcstck_movement_stock dms WHERE dms.etiqueta = dpv.etiqueta_rfid AND dms.m_product_id = dpv.m_product_id AND dms.movement_qty >= 0 AND dms.movement_date <= '2026-03-01 00:00:00.00');
Date: 2026-07-19 16:27:58 Duration: 1s218ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select dpv.etiqueta_rfid as etiqueta, dpv.dlc_piezas_v_id as sdid from dlc_piezas_v dpv left join opxdes_vehiculo_pieza ovp on ovp.etiqueta = dpv.etiqueta_rfid and dpv.m_product_id = ovp.m_product_id join m_storage_detail msd on msd.m_storage_detail_id = dpv.dlc_piezas_v_id where dpv.etiqueta_rfid is not null AND NOT EXISTS ( SELECT 1 FROM dlc_pieza_info dpi WHERE dpi.etiqueta = dpv.etiqueta_rfid) and dpv.m_product_id = 'BC13C923A3CE449CA1998CAFECB9843F' AND EXISTS ( SELECT 1 FROM dlcstck_movement_stock dms WHERE dms.etiqueta = dpv.etiqueta_rfid AND dms.m_product_id = dpv.m_product_id AND dms.movement_qty >= 0 AND dms.movement_date <= '2026-03-01 00:00:00.00');
Date: 2026-07-19 13:27:57 Duration: 1s117ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
11 1s58ms 1s58ms 1s58ms 1 1s58ms select msd.m_storage_detail_id as stgid from m_storage_detail msd left join m_locator ml on ml.m_locator_id = msd.m_locator_id left join obawo_locator_group olg on olg.obawo_locator_group_id = ml.em_obawo_locator_group_id left join m_attributesetinstance ma on ma.m_attributesetinstance_id = msd.m_attributesetinstance_id left join m_attributesetinstance parent on parent.m_attributesetinstance_id = ma.parent_attributesetinstance_id where coalesce(msd.em_dlc_etiqueta, parent.em_dlc_etiqueta, ma.em_dlc_etiqueta, ?) != ? and msd.qtyonhand > ? and ml.m_warehouse_id = ? and exists ( select ? from dlcstck_mov_conf_loc_out dmclo where dmclo.dlcstck_mov_stock_conf_id = ? and (dmclo.m_locator_id = msd.m_locator_id or dmclo.obawo_locator_group_id = olg.obawo_locator_group_id or dmclo.obawo_internal_routing_area_id = olg.obawo_internal_routing_area_id)) and not exists ( select ? from dlcstck_mov_conf_product dmcp where dmcp.dlcstck_mov_stock_conf_id = ? and dmcp.m_product_id = msd.m_product_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 19 19 1 1s58ms 1s58ms [ User: tad - Total duration: 1s58ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 1s58ms - Times executed: 1 ]
-
select msd.m_storage_detail_id as stgid from m_storage_detail msd left join m_locator ml on ml.m_locator_id = msd.m_locator_id left join obawo_locator_group olg on olg.obawo_locator_group_id = ml.em_obawo_locator_group_id left join m_attributesetinstance ma on ma.m_attributesetinstance_id = msd.m_attributesetinstance_id left join m_attributesetinstance parent on parent.m_attributesetinstance_id = ma.parent_attributesetinstance_id where coalesce(msd.em_dlc_etiqueta, parent.em_dlc_etiqueta, ma.em_dlc_etiqueta, '') != '' and msd.qtyonhand > 0 and ml.m_warehouse_id = 'FCA81F56E9E643E096E86F5F379459FB' and exists ( select 1 from dlcstck_mov_conf_loc_out dmclo where dmclo.dlcstck_mov_stock_conf_id = 'A4CDC483529D4D32B9485310FB1D7900' and (dmclo.m_locator_id = msd.m_locator_id or dmclo.obawo_locator_group_id = olg.obawo_locator_group_id or dmclo.obawo_internal_routing_area_id = olg.obawo_internal_routing_area_id)) and not exists ( select 1 from dlcstck_mov_conf_product dmcp where dmcp.dlcstck_mov_stock_conf_id = 'A4CDC483529D4D32B9485310FB1D7900' and dmcp.m_product_id = msd.m_product_id);
Date: 2026-07-19 19:29:33 Duration: 1s58ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 35,840 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Events per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET