explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vmDr

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

Finalize Aggregate (cost=113,497.92..113,497.93 rows=1 width=8) (actual time=732.113..732.113 rows=1 loops=1)

2. 34.512 761.017 ↓ 1.5 3 1

Gather (cost=113,497.71..113,497.92 rows=2 width=8) (actual time=731.744..761.017 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 77.727 726.505 ↑ 1.0 1 3

Partial Aggregate (cost=112,497.71..112,497.72 rows=1 width=8) (actual time=726.505..726.505 rows=1 loops=3)

4. 84.102 648.778 ↑ 1.3 1,007,635 3

Append (cost=0.13..109,344.99 rows=1,261,089 width=4) (actual time=159.625..648.778 rows=1,007,635 loops=3)

5. 0.015 0.015 ↑ 1.0 1 3

Parallel Index Only Scan using bet_facts_20190301_bet_number_idx on bet_facts_20190301 (cost=0.13..12.15 rows=1 width=4) (actual time=0.014..0.015 rows=1 loops=3)

  • Heap Fetches: 2
6. 328.577 564.583 ↑ 1.3 1,007,634 3

Parallel Bitmap Heap Scan on bet_facts_20190302 (cost=49,039.43..109,177.46 rows=1,259,603 width=4) (actual time=241.664..564.583 rows=1,007,634 loops=3)

  • Heap Blocks: exact=17863
7. 236.006 236.006 ↑ 1.0 3,022,902 1

Bitmap Index Scan on bet_facts_20190302_bet_number_idx (cost=0.00..48,283.67 rows=3,023,047 width=0) (actual time=236.006..236.006 rows=3,022,902 loops=1)

8. 0.020 0.027 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on bet_facts_20190303 (cost=5.62..17.26 rows=165 width=4) (actual time=0.027..0.027 rows=0 loops=3)

9. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on bet_facts_20190303_bet_number_idx (cost=0.00..5.55 rows=280 width=0) (actual time=0.007..0.007 rows=0 loops=1)

10. 0.002 0.007 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on bet_facts_20190304 (cost=5.62..17.26 rows=165 width=4) (actual time=0.007..0.007 rows=0 loops=3)

11. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on bet_facts_20190304_bet_number_idx (cost=0.00..5.55 rows=280 width=0) (actual time=0.005..0.005 rows=0 loops=1)

12. 0.000 0.004 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on bet_facts_20190305 (cost=5.62..17.26 rows=165 width=4) (actual time=0.004..0.004 rows=0 loops=3)

13. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on bet_facts_20190305_bet_number_idx (cost=0.00..5.55 rows=280 width=0) (actual time=0.004..0.004 rows=0 loops=1)

14. 0.014 0.016 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on bet_facts_20190306 (cost=5.62..17.26 rows=165 width=4) (actual time=0.016..0.016 rows=0 loops=3)

15. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on bet_facts_20190306_bet_number_idx (cost=0.00..5.55 rows=280 width=0) (actual time=0.002..0.002 rows=0 loops=1)

16. 0.000 0.004 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on bet_facts_20190307 (cost=5.62..17.26 rows=165 width=4) (actual time=0.004..0.004 rows=0 loops=3)

17. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on bet_facts_20190307_bet_number_idx (cost=0.00..5.55 rows=280 width=0) (actual time=0.004..0.004 rows=0 loops=1)

18. 0.001 0.003 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on bet_facts_20190308 (cost=5.62..17.26 rows=165 width=4) (actual time=0.003..0.003 rows=0 loops=3)

19. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on bet_facts_20190308_bet_number_idx (cost=0.00..5.55 rows=280 width=0) (actual time=0.002..0.002 rows=0 loops=1)

20. 0.009 0.011 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on bet_facts_20190309 (cost=5.62..17.26 rows=165 width=4) (actual time=0.011..0.011 rows=0 loops=3)

21. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on bet_facts_20190309_bet_number_idx (cost=0.00..5.55 rows=280 width=0) (actual time=0.002..0.002 rows=0 loops=1)

22. 0.000 0.004 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on bet_facts_20190310 (cost=5.62..17.26 rows=165 width=4) (actual time=0.004..0.004 rows=0 loops=3)

23. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on bet_facts_20190310_bet_number_idx (cost=0.00..5.55 rows=280 width=0) (actual time=0.004..0.004 rows=0 loops=1)

24. 0.000 0.002 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on bet_facts_20190311 (cost=5.62..17.26 rows=165 width=4) (actual time=0.002..0.002 rows=0 loops=3)

25. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on bet_facts_20190311_bet_number_idx (cost=0.00..5.55 rows=280 width=0) (actual time=0.002..0.002 rows=0 loops=1)

Planning time : 2.260 ms
Execution time : 761.196 ms