explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dC2eN

Settings
# exclusive inclusive rows x rows loops node
1. 1.560 79,336.782 ↓ 17.1 3,415 1

Subquery Scan on five (cost=2,389,330.030..2,392,576.220 rows=200 width=66) (actual time=79,332.644..79,336.782 rows=3,415 loops=1)

2. 1.685 79,335.222 ↓ 17.1 3,415 1

Unique (cost=2,389,330.030..2,392,574.220 rows=200 width=70) (actual time=79,332.642..79,335.222 rows=3,415 loops=1)

3. 5.157 79,333.537 ↑ 160.7 4,038 1

Sort (cost=2,389,330.030..2,390,952.130 rows=648,838 width=70) (actual time=79,332.641..79,333.537 rows=4,038 loops=1)

  • Sort Key: oscar.zulu, oscar.victor, sierra.golf
  • Sort Method: quicksort Memory: 716kB
4. 366.654 79,328.380 ↑ 160.7 4,038 1

Nested Loop Left Join (cost=1,505,250.620..2,300,078.840 rows=648,838 width=70) (actual time=66,439.370..79,328.380 rows=4,038 loops=1)

  • Join Filter: ((oscar.victor)::text ~~* (('xray'::text || (sierra.hotel)::text) || 'xray'::text))
  • Rows Removed by Join Filter: 197625
5. 1,702.119 78,915.849 ↑ 183.9 3,529 1

Group (cost=1,505,250.620..1,553,913.430 rows=648,838 width=48) (actual time=66,439.148..78,915.849 rows=3,529 loops=1)

  • Group Key: oscar.victor, oscar.zulu
6. 73,519.032 77,213.730 ↑ 1.0 6,354,486 1

Sort (cost=1,505,250.620..1,521,471.560 rows=6,488,374 width=48) (actual time=66,439.145..77,213.730 rows=6,354,486 loops=1)

  • Sort Key: oscar.victor, oscar.zulu
  • Sort Method: external merge Disk: 389648kB
7. 3,694.698 3,694.698 ↑ 1.0 6,354,486 1

Seq Scan on oscar (cost=0.000..371,920.740 rows=6,488,374 width=48) (actual time=0.050..3,694.698 rows=6,354,486 loops=1)

8. 45.846 45.877 ↑ 1.0 57 3,529

Materialize (cost=0.000..1.850 rows=57 width=31) (actual time=0.000..0.013 rows=57 loops=3,529)

9. 0.031 0.031 ↑ 1.0 57 1

Seq Scan on sierra (cost=0.000..1.570 rows=57 width=31) (actual time=0.015..0.031 rows=57 loops=1)