SCM

[#1010619] pg_fouine 1.1 reporting incorrect time in analysis report

View Trackers | Bugs | Download .csv | Monitor

Date:
2009-05-07 00:04
Priority:
3
State:
Open
Submitted by:
Srinivas Bethi (sbethi)
Assigned to:
Nobody (None)
Category:
Group:
Resolution:
None
 
Summary:
pg_fouine 1.1 reporting incorrect time in analysis report

Detailed description


pg_fouine 1.1 reporting incorrect time in analysis report. This working correctly in 1.0.

V 1.1 shows 14.09s for this stmt. It actually took 985.5 secs.

create temp table property_score_part_new as select p.property_id, 5301 as score_part_id, case count(distinct (pm.media_id)) when 0 then 0 else case when count(distinct (pm.media_id)) between 1 and 3 then 30 when count(distinct (pm.media_id)) between 4 and 6 then 45 when count(distinct (pm.media_id)) between 7 and 10 then 55 when count(distinct (pm.media_id)) > 10 then 60 else 0 end + case when count(distinct (f.floorplan_id))::decimal > 0 then (25 * count (distinct (f.image_media_id))/count(distinct (f.floorplan_id))::decimal)::integer else 0 end + case when count(distinct (fm.floorplan_id)) >= count(distinct (f.floorplan_id)) then 15 else 0 end end + case count(pv.video_id) when 0 then 0 else 50 end as new_value from property p left join property_media pm using (property_id) left join floorplan f on f.property_id = p.property_id and f.is_active and f.is_displayed left join floorplan_media fm using (floorplan_id) left join property_video pv on pv.property_id = p.property_id and pv.is_displayed group by 1,2 union all select p.property_id, 5304, case sign (50 - 2*(current_date - (max(rent_modified_timestamp))::date)/7) when 1 then case sign (10 - 2*(max(rent_modified_timestamp)::date - min(rent_modified_timestamp)::date)/7) when 1 then 10 - 2*(max(rent_modified_timestamp)::date - min(rent_modified_timestamp)::date)/7 else 0 end + 50 - 2*(current_date - (max(rent_modified_timestamp))::date)/7 else 0 end + 25 from property p left join floorplan f on f.property_id = p.property_id and f.is_active and f.is_displayed group by 1,2 union all select property_id, 5307, case listing_level_id when 23 then 75 when 21 then 0 else -75 end from property ;

Followup

Message
Date: 2009-05-12 01:52
Sender: Srinivas Bethi

Unfortunately there is no private URL i can provide with. If
you can provide me with ftp site, i can upload the file to it.

Thanks
Srinivas
Date: 2009-05-11 21:44
Sender: Guillaume Smet

Hi Srinivas,

Could you send me an URL in private so that I can download the file directly (guillaume-pg at smet dot org)?
You log file is too big for the pgFoundry upload limit.

Thanks.

--
Guillaume
Date: 2009-05-11 21:33
Sender: Srinivas Bethi


I get the following error when i tried to upload DB LOG FIle.


Fatal error: Allowed memory size of 62914560 bytes exhausted
(tried to allocate 36754993 bytes) in
/usr/local/www/pgfoundry.org/gforge-4.0.2/common/tracker/ArtifactFile.class
on line 126
Open transaction detected!!!

Date: 2009-05-11 20:50
Sender: Srinivas Bethi


I was wrong, when I said "version 1.1 is reporting incorrect
time"

Actual issue

It is not reporting all the SQL stmts in Version 1.1.
Attaching the log files & reports generated by version 1.0 & 1.1

Thanks
Srinivas
Date: 2009-05-11 20:48
Sender: Srinivas Bethi


I was wrong, when I said "version 1.1 is reporting incorrect
time"

Actual issue

It is not reporting all the SQL stmts in Version 1.1.
Attaching the log files & reports generated by version 1.0 & 1.1

Thanks
Srinivas
Date: 2009-05-10 02:00
Sender: Srinivas Bethi


The logfile is too big for me upload it from my home, i will
upload it on monday.


Here is the text from the logfile.



-------------------------------------------
-------------------------------------------

2009-05-06 01:01:26 PDT [6819]: [2022-1] DETAIL:
parameters: $1 = '1YT518816803'
2009-05-06 01:01:26 PDT [6819]: [2023-1] LOG: duration:
0.753 ms
2009-05-06 01:01:26 PDT [5438]: [6-1] LOG: duration:
985515.960 ms
2009-05-06 01:01:26 PDT [5438]: [7-1] LOG: statement:
create temp table property_score_part_new (
property_id integer,
score_part_id integer,
new_value integer
);
2009-05-06 01:01:26 PDT [5438]: [8-1] LOG: duration: 6.223 ms
2009-05-06 01:01:26 PDT [5438]: [9-1] LOG: statement:
insert into property_score_part_new
select property_id, 5308,


f_get_adaptive_sort_score_adjust(property_id,cbsa_tier,revenue_model_id,

cost_per_lead_cap,leads_unique_last_30,impressions_last_5,

DLP_views_last_5,online_inquiries_id,application_usage_type_id,

call_routing_type_id,use_call_tracking_number,
call_tracking_number)

from property_score_adjust_tmp
;
2009-05-06 01:01:27 PDT [7699]: [18-1] LOG: duration: 2.848 ms
2009-05-06 01:01:27 PDT [7699]: [19-1] LOG: duration: 0.113 ms
2009-05-06 01:01:27 PDT [7699]: [20-1] LOG: execute
<unnamed>: SELECT property_amenity_id as id,
list_type_id,
property_amenity_name as name,
abbrev,
display_sequence,
is_mutable,
bit_position,
mits_name
FROM property_amenity

UNION

SELECT floorplan_amenity_id as id,
list_type_id,
floorplan_amenity_name as name,
abbrev,
display_sequence,
is_mutable,
bit_position,
mits_name
FROM floorplan_amenity

2009-05-06 01:01:27 PDT [7699]: [21-1] LOG: duration: 0.431 ms
2009-05-06 01:01:27 PDT [7699]: [22-1] LOG: duration: 1.531 ms
2009-05-06 01:01:27 PDT [7699]: [23-1] LOG: duration: 1.017 ms


-------------------------------------------------------
-------------------------------------------------------
Date: 2009-05-09 17:06
Sender: Srinivas Bethi


The logfile is too big for me upload it from my home, i will
upload it on monday.


Here is the text from the logfile.



-------------------------------------------
-------------------------------------------

2009-05-06 01:01:26 PDT [6819]: [2022-1] DETAIL:
parameters: $1 = '1YT518816803'
2009-05-06 01:01:26 PDT [6819]: [2023-1] LOG: duration:
0.753 ms
2009-05-06 01:01:26 PDT [5438]: [6-1] LOG: duration:
985515.960 ms
2009-05-06 01:01:26 PDT [5438]: [7-1] LOG: statement:
create temp table property_score_part_new (
property_id integer,
score_part_id integer,
new_value integer
);
2009-05-06 01:01:26 PDT [5438]: [8-1] LOG: duration: 6.223 ms
2009-05-06 01:01:26 PDT [5438]: [9-1] LOG: statement:
insert into property_score_part_new
select property_id, 5308,


f_get_adaptive_sort_score_adjust(property_id,cbsa_tier,revenue_model_id,

cost_per_lead_cap,leads_unique_last_30,impressions_last_5,

DLP_views_last_5,online_inquiries_id,application_usage_type_id,

call_routing_type_id,use_call_tracking_number,
call_tracking_number)

from property_score_adjust_tmp
;
2009-05-06 01:01:27 PDT [7699]: [18-1] LOG: duration: 2.848 ms
2009-05-06 01:01:27 PDT [7699]: [19-1] LOG: duration: 0.113 ms
2009-05-06 01:01:27 PDT [7699]: [20-1] LOG: execute
<unnamed>: SELECT property_amenity_id as id,
list_type_id,
property_amenity_name as name,
abbrev,
display_sequence,
is_mutable,
bit_position,
mits_name
FROM property_amenity

UNION

SELECT floorplan_amenity_id as id,
list_type_id,
floorplan_amenity_name as name,
abbrev,
display_sequence,
is_mutable,
bit_position,
mits_name
FROM floorplan_amenity

2009-05-06 01:01:27 PDT [7699]: [21-1] LOG: duration: 0.431 ms
2009-05-06 01:01:27 PDT [7699]: [22-1] LOG: duration: 1.531 ms
2009-05-06 01:01:27 PDT [7699]: [23-1] LOG: duration: 1.017 ms


-------------------------------------------------------
-------------------------------------------------------
Date: 2009-05-09 10:41
Sender: Guillaume Smet

Hi,

Could you please provide me the related the log file so that I can reproduce the problem?

Thanks.

Attached Files:

Attachments:
prddb10-Reports.zip
prddb10-Reports.zip

Changes:

Field Old Value Date By
File Added401: prddb10-Reports.zip2009-05-11 20:50sbethi
File Added400: prddb10-Reports.zip2009-05-11 20:48sbethi
Powered By FusionForge