explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wEq

Settings
# exclusive inclusive rows x rows loops node
1. 48,983.792 850,388.739 ↑ 957.7 99,048 1

GroupAggregate (cost=28,388,031.720..30,522,399.590 rows=94,860,794 width=65) (actual time=698,652.667..850,388.739 rows=99,048 loops=1)

  • Group Key: hotel_quebec.november_lima, romeo_three.hotel_romeo, yankee.hotel_romeo
2. 725,869.854 801,404.947 ↓ 1.1 102,053,551 1

Sort (cost=28,388,031.720..28,625,183.710 rows=94,860,794 width=82) (actual time=698,643.884..801,404.947 rows=102,053,551 loops=1)

  • Sort Key: hotel_quebec.november_lima, romeo_three.hotel_romeo, yankee.hotel_romeo
  • Sort Method: external merge Disk: 9214256kB
3. 38,294.590 75,535.093 ↓ 1.1 102,053,551 1

Hash Join (cost=627,457.880..2,201,591.950 rows=94,860,794 width=82) (actual time=35,271.629..75,535.093 rows=102,053,551 loops=1)

  • Hash Cond: ((yankee."romeo_romeo")::text = (romeo_three.uniform)::text)
4. 0.000 2,254.610 ↓ 1.0 558,299 1

Gather (cost=1,053.820..174,118.110 rows=551,391 width=91) (actual time=15.491..2,254.610 rows=558,299 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
5. 2,453.492 2,503.859 ↑ 1.2 279,150 2

Nested Loop (cost=53.820..117,979.010 rows=324,348 width=91) (actual time=10.930..2,503.859 rows=279,150 loops=2)

6. 29.668 50.189 ↓ 1.2 12,528 2

Hash Join (cost=53.260..4,256.040 rows=10,738 width=46) (actual time=8.797..50.189 rows=12,528 loops=2)

  • Hash Cond: ((kilo_foxtrot."kilo_charlie")::text = (hotel_quebec.uniform)::text)
7. 20.247 20.247 ↑ 1.2 63,821 2

Parallel Seq Scan on five kilo_foxtrot (cost=0.000..3,813.840 rows=75,084 width=50) (actual time=0.006..20.247 rows=63,821 loops=2)

8. 0.062 0.274 ↓ 1.1 137 2

Hash (cost=51.660..51.660 rows=128 width=46) (actual time=0.274..0.274 rows=137 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
9. 0.212 0.212 ↓ 1.1 137 2

Seq Scan on golf hotel_quebec (cost=0.000..51.660 rows=128 width=46) (actual time=0.067..0.212 rows=137 loops=2)

  • Filter: ((("papa")::text = 'lima'::text) AND (("papa")::text <> november_november ('romeo_lima'::text[])))
  • Rows Removed by Filter: 758
10. 0.178 0.178 ↑ 4.3 22 25,056

Index Scan using alpha on hotel_oscar yankee (cost=0.560..9.650 rows=94 width=95) (actual time=0.057..0.178 rows=22 loops=25,056)

  • Index Cond: (("charlie")::text = (kilo_foxtrot.uniform)::text)
11. 867.289 34,985.893 ↑ 1.0 1,413,514 1

Hash (cost=596,311.140..596,311.140 rows=1,413,514 width=41) (actual time=34,985.893..34,985.893 rows=1,413,514 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 3641kB
12. 34,118.604 34,118.604 ↑ 1.0 1,413,514 1

Seq Scan on romeo_two romeo_three (cost=0.000..596,311.140 rows=1,413,514 width=41) (actual time=0.846..34,118.604 rows=1,413,514 loops=1)