Advertisement
Twissel

Advanced

May 23rd, 2022
763
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  2.  Sort  (cost=4138424.27..4138424.29 rows=9 width=903) (actual time=235525.506..235571.749 rows=0 loops=1)
  3.    Sort Key: worker_activity_liquidity_maker_1.id
  4.    Sort Method: quicksort  Memory: 25kB
  5.    Buffers: shared hit=120287 read=3750619
  6.    ->  Gather  (cost=1000.00..4138424.12 rows=9 width=903) (actual time=235525.494..235571.733 rows=0 loops=1)
  7.          Workers Planned: 2
  8.          Workers Launched: 2
  9.          Buffers: shared hit=120287 read=3750619
  10.          ->  Append  (cost=0.00..4137423.22 rows=9 width=903) (actual time=235521.443..235521.462 rows=0 loops=3)
  11.                Buffers: shared hit=120287 read=3750619
  12.                ->  Parallel Seq Scan on worker_activity_liquidity_maker_1  (cost=0.00..577947.97 rows=1 width=883) (actual time=30871.374..30871.375 rows=0 loops=3)
  13.                      Filter: ((created_at >= '2021-07-06 06:49:25'::timestamp without time zone) AND (created_at <= '2021-07-07 00:00:00'::timestamp without time zone) AND ((action = 'Start Work'::text) OR (action = 'End Work'::text)))
  14.                      Rows Removed by Filter: 1532803
  15.                      Buffers: shared hit=493 read=539153
  16.                ->  Parallel Seq Scan on worker_activity_liquidity_maker_2  (cost=0.00..505967.24 rows=1 width=935) (actual time=29927.739..29927.740 rows=0 loops=3)
  17.                      Filter: ((created_at >= '2021-07-06 06:49:25'::timestamp without time zone) AND (created_at <= '2021-07-07 00:00:00'::timestamp without time zone) AND ((action = 'Start Work'::text) OR (action = 'End Work'::text)))
  18.                      Rows Removed by Filter: 1273284
  19.                      Buffers: shared hit=290 read=473816
  20.                ->  Parallel Seq Scan on worker_activity_liquidity_maker_3  (cost=0.00..409953.82 rows=1 width=978) (actual time=24560.669..24560.670 rows=0 loops=3)
  21.                      Filter: ((created_at >= '2021-07-06 06:49:25'::timestamp without time zone) AND (created_at <= '2021-07-07 00:00:00'::timestamp without time zone) AND ((action = 'Start Work'::text) OR (action = 'End Work'::text)))
  22.                      Rows Removed by Filter: 986666
  23.                      Buffers: shared hit=464 read=384922
  24.                ->  Parallel Seq Scan on worker_activity_liquidity_maker_4  (cost=0.00..517571.53 rows=1 width=912) (actual time=30845.683..30845.684 rows=0 loops=3)
  25.                      Filter: ((created_at >= '2021-07-06 06:49:25'::timestamp without time zone) AND (created_at <= '2021-07-07 00:00:00'::timestamp without time zone) AND ((action = 'Start Work'::text) OR (action = 'End Work'::text)))
  26.                      Rows Removed by Filter: 1328712
  27.                      Buffers: shared hit=602 read=483822
  28.                ->  Parallel Seq Scan on worker_activity_liquidity_maker_5  (cost=0.00..412771.36 rows=1 width=969) (actual time=24726.327..24726.328 rows=0 loops=3)
  29.                      Filter: ((created_at >= '2021-07-06 06:49:25'::timestamp without time zone) AND (created_at <= '2021-07-07 00:00:00'::timestamp without time zone) AND ((action = 'Start Work'::text) OR (action = 'End Work'::text)))
  30.                      Rows Removed by Filter: 1003528
  31.                      Buffers: shared hit=397 read=387242
  32.                ->  Parallel Seq Scan on worker_activity_liquidity_maker_6  (cost=0.00..505008.02 rows=1 width=950) (actual time=30233.641..30233.642 rows=0 loops=3)
  33.                      Filter: ((created_at >= '2021-07-06 06:49:25'::timestamp without time zone) AND (created_at <= '2021-07-07 00:00:00'::timestamp without time zone) AND ((action = 'Start Work'::text) OR (action = 'End Work'::text)))
  34.                      Rows Removed by Filter: 1236177
  35.                      Buffers: shared hit=444 read=473533
  36.                ->  Parallel Seq Scan on worker_activity_liquidity_maker_7  (cost=0.00..452042.03 rows=1 width=871) (actual time=26881.948..26881.949 rows=0 loops=3)
  37.                      Filter: ((created_at >= '2021-07-06 06:49:25'::timestamp without time zone) AND (created_at <= '2021-07-07 00:00:00'::timestamp without time zone) AND ((action = 'Start Work'::text) OR (action = 'End Work'::text)))
  38.                      Rows Removed by Filter: 1215541
  39.                      Buffers: shared hit=516 read=421139
  40.                ->  Parallel Seq Scan on worker_activity_liquidity_maker_8  (cost=0.00..126317.74 rows=1 width=757) (actual time=199.055..199.056 rows=0 loops=3)
  41.                      Filter: ((created_at >= '2021-07-06 06:49:25'::timestamp without time zone) AND (created_at <= '2021-07-07 00:00:00'::timestamp without time zone) AND ((action = 'Start Work'::text) OR (action = 'End Work'::text)))
  42.                      Rows Removed by Filter: 389744
  43.                      Buffers: shared hit=116649
  44.                ->  Parallel Seq Scan on worker_activity_liquidity_maker_9  (cost=0.00..629843.52 rows=1 width=873) (actual time=37274.984..37274.985 rows=0 loops=3)
  45.                      Filter: ((created_at >= '2021-07-06 06:49:25'::timestamp without time zone) AND (created_at <= '2021-07-07 00:00:00'::timestamp without time zone) AND ((action = 'Start Work'::text) OR (action = 'End Work'::text)))
  46.                      Rows Removed by Filter: 1696199
  47.                      Buffers: shared hit=432 read=586992
  48.  Planning time: 0.919 ms
  49.  Execution time: 235571.830 ms
  50. (48 rows)
Advertisement
RAW Paste Data Copied
Advertisement