explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cara

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 308,758.897 ↑ 104,178.0 7 1

Finalize GroupAggregate (cost=3,537,366.60..4,272,419.30 rows=729,246 width=12) (actual time=307,859.624..308,758.897 rows=7 loops=1)

  • Group Key: (date(date_trunc('month'::text, to_timestamp((tracking_point_2020_2."timestamp")::double precision))))
  • Functions: 315
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 32.738 ms, Inlining 128.962 ms, Optimization 1735.739 ms, Emission 985.284 ms, Total 2882.724 ms
2. 5,987.212 312,002.293 ↑ 510,472.2 10 1

Gather Merge (cost=3,537,366.60..4,232,310.77 rows=5,104,722 width=12) (actual time=307,349.708..312,002.293 rows=10 loops=1)

  • Workers Planned: 7
  • Workers Launched: 2
3. 947.970 306,015.081 ↑ 243,082.0 3 3 / 3

Partial GroupAggregate (cost=3,536,366.48..3,605,982.21 rows=729,246 width=12) (actual time=305,139.416..306,015.081 rows=3 loops=3)

  • Group Key: (date(date_trunc('month'::text, to_timestamp((tracking_point_2020_2."timestamp")::double precision))))
4. 46,660.456 305,067.111 ↓ 2.3 17,117,464 3 / 3

Sort (cost=3,536,366.48..3,554,710.08 rows=7,337,441 width=4) (actual time=303,453.094..305,067.111 rows=17,117,464 loops=3)

  • Sort Key: (date(date_trunc('month'::text, to_timestamp((tracking_point_2020_2."timestamp")::double precision))))
  • Sort Method: external merge Disk: 158,888kB
  • Worker 0: Sort Method: external merge Disk: 277,768kB
  • Worker 1: Sort Method: external merge Disk: 267,016kB
5. 1,854.757 258,406.655 ↓ 2.3 17,117,464 3 / 3

Parallel Append (cost=0.00..2,640,889.96 rows=7,337,441 width=4) (actual time=1,285.675..258,406.655 rows=17,117,464 loops=3)

6. 70,491.843 70,491.843 ↓ 7.0 19,374,890 1 / 3

Parallel Seq Scan on tracking_point_2020_2 (cost=0.00..1,079,374.13 rows=2,768,628 width=4) (actual time=1,467.758..211,475.529 rows=19,374,890 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
7. 47,212.881 47,212.881 ↓ 6.0 12,302,634 1 / 3

Parallel Seq Scan on tracking_point_2020_3 (cost=0.00..639,099.65 rows=2,050,562 width=4) (actual time=956.863..141,638.643 rows=12,302,634 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
8. 36,231.452 36,231.452 ↓ 2.0 2,431,826 3 / 3

Parallel Seq Scan on tracking_point_2020_5 (cost=0.00..325,667.78 rows=1,216,168 width=4) (actual time=1.510..36,231.452 rows=2,431,826 loops=3)

  • Filter: ("timestamp" >= 1,577,836,800)
9. 25,748.736 25,748.736 ↓ 2.5 2,047,306 2 / 3

Parallel Seq Scan on tracking_point_2020_4 (cost=0.00..199,253.19 rows=818,764 width=4) (actual time=9.741..38,623.104 rows=2,047,306 loops=2)

  • Filter: ("timestamp" >= 1,577,836,800)
10. 25,151.821 25,151.821 ↓ 5.0 3,548,135 1 / 3

Parallel Seq Scan on tracking_point_2020_7 (cost=0.00..146,390.45 rows=709,842 width=4) (actual time=17.864..75,455.463 rows=3,548,135 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
11. 21,320.797 21,320.797 ↓ 5.0 2,880,301 1 / 3

Parallel Seq Scan on tracking_point_2020_6 (cost=0.00..128,759.35 rows=576,060 width=4) (actual time=1.998..63,962.392 rows=2,880,301 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
12. 30,394.367 30,394.367 ↓ 4.0 1,856,343 1 / 3

Parallel Seq Scan on tracking_point_2020_1 (cost=0.00..85,432.93 rows=464,086 width=4) (actual time=1,432.393..91,183.101 rows=1,856,343 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
13. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2020_8 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
14. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2020_9 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
15. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2020_10 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
16. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2020_11 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
17. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2020_12 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
18. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2021_1 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
19. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2021_2 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
20. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2021_3 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
21. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2021_4 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
22. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2021_5 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
23. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2021_6 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
24. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2021_7 (cost=0.00..12.52 rows=53 width=4) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
25. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2021_8 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
26. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2021_9 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
27. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2021_10 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
28. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2021_11 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
29. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_2021_12 (cost=0.00..12.52 rows=53 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
30. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on tracking_point_def (cost=0.00..12.52 rows=53 width=4) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ("timestamp" >= 1,577,836,800)
Execution time : 312,047.175 ms