query-plan-1173

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
495078.137 100.00% 
 Hash Left Join (cost=4500674.76..4804148.91 rows=655697 width=82) (actual time=463371.432..495078.137 rows=567582 loops=1)
   Hash Cond: (activity.status_id = status_code.status_id)
492795.609 99.54% 
   -> Hash Left Join (cost=4500671.37..4795129.69 rows=655697 width=56) (actual time=463330.144..492795.609 rows=567582 loops=1)
         Hash Cond: (loc.ticket_id = tic.ticket_id)
435492.478 87.96% 
         -> Hash Left Join (cost=4140849.61..4358513.13 rows=655697 width=38) (actual time=412662.088..435492.478 rows=567582 loops=1)
               Hash Cond: (activity.locate_id = loc.locate_id)
322091.591 65.06% 
               -> Merge Left Join (cost=3386981.07..3498249.57 rows=655697 width=34) (actual time=311325.409..322091.591 rows=567582 loops=1)
                     Merge Cond: (visit.visit_id = activity.visit_id)
3608.926 0.73% 
                     -> Sort (cost=69708.29..70557.91 rows=339845 width=16) (actual time=3006.577..3608.926 rows=319266 loops=1)
                           Sort Key: visit.visit_id
                           Sort Method:  quicksort  Memory: 37231kB
2182.841 0.44% 
                           -> Hash Join (cost=34.05..38485.85 rows=339845 width=16) (actual time=4.465..2182.841 rows=319266 loops=1)
                                 Hash Cond: (visit.actor_id = hu.h_usr_id)
887.542 0.18% 
                                 -> Index Scan using visit_by_arrived on visit (cost=0.0..33749.22 rows=347769 width=16) (actual time=0.044..887.542 rows=355059 loops=1)
                                       Index Cond: ((arrived >= '2008-09-01 00:00:00'::timestamp without time zone) AND (arrived <= '2008-09-29 00:00:00'::timestamp without time zone))
4.403 0.00% 
                                 -> Hash (cost=19.58..19.58 rows=1158 width=4) (actual time=4.403..4.403 rows=1158 loops=1)
2.092 0.00% 
                                       -> Seq Scan on hu (cost=0.0..19.58 rows=1158 width=4) (actual time=0.014..2.092 rows=1158 loops=1)
279999.349 56.56% 
                     -> Materialize (cost=3316954.03..3575373.95 rows=20673594 width=22) (actual time=155339.498..279999.349 rows=20672409 loops=1)
209814.708 42.38% 
                           -> Sort (cost=3316954.03..3368638.01 rows=20673594 width=22) (actual time=155339.487..209814.708 rows=20672409 loops=1)
                                 Sort Key: activity.visit_id
                                 Sort Method:  external merge  Disk: 808416kB
56897.584 11.49% 
                                 -> Seq Scan on activity (cost=0.0..381006.94 rows=20673594 width=22) (actual time=0.020..56897.584 rows=20675415 loops=1)
101283.085 20.46% 
               -> Hash (cost=449873.24..449873.24 rows=18529224 width=8) (actual time=101283.085..101283.085 rows=18529242 loops=1)
62257.891 12.58% 
                     -> Seq Scan on locate loc (cost=0.0..449873.24 rows=18529224 width=8) (actual time=18.347..62257.891 rows=18529242 loops=1)
50641.260 10.23% 
         -> Hash (cost=200098.67..200098.67 rows=8699767 width=22) (actual time=50641.260..50641.260 rows=8690343 loops=1)
31324.744 6.33% 
               -> Seq Scan on ticket tic (cost=0.0..200098.67 rows=8699767 width=22) (actual time=35.600..31324.744 rows=8690343 loops=1)
41.218 0.01% 
   -> Hash (cost=2.06..2.06 rows=106 width=34) (actual time=41.218..41.218 rows=106 loops=1)
41.005 0.01% 
         -> Seq Scan on status_code (cost=0.0..2.06 rows=106 width=34) (actual time=40.814..41.005 rows=106 loops=1)
Run-time
8 minutes 17.118937 seconds (497118.937 ms)