explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5Hcd

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

Finalize Aggregate (cost=64,478.32..64,478.33 rows=1 width=8) (actual time=404.033..404.033 rows=1 loops=1)

2. 32.649 432.387 ↓ 1.5 3 1

Gather (cost=64,478.11..64,478.32 rows=2 width=8) (actual time=403.897..432.387 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 86.997 399.738 ↑ 1.0 1 3

Partial Aggregate (cost=63,478.11..63,478.12 rows=1 width=8) (actual time=399.738..399.738 rows=1 loops=3)

4. 94.351 312.741 ↑ 1.3 1,007,635 3

Append (cost=0.00..60,309.08 rows=1,267,611 width=0) (actual time=0.018..312.741 rows=1,007,635 loops=3)

5. 0.004 0.004 ↑ 1.0 1 3

Parallel Seq Scan on bet_facts_20190301 (cost=0.00..1.01 rows=1 width=0) (actual time=0.003..0.004 rows=1 loops=3)

6. 218.386 218.386 ↑ 1.3 1,007,634 3

Parallel Seq Scan on bet_facts_20190302 (cost=0.00..60,203.25 rows=1,266,125 width=0) (actual time=0.020..218.386 rows=1,007,634 loops=3)

7. 0.000 0.000 ↓ 0.0 0 3

Parallel Seq Scan on bet_facts_20190303 (cost=0.00..11.65 rows=165 width=0) (actual time=0.000..0.000 rows=0 loops=3)

8. 0.000 0.000 ↓ 0.0 0 3

Parallel Seq Scan on bet_facts_20190304 (cost=0.00..11.65 rows=165 width=0) (actual time=0.000..0.000 rows=0 loops=3)

9. 0.000 0.000 ↓ 0.0 0 3

Parallel Seq Scan on bet_facts_20190305 (cost=0.00..11.65 rows=165 width=0) (actual time=0.000..0.000 rows=0 loops=3)

10. 0.000 0.000 ↓ 0.0 0 3

Parallel Seq Scan on bet_facts_20190306 (cost=0.00..11.65 rows=165 width=0) (actual time=0.000..0.000 rows=0 loops=3)

11. 0.000 0.000 ↓ 0.0 0 3

Parallel Seq Scan on bet_facts_20190307 (cost=0.00..11.65 rows=165 width=0) (actual time=0.000..0.000 rows=0 loops=3)

12. 0.000 0.000 ↓ 0.0 0 3

Parallel Seq Scan on bet_facts_20190308 (cost=0.00..11.65 rows=165 width=0) (actual time=0.000..0.000 rows=0 loops=3)

13. 0.000 0.000 ↓ 0.0 0 3

Parallel Seq Scan on bet_facts_20190309 (cost=0.00..11.65 rows=165 width=0) (actual time=0.000..0.000 rows=0 loops=3)

14. 0.000 0.000 ↓ 0.0 0 3

Parallel Seq Scan on bet_facts_20190310 (cost=0.00..11.65 rows=165 width=0) (actual time=0.000..0.000 rows=0 loops=3)

15. 0.000 0.000 ↓ 0.0 0 3

Parallel Seq Scan on bet_facts_20190311 (cost=0.00..11.65 rows=165 width=0) (actual time=0.000..0.000 rows=0 loops=3)