explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5ELR

Settings
# exclusive inclusive rows x rows loops node
1. 395.914 2,407.673 ↓ 6.3 655,706 1

Gather (cost=33,047.530..65,117.880 rows=104,448 width=512) (actual time=1,790.943..2,407.673 rows=655,706 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 548.605 2,011.759 ↓ 5.0 218,569 3

Parallel Hash Left Join (cost=32,047.530..53,673.080 rows=43,520 width=512) (actual time=1,730.565..2,011.759 rows=218,569 loops=3)

  • Hash Cond: ((tango.quebec_seven)::text = (victor_hotel.quebec_seven)::text)
3. 519.584 1,211.859 ↓ 5.0 218,569 3

Hash Join (cost=11,285.750..25,217.060 rows=43,520 width=207) (actual time=632.658..1,211.859 rows=218,569 loops=3)

  • Hash Cond: ((tango.quebec_seven)::text = (kilo_golf.papa)::text)
4. 63.587 63.587 ↑ 1.1 97,413 3

Parallel Seq Scan on uniform tango (cost=0.000..6,850.670 rows=109,267 width=178) (actual time=0.134..63.587 rows=97,413 loops=3)

5. 312.350 628.688 ↓ 6.3 655,706 3

Hash (cost=9,266.150..9,266.150 rows=104,448 width=29) (actual time=628.688..628.688 rows=655,706 loops=3)

  • Buckets: 65536 (originally 65536) Batches: 16 (originally 2) Memory Usage: 3585kB
6. 295.944 316.338 ↓ 6.3 655,706 3

Nested Loop (cost=0.700..9,266.150 rows=104,448 width=29) (actual time=0.238..316.338 rows=655,706 loops=3)

7. 0.029 0.043 ↑ 1.0 10 3

HashAggregate (cost=0.150..0.250 rows=10 width=32) (actual time=0.026..0.043 rows=10 loops=3)

  • Group Key: "quebec_kilo".victor_juliet1
8. 0.014 0.014 ↑ 1.0 10 3

Values Scan on "*VALUES*" (cost=0.000..0.130 rows=10 width=32) (actual time=0.006..0.014 rows=10 loops=3)

9. 20.351 20.351 ↓ 6.3 65,571 30

Index Only Scan using delta on hotel kilo_golf (cost=0.550..822.140 rows=10,445 width=29) (actual time=0.048..20.351 rows=65,571 loops=30)

  • Index Cond: (kilo_whiskey = "quebec_kilo".victor_juliet1)
  • Heap Fetches: 0
10. 150.007 251.295 ↑ 1.2 97,435 3

Parallel Hash (cost=14,125.680..14,125.680 rows=121,768 width=317) (actual time=251.295..251.295 rows=97,435 loops=3)

  • Buckets: 16384 Batches: 32 Memory Usage: 1664kB
11. 101.288 101.288 ↑ 1.2 97,435 3

Parallel Seq Scan on five victor_hotel (cost=0.000..14,125.680 rows=121,768 width=317) (actual time=0.150..101.288 rows=97,435 loops=3)

Planning time : 4.979 ms
Execution time : 2,440.114 ms