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

Aggregate (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)

  • Buffers: shared hit=385418, temp read=86218 written=86235
2. 0.000 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)

  • Buffers: shared hit=1936133, temp read=433467 written=433554
3. 14,022.215 133,745.850 ↑ 1.1 2,713,715 5

Aggregate (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)

  • Buffers: shared hit=1936133, temp read=433467 written=433554
4. 104,858.500 119,723.635 ↑ 1.2 5,867,563 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: 689744kB
  • Buffers: shared hit=1936133, temp read=433467 written=433554
5. 2,252.155 14,865.135 ↑ 1.2 5,867,563 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=1936017
6. 419.655 419.655 ↑ 1.2 201,734 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 = 35636895) AND (metric_id = 52))
  • Buffers: shared hit=62606
7. 1,024.275 1,024.275 ↑ 1.3 497,814 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 = 35636895) AND (metric_id = 52))
  • Buffers: shared hit=155449
8. 1,296.745 1,296.745 ↑ 1.2 631,377 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 = 35636895) AND (metric_id = 52))
  • Buffers: shared hit=194791
9. 1,503.135 1,503.135 ↑ 1.2 677,271 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 = 35636895) AND (metric_id = 52))
  • Buffers: shared hit=237044
10. 3,351.485 3,351.485 ↑ 1.2 1,514,117 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 = 35636895) AND (metric_id = 52))
  • Buffers: shared hit=523858
11. 5,017.685 5,017.685 ↑ 1.2 2,345,250 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 = 35636895) AND (metric_id = 52))
  • Buffers: shared hit=762269
Planning time : 0.608 ms
Execution time : 48,809.086 ms