Part of Slepp's ProjectsPastebinTURLImagebinFilebin
Feedback -- English French German Japanese
Create Upload Newest Tools Donate


Paste Description for EXPLAIN ANALYZE PostgreSQL


Thursday, July 26th, 2012 at 1:16:49pm UTC 

  1.                                                                                          QUERY PLAN                                                                                         
  2. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  3.  Subquery Scan on "Swiss_client_wise_minutes_and_profit"  (cost=2341694.28..104895863.38 rows=44754 width=677) (actual time=298749.120..1425244.654 rows=26910 loops=1)
  4.    Filter: ("Swiss_client_wise_minutes_and_profit".start_time = '2012-07-22 08:00:00+00'::timestamp with time zone)
  5.    ->  WindowAgg  (cost=2341694.28..104783977.97 rows=8950833 width=148) (actual time=46300.153..1421611.261 rows=9372411 loops=1)
  6.          ->  Sort  (cost=2341694.28..2364071.37 rows=8950833 width=148) (actual time=46299.919..52269.932 rows=9372411 loops=1)
  7.                Sort Key:, rdga.group_id
  8.                Sort Method: external sort  Disk: 1194832kB
  9.                ->  Hash Left Join  (cost=1661.50..650394.42 rows=8950833 width=148) (actual time=96.768..31796.029 rows=9372411 loops=1)
  10.                      Hash Cond: (((cc.company_id)::text = (rdga.company_id)::text) AND ((cs.c_prefix_id)::text = (rdga.dest_id)::text))
  11.                      ->  Hash Left Join  (cost=7.88..491762.78 rows=8950833 width=123) (actual time=0.429..23000.254 rows=9372411 loops=1)
  12.                            Hash Cond: ((cs.client_name_id)::text = (cc."Alias_name")::text)
  13.                            ->  Append  (cost=0.00..391898.12 rows=8950833 width=111) (actual time=0.041..14645.703 rows=9372411 loops=1)
  14.                                  ->  Seq Scan on "Swiss_buz_scdr" cs  (cost=0.00..1.00 rows=1 width=610) (actual time=0.008..0.008 rows=0 loops=1)
  15.                                        Filter: ((customer_name)::text = 'SSP Root'::text)
  16.                                  ->  Seq Scan on scdr_buz__2012_07_11 cs  (cost=0.00..391877.86 rows=8950830 width=111) (actual time=0.031..11027.662 rows=9372411 loops=1)
  17.                                        Filter: ((customer_name)::text = 'SSP Root'::text)
  18.                                  ->  Seq Scan on scdr_buz_yy2012mm7 cs  (cost=0.00..10.62 rows=1 width=610) (actual time=0.001..0.001 rows=0 loops=1)
  19.                                        Filter: ((customer_name)::text = 'SSP Root'::text)
  20.                                  ->  Index Scan using index_scdr_buz__2012_07_23 on scdr_buz__2012_07_23 cs  (cost=0.00..8.64 rows=1 width=610) (actual time=0.012..0.012 rows=0 loops=1)
  21.                                        Index Cond: ((customer_name)::text = 'SSP Root'::text)
  22.                            ->  Hash  (cost=5.17..5.17 rows=217 width=24) (actual time=0.368..0.368 rows=281 loops=1)
  23.                                  Buckets: 1024  Batches: 1  Memory Usage: 13kB
  24.                                  ->  Seq Scan on "Corporate_companyalias" cc  (cost=0.00..5.17 rows=217 width=24) (actual time=0.010..0.155 rows=281 loops=1)
  25.                      ->  Hash  (cost=1334.42..1334.42 rows=21280 width=50) (actual time=96.319..96.319 rows=26040 loops=1)
  26.                            Buckets: 4096  Batches: 1  Memory Usage: 1835kB
  27.                            ->  Hash Join  (cost=169.56..1334.42 rows=21280 width=50) (actual time=8.514..73.367 rows=26040 loops=1)
  28.                                  Hash Cond: ((rdga.company_id)::text = (
  29.                                  ->  Hash Join  (cost=162.68..1034.93 rows=21280 width=50) (actual time=8.176..48.632 rows=26040 loops=1)
  30.                                        Hash Cond: ((rdga.group_id)::text = (
  31.                                        ->  Seq Scan on "RateManagement_destgroupassign" rdga  (cost=0.00..497.35 rows=25935 width=40) (actual time=0.013..11.212 rows=26040 loops=1)
  32.                                        ->  Hash  (cost=123.64..123.64 rows=3123 width=32) (actual time=8.153..8.153 rows=3753 loops=1)
  33.                                              Buckets: 1024  Batches: 1  Memory Usage: 196kB
  34.                                              ->  Hash Join  (cost=13.08..123.64 rows=3123 width=32) (actual time=0.620..5.486 rows=3753 loops=1)
  35.                                                    Hash Cond: (rdg.country_id =
  36.                                                    ->  Seq Scan on "RateManagement_destinationgroup" rdg  (cost=0.00..65.06 rows=3806 width=26) (actual time=0.012..1.529 rows=3753 loops=1)
  37.                                                    ->  Hash  (cost=7.48..7.48 rows=448 width=14) (actual time=0.586..0.586 rows=489 loops=1)
  38.                                                          Buckets: 1024  Batches: 1  Memory Usage: 18kB
  39.                                                          ->  Seq Scan on "Corporate_country" cc  (cost=0.00..7.48 rows=448 width=14) (actual time=0.013..0.276 rows=489 loops=1)
  40.                                  ->  Hash  (cost=4.17..4.17 rows=217 width=16) (actual time=0.325..0.325 rows=257 loops=1)
  41.                                        Buckets: 1024  Batches: 1  Memory Usage: 10kB
  42.                                        ->  Seq Scan on "Corporate_company" c  (cost=0.00..4.17 rows=217 width=16) (actual time=0.014..0.128 rows=257 loops=1)
  43.          SubPlan 1
  44.            ->  Seq Scan on "Corporate_companyalias" cc  (cost=0.00..5.71 rows=1 width=12) (actual time=0.049..0.070 rows=1 loops=9372411)
  45.                  Filter: (("Alias_name")::text = (cs.client_name_id)::text)
  46.          SubPlan 2
  47.            ->  Seq Scan on "Corporate_companyalias" cc  (cost=0.00..5.71 rows=1 width=12) (actual time=0.013..0.071 rows=1 loops=9372411)
  48.                  Filter: (("Alias_name")::text = (cs.vendor_name_id)::text)
  49.  Total runtime: 1425570.197 ms
  50. (47 rows)

Paste Details


Update the Post

Either update this post and resubmit it with changes, or make a new post.

You may also comment on this post.

update paste below
details of the post (optional)

Note: Only the paste content is required, though the following information can be useful to others.

Save name / title?

(space separated, optional)

Please note that information posted here will not expire by default. If you do not want it to expire, please set the expiry time above. If it is set to expire, web search engines will not be allowed to index it prior to it expiring. Items that are not marked to expire will be indexable by search engines. Be careful with your passwords. All illegal activities will be reported and any information will be handed over to the authorities, so be good.

comments powered by Disqus