explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D8pE : Optimization for: plan #rgHU

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 21,270.996 195,268.090 ↓ 1.3 7,908,829 1

Sort (cost=10,243,883.850..10,259,363.880 rows=6,192,010 width=122) (actual time=188,470.130..195,268.090 rows=7,908,829 loops=1)

  • Sort Key: quebec.six_romeo
  • Sort Method: external merge Disk: 619,240kB
2. 11,840.143 173,997.094 ↓ 1.3 7,908,829 1

Unique (cost=8,199,688.210..8,339,008.430 rows=6,192,010 width=122) (actual time=139,227.922..173,997.094 rows=7,908,829 loops=1)

3. 106,399.219 162,156.951 ↓ 1.3 8,125,595 1

Sort (cost=8,199,688.210..8,215,168.230 rows=6,192,010 width=122) (actual time=139,227.918..162,156.951 rows=8,125,595 loops=1)

  • Sort Key: (false), (false), quebec.charlie, quebec.six_romeo, quebec.tango, ((quebec.whiskey)::text), quebec.xray, quebec.six_november
  • Sort Method: external merge Disk: 631,416kB
4. 8,076.703 55,757.732 ↓ 1.3 8,125,595 1

Append (cost=0.000..6,294,812.790 rows=6,192,010 width=122) (actual time=0.056..55,757.732 rows=8,125,595 loops=1)

5. 1,498.511 1,498.511 ↓ 1.0 1,263,820 1

Seq Scan on quebec (cost=0.000..112,535.240 rows=1,263,785 width=107) (actual time=0.053..1,498.511 rows=1,263,820 loops=1)

  • Filter: (six_romeo >= 'five'::timestamp without time zone)
6. 11,386.954 46,182.518 ↓ 1.4 6,861,775 1

Hash Join (cost=733,150.970..6,120,357.450 rows=4,928,225 width=102) (actual time=16,943.744..46,182.518 rows=6,861,775 loops=1)

  • Hash Cond: (four.sierra = charlie.sierra)
7. 12,155.164 32,804.374 ↓ 1.4 7,151,241 1

Hash Join (cost=676,178.960..5,918,888.560 rows=5,053,726 width=21) (actual time=14,785.016..32,804.374 rows=7,151,241 loops=1)

  • Hash Cond: (four.lima = uniform.lima)
8. 5,895.131 6,690.028 ↓ 1.4 7,151,241 1

Bitmap Heap Scan on four (cost=97,914.950..5,118,655.560 rows=5,053,726 width=18) (actual time=802.818..6,690.028 rows=7,151,241 loops=1)

  • Recheck Cond: (six_romeo >= 'five'::timestamp without time zone)
  • Rows Removed by Index Recheck: 3,467
  • Heap Blocks: exact=30,720 lossy=79,131
9. 794.897 794.897 ↓ 1.4 7,151,241 1

Bitmap Index Scan on yankee (cost=0.000..96,651.520 rows=5,053,726 width=0) (actual time=794.896..794.897 rows=7,151,241 loops=1)

  • Index Cond: (six_romeo >= 'five'::timestamp without time zone)
10. 6,786.489 13,959.182 ↑ 1.0 8,745,922 1

Hash (cost=426,184.450..426,184.450 rows=8,748,845 width=11) (actual time=13,959.181..13,959.182 rows=8,745,922 loops=1)

  • Buckets: 131,072 Batches: 256 Memory Usage: 2,507kB
11. 7,172.693 7,172.693 ↑ 1.0 8,745,922 1

Seq Scan on uniform (cost=0.000..426,184.450 rows=8,748,845 width=11) (actual time=0.053..7,172.693 rows=8,745,922 loops=1)

12. 1,064.603 1,991.190 ↑ 1.0 1,567,097 1

Hash (cost=26,645.560..26,645.560 rows=1,568,356 width=25) (actual time=1,991.189..1,991.190 rows=1,567,097 loops=1)

  • Buckets: 65,536 Batches: 32 Memory Usage: 3,355kB
13. 926.587 926.587 ↑ 1.0 1,567,097 1

Seq Scan on charlie (cost=0.000..26,645.560 rows=1,568,356 width=25) (actual time=0.014..926.587 rows=1,567,097 loops=1)