explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WFOh : Optimization for: Optimization for: Optimization for: plan #XQWu; plan #8YqG; plan #8hDi

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.180 0.496 ↓ 2.0 10 1

Seq Scan on aircraftprefs ap (cost=3.75..8,299.34 rows=5 width=306) (actual time=0.084..0.496 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.030 0.030 ↑ 1.0 1 10

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

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

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

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

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

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

Initplan (forBitmap Heap 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.080 0.080 ↑ 66.0 1 5

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

  • Index Cond: ((aptfbo_id)::text = $3)
12. 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)
13.          

Initplan (forBitmap Heap Scan)

14. 0.000 0.000 ↓ 0.0 0

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

15. 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)
16. 0.000 0.000 ↓ 0.0 0

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

17. 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))
18. 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)
19.          

Initplan (forBitmap Heap Scan)

20. 0.000 0.000 ↓ 0.0 0

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

21. 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)
22. 0.003 0.109 ↑ 105.0 1 1

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

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

Initplan (forBitmap Heap Scan)

24. 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)

25. 0.105 0.105 ↑ 105.0 1 1

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

  • Index Cond: ((apttransport_id)::text = $10)
26. 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)
27.          

Initplan (forBitmap Heap Scan)

28. 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)

29. 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)
30. 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
31. 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
32. 0.000 0.000 ↓ 0.0 0

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

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)