explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lb8S

Settings
# exclusive inclusive rows x rows loops node
1. 123.851 10,457.970 ↓ 3.5 75,009 1

Group (cost=1,000.58..271,815.37 rows=21,558 width=22) (actual time=4.076..10,457.970 rows=75,009 loops=1)

  • Group Key: country__aln, postal_code__aln
2. 0.000 10,334.119 ↓ 2.3 97,279 1

Gather Merge (cost=1,000.58..271,599.79 rows=43,116 width=22) (actual time=4.074..10,334.119 rows=97,279 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 24,191.304 24,191.304 ↓ 1.5 32,426 3

Group (cost=0.56..265,623.11 rows=21,558 width=22) (actual time=0.080..8,063.768 rows=32,426 loops=3)

  • Group Key: country__aln, postal_code__aln
  • -> Parallel Index Only Scan using address__aln_country__aln_postal_code__aln_idx on address__aln (cost=0.56..232493.34 rows=6625954 width=22) (actual time=0.076..4193.070 rows=53
  • Heap Fetches: 0
Planning time : 0.259 ms
Execution time : 10,522.669 ms