explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lGh

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 431,103.169 ↑ 1.0 1 1

Limit (cost=3,168,520.30..3,168,520.31 rows=1 width=16) (actual time=431,103.168..431,103.169 rows=1 loops=1)

2. 0.014 431,103.166 ↑ 1.0 1 1

Finalize Aggregate (cost=3,168,520.30..3,168,520.31 rows=1 width=16) (actual time=431,103.166..431,103.166 rows=1 loops=1)

3. 12,524.612 431,103.152 ↓ 1.3 4 1

Gather (cost=3,168,519.97..3,168,520.28 rows=3 width=16) (actual time=431,103.093..431,103.152 rows=4 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
  • -> Partial Aggregate (cost=3167519.97..3167519.98 rows=1 width=16) (actual time=431090.704..431090.705 rows=1 loops
  • -> Hash Join (cost=481.24..3133041.58 rows=6895679 width=8) (actual time=10.813..427582.490 rows=9074096 loop
  • Hash Cond: (sending_registry.campaign_id = campaign.id)
  • -> Append (cost=0.00..3013396.22 rows=13388622 width=12) (actual time=0.337..421218.739 rows=10367170 l
  • -> Parallel Seq Scan on sending_registry (cost=0.00..0.00 rows=1 width=12) (actual time=0.001..0.
4. 92,815.026 92,815.026 ↑ 1.2 2,627,850 4

Parallel Seq Scan on sending_registry_2018_08 (cost=0.00..772,783.65 rows=3,250,965 width=12) (actual time=0.334..92,815.026 rows=2,627,850 loops=4)

5. 50,735.218 50,735.218 ↑ 1.3 1,534,429 4

Parallel Seq Scan on sending_registry_2018_09 (cost=0.00..432,082.28 rows=2,006,528 width=12) (actual time=0.414..50,735.218 rows=1,534,429 loops=4)

6. 69,965.088 69,965.088 ↑ 1.3 1,948,203 4

Parallel Seq Scan on sending_registry_2018_10 (cost=0.00..567,198.70 rows=2,554,370 width=12) (actual time=3.214..69,965.088 rows=1,948,203 loops=4)

7. 116,559.620 116,559.620 ↑ 1.3 1,824,856 4

Parallel Seq Scan on sending_registry_2018_11 (cost=0.00..525,771.15 rows=2,394,515 width=12) (actual time=2.138..116,559.620 rows=1,824,856 loops=4)

8. 79,590.202 79,590.202 ↑ 1.3 2,105,164 4

Parallel Seq Scan on sending_registry_2018_12 (cost=0.00..618,011.37 rows=2,760,737 width=12) (actual time=6.649..79,590.202 rows=2,105,164 loops=4)

9. 8,903.245 8,903.245 ↑ 1.3 326,669 4

Parallel Seq Scan on sending_registry_2019_01 (cost=0.00..97,549.06 rows=421,506 width=12) (actual time=3.874..8,903.245 rows=326,669 loops=4)

10. 1.410 10.141 ↓ 1.1 3,149 4

Hash (cost=444.42..444.42 rows=2,945 width=4) (actual time=10.141..10.141 rows=3,149 loops=4)

  • Buckets: 4096 Batches: 1 Memory Usage: 143kB
11. 8.731 8.731 ↓ 1.1 3,149 4

Seq Scan on campaign (cost=0.00..444.42 rows=2,945 width=4) (actual time=0.039..8.731 rows=3,149 loops=4)

  • Filter: (((message_format)::text = 'SAT'::text) AND (company_id = ANY ('{20,28,33,34,35,37,38,27,45,46,51,54,56,58,60,61,63,76,77,78}'::integer[])))
  • Rows Removed by Filter: 2711