explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R0vS

Settings
# exclusive inclusive rows x rows loops node
1. 8,623.358 48,349.474 ↓ 2.1 6,205,056 1

GroupAggregate (cost=3,608,560.36..5,252,264.79 rows=2,901,823 width=126) (actual time=18,795.722..48,349.474 rows=6,205,056 loops=1)

  • Group Key: alg_86400_collaboration_2018_1.employee, alg_86400_collaboration_2018_1.coattendee
  • Buffers: shared hit=385,418, temp read=86,218 written=86,235
2. 12,976.946 39,726.116 ↓ 1.2 13,568,574 1

Gather Merge (cost=3,608,560.36..5,099,919.08 rows=11,607,292 width=126) (actual time=18,795.711..39,726.116 rows=13,568,574 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=1,936,133, temp read=433,467 written=433,554
3. 2,804.443 26,749.170 ↑ 1.1 2,713,715 5 / 5

GroupAggregate (cost=3,607,560.3..3,716,378.65 rows=2,901,823 width=126) (actual time=18,629.574..26,749.17 rows=2,713,715 loops=5)

  • Group Key: alg_86400_collaboration_2018_1.employee, alg_86400_collaboration_2018_1.coattendee
  • Buffers: shared hit=1,936,133, temp read=433,467 written=433,554
4. 20,971.700 23,944.727 ↑ 1.2 5,867,563 5 / 5

Sort (cost=3,607,560.3..3,625,696.69 rows=7,254,556 width=101) (actual time=18,629.562..23,944.727 rows=5,867,563 loops=5)

  • Sort Key: alg_86400_collaboration_2018_1.employee, alg_86400_collaboration_2018_1.coattendee
  • Sort Method: external merge Disk: 689,744kB
  • Buffers: shared hit=1,936,133, temp read=433,467 written=433,554
5. 450.431 2,973.027 ↑ 1.2 5,867,563 5 / 5

Append (cost=0..2,384,151.6 rows=7,254,556 width=101) (actual time=0.008..2,973.027 rows=5,867,563 loops=5)

  • Buffers: shared hit=1,936,017
6. 83.931 83.931 ↑ 1.2 201,734 5 / 5

Seq Scan on alg_86400_collaboration_2018_1 alg_86400_collaboration_2018_1 (cost=0..77,159.21 rows=252,140 width=99) (actual time=0.007..83.931 rows=201,734 loops=5)

  • Filter: ((NOT is_grouped) AND (cdate >= '2018-01-01 00:00:00'::timestamp without time zone) AND (cdate <= '2018-06-30 00:00:00'::timestamp without time zone) AND (company_id = 35,636,895) AND (metric_id = 52))
  • Buffers: shared hit=62,606
7. 204.855 204.855 ↑ 1.3 497,814 5 / 5

Seq Scan on alg_86400_collaboration_2018_2 alg_86400_collaboration_2018_2 (cost=0..191,748.86 rows=622,518 width=99) (actual time=0.005..204.855 rows=497,814 loops=5)

  • Filter: ((NOT is_grouped) AND (cdate >= '2018-01-01 00:00:00'::timestamp without time zone) AND (cdate <= '2018-06-30 00:00:00'::timestamp without time zone) AND (company_id = 35,636,895) AND (metric_id = 52))
  • Buffers: shared hit=155,449
8. 259.349 259.349 ↑ 1.2 631,377 5 / 5

Seq Scan on alg_86400_collaboration_2018_3 alg_86400_collaboration_2018_3 (cost=0..239,929.2 rows=789,008 width=100) (actual time=0.032..259.349 rows=631,377 loops=5)

  • Filter: ((NOT is_grouped) AND (cdate >= '2018-01-01 00:00:00'::timestamp without time zone) AND (cdate <= '2018-06-30 00:00:00'::timestamp without time zone) AND (company_id = 35,636,895) AND (metric_id = 52))
  • Buffers: shared hit=194,791
9. 300.627 300.627 ↑ 1.2 677,271 5 / 5

Seq Scan on alg_86400_collaboration_2018_4 alg_86400_collaboration_2018_4 (cost=0..291,895.03 rows=839,117 width=101) (actual time=0.224..300.627 rows=677,271 loops=5)

  • Filter: ((NOT is_grouped) AND (cdate >= '2018-01-01 00:00:00'::timestamp without time zone) AND (cdate <= '2018-06-30 00:00:00'::timestamp without time zone) AND (company_id = 35,636,895) AND (metric_id = 52))
  • Buffers: shared hit=237,044
10. 670.297 670.297 ↑ 1.2 1,514,117 5 / 5

Seq Scan on alg_86400_collaboration_2018_5 alg_86400_collaboration_2018_5 (cost=0..644,503.64 rows=1,847,332 width=102) (actual time=31.629..670.297 rows=1,514,117 loops=5)

  • Filter: ((NOT is_grouped) AND (cdate >= '2018-01-01 00:00:00'::timestamp without time zone) AND (cdate <= '2018-06-30 00:00:00'::timestamp without time zone) AND (company_id = 35,636,895) AND (metric_id = 52))
  • Buffers: shared hit=523,858
11. 1,003.537 1,003.537 ↑ 1.2 2,345,250 5 / 5

Seq Scan on alg_86400_collaboration_2018_6 alg_86400_collaboration_2018_6 (cost=0..938,915.66 rows=2,904,441 width=101) (actual time=0.088..1,003.537 rows=2,345,250 loops=5)

  • Filter: ((NOT is_grouped) AND (cdate >= '2018-01-01 00:00:00'::timestamp without time zone) AND (cdate <= '2018-06-30 00:00:00'::timestamp without time zone) AND (company_id = 35,636,895) AND (metric_id = 52))
  • Buffers: shared hit=762,269
Planning time : 0.608 ms
Execution time : 48,809.086 ms