explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WXKw

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 20,180.928 ↑ 1.0 1 1

Finalize Aggregate (cost=122,593.62..122,593.63 rows=1 width=8) (actual time=20,180.928..20,180.928 rows=1 loops=1)

2. 49.490 20,200.719 ↓ 1.5 3 1

Gather (cost=122,593.40..122,593.61 rows=2 width=8) (actual time=20,180.539..20,200.719 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 92.189 20,151.229 ↑ 1.0 1 3

Partial Aggregate (cost=121,593.40..121,593.41 rows=1 width=8) (actual time=20,151.229..20,151.229 rows=1 loops=3)

4. 93.239 20,059.040 ↑ 1.3 1,007,635 3

Append (cost=0.13..118,424.38 rows=1,267,611 width=0) (actual time=11,464.337..20,059.040 rows=1,007,635 loops=3)

5. 0.019 0.019 ↑ 1.0 1 3

Parallel Index Only Scan using test_pk on bet_facts_20190301 (cost=0.13..12.15 rows=1 width=0) (actual time=0.018..0.019 rows=1 loops=3)

  • Heap Fetches: 2
6. 2,756.846 19,965.632 ↑ 1.3 1,007,634 3

Parallel Bitmap Heap Scan on bet_facts_20190302 (cost=58,053.60..118,256.85 rows=1,266,125 width=0) (actual time=17,210.823..19,965.632 rows=1,007,634 loops=3)

  • Heap Blocks: exact=15664
7. 17,208.786 17,208.786 ↓ 1.0 3,039,436 1

Bitmap Index Scan on bet_facts_20190302_trading_type_id_idx (cost=0.00..57,293.93 rows=3,038,699 width=0) (actual time=17,208.786..17,208.786 rows=3,039,436 loops=1)

8. 0.046 0.054 ↓ 0.0 0 3

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

9. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

10. 0.000 0.005 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on bet_facts_20190304 (cost=5.62..17.26 rows=165 width=0) (actual time=0.005..0.005 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.003 0.005 ↓ 0.0 0 3

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

13. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

14. 0.000 0.004 ↓ 0.0 0 3

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

15. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

16. 0.010 0.012 ↓ 0.0 0 3

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

17. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

18. 0.003 0.009 ↓ 0.0 0 3

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

19. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

20. 0.003 0.007 ↓ 0.0 0 3

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

21. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

22. 0.036 0.042 ↓ 0.0 0 3

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

23. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

24. 0.002 0.012 ↓ 0.0 0 3

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

25. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)