explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lp9B

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,189,712.32..1,190,750.63 rows=200 width=48) (actual rows= loops=)

  • Group Key: s.sample_hour
2. 0.000 0.000 ↓ 0.0

Sort (cost=1,189,712.32..1,189,756.86 rows=17,814 width=92) (actual rows= loops=)

  • Sort Key: s.sample_hour
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=39,762.32..1,188,454.59 rows=17,814 width=92) (actual rows= loops=)

  • Hash Cond: (s.id = nin2.sample_id)
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=37,242.94..1,185,888.44 rows=17,814 width=96) (actual rows= loops=)

  • Hash Cond: (s.id = norig2.sample_id)
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=34,309.97..1,182,908.71 rows=17,814 width=92) (actual rows= loops=)

  • Hash Cond: (s.id = norig.sample_id)
6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=31,377.00..1,179,928.98 rows=17,814 width=88) (actual rows= loops=)

  • Hash Cond: (s.id = nin.sample_id)
7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=28,857.70..1,177,362.92 rows=17,814 width=84) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=28,857.26..1,042,053.55 rows=17,814 width=80) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=28,856.83..906,744.18 rows=17,814 width=76) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=28,856.39..771,430.81 rows=17,814 width=72) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=28,855.95..636,117.44 rows=17,814 width=68) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=28,855.39..492,056.79 rows=17,814 width=64) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=28,854.82..347,996.13 rows=17,814 width=60) (actual rows= loops=)

  • Hash Cond: (s.id = inefdeny.sample_id)
14. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=26,545.89..345,640.43 rows=17,814 width=56) (actual rows= loops=)

  • Hash Cond: (s.id = ccbovfl.sample_id)
15. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=24,235.98..343,283.76 rows=17,814 width=52) (actual rows= loops=)

  • Hash Cond: (s.id = cploovfl.sample_id)
16. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=21,926.06..340,927.09 rows=17,814 width=48) (actual rows= loops=)

  • Hash Cond: (s.id = origdeny.sample_id)
17. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=19,616.15..338,570.41 rows=17,814 width=44) (actual rows= loops=)

  • Hash Cond: (s.id = tcmvact.sample_id)
18. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=17,366.59..336,274.09 rows=17,814 width=40) (actual rows= loops=)

  • Hash Cond: (s.id = trsgnct.sample_id)
19. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=14,579.66..333,440.40 rows=17,814 width=36) (actual rows= loops=)

  • Hash Cond: (s.id = trsncrt.sample_id)
20. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=11,786.65..330,600.62 rows=17,814 width=32) (actual rows= loops=)

  • Hash Cond: (s.id = cintegfl.sample_id)
21. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=8,817.17..327,584.38 rows=17,814 width=28) (actual rows= loops=)

  • Hash Cond: (s.id = trmmfl.sample_id)
22. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5,884.20..324,604.65 rows=17,814 width=24) (actual rows= loops=)

  • Hash Cond: (s.id = inlkt.sample_id)
23. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2,932.97..321,606.66 rows=17,814 width=20) (actual rows= loops=)

  • Hash Cond: (s.id = origlkt.sample_id)
24. 0.000 0.000 ↓ 0.0

Append (cost=0.00..318,626.93 rows=17,814 width=16) (actual rows= loops=)

  • Subplans Removed: 4
25. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sample_2019_09_omajnevqds0 s (cost=23,506.84..96,504.28 rows=5,451 width=16) (actual rows= loops=)

  • Recheck Cond: (sample_hour >= (now() - '7 days'::interval))
  • Filter: ((switch_name)::text = 'OMAJNEVQDS0'::text)
26. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sample_2019_09_omajnevqds0_sample_hour_idx (cost=0.00..23,505.47 rows=1,090,272 width=0) (actual rows= loops=)

  • Index Cond: (sample_hour >= (now() - '7 days'::interval))
27. 0.000 0.000 ↓ 0.0

