explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AfK5 : ddd

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 4,811.513 ↑ 1.0 3 1

Append (cost=438,630.01..1,611,759.72 rows=3 width=40) (actual time=1,094.698..4,811.513 rows=3 loops=1)

  • Buffers: shared hit=313,986
2. 0.000 1,094.697 ↑ 1.0 1 1

Finalize Aggregate (cost=438,630.01..438,630.02 rows=1 width=40) (actual time=1,094.697..1,094.697 rows=1 loops=1)

  • Buffers: shared hit=64,122
3. 12.683 1,094.818 ↓ 1.2 6 1

Gather (cost=438,629.48..438,629.99 rows=5 width=8) (actual time=1,094.098..1,094.818 rows=6 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=64,122
4. 287.194 1,082.135 ↑ 1.0 1 6 / 6

Partial Aggregate (cost=437,629.48..437,629.49 rows=1 width=8) (actual time=1,082.135..1,082.135 rows=1 loops=6)

  • Buffers: shared hit=64,122
5. 263.217 794.941 ↑ 1.4 3,880,567 6 / 6

Append (cost=0.43..424,487.22 rows=5,256,906 width=0) (actual time=0.060..794.941 rows=3,880,567 loops=6)

  • Buffers: shared hit=64,122
6. 49.101 49.101 ↑ 1.5 249,841 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201601_valutaid_idx on bi_getpaymentssummary_201601 (cost=0.43..27,695.26 rows=374,761 width=0) (actual time=0.059..49.101 rows=249,841 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=4,104
7. 46.119 46.119 ↑ 1.5 267,504 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201602_valutaid_idx on bi_getpaymentssummary_201602 (cost=0.43..29,654.10 rows=401,256 width=0) (actual time=0.088..46.119 rows=267,504 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=4,395
8. 47.245 47.245 ↑ 1.5 306,010 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201603_valutaid_idx on bi_getpaymentssummary_201603 (cost=0.43..33,918.69 rows=459,009 width=0) (actual time=0.123..47.245 rows=306,010 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=5,026
9. 42.567 42.567 ↑ 1.5 311,400 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201604_valutaid_idx on bi_getpaymentssummary_201604 (cost=0.43..34,513.73 rows=467,110 width=0) (actual time=0.074..42.567 rows=311,400 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=5,114
10. 42.276 42.276 ↑ 1.2 315,069 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201605_valutaid_idx on bi_getpaymentssummary_201605 (cost=0.43..33,982.67 rows=378,121 width=0) (actual time=0.043..42.276 rows=315,069 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=5,174
11. 38.248 38.248 ↑ 1.5 303,441 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201606_valutaid_idx on bi_getpaymentssummary_201606 (cost=0.43..33,635.30 rows=455,162 width=0) (actual time=0.058..38.248 rows=303,441 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=4,983
12. 35.860 35.860 ↑ 1.5 276,965 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201607_valutaid_idx on bi_getpaymentssummary_201607 (cost=0.43..30,699.86 rows=415,448 width=0) (actual time=0.061..35.860 rows=276,965 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=4,550
13. 35.964 35.964 ↑ 1.5 285,591 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201608_valutaid_idx on bi_getpaymentssummary_201608 (cost=0.43..31,656.04 rows=428,387 width=0) (actual time=0.054..35.964 rows=285,591 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=4,691
14. 42.744 42.744 ↑ 1.2 341,809 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201609_valutaid_idx on bi_getpaymentssummary_201609 (cost=0.43..36,860.17 rows=410,164 width=0) (actual time=0.050..42.744 rows=341,809 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=5,699
15. 48.584 48.584 ↑ 1.2 393,505 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201610_valutaid_idx on bi_getpaymentssummary_201610 (cost=0.43..42,431.68 rows=472,207 width=0) (actual time=0.084..48.584 rows=393,505 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=6,566
16. 50.342 50.342 ↑ 1.2 407,452 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201611_valutaid_idx on bi_getpaymentssummary_201611 (cost=0.43..43,937.13 rows=488,934 width=0) (actual time=0.060..50.342 rows=407,452 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=6,789
17. 52.674 52.674 ↑ 1.2 421,980 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201612_valutaid_idx on bi_getpaymentssummary_201612 (cost=0.43..45,502.59 rows=506,347 width=0) (actual time=0.041..52.674 rows=421,980 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=7,031
18. 0.000 1,462.479 ↑ 1.0 1 1

Finalize Aggregate (cost=592,164.26..592,164.27 rows=1 width=40) (actual time=1,462.479..1,462.479 rows=1 loops=1)

  • Buffers: shared hit=88,937
19. 13.367 1,462.603 ↓ 1.2 6 1

Gather (cost=592,163.74..592,164.25 rows=5 width=8) (actual time=1,462.232..1,462.603 rows=6 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=88,937
20. 385.582 1,449.236 ↑ 1.0 1 6 / 6

Partial Aggregate (cost=591,163.74..591,163.75 rows=1 width=8) (actual time=1,449.236..1,449.236 rows=1 loops=6)

  • Buffers: shared hit=88,937
21. 353.456 1,063.654 ↑ 1.2 5,333,804 6 / 6

Append (cost=0.43..575,161.97 rows=6,400,709 width=0) (actual time=0.073..1,063.654 rows=5,333,804 loops=6)

  • Buffers: shared hit=88,937
22. 63.243 63.243 ↑ 1.2 385,726 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201701_valutaid_idx on bi_getpaymentssummary_201701 (cost=0.43..41,594.64 rows=462,806 width=0) (actual time=0.073..63.243 rows=385,726 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=6,429
23. 59.324 59.324 ↑ 1.2 415,273 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201702_valutaid_idx on bi_getpaymentssummary_201702 (cost=0.43..44,778.62 rows=498,348 width=0) (actual time=0.102..59.324 rows=415,273 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=6,917
24. 61.109 61.109 ↑ 1.2 470,658 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201703_valutaid_idx on bi_getpaymentssummary_201703 (cost=0.43..50,752.32 rows=564,797 width=0) (actual time=0.072..61.109 rows=470,658 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=7,826
25. 60.042 60.042 ↑ 1.2 470,588 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201704_valutaid_idx on bi_getpaymentssummary_201704 (cost=0.43..50,744.62 rows=564,691 width=0) (actual time=0.047..60.042 rows=470,588 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=7,823
26. 55.960 55.960 ↑ 1.2 435,038 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201705_valutaid_idx on bi_getpaymentssummary_201705 (cost=0.43..46,914.27 rows=522,110 width=0) (actual time=0.051..55.960 rows=435,038 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=7,239
27. 50.929 50.929 ↑ 1.2 370,926 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201706_valutaid_idx on bi_getpaymentssummary_201706 (cost=0.43..39,998.61 rows=445,091 width=0) (actual time=0.067..50.929 rows=370,926 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=6,194
28. 51.912 51.912 ↑ 1.2 373,194 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201707_valutaid_idx on bi_getpaymentssummary_201707 (cost=0.43..40,242.39 rows=447,827 width=0) (actual time=0.065..51.912 rows=373,194 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=6,236
29. 58.025 58.025 ↑ 1.2 422,668 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201708_valutaid_idx on bi_getpaymentssummary_201708 (cost=0.43..45,577.42 rows=507,228 width=0) (actual time=0.059..58.025 rows=422,668 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=7,050
30. 60.208 60.208 ↑ 1.2 489,488 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201709_valutaid_idx on bi_getpaymentssummary_201709 (cost=0.43..52,784.08 rows=587,419 width=0) (actual time=0.060..60.208 rows=489,488 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=8,152
31. 61.523 61.523 ↑ 1.2 493,347 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201710_valutaid_idx on bi_getpaymentssummary_201710 (cost=0.43..53,196.84 rows=592,012 width=0) (actual time=0.091..61.523 rows=493,347 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=8,219
32. 59.311 59.311 ↑ 1.2 462,206 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201711_valutaid_idx on bi_getpaymentssummary_201711 (cost=0.43..49,843.46 rows=554,715 width=0) (actual time=0.073..59.311 rows=462,206 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=7,718
33. 68.612 68.612 ↑ 1.2 544,694 6 / 6

Parallel Index Only Scan using bi_getpaymentssummary_201712_valutaid_idx on bi_getpaymentssummary_201712 (cost=0.43..58,734.70 rows=653,665 width=0) (actual time=0.091..68.612 rows=544,694 loops=6)

  • Heap Fetches: 0
  • Buffers: shared hit=9,134
34. 0.000 2,254.332 ↑ 1.0 1 1

Finalize Aggregate (cost=580,965.39..580,965.40 rows=1 width=40) (actual time=2,254.331..2,254.332 rows=1 loops=1)

  • Buffers: shared hit=160,927
35. 81.142 2,319.851 ↓ 1.2 7 1

Gather (cost=580,964.76..580,965.37 rows=6 width=8) (actual time=2,253.946..2,319.851 rows=7 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
  • Buffers: shared hit=160,927
36. 582.317 2,238.709 ↑ 1.0 1 7 / 7

Partial Aggregate (cost=579,964.76..579,964.77 rows=1 width=8) (actual time=2,238.708..2,238.709 rows=1 loops=7)

  • Buffers: shared hit=160,927
37. 531.969 1,656.392 ↑ 1.3 8,201,676 7 / 7

Append (cost=0.43..552,875.39 rows=10,835,748 width=0) (actual time=0.073..1,656.392 rows=8,201,676 loops=7)

  • Buffers: shared hit=160,927
38. 83.678 83.678 ↑ 1.4 461,520 7 / 7

Parallel Index Only Scan using bi_getpaymentssummary_201801_valutaid_idx on bi_getpaymentssummary_201801 (cost=0.43..31,475.45 rows=646,115 width=0) (actual time=0.073..83.678 rows=461,520 loops=7)

  • Heap Fetches: 0
  • Buffers: shared hit=9,063
39. 76.308 76.308 ↑ 1.4 492,913 7 / 7

Parallel Index Only Scan using bi_getpaymentssummary_201802_valutaid_idx on bi_getpaymentssummary_201802 (cost=0.43..33,619.04 rows=690,132 width=0) (actual time=0.098..76.308 rows=492,913 loops=7)

  • Heap Fetches: 0
  • Buffers: shared hit=9,666
40. 86.783 86.783 ↑ 1.4 616,420 7 / 7

Parallel Index Only Scan using bi_getpaymentssummary_201803_valutaid_idx on bi_getpaymentssummary_201803 (cost=0.43..42,039.29 rows=862,996 width=0) (actual time=0.080..86.783 rows=616,420 loops=7)

  • Heap Fetches: 0
  • Buffers: shared hit=12,096
41. 78.414 78.414 ↑ 1.4 585,329 7 / 7

Parallel Index Only Scan using bi_getpaymentssummary_201804_valutaid_idx on bi_getpaymentssummary_201804 (cost=0.43..39,919.15 rows=819,478 width=0) (actual time=0.067..78.414 rows=585,329 loops=7)

  • Heap Fetches: 0
  • Buffers: shared hit=11,495
42. 70.156 70.156 ↑ 1.4 565,748 7 / 7

Parallel Index Only Scan using bi_getpaymentssummary_201805_valutaid_idx on bi_getpaymentssummary_201805 (cost=0.43..38,581.12 rows=791,963 width=0) (actual time=0.043..70.156 rows=565,748 loops=7)

  • Heap Fetches: 0
  • Buffers: shared hit=11,125
43. 78.776 78.776 ↑ 1.4 632,392 7 / 7

Parallel Index Only Scan using bi_getpaymentssummary_201806_valutaid_idx on bi_getpaymentssummary_201806 (cost=0.43..43,129.27 rows=885,395 width=0) (actual time=0.065..78.776 rows=632,392 loops=7)

  • Heap Fetches: 0
  • Buffers: shared hit=12,421
44. 87.527 87.527 ↑ 1.4 681,437 7 / 7

Parallel Index Only Scan using bi_getpaymentssummary_201807_valutaid_idx on bi_getpaymentssummary_201807 (cost=0.43..46,473.36 rows=954,055 width=0) (actual time=0.042..87.527 rows=681,437 loops=7)

  • Heap Fetches: 0
  • Buffers: shared hit=13,353
45. 83.644 83.644 ↑ 1.4 666,417 7 / 7

Parallel Index Only Scan using bi_getpaymentssummary_201808_valutaid_idx on bi_getpaymentssummary_201808 (cost=0.43..45,448.47 rows=933,001 width=0) (actual time=0.085..83.644 rows=666,417 loops=7)

  • Heap Fetches: 0
  • Buffers: shared hit=13,068
46. 94.880 94.880 ↑ 1.4 727,649 7 / 7

Parallel Index Only Scan using bi_getpaymentssummary_201809_valutaid_idx on bi_getpaymentssummary_201809 (cost=0.43..49,626.34 rows=1,018,797 width=0) (actual time=0.062..94.880 rows=727,649 loops=7)

  • Heap Fetches: 0
  • Buffers: shared hit=14,285
47. 126.468 126.468 ↑ 1.2 893,514 7 / 7

Parallel Index Only Scan using bi_getpaymentssummary_201810_valutaid_idx on bi_getpaymentssummary_201810 (cost=0.43..58,850.03 rows=1,042,415 width=0) (actual time=0.082..126.468 rows=893,514 loops=7)

  • Heap Fetches: 0
  • Buffers: shared hit=17,491
48. 126.623 126.623 ↑ 1.2 910,381 7 / 7

Parallel Index Only Scan using bi_getpaymentssummary_201811_valutaid_idx on bi_getpaymentssummary_201811 (cost=0.43..59,958.73 rows=1,062,058 width=0) (actual time=0.072..126.623 rows=910,381 loops=7)

  • Heap Fetches: 0
  • Buffers: shared hit=17,881
49. 131.166 131.166 ↑ 1.2 967,956 7 / 7

Parallel Index Only Scan using bi_getpaymentssummary_201812_valutaid_idx on bi_getpaymentssummary_201812 (cost=0.43..63,755.14 rows=1,129,343 width=0) (actual time=0.070..131.166 rows=967,956 loops=7)

  • Heap Fetches: 0
  • Buffers: shared hit=18,983
Planning time : 3.423 ms
Execution time : 4,877.631 ms