explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5J5Z

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 68.862 ↑ 40.0 5 1

Finalize GroupAggregate (cost=82,657.79..82,770.58 rows=200 width=87) (actual time=68.822..68.862 rows=5 loops=1)

  • Group Key: mt_trades_s1_2019_12.symbol
2. 19.012 76.893 ↑ 44.4 18 1

Gather Merge (cost=82,657.79..82,753.58 rows=800 width=87) (actual time=68.800..76.893 rows=18 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 0.048 57.881 ↑ 50.0 4 5 / 5

Sort (cost=81,657.73..81,658.23 rows=200 width=87) (actual time=57.881..57.881 rows=4 loops=5)

  • Sort Key: mt_trades_s1_2019_12.symbol
  • Sort Method: quicksort Memory: 25kB
  • 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
4. 17.566 57.833 ↑ 50.0 4 5 / 5

Partial HashAggregate (cost=81,647.09..81,650.09 rows=200 width=87) (actual time=57.828..57.833 rows=4 loops=5)

  • Group Key: mt_trades_s1_2019_12.symbol
5. 2.208 40.267 ↑ 1.2 22,236 5 / 5

Parallel Append (cost=187.13..81,067.76 rows=25,748 width=20) (actual time=7.351..40.267 rows=22,236 loops=5)

6. 1.149 6.141 ↓ 2.1 3,388 1 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_12 (cost=2,441.86..6,098.47 rows=1,644 width=20) (actual time=25.115..30.706 rows=3,388 loops=1)

  • Recheck Cond: ((login = 525608) AND (close_time > '2019-02-01 00:00:00+00'::timestamp with time zone) AND (close_time < '2019-12-14 00:00:00+00'::timestamp with time zone))
  • Filter: ((profit <> '0'::numeric) AND (server_id = 1))
  • Rows Removed by Filter: 10
7. 0.032 4.992 ↓ 0.0 0 1 / 5

BitmapAnd (cost=2,441.86..2,441.86 rows=4,365 width=0) (actual time=24.959..24.959 rows=0 loops=1)

8. 0.325 0.325 ↓ 1.0 9,093 1 / 5

Bitmap Index Scan on mt_trades_s1_2019_12_login_idx (cost=0.00..103.36 rows=8,885 width=0) (actual time=1.623..1.623 rows=9,093 loops=1)

  • Index Cond: (login = 525608)
9. 4.635 4.635 ↓ 1.0 155,591 1 / 5

Bitmap Index Scan on mt_trades_s1_2019_12_close_time_idx (cost=0.00..2,336.27 rows=155,155 width=0) (actual time=23.177..23.177 rows=155,591 loops=1)

  • Index Cond: ((close_time > '2019-02-01 00:00:00+00'::timestamp with time zone) AND (close_time < '2019-12-14 00:00:00+00'::timestamp with time zone))
10. 6.945 7.744 ↓ 1.6 11,378 2 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_06 (cost=277.10..12,095.08 rows=6,955 width=20) (actual time=2.371..19.359 rows=11,378 loops=2)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (close_time > '2019-02-01 00:00:00+00'::timestamp with time zone) AND (close_time < '2019-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 64
11. 0.799 0.799 ↑ 1.0 22,884 1 / 5

Bitmap Index Scan on mt_trades_s1_2019_06_login_idx (cost=0.00..271.71 rows=23,558 width=0) (actual time=3.993..3.993 rows=22,884 loops=1)

  • Index Cond: (login = 525608)
12. 5.108 5.624 ↓ 3.3 17,287 1 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_05 (cost=207.85..11,745.28 rows=5,232 width=20) (actual time=3.469..28.122 rows=17,287 loops=1)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (close_time > '2019-02-01 00:00:00+00'::timestamp with time zone) AND (close_time < '2019-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 89
13. 0.516 0.516 ↑ 1.0 17,376 1 / 5

Bitmap Index Scan on mt_trades_s1_2019_05_login_idx (cost=0.00..203.79 rows=17,729 width=0) (actual time=2.580..2.580 rows=17,376 loops=1)

  • Index Cond: (login = 525608)
14. 4.927 5.437 ↓ 3.3 15,431 1 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_04 (cost=187.13..11,445.22 rows=4,621 width=20) (actual time=3.093..27.184 rows=15,431 loops=1)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (close_time > '2019-02-01 00:00:00+00'::timestamp with time zone) AND (close_time < '2019-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 141
15. 0.510 0.510 ↑ 1.0 15,572 1 / 5

Bitmap Index Scan on mt_trades_s1_2019_04_login_idx (cost=0.00..183.55 rows=15,910 width=0) (actual time=2.548..2.548 rows=15,572 loops=1)

  • Index Cond: (login = 525608)
16. 5.672 6.124 ↑ 1.4 3,281 5 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_03 (cost=182.86..12,429.41 rows=4,478 width=20) (actual time=0.616..6.124 rows=3,281 loops=5)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (close_time > '2019-02-01 00:00:00+00'::timestamp with time zone) AND (close_time < '2019-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 12
  • Heap Blocks: exact=493
17. 0.452 0.452 ↓ 1.1 16,465 1 / 5

Bitmap Index Scan on mt_trades_s1_2019_03_login_idx (cost=0.00..179.39 rows=15,649 width=0) (actual time=2.260..2.260 rows=16,465 loops=1)

  • Index Cond: (login = 525608)
18. 2.472 2.728 ↓ 1.3 7,077 2 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_07 (cost=165.90..9,211.94 rows=5,332 width=20) (actual time=0.828..6.820 rows=7,077 loops=2)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (close_time > '2019-02-01 00:00:00+00'::timestamp with time zone) AND (close_time < '2019-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 34
  • Heap Blocks: exact=1072
19. 0.256 0.256 ↓ 1.0 14,223 1 / 5

Bitmap Index Scan on mt_trades_s1_2019_07_login_idx (cost=0.00..162.70 rows=14,157 width=0) (actual time=1.279..1.279 rows=14,223 loops=1)

  • Index Cond: (login = 525608)
20. 1.432 1.615 ↓ 2.6 9,859 1 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_08 (cost=119.16..7,233.62 rows=3,832 width=20) (actual time=1.098..8.075 rows=9,859 loops=1)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (close_time > '2019-02-01 00:00:00+00'::timestamp with time zone) AND (close_time < '2019-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 62
  • Heap Blocks: exact=781
21. 0.183 0.183 ↑ 1.0 9,921 1 / 5

Bitmap Index Scan on mt_trades_s1_2019_08_login_idx (cost=0.00..116.86 rows=10,099 width=0) (actual time=0.917..0.917 rows=9,921 loops=1)

  • Index Cond: (login = 525608)
22. 1.236 1.374 ↓ 2.6 6,440 1 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_02 (cost=80.53..6,379.75 rows=2,492 width=20) (actual time=0.934..6.868 rows=6,440 loops=1)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (close_time > '2019-02-01 00:00:00+00'::timestamp with time zone) AND (close_time < '2019-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 34
  • Heap Blocks: exact=881
23. 0.137 0.137 ↑ 1.1 6,474 1 / 5

Bitmap Index Scan on mt_trades_s1_2019_02_login_idx (cost=0.00..79.04 rows=6,815 width=0) (actual time=0.687..0.687 rows=6,474 loops=1)

  • Index Cond: (login = 525608)
24. 1.055 1.193 ↓ 2.7 5,460 1 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_11 (cost=64.43..4,067.31 rows=2,043 width=20) (actual time=0.855..5.967 rows=5,460 loops=1)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (close_time > '2019-02-01 00:00:00+00'::timestamp with time zone) AND (close_time < '2019-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 30
  • Heap Blocks: exact=499
25. 0.139 0.139 ↓ 1.0 5,490 1 / 5

Bitmap Index Scan on mt_trades_s1_2019_11_login_idx (cost=0.00..63.20 rows=5,438 width=0) (actual time=0.693..0.693 rows=5,490 loops=1)

  • Index Cond: (login = 525608)
26. 0.000 0.002 ↓ 0.0 0 1 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_10 (cost=2.36..122.57 rows=58 width=20) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (close_time > '2019-02-01 00:00:00+00'::timestamp with time zone) AND (close_time < '2019-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
27. 0.002 0.002 ↓ 0.0 0 1 / 5

Bitmap Index Scan on mt_trades_s1_2019_10_login_idx (cost=0.00..2.34 rows=109 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (login = 525608)
28. 0.074 0.077 ↑ 52.0 1 1 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_09 (cost=2.28..110.36 rows=52 width=20) (actual time=0.383..0.384 rows=1 loops=1)

  • Recheck Cond: (login = 525608)
  • Filter: ((profit <> '0'::numeric) AND (close_time > '2019-02-01 00:00:00+00'::timestamp with time zone) AND (close_time < '2019-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Heap Blocks: exact=1
29. 0.003 0.003 ↑ 98.0 1 1 / 5

Bitmap Index Scan on mt_trades_s1_2019_09_login_idx (cost=0.00..2.26 rows=98 width=0) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (login = 525608)
Planning time : 2.454 ms
Execution time : 77.191 ms