explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XEeZ

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

Finalize GroupAggregate (cost=69,021.11..69,171.53 rows=200 width=87) (actual time=172.507..172.546 rows=8 loops=1)

  • Group Key: mt_trades_3_s1_2019_06.symbol
2. 39.085 187.224 ↑ 40.0 25 1

Gather Merge (cost=69,021.11..69,142.03 rows=1,000 width=87) (actual time=172.493..187.224 rows=25 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
3. 0.065 148.139 ↑ 50.0 4 6 / 6

Sort (cost=68,021.03..68,021.53 rows=200 width=87) (actual time=148.138..148.139 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. 57.864 148.074 ↑ 50.0 4 6 / 6

Partial HashAggregate (cost=68,011.39..68,013.39 rows=200 width=87) (actual time=148.070..148.074 rows=4 loops=6)

  • Group Key: mt_trades_3_s1_2019_06.symbol
5. 2.121 90.210 ↓ 1.2 20,476 6 / 6

Parallel Append (cost=111.66..65,853.71 rows=16,923 width=20) (actual time=2.955..90.210 rows=20,476 loops=6)

  • Subplans Removed: 13
6. 6.189 6.777 ↓ 3.4 22,757 1 / 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=4.153..40.662 rows=22,757 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: 127
7. 0.588 0.588 ↑ 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.525..3.525 rows=22,884 loops=1)

  • Index Cond: (login = 525608)
8. 5.441 5.870 ↓ 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.075..35.218 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.429 0.429 ↑ 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.575..2.575 rows=17,376 loops=1)

  • Index Cond: (login = 525608)
10. 5.011 5.451 ↓ 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.117..32.704 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.440 0.440 ↑ 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.637..2.637 rows=15,572 loops=1)

  • Index Cond: (login = 525608)
12. 7.045 7.692 ↓ 1.2 5,468 3 / 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=1.570..15.384 rows=5,468 loops=3)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (server_id = 1) AND (close_time > (now() - '1 year'::interval)))
  • Rows Removed by Filter: 20
13. 0.647 0.647 ↓ 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.884..3.884 rows=16,465 loops=1)

  • Index Cond: (login = 525608)
14. 4.274 4.604 ↓ 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=2.317..27.625 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.330 0.330 ↓ 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.980..1.980 rows=9,921 loops=1)

  • Index Cond: (login = 525608)
16. 1.571 1.675 ↓ 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.791..10.050 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.104 0.104 ↑ 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.627..0.627 rows=6,474 loops=1)

  • Index Cond: (login = 525608)
18. 1.580 1.693 ↓ 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.401..5.080 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.114 0.114 ↑ 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.682..0.682 rows=5,490 loops=1)

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

Parallel Bitmap Heap Scan on mt_trades_3_s1_2019_07 (cost=31.31..36.87 rows=1 width=58) (actual time=37.017..42.642 rows=2,359 loops=6)

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

BitmapAnd (cost=31.31..31.31 rows=5 width=0) (actual time=47.322..47.322 rows=0 loops=1)

22. 7.456 7.456 ↓ 429.5 424,298 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_07_server_id_idx (cost=0.00..14.43 rows=988 width=0) (actual time=44.738..44.738 rows=424,298 loops=1)

  • Index Cond: (server_id = 1)
23. 0.260 0.260 ↓ 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.560..1.560 rows=14,223 loops=1)

  • Index Cond: (login = 525608)
24. 1.576 6.304 ↓ 9,066.0 9,066 1 / 6

Parallel Bitmap Heap Scan on mt_trades_3_s1_2019_12 (cost=24.26..28.71 rows=1 width=58) (actual time=28.637..37.825 rows=9,066 loops=1)

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

BitmapAnd (cost=24.26..24.26 rows=4 width=0) (actual time=28.371..28.371 rows=0 loops=1)

26. 4.499 4.499 ↓ 427.9 315,808 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2019_12_server_id_idx (cost=0.00..11.46 rows=738 width=0) (actual time=26.992..26.992 rows=315,808 loops=1)

  • Index Cond: (server_id = 1)
27. 0.127 0.127 ↓ 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.762..0.762 rows=9,093 loops=1)

  • Index Cond: (login = 525608)
28. 1.393 5.316 ↓ 5,995.0 5,995 1 / 6

Parallel Bitmap Heap Scan on mt_trades_3_s1_2020_01 (cost=17.43..20.77 rows=1 width=58) (actual time=24.076..31.897 rows=5,995 loops=1)

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

BitmapAnd (cost=17.43..17.43 rows=3 width=0) (actual time=23.536..23.536 rows=0 loops=1)

30. 3.703 3.703 ↓ 429.2 215,874 1 / 6

Bitmap Index Scan on mt_trades_3_s1_2020_01_server_id_idx (cost=0.00..7.49 rows=503 width=0) (actual time=22.216..22.217 rows=215,874 loops=1)

  • Index Cond: (server_id = 1)
31. 0.111 0.111 ↓ 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.663..0.663 rows=6,027 loops=1)

  • Index Cond: (login = 525608)
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.059 0.061 ↑ 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.368..0.369 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_server_id_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: (server_id = 1)
  • Filter: ((profit <> '0'::numeric) AND (login = 525608) 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 : 8.306 ms
Execution time : 187.938 ms