explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o9Xs

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 1,285,870.794 ↑ 1.0 10 1

Sort (cost=108,081,853.80..108,081,853.82 rows=10 width=76) (actual time=1,285,870.793..1,285,870.794 rows=10 loops=1)

  • Sort Key: (1), (0)
  • Sort Method: quicksort Memory: 26kB
2. 0.057 1,285,870.766 ↑ 1.0 10 1

HashAggregate (cost=108,081,853.53..108,081,853.63 rows=10 width=76) (actual time=1,285,870.762..1,285,870.766 rows=10 loops=1)

  • Group Key: (1), (0), ('product hierarchy'::text), "*SELECT* 1".verstat, "*SELECT* 1".cnt, (0), (0), (0), (0), "*SELECT* 1".minpid, "*SELECT* 1".maxpid
3. 0.017 1,285,870.709 ↑ 1.0 10 1

Append (cost=5,790.89..108,081,853.26 rows=10 width=76) (actual time=75.023..1,285,870.709 rows=10 loops=1)

4. 0.003 75.023 ↑ 1.0 1 1

Subquery Scan on *SELECT* 1 (cost=5,790.89..5,790.93 rows=1 width=76) (actual time=75.022..75.023 rows=1 loops=1)

5. 0.008 75.020 ↑ 1.0 1 1

Finalize GroupAggregate (cost=5,790.89..5,790.92 rows=1 width=76) (actual time=75.019..75.020 rows=1 loops=1)

  • Group Key: 1, 0, 'product hierarchy'::text, prodhier.verstat
6. 0.000 75.012 ↓ 2.0 2 1

Sort (cost=5,790.89..5,790.89 rows=1 width=60) (actual time=75.011..75.012 rows=2 loops=1)

  • Sort Key: prodhier.verstat
  • Sort Method: quicksort Memory: 25kB
7. 19.417 75.070 ↓ 2.0 2 1