Hash (cost=1,571.32..1,571.32 rows=108,932 width=8) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on reg_origlkt origlkt (cost=0.00..1,571.32 rows=108,932 width=8) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Hash (cost=1,581.10..1,581.10 rows=109,610 width=8) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Seq Scan on reg_inlkt inlkt (cost=0.00..1,581.10 rows=109,610 width=8) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Hash (cost=1,571.32..1,571.32 rows=108,932 width=8) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Seq Scan on reg_trmmfl trmmfl (cost=0.00..1,571.32 rows=108,932 width=8) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Hash (cost=1,590.88..1,590.88 rows=110,288 width=8) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Seq Scan on reg_cintegfl cintegfl (cost=0.00..1,590.88 rows=110,288 width=8) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Hash (cost=1,496.34..1,496.34 rows=103,734 width=8) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Seq Scan on reg_trsncrt trsncrt (cost=0.00..1,496.34 rows=103,734 width=8) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Hash (cost=1,493.08..1,493.08 rows=103,508 width=8) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Seq Scan on reg_trsgnct trsgnct (cost=0.00..1,493.08 rows=103,508 width=8) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Hash (cost=1,245.36..1,245.36 rows=80,336 width=8) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Seq Scan on reg_tcmvact tcmvact (cost=0.00..1,245.36 rows=80,336 width=8) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Hash (cost=1,253.85..1,253.85 rows=84,485 width=8) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Seq Scan on reg_origdeny origdeny (cost=0.00..1,253.85 rows=84,485 width=8) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Hash (cost=1,253.85..1,253.85 rows=84,485 width=8) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Seq Scan on reg_cploovfl cploovfl (cost=0.00..1,253.85 rows=84,485 width=8) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Hash (cost=1,253.85..1,253.85 rows=84,485 width=8) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Seq Scan on reg_ccbovfl ccbovfl (cost=0.00..1,253.85 rows=84,485 width=8) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Hash (cost=1,252.86..1,252.86 rows=84,486 width=8) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Seq Scan on reg_inefdeny inefdeny (cost=0.00..1,252.86 rows=84,486 width=8) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Index Scan using reg_infail_pkey on reg_infail infail (cost=0.56..8.09 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (s.id = sample_id)
50. 0.000 0.000 ↓ 0.0

Index Scan using reg_outfail_pkey on reg_outfail outfail (cost=0.56..8.09 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (s.id = sample_id)
51. 0.000 0.000 ↓ 0.0

Index Scan using reg_perclfl_pkey on reg_perclfl perclfl (cost=0.44..7.60 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (s.id = sample_id)
52. 0.000 0.000 ↓ 0.0

Index Scan using reg_origfail_pkey on reg_origfail origfail (cost=0.44..7.60 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (s.id = sample_id)
53. 0.000 0.000 ↓ 0.0

Index Scan using reg_origblk_pkey on reg_origblk origblk (cost=0.44..7.60 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (s.id = sample_id)
54. 0.000 0.000 ↓ 0.0

Index Scan using reg_termblk_pkey on reg_termblk termblk (cost=0.44..7.60 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (s.id = sample_id)
55. 0.000 0.000 ↓ 0.0

Hash (cost=1,388.02..1,388.02 rows=90,502 width=8) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Seq Scan on reg_nin nin (cost=0.00..1,388.02 rows=90,502 width=8) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Hash (cost=1,571.32..1,571.32 rows=108,932 width=8) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Seq Scan on reg_norig norig (cost=0.00..1,571.32 rows=108,932 width=8) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Hash (cost=1,571.32..1,571.32 rows=108,932 width=8) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Seq Scan on reg_norig2 norig2 (cost=0.00..1,571.32 rows=108,932 width=8) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Hash (cost=1,388.06..1,388.06 rows=90,506 width=8) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Seq Scan on reg_nin2 nin2 (cost=0.00..1,388.06 rows=90,506 width=8) (actual rows= loops=)