Result: 8YqG : Optimization for: plan #XQWu

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.275 29.808 ↓ 2.0 10 1

Seq Scan on aircraftprefs ap (cost=3.75..29,849.15 rows=5 width=306) (actual time=2.892..29.808 rows=10 loops=1)

• Filter: (NOT deletedflag)
2.

Initplan (for Seq Scan)

3. 0.000 0.000 ↓ 0.0 0

Seq Scan on prefs (cost=0.00..1.88 rows=1 width=14) (never executed)

• Filter: (pref_id = 2)
4. 0.000 0.000 ↓ 0.0 0

Seq Scan on prefs prefs_1 (cost=0.00..1.88 rows=1 width=14) (never executed)

• Filter: (pref_id = 2)
5.

SubPlan (for Seq Scan)

6. 0.050 0.050 ↑ 1.0 1 10

Seq Scan on aircraft (cost=0.00..5.97 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=10)

• Filter: (aircraft_id = ap.ac_id)
• Rows Removed by Filter: 31
7. 0.060 0.060 ↑ 1.0 1 4

Index Scan using aptidentifier_idx on airport (cost=0.29..8.30 rows=1 width=5) (actual time=0.015..0.015 rows=1 loops=4)

• Index Cond: (identifier = ap.airport_id)
8. 11.495 11.500 ↑ 66.0 1 5

Seq Scan on aptfbo (cost=0.01..790.25 rows=66 width=19) (actual time=1.182..2.300 rows=1 loops=5)

• Filter: ((aptfbo_id)::text = \$3)
• Rows Removed by Filter: 13159
9.

Initplan (for Seq Scan)

10. 0.005 0.005 ↑ 1.0 1 5

(cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=5)

11. 0.000 0.000 ↓ 0.0 0

Seq Scan on aptcatering (cost=0.01..102.50 rows=13 width=15) (never executed)

• Filter: ((aptcatering_id)::text = \$5)
12.

Initplan (for Seq Scan)

13. 0.000 0.000 ↓ 0.0 0

(cost=0.00..0.01 rows=1 width=0) (never executed)

14. 0.000 0.000 ↓ 0.0 0

(cost=0.28..8.29 rows=1 width=7) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Index Scan using fuel_icao_idx on aptfuel (cost=0.28..8.29 rows=1 width=7) (never executed)

• Index Cond: (icao = split_part(ap.svcprovider_id, '^'::text, 1))
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on apthotel (cost=0.01..3,121.26 rows=282 width=26) (never executed)

• Filter: ((apthotel_id)::text = \$8)
17.

Initplan (for Seq Scan)

18. 0.000 0.000 ↓ 0.0 0

(cost=0.00..0.01 rows=1 width=0) (never executed)

19. 3.306 3.308 ↑ 105.0 1 1

Seq Scan on apttransport (cost=0.01..890.30 rows=105 width=24) (actual time=2.417..3.308 rows=1 loops=1)

• Filter: ((apttransport_id)::text = \$10)
• Rows Removed by Filter: 20990
20.

Initplan (for Seq Scan)

21. 0.002 0.002 ↑ 1.0 1 1

(cost=0.00..0.01 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=1)

22. 14.576 14.580 ↑ 142.0 1 4

Seq Scan on aptotherservice (cost=0.01..1,039.21 rows=142 width=21) (actual time=3.645..3.645 rows=1 loops=4)

• Filter: ((aptother_id)::text = \$12)
• Rows Removed by Filter: 28467
23.

Initplan (for Seq Scan)

24. 0.004 0.004 ↑ 1.0 1 4

(cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=4)

25. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on customer (cost=0.00..1.23 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=1)

• Filter: (customer_id = ap.customer_id)
• Rows Removed by Filter: 18
26. 0.030 0.030 ↑ 1.0 1 10

Seq Scan on acconfig (cost=0.00..1.41 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=10)

• Filter: (acconfig_id = ap.acconfig_id)
• Rows Removed by Filter: 34
27. 0.000 0.000 ↓ 0.0 0

(cost=0.00..0.01 rows=1 width=0) (never executed)

28. 0.000 0.000 ↓ 0.0 0

(cost=0.00..0.01 rows=1 width=0) (never executed)

29. 0.000 0.000 ↓ 0.0 0

(cost=0.00..0.01 rows=1 width=0) (never executed)

30. 0.000 0.000 ↓ 0.0 0

(cost=0.00..0.01 rows=1 width=0) (never executed)

31. 0.000 0.000 ↓ 0.0 0

(cost=0.00..0.01 rows=1 width=0) (never executed)

32. 0.000 0.000 ↓ 0.0 0

(cost=0.00..0.01 rows=1 width=0) (never executed)

 Total runtime : 29.992 ms