explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3JwN

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

Hash Join (cost=1,606,854,179.54..1,606,902,169.21 rows=53,996 width=196) (actual rows= loops=)

  • Hash Cond: (x.optype = aa.optype)
2.          

CTE accountancy_account

3. 0.000 0.000 ↓ 0.0

Values Scan on "*VALUES*" (cost=0.00..0.08 rows=6 width=96) (actual rows= loops=)

4.          

CTE x

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16,067,908.67..1,606,854,179.27 rows=1,808,900 width=95) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Function Scan on unnest bank_trx (cost=0.00..1.00 rows=100 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

HashAggregate (cost=16,067,908.67..16,068,180.00 rows=18,089 width=28) (actual rows= loops=)

  • Group Key: fo.bank_trxid, fo.mch_accountid, gfo.optype, gfo.currency
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,070.21..16,067,682.56 rows=18,089 width=28) (actual rows= loops=)

  • Hash Cond: (gfo.popid = fo.opid)
9. 0.000 0.000 ↓ 0.0

Append (cost=0.00..14,291,281.51 rows=473,106,652 width=24) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation gfo (cost=0.00..0.00 rows=1 width=72) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201301 gfo_1 (cost=0.00..1.09 rows=9 width=27) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201302 gfo_2 (cost=0.00..1.04 rows=4 width=27) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201303 gfo_3 (cost=0.00..12.00 rows=200 width=72) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201304 gfo_4 (cost=0.00..5.83 rows=183 width=27) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201305 gfo_5 (cost=0.00..147.93 rows=5,293 width=23) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201306 gfo_6 (cost=0.00..166.70 rows=5,770 width=23) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201307 gfo_7 (cost=0.00..743.65 rows=25,465 width=25) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201308 gfo_8 (cost=0.00..1,422.13 rows=48,713 width=26) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201309 gfo_9 (cost=0.00..1,472.48 rows=50,448 width=26) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201310 gfo_10 (cost=0.00..1,934.08 rows=66,408 width=25) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201311 gfo_11 (cost=0.00..3,071.49 rows=105,749 width=24) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201312 gfo_12 (cost=0.00..4,009.22 rows=138,222 width=24) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201401 gfo_13 (cost=0.00..5,785.25 rows=199,725 width=24) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201402 gfo_14 (cost=0.00..5,278.20 rows=181,920 width=24) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201403 gfo_15 (cost=0.00..5,710.75 rows=196,275 width=24) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201404 gfo_16 (cost=0.00..6,367.12 rows=212,012 width=24) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201405 gfo_17 (cost=0.00..7,727.58 rows=255,258 width=24) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201406 gfo_18 (cost=0.00..10,112.65 rows=333,665 width=24) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201407 gfo_19 (cost=0.00..15,749.99 rows=518,299 width=24) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201408 gfo_20 (cost=0.00..23,581.73 rows=774,773 width=23) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201409 gfo_21 (cost=0.00..38,081.75 rows=1,251,675 width=22) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201410 gfo_22 (cost=0.00..46,314.03 rows=1,532,403 width=22) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201411 gfo_23 (cost=0.00..55,247.43 rows=1,816,943 width=23) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201412 gfo_24 (cost=0.00..77,574.49 rows=2,581,549 width=23) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201501 gfo_25 (cost=0.00..80,018.31 rows=2,678,931 width=23) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201502 gfo_26 (cost=0.00..68,360.99 rows=2,304,099 width=23) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201503 gfo_27 (cost=0.00..80,104.75 rows=2,714,175 width=23) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201504 gfo_28 (cost=0.00..73,370.96 rows=2,485,296 width=23) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201505 gfo_29 (cost=0.00..83,845.08 rows=2,772,108 width=23) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201506 gfo_30 (cost=0.00..84,890.54 rows=2,881,354 width=23) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201507 gfo_31 (cost=0.00..88,353.71 rows=2,989,771 width=23) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201508 gfo_32 (cost=0.00..86,960.97 rows=2,960,697 width=23) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201509 gfo_33 (cost=0.00..97,111.11 rows=3,296,411 width=23) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201510 gfo_34 (cost=0.00..105,714.51 rows=3,525,851 width=24) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201511 gfo_35 (cost=0.00..116,989.91 rows=3,961,991 width=24) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201512 gfo_36 (cost=0.00..145,205.09 rows=4,828,909 width=24) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201601 gfo_37 (cost=0.00..143,764.96 rows=4,765,096 width=24) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201602 gfo_38 (cost=0.00..131,858.91 rows=4,401,291 width=24) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201603 gfo_39 (cost=0.00..164,483.44 rows=5,524,744 width=23) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201604 gfo_40 (cost=0.00..163,054.61 rows=5,467,961 width=24) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201605 gfo_41 (cost=0.00..167,008.13 rows=5,616,113 width=24) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201606 gfo_42 (cost=0.00..174,895.04 rows=5,885,004 width=24) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201607 gfo_43 (cost=0.00..164,881.21 rows=5,533,021 width=23) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201608 gfo_44 (cost=0.00..175,906.36 rows=5,918,336 width=23) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201609 gfo_45 (cost=0.00..172,034.01 rows=5,775,601 width=23) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201610 gfo_46 (cost=0.00..187,475.80 rows=6,296,380 width=24) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201611 gfo_47 (cost=0.00..231,137.85 rows=7,642,485 width=23) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201612 gfo_48 (cost=0.00..261,992.73 rows=8,771,273 width=23) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201701 gfo_49 (cost=0.00..319,757.68 rows=10,698,168 width=24) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201702 gfo_50 (cost=0.00..255,986.71 rows=8,520,571 width=24) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201703 gfo_51 (cost=0.00..275,357.85 rows=9,093,385 width=24) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201704 gfo_52 (cost=0.00..251,086.12 rows=8,316,812 width=24) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201705 gfo_53 (cost=0.00..313,956.50 rows=10,455,550 width=24) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201706 gfo_54 (cost=0.00..330,908.13 rows=10,999,413 width=24) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201707 gfo_55 (cost=0.00..292,998.45 rows=9,727,545 width=24) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201708 gfo_56 (cost=0.00..349,093.98 rows=11,614,998 width=24) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201709 gfo_57 (cost=0.00..663,693.42 rows=21,849,142 width=25) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201710 gfo_58 (cost=0.00..387,702.00 rows=12,974,600 width=24) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201711 gfo_59 (cost=0.00..471,875.11 rows=15,760,711 width=24) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201712 gfo_60 (cost=0.00..472,428.43 rows=15,750,743 width=24) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201801 gfo_61 (cost=0.00..486,989.10 rows=15,491,710 width=24) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201802 gfo_62 (cost=0.00..401,759.10 rows=12,707,010 width=24) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201803 gfo_63 (cost=0.00..453,481.74 rows=14,307,174 width=24) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201804 gfo_64 (cost=0.00..408,548.26 rows=12,984,226 width=24) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201805 gfo_65 (cost=0.00..427,251.62 rows=14,222,362 width=24) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201806 gfo_66 (cost=0.00..472,054.06 rows=15,721,406 width=24) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201807 gfo_67 (cost=0.00..463,622.59 rows=15,418,359 width=24) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201808 gfo_68 (cost=0.00..442,865.45 rows=14,652,745 width=24) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201809 gfo_69 (cost=0.00..456,969.30 rows=15,154,130 width=24) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201810 gfo_70 (cost=0.00..496,273.97 rows=16,449,197 width=24) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201811 gfo_71 (cost=0.00..553,314.64 rows=18,363,864 width=24) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201812 gfo_72 (cost=0.00..594,472.80 rows=19,741,080 width=24) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201901 gfo_73 (cost=0.00..593,019.52 rows=19,651,052 width=24) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201902 gfo_74 (cost=0.00..95,853.39 rows=3,182,439 width=24) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201903 gfo_75 (cost=0.00..12.00 rows=200 width=72) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Seq Scan on gateway_financial_operation_201904 gfo_76 (cost=0.00..12.00 rows=200 width=72) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Hash (cost=2,023.60..2,023.60 rows=3,729 width=20) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Index Scan using financial_operation_bank_trxid_idx on financial_operation fo (cost=0.57..2,023.60 rows=3,729 width=20) (actual rows= loops=)

  • Index Cond: (bank_trxid = bank_trx.bank_trx)
  • Filter: (optype = ANY ('{SALE,REF}'::text[]))
89. 0.000 0.000 ↓ 0.0

CTE Scan on x (cost=0.00..40,700.25 rows=1,799,856 width=132) (actual rows= loops=)

  • Filter: (montant_en_devises <> '0'::numeric)
90. 0.000 0.000 ↓ 0.0

Hash (cost=0.12..0.12 rows=6 width=96) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

CTE Scan on accountancy_account aa (cost=0.00..0.12 rows=6 width=96) (actual rows= loops=)