explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3oaq

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 176.484 ↑ 25.0 8 1

Finalize GroupAggregate (cost=69,037.76..69,188.19 rows=200 width=87) (actual time=176.465..176.484 rows=8 loops=1)

  • Group Key: mt_trades_3_s1_2019_06.symbol
2. 38.887 191.481 ↑ 37.0 27 1

Gather Merge (cost=69,037.76..69,158.69 rows=1,000 width=87) (actual time=176.451..191.481 rows=27 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
3. 0.061 152.594 ↑ 50.0 4 6 / 6

Sort (cost=68,037.68..68,038.18 rows=200 width=87) (actual time=152.593..152.594 rows=4 loops=6)

  • Sort Key: mt_trades_3_s1_2019_06.symbol
  • Sort Method: quicksort Memory: 26kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
  • Worker 2: Sort Method: quicksort Memory: 25kB
  • Worker 3: Sort Method: quicksort Memory: 25kB
  • Worker 4: Sort Method: quicksort Memory: 25kB
4. 50.827 152.533 ↑ 50.0 4 6 / 6

Partial HashAggregate (cost=68,028.04..68,030.04 rows=200 width=87) (actual time=152.530..152.533 rows=4 loops=6)

  • Group Key: mt_trades_3_s1_2019_06.symbol
5. 1.987 101.706 ↓ 1.2 20,476 6 / 6

Parallel Append (cost=111.66..65,870.36 rows=16,923 width=20) (actual time=2.882..101.706 rows=20,476 loops=6)

  • Subplans Removed: 13
6. 6.452 7.093 ↓ 1.7 11,378 2 / 6

Parallel Bitmap Heap Scan on mt_trades_3_s1_2019_06 (cost=268.78..12,008.30 rows=6,777 width=20) (actual time=2.289..21.279 rows=11,378 loops=2)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
  • Rows Removed by Filter: 64
7. 0.641 0.641 ↑ 1.0 22,884 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_06_login_idx (cost=0.00..263.53 rows=22,908 width=0) (actual time=3.847..3.847 rows=22,884 loops=1)

  • Index Cond: (login = 525608)
8. 5.514 5.970 ↓ 3.3 17,287 1 / 6

Parallel Bitmap Heap Scan on mt_trades_3_s1_2019_05 (cost=205.05..11,667.52 rows=5,178 width=20) (actual time=3.575..35.819 rows=17,287 loops=1)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
  • Rows Removed by Filter: 89
9. 0.456 0.456 ↑ 1.0 17,376 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_05_login_idx (cost=0.00..201.04 rows=17,508 width=0) (actual time=2.734..2.734 rows=17,376 loops=1)

  • Index Cond: (login = 525608)
10. 5.610 6.077 ↓ 3.2 15,431 1 / 6

Parallel Bitmap Heap Scan on mt_trades_3_s1_2019_04 (cost=193.81..11,735.14 rows=4,769 width=20) (actual time=3.505..36.464 rows=15,431 loops=1)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
  • Rows Removed by Filter: 141
11. 0.467 0.467 ↑ 1.1 15,572 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_04_login_idx (cost=0.00..190.12 rows=16,492 width=0) (actual time=2.802..2.802 rows=15,572 loops=1)

  • Index Cond: (login = 525608)
12. 5.996 6.525 ↓ 3.7 16,404 1 / 6

Parallel Bitmap Heap Scan on mt_trades_3_s1_2019_03 (cost=180.24..12,325.40 rows=4,423 width=20) (actual time=3.875..39.150 rows=16,404 loops=1)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
  • Rows Removed by Filter: 61
13. 0.528 0.528 ↓ 1.1 16,465 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_03_login_idx (cost=0.00..176.81 rows=15,451 width=0) (actual time=3.170..3.171 rows=16,465 loops=1)

  • Index Cond: (login = 525608)
14. 2.748 2.952 ↓ 2.8 9,859 1 / 6

Parallel Bitmap Heap Scan on mt_trades_3_s1_2019_08 (cost=111.66..6,909.43 rows=3,580 width=20) (actual time=1.439..17.711 rows=9,859 loops=1)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
  • Rows Removed by Filter: 62
15. 0.203 0.203 ↓ 1.1 9,921 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_08_login_idx (cost=0.00..109.51 rows=9,412 width=0) (actual time=1.219..1.220 rows=9,921 loops=1)

  • Index Cond: (login = 525608)
16. 1.999 2.132 ↓ 3.0 6,440 1 / 6

Parallel Bitmap Heap Scan on mt_trades_3_s1_2019_02 (cost=83.08..6,562.62 rows=2,138 width=20) (actual time=0.976..12.791 rows=6,440 loops=1)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
  • Rows Removed by Filter: 34
17. 0.133 0.133 ↑ 1.1 6,474 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_02_login_idx (cost=0.00..81.80 rows=7,036 width=0) (actual time=0.798..0.798 rows=6,474 loops=1)

  • Index Cond: (login = 525608)
18. 1.530 1.625 ↓ 1.3 2,730 2 / 6

Parallel Bitmap Heap Scan on mt_trades_3_s1_2019_11 (cost=67.56..4,206.84 rows=2,145 width=20) (actual time=0.352..4.876 rows=2,730 loops=2)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
  • Rows Removed by Filter: 15
19. 0.096 0.096 ↑ 1.0 5,490 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_11_login_idx (cost=0.00..66.27 rows=5,700 width=0) (actual time=0.575..0.575 rows=5,490 loops=1)

  • Index Cond: (login = 525608)
20. 38.883 48.782 ↓ 2,359.0 2,359 6 / 6

Parallel Bitmap Heap Scan on mt_trades_3_s1_2019_07 (cost=42.59..44.81 rows=1 width=58) (actual time=44.946..48.782 rows=2,359 loops=6)

  • Recheck Cond: ((login = 525608) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
  • Filter: (profit <> '0'::numeric)
  • Rows Removed by Filter: 12
  • Heap Blocks: exact=463
21. 0.019 9.899 ↓ 0.0 0 1 / 6

BitmapAnd (cost=42.59..42.59 rows=2 width=0) (actual time=59.394..59.394 rows=0 loops=1)

22. 0.249 0.249 ↓ 14.4 14,223 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_07_login_idx (cost=0.00..16.63 rows=988 width=0) (actual time=1.495..1.495 rows=14,223 loops=1)

  • Index Cond: (login = 525608)
23. 9.630 9.630 ↓ 1,289.7 424,298 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_07_pkey (cost=0.00..25.71 rows=329 width=0) (actual time=57.782..57.782 rows=424,298 loops=1)

  • Index Cond: ((server_id = 1) AND (close_time > (now() - '1 year'::interval)))
24. 2.882 10.706 ↓ 3,022.0 3,022 3 / 6

Parallel Bitmap Heap Scan on mt_trades_3_s1_2019_12 (cost=32.71..33.83 rows=1 width=58) (actual time=17.245..21.411 rows=3,022 loops=3)

  • Recheck Cond: ((login = 525608) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
  • Filter: (profit <> '0'::numeric)
  • Rows Removed by Filter: 9
  • Heap Blocks: exact=648
25. 0.010 7.824 ↓ 0.0 0 1 / 6

BitmapAnd (cost=32.71..32.71 rows=1 width=0) (actual time=46.941..46.941 rows=0 loops=1)

26. 0.149 0.149 ↓ 12.3 9,093 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_12_login_idx (cost=0.00..12.56 rows=738 width=0) (actual time=0.895..0.895 rows=9,093 loops=1)

  • Index Cond: (login = 525608)
27. 7.664 7.664 ↓ 1,283.8 315,808 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_12_pkey (cost=0.00..19.91 rows=246 width=0) (actual time=45.985..45.985 rows=315,808 loops=1)

  • Index Cond: ((server_id = 1) AND (close_time > (now() - '1 year'::interval)))
28. 0.939 7.794 ↓ 5,995.0 5,995 1 / 6

Parallel Bitmap Heap Scan on mt_trades_3_s1_2020_01 (cost=23.09..24.21 rows=1 width=58) (actual time=41.292..46.765 rows=5,995 loops=1)

  • Recheck Cond: ((login = 525608) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
  • Filter: (profit <> '0'::numeric)
  • Rows Removed by Filter: 32
  • Heap Blocks: exact=678
29. 0.010 6.855 ↓ 0.0 0 1 / 6

BitmapAnd (cost=23.09..23.09 rows=1 width=0) (actual time=41.130..41.130 rows=0 loops=1)

30. 0.132 0.132 ↓ 12.0 6,027 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2020_01_login_idx (cost=0.00..9.69 rows=503 width=0) (actual time=0.790..0.791 rows=6,027 loops=1)

  • Index Cond: (login = 525608)
31. 6.713 6.713 ↓ 1,285.0 215,874 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2020_01_pkey (cost=0.00..13.15 rows=168 width=0) (actual time=40.276..40.276 rows=215,874 loops=1)

  • Index Cond: ((server_id = 1) AND (close_time > (now() - '1 year'::interval)))
32. 0.000 0.002 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on mt_trades_3_s1_2019_10 (cost=2.37..123.83 rows=58 width=20) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
33. 0.002 0.002 ↓ 0.0 0 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_10_login_idx (cost=0.00..2.35 rows=110 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (login = 525608)
34. 0.057 0.059 ↑ 52.0 1 1 / 6

Parallel Bitmap Heap Scan on mt_trades_3_s1_2019_09 (cost=2.27..109.40 rows=52 width=20) (actual time=0.353..0.354 rows=1 loops=1)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
  • Heap Blocks: exact=1
35. 0.002 0.002 ↑ 97.0 1 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_09_login_idx (cost=0.00..2.25 rows=97 width=0) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (login = 525608)
36. 0.000 0.000 ↓ 0.0 0 1 / 6

Parallel Index Scan using mt_trades_3_s1_2020_02_login_idx on mt_trades_3_s1_2020_02 (cost=0.14..2.37 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
37. 0.001 0.001 ↓ 0.0 0 1 / 6

Parallel Index Scan using mt_trades_3_default_login_idx on mt_trades_3_default (cost=0.14..1.27 rows=1 width=21) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
Planning time : 7.350 ms
Execution time : 191.889 ms