explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PJLD

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 63.832 ↑ 1.0 1 1

Finalize Aggregate (cost=82,681.03..82,681.04 rows=1 width=80) (actual time=63.831..63.832 rows=1 loops=1)

2. 18.493 71.667 ↓ 1.2 5 1

Gather (cost=82,680.56..82,680.97 rows=4 width=80) (actual time=63.652..71.667 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 14.431 53.174 ↑ 1.0 1 5 / 5

Partial Aggregate (cost=81,680.56..81,680.57 rows=1 width=80) (actual time=53.174..53.174 rows=1 loops=5)

4. 2.366 38.743 ↑ 1.1 23,372 5 / 5

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

5. 6.522 7.355 ↓ 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=5) (actual time=2.448..18.387 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
6. 0.833 0.833 ↑ 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.166..4.166 rows=22,884 loops=1)

  • Index Cond: (login = 525608)
7. 5.011 5.533 ↓ 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=5) (actual time=3.456..27.665 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
8. 0.522 0.522 ↑ 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.610..2.610 rows=17,376 loops=1)

  • Index Cond: (login = 525608)
9. 5.113 5.701 ↓ 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=5) (actual time=3.482..28.507 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
10. 0.588 0.588 ↑ 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.942..2.942 rows=15,572 loops=1)

  • Index Cond: (login = 525608)
11. 5.499 6.173 ↓ 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=5) (actual time=4.087..30.863 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
12. 0.674 0.674 ↓ 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.370..3.370 rows=16,465 loops=1)

  • Index Cond: (login = 525608)
13. 4.652 4.966 ↑ 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=5) (actual time=0.442..4.966 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=376
14. 0.314 0.314 ↓ 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.570..1.570 rows=14,223 loops=1)

  • Index Cond: (login = 525608)
15. 1.848 2.065 ↓ 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=5) (actual time=0.656..5.163 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=746
16. 0.218 0.218 ↑ 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=1.088..1.088 rows=9,921 loops=1)

  • Index Cond: (login = 525608)
17. 1.604 1.811 ↓ 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=5) (actual time=1.318..9.056 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
18. 0.207 0.207 ↓ 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.034..1.034 rows=9,093 loops=1)

  • Index Cond: (login = 525608)
19. 1.292 1.445 ↓ 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=5) (actual time=1.005..7.223 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
20. 0.153 0.153 ↑ 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.763..0.763 rows=6,474 loops=1)

  • Index Cond: (login = 525608)
21. 1.111 1.253 ↓ 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=5) (actual time=0.859..6.265 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
22. 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)
23. 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=5) (actual time=0.011..0.011 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))
24. 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.009..0.009 rows=0 loops=1)

  • Index Cond: (login = 525608)
25. 0.070 0.073 ↑ 52.0 1 1 / 5

Parallel Bitmap Heap Scan on mt_trades_s1_2019_09 (cost=2.28..110.36 rows=52 width=5) (actual time=0.361..0.363 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
26. 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.038 ms
Execution time : 71.893 ms