API tools faq
paste
Guest User

Untitled

a guest
Feb 21st, 2020
50
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 18.79 KB | None | 0 0
raw download clone embed print report
  1. Nested Loop  (cost=5240.57..5375338.20 rows=43 width=8) (actual time=501753.564..501753.564 rows=0 loops=1)
  2.   ->  Hash Left Join  (cost=5240.15..5375217.21 rows=43 width=8) (actual time=501753.563..501753.564 rows=0 loops=1)
  3.         Hash Cond: (checkpoint3_.resultindicator = resultindi4_.version_meta_id)
  4.         Filter: (((resultindi1_.fpresultsexecution IS NOT NULL) AND (SubPlan 1)) OR ((resultindi1_.fpresultsexecution IS NULL) AND (SubPlan 2) AND (resultindi1_.event IS NOT NULL) AND (events2_.checkpoint IS NOT NULL) AND (((checkpoint3_.result IS NOT NULL) AND (SubPlan 3)) OR ((checkpoint3_.resultindicator IS NOT NULL) AND (resultindi4_.result IS NOT NULL) AND (SubPlan 4)))))
  5.         Rows Removed by Filter: 1549
  6.         ->  Nested Loop Left Join  (cost=1.43..5369241.07 rows=113 width=64) (actual time=631.544..493387.621 rows=1549 loops=1)
  7.               ->  Nested Loop Left Join  (cost=1.00..5365662.81 rows=113 width=48) (actual time=620.950..480282.097 rows=1549 loops=1)
  8.                     ->  Nested Loop  (cost=0.72..5363895.54 rows=113 width=40) (actual time=6.562..464184.322 rows=1549 loops=1)
  9.                           ->  Nested Loop  (cost=0.29..5362947.13 rows=113 width=32) (actual time=4.302..454432.985 rows=1549 loops=1)
  10.                                 ->  Seq Scan on eventrisks eventrisks0_  (cost=0.00..130.46 rows=8445 width=16) (actual time=0.026..22.721 rows=8445 loops=1)
  11.                                       Filter: (resultindicatoreventexecution IS NOT NULL)
  12.                                       Rows Removed by Filter: 1
  13.                                 ->  Index Scan using public_resultindicatoreventexecution_not_del_version_period_ran on resultindicatoreventexecution resultindi1_  (cost=0.29..635.02 rows=1 width=32) (actual time=53.776..53.805 rows=0 loops=8445)
  14.                                       Index Cond: (version_meta_id = eventrisks0_.resultindicatoreventexecution)
  15.                                       Filter: ((tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp())) AND (((fpresultsexecution IS NOT NULL) AND (SubPlan 1)) OR ((fpresultsexecution IS NULL) AND (event IS NOT NULL))))
  16.                                       Rows Removed by Filter: 4
  17.                                       SubPlan 1
  18.                                         ->  Nested Loop  (cost=9.51..157.20 rows=1 width=0) (actual time=64.468..64.468 rows=0 loops=6896)
  19.                                               ->  Nested Loop  (cost=9.37..156.89 rows=1 width=8) (actual time=53.256..64.458 rows=1 loops=6896)
  20.                                                     ->  Nested Loop  (cost=9.09..132.46 rows=1 width=8) (actual time=51.722..62.316 rows=1 loops=6896)
  21.                                                           ->  Bitmap Heap Scan on fpresultsexecution fpresultse5_  (cost=8.66..47.84 rows=10 width=16) (actual time=34.029..34.984 rows=9 loops=6896)
  22.                                                                 Recheck Cond: ((version_meta_id = resultindi1_.fpresultsexecution) OR (version_meta_id IS NULL))
  23.                                                                 Filter: ((version_meta_id = resultindi1_.fpresultsexecution) OR ((version_meta_id IS NULL) AND (resultindi1_.fpresultsexecution IS NULL)))
  24.                                                                 Heap Blocks: exact=51820
  25.                                                                 ->  BitmapOr  (cost=8.66..8.66 rows=10 width=0) (actual time=33.723..33.723 rows=0 loops=6896)
  26.                                                                       ->  Bitmap Index Scan on public_fpresultsexecution_version_period_range_idx  (cost=0.00..4.36 rows=10 width=0) (actual time=0.030..0.030 rows=9 loops=6896)
  27.                                                                             Index Cond: (version_meta_id = resultindi1_.fpresultsexecution)
  28.                                                                       ->  Bitmap Index Scan on public_fpresultsexecution_version_period_range_idx  (cost=0.00..4.29 rows=1 width=0) (actual time=33.690..33.690 rows=0 loops=6896)
  29.                                                                             Index Cond: (version_meta_id IS NULL)
  30.                                                           ->  Index Scan using fpresultexecution_pkey on fpresultexecution fpresultse5_1_  (cost=0.43..8.46 rows=1 width=8) (actual time=2.879..2.879 rows=0 loops=65407)
  31.                                                                 Index Cond: (id = fpresultse5_.id)
  32.                                                                 Filter: ((NOT version_is_deleted) AND (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp())))
  33.                                                                 Rows Removed by Filter: 1
  34.                                                     ->  Index Scan using public_results_version_period_range_idx on results results6_  (cost=0.28..24.42 rows=1 width=16) (actual time=1.528..2.135 rows=1 loops=6896)
  35.                                                           Index Cond: (version_meta_id = fpresultse5_.result)
  36.                                                           Filter: ((NOT version_is_deleted) AND (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp())))
  37.                                                           Rows Removed by Filter: 4
  38.                                               ->  Index Scan using public_tasks_not_del_version_period_range_idx on tasks tasks7_  (cost=0.14..0.30 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=6896)
  39.                                                     Index Cond: (version_meta_id = results6_.task)
  40.                                                     Filter: ((projectversion = 2135) AND (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp())))
  41.                                                     Rows Removed by Filter: 0
  42.                           ->  Index Scan using fpresultexecution_pkey on fpresultexecution resultindi1_1_  (cost=0.43..8.39 rows=1 width=24) (actual time=6.289..6.289 rows=1 loops=1549)
  43.                                 Index Cond: (id = resultindi1_.id)
  44.                     ->  Index Scan using public_events_not_del_version_period_range_idx on events events2_  (cost=0.29..15.63 rows=1 width=16) (actual time=6.734..10.386 rows=1 loops=1549)
  45.                           Index Cond: (resultindi1_.event = version_meta_id)
  46.                           Filter: (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp()))
  47.                           Rows Removed by Filter: 1
  48.               ->  Index Scan using public_checkpoints_version_period_idx on checkpoints checkpoint3_  (cost=0.43..31.66 rows=1 width=24) (actual time=8.449..8.455 rows=1 loops=1549)
  49.                     Index Cond: (events2_.checkpoint = version_meta_id)
  50.                     Filter: ((NOT version_is_deleted) AND (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp())))
  51.                     Rows Removed by Filter: 3
  52.         ->  Hash  (cost=5230.81..5230.81 rows=633 width=16) (actual time=1171.924..1171.924 rows=81183 loops=1)
  53.               Buckets: 131072 (originally 1024)  Batches: 1 (originally 1)  Memory Usage: 4830kB
  54.               ->  Gather  (cost=1000.00..5230.81 rows=633 width=16) (actual time=2.127..1149.638 rows=81183 loops=1)
  55.                     Workers Planned: 1
  56.                     Workers Launched: 1
  57.                     ->  Parallel Seq Scan on resultindicators resultindi4_  (cost=0.00..4167.51 rows=372 width=16) (actual time=13.890..1124.946 rows=40592 loops=2)
  58.                           Filter: ((NOT version_is_deleted) AND (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp())))
  59.                           Rows Removed by Filter: 31552
  60.         SubPlan 2
  61.           ->  Nested Loop  (cost=12.16..217.47 rows=1 width=0) (actual time=3.368..3.368 rows=1 loops=1549)
  62.                 ->  Nested Loop  (cost=11.73..210.11 rows=2 width=8) (actual time=0.117..0.641 rows=164 loops=1549)
  63.                       ->  Nested Loop  (cost=8.59..151.59 rows=1 width=8) (actual time=0.087..0.207 rows=6 loops=1549)
  64.                             ->  Bitmap Heap Scan on tasks tasks10_  (cost=4.19..18.21 rows=1 width=8) (actual time=0.024..0.033 rows=3 loops=1549)
  65.                                   Recheck Cond: (projectversion = 2135)
  66.                                   Filter: ((NOT version_is_deleted) AND (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp())))
  67.                                   Heap Blocks: exact=3085
  68.                                   ->  Bitmap Index Scan on ind_1677fc3667886b5199de8078078d04b4_simple  (cost=0.00..4.19 rows=6 width=0) (actual time=0.016..0.016 rows=6 loops=1549)
  69.                                         Index Cond: (projectversion = 2135)
  70.                             ->  Bitmap Heap Scan on results results9_  (cost=4.40..133.37 rows=1 width=16) (actual time=0.049..0.060 rows=2 loops=4107)
  71.                                   Recheck Cond: ((task = tasks10_.version_meta_id) AND (NOT version_is_deleted))
  72.                                   Filter: (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp()))
  73.                                   Rows Removed by Filter: 6
  74.                                   Heap Blocks: exact=28196
  75.                                   ->  Bitmap Index Scan on ind_1fde84286c8d4905bd5a463b4ed1b673  (cost=0.00..4.39 rows=33 width=0) (actual time=0.028..0.028 rows=8 loops=4107)
  76.                                         Index Cond: (task = tasks10_.version_meta_id)
  77.                       ->  Bitmap Heap Scan on fpresultsexecution fpresultse8_  (cost=3.14..58.10 rows=42 width=16) (actual time=0.013..0.066 rows=28 loops=9223)
  78.                             Recheck Cond: (result = results9_.version_meta_id)
  79.                             Heap Blocks: exact=194977
  80.                             ->  Bitmap Index Scan on ind_46c4ca8d6d20616dff3de52e442f8921_simple  (cost=0.00..3.13 rows=42 width=0) (actual time=0.007..0.007 rows=30 loops=9223)
  81.                                   Index Cond: (result = results9_.version_meta_id)
  82.                 ->  Index Scan using fpresultexecution_pkey on fpresultexecution fpresultse8_1_  (cost=0.43..3.67 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=253744)
  83.                       Index Cond: (id = fpresultse8_.id)
  84.                       Filter: ((NOT version_is_deleted) AND ((year = resultindi1_1_.year) OR ((year IS NULL) AND (resultindi1_1_.year IS NULL))) AND ((resultindi1_1_.month = month) OR ((resultindi1_1_.month IS NULL) AND (month IS NULL))) AND (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp())))
  85.                       Rows Removed by Filter: 1
  86.         SubPlan 3
  87.           ->  Nested Loop  (cost=22.78..177.84 rows=1 width=0) (actual time=1.336..1.336 rows=0 loops=1038)
  88.                 ->  Nested Loop  (cost=22.35..169.38 rows=1 width=8) (actual time=1.328..1.328 rows=0 loops=1038)
  89.                       ->  Nested Loop  (cost=8.59..151.59 rows=1 width=8) (actual time=0.049..0.321 rows=16 loops=1038)
  90.                             ->  Bitmap Heap Scan on tasks tasks13_  (cost=4.19..18.21 rows=1 width=8) (actual time=0.012..0.029 rows=6 loops=1038)
  91.                                   Recheck Cond: (projectversion = 2135)
  92.                                   Filter: ((NOT version_is_deleted) AND (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp())))
  93.                                   Heap Blocks: exact=4152
  94.                                   ->  Bitmap Index Scan on ind_1677fc3667886b5199de8078078d04b4_simple  (cost=0.00..4.19 rows=6 width=0) (actual time=0.007..0.007 rows=6 loops=1038)
  95.                                         Index Cond: (projectversion = 2135)
  96.                             ->  Bitmap Heap Scan on results results12_  (cost=4.40..133.37 rows=1 width=16) (actual time=0.035..0.046 rows=3 loops=6228)
  97.                                   Recheck Cond: ((task = tasks13_.version_meta_id) AND (NOT version_is_deleted))
  98.                                   Filter: (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp()))
  99.                                   Rows Removed by Filter: 7
  100.                                   Heap Blocks: exact=48786
  101.                                   ->  Bitmap Index Scan on ind_1fde84286c8d4905bd5a463b4ed1b673  (cost=0.00..4.39 rows=33 width=0) (actual time=0.020..0.020 rows=10 loops=6228)
  102.                                         Index Cond: (task = tasks13_.version_meta_id)
  103.                       ->  Bitmap Heap Scan on fpresultsexecution fpresultse11_  (cost=13.76..17.77 rows=1 width=16) (actual time=0.062..0.062 rows=0 loops=16608)
  104.                             Recheck Cond: ((result = results12_.version_meta_id) AND ((result = checkpoint3_.result) OR (result IS NULL)))
  105.                             Filter: ((result = checkpoint3_.result) OR ((result IS NULL) AND (checkpoint3_.result IS NULL)))
  106.                             ->  BitmapAnd  (cost=13.76..13.76 rows=1 width=0) (actual time=0.060..0.060 rows=0 loops=16608)
  107.                                   ->  Bitmap Index Scan on ind_46c4ca8d6d20616dff3de52e442f8921_simple  (cost=0.00..3.13 rows=42 width=0) (actual time=0.004..0.004 rows=29 loops=16608)
  108.                                         Index Cond: (result = results12_.version_meta_id)
  109.                                   ->  BitmapOr  (cost=10.38..10.38 rows=200 width=0) (actual time=0.058..0.058 rows=0 loops=15570)
  110.                                         ->  Bitmap Index Scan on ind_46c4ca8d6d20616dff3de52e442f8921_simple  (cost=0.00..4.74 rows=42 width=0) (actual time=0.051..0.051 rows=52 loops=15570)
  111.                                               Index Cond: (result = checkpoint3_.result)
  112.                                         ->  Bitmap Index Scan on ind_46c4ca8d6d20616dff3de52e442f8921_simple  (cost=0.00..5.62 rows=159 width=0) (actual time=0.006..0.006 rows=140 loops=15570)
  113.                                               Index Cond: (result IS NULL)
  114.                 ->  Index Scan using fpresultexecution_pkey on fpresultexecution fpresultse11_1_  (cost=0.43..8.46 rows=1 width=8) (never executed)
  115.                       Index Cond: (id = fpresultse11_.id)
  116.                       Filter: ((NOT version_is_deleted) AND (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp())))
  117.         SubPlan 4
  118.           ->  Nested Loop  (cost=22.78..177.84 rows=1 width=0) (actual time=0.529..0.529 rows=0 loops=1038)
  119.                 ->  Nested Loop  (cost=22.35..169.38 rows=1 width=8) (actual time=0.524..0.524 rows=0 loops=1038)
  120.                       ->  Nested Loop  (cost=8.59..151.59 rows=1 width=8) (actual time=0.044..0.244 rows=16 loops=1038)
  121.                             ->  Bitmap Heap Scan on tasks tasks16_  (cost=4.19..18.21 rows=1 width=8) (actual time=0.011..0.022 rows=6 loops=1038)
  122.                                   Recheck Cond: (projectversion = 2135)
  123.                                   Filter: ((NOT version_is_deleted) AND (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp())))
  124.                                   Heap Blocks: exact=4152
  125.                                   ->  Bitmap Index Scan on ind_1677fc3667886b5199de8078078d04b4_simple  (cost=0.00..4.19 rows=6 width=0) (actual time=0.007..0.007 rows=6 loops=1038)
  126.                                         Index Cond: (projectversion = 2135)
  127.                             ->  Bitmap Heap Scan on results results15_  (cost=4.40..133.37 rows=1 width=16) (actual time=0.027..0.035 rows=3 loops=6228)
  128.                                   Recheck Cond: ((task = tasks16_.version_meta_id) AND (NOT version_is_deleted))
  129.                                   Filter: (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp()))
  130.                                   Rows Removed by Filter: 7
  131.                                   Heap Blocks: exact=48786
  132.                                   ->  Bitmap Index Scan on ind_1fde84286c8d4905bd5a463b4ed1b673  (cost=0.00..4.39 rows=33 width=0) (actual time=0.017..0.017 rows=10 loops=6228)
  133.                                         Index Cond: (task = tasks16_.version_meta_id)
  134.                       ->  Bitmap Heap Scan on fpresultsexecution fpresultse14_  (cost=13.76..17.77 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=16608)
  135.                             Recheck Cond: ((result = results15_.version_meta_id) AND ((result = resultindi4_.result) OR (result IS NULL)))
  136.                             Filter: ((result = resultindi4_.result) OR ((result IS NULL) AND (resultindi4_.result IS NULL)))
  137.                             ->  BitmapAnd  (cost=13.76..13.76 rows=1 width=0) (actual time=0.015..0.015 rows=0 loops=16608)
  138.                                   ->  Bitmap Index Scan on ind_46c4ca8d6d20616dff3de52e442f8921_simple  (cost=0.00..3.13 rows=42 width=0) (actual time=0.004..0.004 rows=29 loops=16608)
  139.                                         Index Cond: (result = results15_.version_meta_id)
  140.                                   ->  BitmapOr  (cost=10.38..10.38 rows=200 width=0) (actual time=0.010..0.010 rows=0 loops=15570)
  141.                                         ->  Bitmap Index Scan on ind_46c4ca8d6d20616dff3de52e442f8921_simple  (cost=0.00..4.74 rows=42 width=0) (actual time=0.004..0.004 rows=52 loops=15570)
  142.                                               Index Cond: (result = resultindi4_.result)
  143.                                         ->  Bitmap Index Scan on ind_46c4ca8d6d20616dff3de52e442f8921_simple  (cost=0.00..5.62 rows=159 width=0) (actual time=0.006..0.006 rows=140 loops=15570)
  144.                                               Index Cond: (result IS NULL)
  145.                 ->  Index Scan using fpresultexecution_pkey on fpresultexecution fpresultse14_1_  (cost=0.43..8.46 rows=1 width=8) (never executed)
  146.                       Index Cond: (id = fpresultse14_.id)
  147.                       Filter: ((NOT version_is_deleted) AND (tsrange(version_actual_period_start, version_actual_period_end, '[]'::text) @> timezone('utc'::text, clock_timestamp())))
  148.   ->  Index Only Scan using projectrisks_pkey on projectrisks eventrisks0_1_  (cost=0.42..2.81 rows=1 width=8) (never executed)
  149.         Index Cond: (id = eventrisks0_.id)
  150.         Heap Fetches: 0
  151. Planning time: 3170.976 ms
  152. Execution time: 501759.987 ms
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!