Gather (cost=5,790.77..5,790.88 rows=1 width=60) (actual time=74.893..75.070 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
8. 22.485 55.653 ↑ 1.0 1 2

Partial HashAggregate (cost=4,790.77..4,790.78 rows=1 width=60) (actual time=55.652..55.653 rows=1 loops=2)

  • Group Key: 1, 0, 'product hierarchy'::text, prodhier.verstat
9. 33.168 33.168 ↑ 1.2 57,670 2

Parallel Seq Scan on prodhier (cost=0.00..3,603.46 rows=67,846 width=48) (actual time=0.457..33.168 rows=57,670 loops=2)

10. 0.002 25.966 ↑ 1.0 1 1

Subquery Scan on *SELECT* 2 (cost=5,186.59..5,186.64 rows=1 width=76) (actual time=25.966..25.966 rows=1 loops=1)

11. 0.008 25.964 ↑ 1.0 1 1

Finalize GroupAggregate (cost=5,186.59..5,186.63 rows=1 width=76) (actual time=25.964..25.964 rows=1 loops=1)

  • Group Key: 2, 1, 'acv_mkt'::text, acv_mkt.verstat
12. 0.003 25.956 ↓ 2.0 2 1

Sort (cost=5,186.59..5,186.60 rows=1 width=68) (actual time=25.955..25.956 rows=2 loops=1)

  • Sort Key: acv_mkt.verstat
  • Sort Method: quicksort Memory: 25kB
13. 3.125 25.953 ↓ 2.0 2 1

Gather (cost=5,186.47..5,186.58 rows=1 width=68) (actual time=25.827..25.953 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
14. 7.598 22.828 ↑ 1.0 1 2

Partial HashAggregate (cost=4,186.47..4,186.48 rows=1 width=68) (actual time=22.828..22.828 rows=1 loops=2)

  • Group Key: 2, 1, 'acv_mkt'::text, acv_mkt.verstat
15. 15.230 15.230 ↑ 5.4 17,396 2

Parallel Seq Scan on acv_mkt (cost=0.00..2,072.53 rows=93,953 width=52) (actual time=0.501..15.230 rows=17,396 loops=2)

16. 0.003 259.214 ↑ 1.0 1 1

Subquery Scan on *SELECT* 3 (cost=23,396.14..23,396.21 rows=1 width=76) (actual time=259.213..259.214 rows=1 loops=1)

17. 0.014 259.211 ↑ 1.0 1 1

Finalize GroupAggregate (cost=23,396.14..23,396.20 rows=1 width=76) (actual time=259.211..259.211 rows=1 loops=1)

  • Group Key: 2, 2, 'acv_rma'::text, acv_rma.verstat
18. 0.000 259.197 ↑ 1.0 2 1

Sort (cost=23,396.14..23,396.14 rows=2 width=68) (actual time=259.196..259.197 rows=2 loops=1)

  • Sort Key: acv_rma.verstat
  • Sort Method: quicksort Memory: 25kB
19. 3.260 259.213 ↑ 1.0 2 1

Gather (cost=23,395.92..23,396.13 rows=2 width=68) (actual time=259.002..259.213 rows=2 loops=1)

  • Workers Planned: 2
  • Workers Launched: 1
20. 65.912 255.953 ↑ 1.0 1 2

Partial HashAggregate (cost=22,395.92..22,395.93 rows=1 width=68) (actual time=255.952..255.953 rows=1 loops=2)

  • Group Key: 2, 2, 'acv_rma'::text, acv_rma.verstat
21. 190.041 190.041 ↑ 4.0 114,976 2

Parallel Seq Scan on acv_rma (cost=0.00..12,021.05 rows=461,105 width=52) (actual time=155.365..190.041 rows=114,976 loops=2)

22. 0.003 126.188 ↑ 1.0 1 1

Subquery Scan on *SELECT* 4 (cost=23,712.14..23,712.21 rows=1 width=76) (actual time=126.187..126.188 rows=1 loops=1)

23. 0.010 126.185 ↑ 1.0 1 1

Finalize GroupAggregate (cost=23,712.14..23,712.20 rows=1 width=76) (actual time=126.185..126.185 rows=1 loops=1)

  • Group Key: 2, 3, 'acv_crma'::text, acv_crma.verstat
24. 0.000 126.175 ↓ 1.5 3 1

Sort (cost=23,712.14..23,712.14 rows=2 width=68) (actual time=126.174..126.175 rows=3 loops=1)

  • Sort Key: acv_crma.verstat
  • Sort Method: quicksort Memory: 25kB
25. 5.381 126.175 ↓ 1.5 3 1

Gather (cost=23,711.92..23,712.13 rows=2 width=68) (actual time=125.860..126.175 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
26. 33.115 120.794 ↑ 1.0 1 3

Partial HashAggregate (cost=22,711.92..22,711.93 rows=1 width=68) (actual time=120.794..120.794 rows=1 loops=3)

  • Group Key: 2, 3, 'acv_crma'::text, acv_crma.verstat
27. 87.679 87.679 ↑ 6.0 76,651 3

Parallel Seq Scan on acv_crma (cost=0.00..12,337.05 rows=461,105 width=52) (actual time=69.211..87.679 rows=76,651 loops=3)

28. 0.003 71,939.126 ↑ 1.0 1 1

Subquery Scan on *SELECT* 5 (cost=5,363,057.21..5,363,057.29 rows=1 width=76) (actual time=71,939.125..71,939.126 rows=1 loops=1)

29. 0.010 71,939.123 ↑ 1.0 1 1

Finalize GroupAggregate (cost=5,363,057.21..5,363,057.28 rows=1 width=76) (actual time=71,939.123..71,939.123 rows=1 loops=1)

  • Group Key: 3, 1, 'sales_mkt'::text, sales_mkt.verstat
30. 0.000 71,939.113 ↑ 1.0 2 1

Sort (cost=5,363,057.21..5,363,057.22 rows=2 width=76) (actual time=71,939.113..71,939.113 rows=2 loops=1)

  • Sort Key: sales_mkt.verstat
  • Sort Method: quicksort Memory: 25kB
31. 2.947 71,939.135 ↑ 1.0 2 1

Gather (cost=5,363,056.99..5,363,057.20 rows=2 width=76) (actual time=71,938.968..71,939.135 rows=2 loops=1)

  • Workers Planned: 2
  • Workers Launched: 1
32. 39,381.427 71,936.188 ↑ 1.0 1 2

Partial HashAggregate (cost=5,362,056.99..5,362,057.00 rows=1 width=76) (actual time=71,936.188..71,936.188 rows=1 loops=2)

  • Group Key: 3, 1, 'sales_mkt'::text, sales_mkt.verstat
33. 32,554.761 32,554.761 ↓ 1.2 78,383,118 2

Parallel Seq Scan on sales_mkt (cost=0.00..3,565,612.53 rows=65,325,253 width=56) (actual time=0.262..32,554.761 rows=78,383,118 loops=2)

34. 0.004 107,184.065 ↑ 1.0 1 1

Subquery Scan on *SELECT* 6 (cost=10,527,879.72..10,527,879.80 rows=1 width=76) (actual time=107,184.064..107,184.065 rows=1 loops=1)

35. 0.011 107,184.061 ↑ 1.0 1 1

Finalize GroupAggregate (cost=10,527,879.72..10,527,879.79 rows=1 width=76) (actual time=107,184.061..107,184.061 rows=1 loops=1)

  • Group Key: 3, 2, 'sales_rma'::text, sales_rma.verstat
36. 0.000 107,184.050 ↓ 1.5 3 1

Sort (cost=10,527,879.72..10,527,879.72 rows=2 width=76) (actual time=107,184.049..107,184.050 rows=3 loops=1)

  • Sort Key: sales_rma.verstat
  • Sort Method: quicksort Memory: 25kB
37. 3.577 107,184.050 ↓ 1.5 3 1

Gather (cost=10,527,879.50..10,527,879.71 rows=2 width=76) (actual time=107,183.882..107,184.050 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
38. 53,933.818 107,180.473 ↑ 1.0 1 3

Partial HashAggregate (cost=10,526,879.50..10,526,879.51 rows=1 width=76) (actual time=107,180.473..107,180.473 rows=1 loops=3)

  • Group Key: 3, 2, 'sales_rma'::text, sales_rma.verstat
39. 53,246.655 53,246.655 ↑ 1.3 103,463,862 3

Parallel Seq Scan on sales_rma (cost=0.00..6,969,969.00 rows=129,342,200 width=56) (actual time=0.619..53,246.655 rows=103,463,862 loops=3)

40. 0.008 449,355.295 ↑ 1.0 1 1

Subquery Scan on *SELECT* 7 (cost=34,128,739.22..34,128,739.30 rows=1 width=76) (actual time=449,355.294..449,355.295 rows=1 loops=1)

41. 0.011 449,355.287 ↑ 1.0 1 1

Finalize GroupAggregate (cost=34,128,739.22..34,128,739.29 rows=1 width=76) (actual time=449,355.287..449,355.287 rows=1 loops=1)

  • Group Key: 3, 3, 'sales_crma'::text, sales_crma.verstat
42. 0.000 449,355.276 ↑ 1.0 2 1

Sort (cost=34,128,739.22..34,128,739.23 rows=2 width=76) (actual time=449,355.275..449,355.276 rows=2 loops=1)

  • Sort Key: sales_crma.verstat
  • Sort Method: quicksort Memory: 25kB
43. 5.497 449,355.287 ↑ 1.0 2 1

Gather (cost=34,128,739.00..34,128,739.21 rows=2 width=76) (actual time=449,353.337..449,355.287 rows=2 loops=1)

  • Workers Planned: 2
  • Workers Launched: 1
44. 241,405.214 449,349.790 ↑ 1.0 1 2

Partial HashAggregate (cost=34,127,739.00..34,127,739.01 rows=1 width=76) (actual time=449,349.789..449,349.790 rows=1 loops=2)

  • Group Key: 3, 3, 'sales_crma'::text, sales_crma.verstat
45. 207,944.576 207,944.576 ↓ 1.2 483,569,459 2

Parallel Seq Scan on sales_crma (cost=0.00..23,044,433.80 rows=403,029,280 width=56) (actual time=156.196..207,944.576 rows=483,569,459 loops=2)

46. 0.003 78,306.360 ↑ 1.0 1 1

Subquery Scan on *SELECT* 8 (cost=7,276,279.21..7,276,279.29 rows=1 width=76) (actual time=78,306.358..78,306.360 rows=1 loops=1)

47. 0.011 78,306.357 ↑ 1.0 1 1

Finalize GroupAggregate (cost=7,276,279.21..7,276,279.28 rows=1 width=76) (actual time=78,306.357..78,306.357 rows=1 loops=1)

  • Group Key: 4, 1, 'dist_mkt'::text, dist_mkt.verstat
48. 0.005 78,306.346 ↓ 1.5 3 1

Sort (cost=7,276,279.21..7,276,279.22 rows=2 width=76) (actual time=78,306.345..78,306.346 rows=3 loops=1)

  • Sort Key: dist_mkt.verstat
  • Sort Method: quicksort Memory: 25kB
49. 14.993 78,306.341 ↓ 1.5 3 1

Gather (cost=7,276,278.99..7,276,279.20 rows=2 width=76) (actual time=78,304.005..78,306.341 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
50. 49,010.149 78,291.348 ↑ 1.0 1 3

Partial HashAggregate (cost=7,275,278.99..7,275,279.00 rows=1 width=76) (actual time=78,291.348..78,291.348 rows=1 loops=3)

  • Group Key: 4, 1, 'dist_mkt'::text, dist_mkt.verstat
51. 29,281.199 29,281.199 ↑ 1.3 100,586,135 3

Parallel Seq Scan on dist_mkt (cost=0.00..3,817,524.33 rows=125,736,533 width=56) (actual time=0.577..29,281.199 rows=100,586,135 loops=3)

52. 0.002 115,950.474 ↑ 1.0 1 1

Subquery Scan on *SELECT* 9 (cost=7,584,776.21..7,584,776.29 rows=1 width=76) (actual time=115,950.473..115,950.474 rows=1 loops=1)

53. 0.011 115,950.472 ↑ 1.0 1 1

Finalize GroupAggregate (cost=7,584,776.21..7,584,776.28 rows=1 width=76) (actual time=115,950.472..115,950.472 rows=1 loops=1)

  • Group Key: 4, 2, 'dist_rma'::text, dist_rma.verstat
54. 0.000 115,950.461 ↑ 1.0 2 1

Sort (cost=7,584,776.21..7,584,776.22 rows=2 width=76) (actual time=115,950.460..115,950.461 rows=2 loops=1)

  • Sort Key: dist_rma.verstat
  • Sort Method: quicksort Memory: 25kB
55. 4.148 115,950.471 ↑ 1.0 2 1

Gather (cost=7,584,775.99..7,584,776.20 rows=2 width=76) (actual time=115,950.296..115,950.471 rows=2 loops=1)

  • Workers Planned: 2
  • Workers Launched: 1
56. 75,292.784 115,946.323 ↑ 1.0 1 2

Partial HashAggregate (cost=7,583,775.99..7,583,776.00 rows=1 width=76) (actual time=115,946.322..115,946.323 rows=1 loops=2)

  • Group Key: 4, 2, 'dist_rma'::text, dist_rma.verstat
57. 40,653.539 40,653.539 ↓ 1.2 155,024,607 2

Parallel Seq Scan on dist_rma (cost=0.00..4,032,706.13 rows=129,129,813 width=56) (actual time=0.747..40,653.539 rows=155,024,607 loops=2)

58. 0.003 462,648.981 ↑ 1.0 1 1

Subquery Scan on *SELECT* 10 (cost=43,143,035.22..43,143,035.30 rows=1 width=76) (actual time=462,648.980..462,648.981 rows=1 loops=1)

59. 0.012 462,648.978 ↑ 1.0 1 1

Finalize GroupAggregate (cost=43,143,035.22..43,143,035.29 rows=1 width=76) (actual time=462,648.978..462,648.978 rows=1 loops=1)

  • Group Key: 4, 3, 'dist_crma'::text, dist_crma.verstat
60. 0.000 462,648.966 ↓ 1.5 3 1

Sort (cost=43,143,035.22..43,143,035.23 rows=2 width=76) (actual time=462,648.966..462,648.966 rows=3 loops=1)

  • Sort Key: dist_crma.verstat
  • Sort Method: quicksort Memory: 25kB
61. 7.439 462,652.321 ↓ 1.5 3 1

Gather (cost=43,143,035.00..43,143,035.21 rows=2 width=76) (actual time=462,648.812..462,652.321 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
62. 287,340.009 462,644.882 ↑ 1.0 1 3

Partial HashAggregate (cost=43,142,035.00..43,142,035.01 rows=1 width=76) (actual time=462,644.882..462,644.882 rows=1 loops=3)

  • Group Key: 4, 3, 'dist_crma'::text, dist_crma.verstat
63. 175,304.873 175,304.873 ↑ 1.2 586,657,705 3

Parallel Seq Scan on dist_crma (cost=0.00..22,983,448.20 rows=733,039,520 width=56) (actual time=1.557..175,304.873 rows=586,657,705 loops=3)