explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fhQ4

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.249 34.093 ↓ 2.0 10 1

Seq Scan on aircraftprefs ap (cost=3.75..29,849.06 rows=5 width=306) (actual time=4.546..34.093 rows=10 loops=1)

  • Filter: (NOT deletedflag)
2.          

Initplan (forSeq 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 (forSeq 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.052 0.052 ↑ 1.0 1 4

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

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

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

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

Initplan (forSeq Scan)

10. 0.005 0.005 ↑ 1.0 1 5

Result (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 (forSeq Scan)

13. 0.000 0.000 ↓ 0.0 0

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

14. 0.000 0.000 ↓ 0.0 0

Limit (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 (forSeq Scan)

18. 0.000 0.000 ↓ 0.0 0

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

19. 4.360 4.362 ↑ 105.0 1 1

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

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

Initplan (forSeq Scan)

21. 0.002 0.002 ↑ 1.0 1 1

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

22. 15.612 15.616 ↑ 142.0 1 4

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

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

Initplan (forSeq Scan)

24. 0.004 0.004 ↑ 1.0 1 4

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

25. 0.004 0.004 ↑ 1.0 1 1

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

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

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

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

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

28. 0.000 0.000 ↓ 0.0 0

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

29. 0.000 0.000 ↓ 0.0 0

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

30. 0.000 0.000 ↓ 0.0 0

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

31. 0.000 0.000 ↓ 0.0 0

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

32. 0.000 0.000 ↓ 0.0 0

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