explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IUqN

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

Finalize GroupAggregate (cost=82,758.18..82,870.97 rows=200 width=87) (actual time=72.625..72.669 rows=5 loops=1)

  • Group Key: mt_trades_s1_2019_06.symbol
2. 20.281 80.715 ↑ 44.4 18 1

Gather Merge (cost=82,758.18..82,853.97 rows=800 width=87) (actual time=72.599..80.715 rows=18 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 0.057 60.434 ↑ 50.0 4 5 / 5

Sort (cost=81,758.12..81,758.62 rows=200 width=87) (actual time=60.433..60.434 rows=4 loops=5)

  • Sort Key: mt_trades_s1_2019_06.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. 21.000 60.377 ↑ 50.0 4 5 / 5

Partial HashAggregate (cost=81,747.48..81,750.48 rows=200 width=87) (actual time=60.372..60.377 rows=4 loops=5)

  • Group Key: mt_trades_s1_2019_06.symbol
5. 2.336 39.377 ↑ 1.1 23,372 5 / 5

Parallel Append (cost=182.86..81,145.15 rows=26,770 width=12) (actual time=3.276..39.377 rows=23,372 loops=5)

6. 7.143 8.000 ↓ 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=12) (actual time=2.506..19.999 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 < '2020-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 64
7. 0.857 0.857 ↑ 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=4.283..4.283 rows=22,884 loops=1)

  • Index Cond: (login = 525608)
8. 5.378 6.037 ↓ 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=12) (actual time=3.836..30.187 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 < '2020-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 89
9. 0.660 0.660 ↑ 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=3.299..3.299 rows=17,376 loops=1)

  • Index Cond: (login = 525608)
10. 5.306 5.847 ↓ 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=12) (actual time=3.248..29.235 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 < '2020-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 141
11. 0.541 0.541 ↑ 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.702..2.703 rows=15,572 loops=1)

  • Index Cond: (login = 525608)
12. 5.974 6.611 ↓ 3.7 16,404 1 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_03 (cost=182.86..12,429.41 rows=4,478 width=12) (actual time=3.897..33.056 rows=16,404 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 < '2020-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 61
13. 0.638 0.638 ↓ 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=3.188..3.188 rows=16,465 loops=1)

  • Index Cond: (login = 525608)
14. 3.946 4.283 ↑ 1.9 2,831 5 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_07 (cost=165.90..9,211.94 rows=5,332 width=12) (actual time=0.474..4.283 rows=2,831 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 < '2020-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=582
15. 0.337 0.337 ↓ 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.686..1.686 rows=14,223 loops=1)

  • Index Cond: (login = 525608)
16. 1.440 1.596 ↓ 1.3 4,930 2 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_08 (cost=119.16..7,233.62 rows=3,832 width=12) (actual time=0.495..3.990 rows=4,930 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 < '2020-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 31
  • Heap Blocks: exact=764
17. 0.156 0.156 ↑ 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.780..0.780 rows=9,921 loops=1)

  • Index Cond: (login = 525608)
18. 1.643 1.826 ↓ 2.7 9,066 1 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_12 (cost=105.37..6,170.76 rows=3,346 width=12) (actual time=1.186..9.131 rows=9,066 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 < '2020-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 27
  • Heap Blocks: exact=1065
19. 0.184 0.184 ↓ 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=0.917..0.918 rows=9,093 loops=1)

  • Index Cond: (login = 525608)
20. 1.330 1.477 ↓ 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=12) (actual time=0.987..7.387 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 < '2020-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 34
  • Heap Blocks: exact=881
21. 0.148 0.148 ↑ 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.739..0.739 rows=6,474 loops=1)

  • Index Cond: (login = 525608)
22. 1.139 1.280 ↓ 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=12) (actual time=0.867..6.401 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 < '2020-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Rows Removed by Filter: 30
  • Heap Blocks: exact=499
23. 0.142 0.142 ↓ 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.708..0.708 rows=5,490 loops=1)

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

Parallel Bitmap Heap Scan on mt_trades_s1_2019_10 (cost=2.36..122.57 rows=58 width=12) (actual time=0.015..0.015 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 < '2020-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
25. 0.003 0.003 ↓ 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.013..0.013 rows=0 loops=1)

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

Parallel Bitmap Heap Scan on mt_trades_s1_2019_09 (cost=2.28..110.36 rows=52 width=12) (actual time=0.400..0.401 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 < '2020-12-14 00:00:00+00'::timestamp with time zone) AND (server_id = 1))
  • Heap Blocks: exact=1
27. 0.006 0.006 ↑ 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.030..0.030 rows=1 loops=1)

  • Index Cond: (login = 525608)
Planning time : 2.457 ms
Execution time : 81.125 ms