explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uYMJ : Optimization for: Optimization for: Optimization for: plan #fhQ4; plan #NZTB; plan #GRG

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.019 0.381 ↓ 2.0 10 1

Sort (cost=8,299.40..8,299.42 rows=5 width=306) (actual time=0.381..0.381 rows=10 loops=1)

  • Sort Key: ap.acpref_id
  • Sort Method: quicksort Memory: 28kB
2.          

Initplan (forSort)

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. 0.137 0.362 ↓ 2.0 10 1

Seq Scan on aircraftprefs ap (cost=0.00..8,295.59 rows=5 width=306) (actual time=0.103..0.362 rows=10 loops=1)

  • Filter: (NOT deletedflag)
6.          

SubPlan (forSeq Scan)

7. 0.040 0.040 ↑ 1.0 1 10

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

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

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

  • Index Cond: (identifier = ap.airport_id)
9. 0.010 0.090 ↑ 66.0 1 5

Bitmap Heap Scan on aptfbo (cost=4.82..194.58 rows=66 width=19) (actual time=0.018..0.018 rows=1 loops=5)

  • Recheck Cond: ((aptfbo_id)::text = $3)
10.          

Initplan (forBitmap Heap Scan)

11. 0.045 0.045 ↑ 1.0 1 5

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

12. 0.035 0.035 ↑ 66.0 1 5

Bitmap Index Scan on aptfbo_id_text_idx (cost=0.00..4.79 rows=66 width=0) (actual time=0.007..0.007 rows=1 loops=5)

  • Index Cond: ((aptfbo_id)::text = $3)
13. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on aptcatering (cost=4.40..36.11 rows=13 width=15) (never executed)

  • Recheck Cond: ((aptcatering_id)::text = $5)
14.          

Initplan (forBitmap Heap Scan)

15. 0.000 0.000 ↓ 0.0 0

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

16. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on aptcatering_id_text_idx (cost=0.00..4.38 rows=13 width=0) (never executed)

  • Index Cond: ((aptcatering_id)::text = $5)
17. 0.000 0.000 ↓ 0.0 0

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

18. 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))
19. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on apthotel (cost=6.55..805.82 rows=289 width=26) (never executed)

  • Recheck Cond: ((apthotel_id)::text = $8)
20.          

Initplan (forBitmap Heap Scan)

21. 0.000 0.000 ↓ 0.0 0

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

22. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on apthotel_id_text_idx (cost=0.00..6.46 rows=289 width=0) (never executed)

  • Index Cond: ((apthotel_id)::text = $8)
23. 0.003 0.009 ↑ 105.0 1 1

Bitmap Heap Scan on apttransport (cost=5.12..267.57 rows=105 width=24) (actual time=0.009..0.009 rows=1 loops=1)

  • Recheck Cond: ((apttransport_id)::text = $10)
24.          

Initplan (forBitmap Heap Scan)

25. 0.001 0.001 ↑ 1.0 1 1

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

26. 0.005 0.005 ↑ 105.0 1 1

Bitmap Index Scan on apttransport_id_text_idx (cost=0.00..5.08 rows=105 width=0) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: ((apttransport_id)::text = $10)
27. 0.008 0.024 ↑ 142.0 1 4

Bitmap Heap Scan on aptotherservice (cost=5.41..329.47 rows=142 width=21) (actual time=0.006..0.006 rows=1 loops=4)

  • Recheck Cond: ((aptother_id)::text = $12)
28.          

Initplan (forBitmap Heap Scan)

29. 0.000 0.000 ↑ 1.0 1 4

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

30. 0.016 0.016 ↑ 142.0 1 4

Bitmap Index Scan on aptother_id_text_idx (cost=0.00..5.36 rows=142 width=0) (actual time=0.004..0.004 rows=1 loops=4)

  • Index Cond: ((aptother_id)::text = $12)
31. 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
32. 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
33. 0.000 0.000 ↓ 0.0 0

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

34. 0.000 0.000 ↓ 0.0 0

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

35. 0.000 0.000 ↓ 0.0 0

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

36. 0.000 0.000 ↓ 0.0 0

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

37. 0.000 0.000 ↓ 0.0 0

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

38. 0.000 0.000 ↓ 0.0 0

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