explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lmM7

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

Finalize Aggregate (cost=64,396.80..64,396.81 rows=1 width=8) (actual time=454.624..454.624 rows=1 loops=1)

2. 33.191 483.580 ↓ 1.5 3 1

Gather (cost=64,396.59..64,396.80 rows=2 width=8) (actual time=454.496..483.580 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 79.189 450.389 ↑ 1.0 1 3

Partial Aggregate (cost=63,396.59..63,396.60 rows=1 width=8) (actual time=450.389..450.389 rows=1 loops=3)

4. 84.358 371.200 ↑ 1.3 1,007,635 3

Append (cost=0.00..60,243.86 rows=1,261,089 width=4) (actual time=0.014..371.200 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=4) (actual time=0.003..0.003 rows=1 loops=3)

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

Parallel Seq Scan on bet_facts_20190302 (cost=0.00..60,138.03 rows=1,259,603 width=4) (actual time=0.013..286.839 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=4) (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=4) (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=4) (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=4) (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=4) (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=4) (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=4) (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=4) (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=4) (actual time=0.000..0.000 rows=0 loops=3)