explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TNI7

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

Finalize Aggregate (cost=64,396.05..64,396.06 rows=1 width=8) (actual time=363.806..363.806 rows=1 loops=1)

2. 32.817 392.113 ↓ 1.5 3 1

Gather (cost=64,395.83..64,396.04 rows=2 width=8) (actual time=363.673..392.113 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 82.589 359.296 ↑ 1.0 1 3

Partial Aggregate (cost=63,395.83..63,395.84 rows=1 width=8) (actual time=359.295..359.296 rows=1 loops=3)

4. 94.823 276.707 ↑ 1.3 1,007,635 3

Append (cost=0.00..60,243.26 rows=1,261,028 width=0) (actual time=0.018..276.707 rows=1,007,635 loops=3)

5. 0.003 0.003 ↑ 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.003 rows=1 loops=3)

6. 181.881 181.881 ↑ 1.2 1,007,634 3

Parallel Seq Scan on bet_facts_20190302 (cost=0.00..60,137.43 rows=1,259,542 width=0) (actual time=0.016..181.881 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)

Planning time : 1.993 ms
Execution time : 392.216 ms