explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Auo

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

Hash Left Join (cost=14,841.30..24,684.71 rows=286 width=5,342) (actual rows= loops=)

  • Hash Cond: (prodofrprc9_.st_id = gnlstentit15_.gnl_st_id)
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=14,828.15..24,659.04 rows=286 width=5,256) (actual rows= loops=)

  • Hash Cond: (prodofrprc9_.prc_chrg_tp_id = prcchrgtpe14_.prc_chrg_tp_id)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=14,827.08..24,654.04 rows=286 width=5,021) (actual rows= loops=)

  • Hash Cond: (prodofrprc9_.prc_chrg_tp_dur_uom_id = unitofmsrm13_.unit_of_msrmt_id)
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=14,825.58..24,651.46 rows=286 width=4,806) (actual rows= loops=)

  • Hash Cond: (prodofrprc9_.prc_calc_tp_id = gnltpentit12_.gnl_tp_id)
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=14,808.36..24,630.30 rows=286 width=4,709) (actual rows= loops=)

  • Hash Cond: (prodofrprc9_.pymnt_tp_id = gnltpentit11_.gnl_tp_id)
6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=14,791.13..24,609.51 rows=286 width=4,612) (actual rows= loops=)

  • Hash Cond: (prodofrprc9_.cur_id = curentity10_.cur_id)
7. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=14,790.09..24,604.53 rows=286 width=3,924) (actual rows= loops=)

  • Hash Cond: (prod_prc.prod_ofr_prc_id = prodofrprc9_.prod_ofr_prc_id)
8. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=14,707.47..24,517.97 rows=286 width=3,805) (actual rows= loops=)

  • Hash Cond: (prod_2.st_id = gnlstentit4_.gnl_st_id)
9. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=14,694.31..24,500.89 rows=286 width=3,719) (actual rows= loops=)

  • Hash Cond: (prod_2.tax_geo_plc_id = geoplcenti5_.geo_plc_id)
10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=14,652.55..24,455.19 rows=286 width=3,351) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=14,650.98..22,840.87 rows=286 width=1,762) (actual rows= loops=)

  • Hash Cond: (prod_1.end_user_st_id = gnlstentit2_.gnl_st_id)
12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=14,637.82..22,826.58 rows=286 width=1,676) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash Join (cost=14,636.25..21,208.64 rows=283 width=87) (actual rows= loops=)

  • Hash Cond: (prod_prc.st_id = gnl_st.gnl_st_id)
14. 0.000 0.000 ↓ 0.0

Hash Join (cost=14,624.90..21,190.15 rows=1,152 width=94) (actual rows= loops=)

  • Hash Cond: (prod_prc.prod_id = prod.prod_id)
15. 0.000 0.000 ↓ 0.0

Seq Scan on prod_prc (cost=0.00..5,689.80 rows=230,380 width=76) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Hash (cost=14,602.75..14,602.75 rows=1,772 width=18) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on prod (cost=0.00..14,602.75 rows=1,772 width=18) (actual rows= loops=)

  • Filter: (CASE WHEN (prnt_prod_id IS NOT NULL) THEN prnt_prod_id ELSE prod_id END = '222222'::numeric)
18. 0.000 0.000 ↓ 0.0

Hash (cost=10.37..10.37 rows=78 width=5) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on gnl_st (cost=0.00..10.37 rows=78 width=5) (actual rows= loops=)

  • Filter: ((shrt_code)::text = ANY ('{PNDG_ACTV,ACTV,PNDG_CNCL}'::text[]))
20. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.57..5.71 rows=1 width=1,589) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.28..1.95 rows=1 width=1,558) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.14..1.78 rows=1 width=1,551) (actual rows= loops=)

  • Join Filter: (gnl_st_1.gnl_st_id = gnl_st_lang.gnl_st_id)
23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..1.41 rows=1 width=1,521) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..1.23 rows=1 width=1,516) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..0.82 rows=1 width=1,513) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Index Scan using pk_prod on prod prod_1 (cost=0.42..0.65 rows=1 width=1,508) (actual rows= loops=)

  • Index Cond: (prod_prc.prod_id = prod_id)
27. 0.000 0.000 ↓ 0.0

Index Scan using prod_ofr_pkey on prod_ofr (cost=0.14..0.16 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (prod_ofr_id = prod_1.prod_ofr_id)
28. 0.000 0.000 ↓ 0.0

Index Scan using gnl_tp_pkey on gnl_tp (cost=0.15..0.40 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (gnl_tp_id = prod_ofr.prod_ofr_tp_id)
29. 0.000 0.000 ↓ 0.0

Index Scan using gnl_st_pkey on gnl_st gnl_st_1 (cost=0.15..0.17 rows=1 width=5) (actual rows= loops=)

  • Index Cond: (gnl_st_id = prod_1.st_id)
  • Filter: ((shrt_code)::text = ANY ('{PHANTOM,SPND,QUOTE,ACTV,PNDG,CNCL}'::text[]))
30. 0.000 0.000 ↓ 0.0

Index Scan using idx_gnl_st_lang_gnl_st_id on gnl_st_lang (cost=0.28..0.33 rows=3 width=20) (actual rows= loops=)

  • Index Cond: (gnl_st_id = prod_1.st_id)
31. 0.000 0.000 ↓ 0.0

Index Scan using pk_end_user on end_user (cost=0.15..0.17 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (prod_1.end_user_id = end_user_id)
32. 0.000 0.000 ↓ 0.0

Index Scan using pk_party on party (cost=0.29..3.74 rows=1 width=260) (actual rows= loops=)

  • Index Cond: (end_user.party_id = party_id)
33. 0.000 0.000 ↓ 0.0

Hash (cost=9.18..9.18 rows=318 width=86) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Seq Scan on gnl_st gnlstentit2_ (cost=0.00..9.18 rows=318 width=86) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.57..5.63 rows=1 width=1,589) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.28..1.88 rows=1 width=1,558) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.14..1.71 rows=1 width=1,551) (actual rows= loops=)

  • Join Filter: (gnl_st_2.gnl_st_id = gnl_st_lang_1.gnl_st_id)
38. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..1.34 rows=1 width=1,521) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..1.16 rows=1 width=1,516) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..0.75 rows=1 width=1,513) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Index Scan using pk_prod on prod prod_2 (cost=0.42..0.57 rows=1 width=1,508) (actual rows= loops=)

  • Index Cond: (prod_1.prnt_prod_id = prod_id)
42. 0.000 0.000 ↓ 0.0

Index Scan using prod_ofr_pkey on prod_ofr prod_ofr_1 (cost=0.14..0.16 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (prod_ofr_id = prod_2.prod_ofr_id)
43. 0.000 0.000 ↓ 0.0

Index Scan using gnl_tp_pkey on gnl_tp gnl_tp_1 (cost=0.15..0.40 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (gnl_tp_id = prod_ofr_1.prod_ofr_tp_id)
44. 0.000 0.000 ↓ 0.0

Index Scan using gnl_st_pkey on gnl_st gnl_st_2 (cost=0.15..0.17 rows=1 width=5) (actual rows= loops=)

  • Index Cond: (gnl_st_id = prod_2.st_id)
  • Filter: ((shrt_code)::text = ANY ('{PHANTOM,SPND,QUOTE,ACTV,PNDG,CNCL}'::text[]))
45. 0.000 0.000 ↓ 0.0

Index Scan using idx_gnl_st_lang_gnl_st_id on gnl_st_lang gnl_st_lang_1 (cost=0.28..0.33 rows=3 width=20) (actual rows= loops=)

  • Index Cond: (gnl_st_id = prod_2.st_id)
46. 0.000 0.000 ↓ 0.0

Index Scan using pk_end_user on end_user end_user_1 (cost=0.15..0.17 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (prod_2.end_user_id = end_user_id)
47. 0.000 0.000 ↓ 0.0

Index Scan using pk_party on party party_1 (cost=0.29..3.74 rows=1 width=260) (actual rows= loops=)

  • Index Cond: (end_user_1.party_id = party_id)
48. 0.000 0.000 ↓ 0.0

Hash (cost=41.72..41.72 rows=3 width=368) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=27.03..41.72 rows=3 width=368) (actual rows= loops=)

  • Hash Cond: (gnltpentit7_.gnl_tp_id = geoplcenti5_.geo_plc_tp_id)
50. 0.000 0.000 ↓ 0.0

Seq Scan on gnl_tp gnltpentit7_ (cost=0.00..12.10 rows=410 width=97) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Hash (cost=26.99..26.99 rows=3 width=271) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=12.30..26.99 rows=3 width=271) (actual rows= loops=)

  • Hash Cond: (gnltpentit6_.gnl_tp_id = geoplcenti5_.geo_plc_hierc_tp_id)
53. 0.000 0.000 ↓ 0.0

Seq Scan on gnl_tp gnltpentit6_ (cost=0.00..12.10 rows=410 width=97) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Hash (cost=12.27..12.27 rows=3 width=174) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=1.07..12.27 rows=3 width=174) (actual rows= loops=)

  • Hash Cond: (gnlstentit8_.gnl_st_id = geoplcenti5_.st_id)
56. 0.000 0.000 ↓ 0.0

Seq Scan on gnl_st gnlstentit8_ (cost=0.00..9.18 rows=318 width=86) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Hash (cost=1.03..1.03 rows=3 width=88) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Seq Scan on geo_plc geoplcenti5_ (cost=0.00..1.03 rows=3 width=88) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Hash (cost=9.18..9.18 rows=318 width=86) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Seq Scan on gnl_st gnlstentit4_ (cost=0.00..9.18 rows=318 width=86) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Hash (cost=55.61..55.61 rows=2,161 width=119) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Seq Scan on prod_ofr_prc prodofrprc9_ (cost=0.00..55.61 rows=2,161 width=119) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Hash (cost=1.02..1.02 rows=2 width=688) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Seq Scan on cur curentity10_ (cost=0.00..1.02 rows=2 width=688) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Hash (cost=12.10..12.10 rows=410 width=97) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Seq Scan on gnl_tp gnltpentit11_ (cost=0.00..12.10 rows=410 width=97) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Hash (cost=12.10..12.10 rows=410 width=97) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Seq Scan on gnl_tp gnltpentit12_ (cost=0.00..12.10 rows=410 width=97) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Hash (cost=1.22..1.22 rows=22 width=215) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Seq Scan on unit_of_msrmt unitofmsrm13_ (cost=0.00..1.22 rows=22 width=215) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Hash (cost=1.03..1.03 rows=3 width=235) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Seq Scan on prc_chrg_tp prcchrgtpe14_ (cost=0.00..1.03 rows=3 width=235) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Hash (cost=9.18..9.18 rows=318 width=86) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Seq Scan on gnl_st gnlstentit15_ (cost=0.00..9.18 rows=318 width=86) (actual rows= loops=)