Skip site navigation (1) Skip section navigation (2)

Re: planner fails on HEAD

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: planner fails on HEAD
Date: 2011-12-04 07:49:24
Message-ID: CAFj8pRCRQOoi3jfBFh03mxdRXvVyaKU0ETbyZW6wR5GyU_WWQA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
a plan for modified query is

ohs=# explain analyze SELECT object_id,
       inserted,
       'ASSIGN_RSLT',
       order_id,
       2,
       seqnum,
       rejected_flat_file_id,
       true
FROM (
   SELECT q.object_id,
          fe.inserted,
          q.order_id,
          q.seqnum,
          q.rejected_flat_file_id,
          q.rejected_result
      FROM queue q
           JOIN
           outgoing.cps_forms f
           ON f.id = q.object_id AND q.object_type = 'cp'
           JOIN
           flat_file_ex fe
           ON fe.id = q.rejected_flat_file_id
offset 0) x
     WHERE rejected_result = 'ACTV';

QUERY PLAN
────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
 Subquery Scan on x  (cost=11.68..192.72 rows=1 width=24) (actual
time=1.748..12.398 rows=139 loops=1)
   Filter: (x.rejected_result = 'ACTV'::bpchar)
   Rows Removed by Filter: 17
   ->  Limit  (cost=11.68..192.65 rows=6 width=29) (actual
time=1.739..11.655 rows=156 loops=1)
         ->  Nested Loop  (cost=11.68..192.65 rows=6 width=29) (actual
time=1.732..11.036 rows=156 loops=1)
               ->  Hash Join  (cost=11.68..138.77 rows=15 width=21)
(actual time=1.459..6.987 rows=186 loops=1)
                     Hash Cond: (q.object_id = f.id)
                     ->  Seq Scan on queue q  (cost=0.00..126.24
rows=186 width=21) (actual time=0.032..4.658 rows=186 loops=1)
                           Filter: (object_type = 'cp'::bpchar)
                           Rows Removed by Filter: 4313
                     ->  Hash  (cost=9.08..9.08 rows=208 width=4)
(actual time=1.402..1.402 rows=208 loops=1)
                           Buckets: 1024  Batches: 1  Memory Usage: 5kB
                           ->  Seq Scan on cps_forms f
(cost=0.00..9.08 rows=208 width=4) (actual time=0.008..0.576 rows=208
loops=1)
               ->  Index Scan using flat_file_ex_pkey on flat_file_ex
fe  (cost=0.00..3.58 rows=1 width=12) (actual time=0.008..0.010 rows=1
loops=186)
                     Index Cond: (id = q.rejected_flat_file_id)
 Total runtime: 12.846 ms
(16 rows)

In response to

pgsql-hackers by date

Next:From: NISHIYAMA TomoakiDate: 2011-12-04 08:14:50
Subject: Re: [PATCH] PostgreSQL fails to build with 32bit MinGW-w64
Previous:From: Pavel StehuleDate: 2011-12-04 07:40:31
Subject: planner fails on HEAD

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group