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. 2,270.351 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. 3,870.698 8,063.768 ↓ 1.5 32,426 3 / 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
4. 4,193.070 4,193.070 ↑ 1.3 5,300,763 3 / 3

Parallel Index Only Scan using address__aln_country__aln_postal_code__aln_idx on address__aln (cost=0.56..232,493.34 rows=6,625,954 width=22) (actual time=0.076..4,193.070 rows=5,300,763 loops=3)

  • Heap Fetches: 0
Planning time : 0.259 ms
Execution time : 10,522.669 ms