explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XQWu

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.107 0.336 ↓ 2.0 10 1

Seq Scan on aircraftprefs ap (cost=3.75..90.07 rows=5 width=306) (actual time=0.077..0.336 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.070 0.070 ↑ 1.0 1 10

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

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

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

  • Index Cond: (identifier = ap.airport_id)
8. 0.037 0.037 ↑ 1.0 1 1

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

  • Filter: (customer_id = ap.customer_id)
  • Rows Removed by Filter: 18
9. 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
10. 0.000 0.000 ↓ 0.0 0

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

11. 0.000 0.000 ↓ 0.0 0

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

12. 0.000 0.000 ↓ 0.0 0

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

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

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

15. 0.000 0.000 ↓ 0.0 0

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