explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wx7ON

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3.841 ↑ 1.0 1 1

Limit (cost=23.40..1,103.08 rows=1 width=138) (actual time=3.827..3.841 rows=1 loops=1)

2.          

Initplan (forLimit)

3. 0.137 0.137 ↑ 1.0 1 1

Index Scan using csidx on hd hd_1 (cost=0.43..2.45 rows=1 width=10) (actual time=0.136..0.137 rows=1 loops=1)

  • Index Cond: (callsign = 'K5CG'::text)
  • Filter: (license_status = 'A'::text)
  • Rows Removed by Filter: 1
4. 0.180 3.824 ↑ 1.0 1 1

Result (cost=20.95..1,100.64 rows=1 width=138) (actual time=3.823..3.824 rows=1 loops=1)

5. 0.185 1.274 ↑ 1.0 1 1

Sort (cost=20.95..20.95 rows=1 width=106) (actual time=1.273..1.274 rows=1 loops=1)

  • Sort Key: hd.last_action_date DESC
  • Sort Method: quicksort Memory: 25kB
6. 0.005 1.089 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.28..20.94 rows=1 width=106) (actual time=0.991..1.089 rows=1 loops=1)

  • Join Filter: (am.callsign = darc.callsign)
7. 0.008 0.987 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.28..16.65 rows=1 width=106) (actual time=0.889..0.987 rows=1 loops=1)

  • Join Filter: (am.callsign = rwk.callsign)
8. 0.011 0.643 ↑ 1.0 1 1

Nested Loop (cost=1.28..5.38 rows=1 width=106) (actual time=0.637..0.643 rows=1 loops=1)

  • Join Filter: (am.unique_system_identifier = hd.unique_system_identifier)
9. 0.017 0.454 ↓ 2.0 2 1

Nested Loop (cost=0.85..4.90 rows=1 width=102) (actual time=0.337..0.454 rows=2 loops=1)

10. 0.255 0.255 ↓ 2.0 2 1

Index Scan using amcsidx on am (cost=0.43..2.45 rows=1 width=14) (actual time=0.234..0.255 rows=2 loops=1)

  • Index Cond: (callsign = 'K5CG'::text)
11. 0.182 0.182 ↑ 1.0 1 2

Index Scan using enusiidx on en (cost=0.43..2.45 rows=1 width=88) (actual time=0.090..0.091 rows=1 loops=2)

  • Index Cond: (unique_system_identifier = am.unique_system_identifier)
12. 0.178 0.178 ↓ 0.0 0 2

Index Scan using hdusiidx on hd (cost=0.43..0.46 rows=1 width=22) (actual time=0.088..0.089 rows=0 loops=2)

  • Index Cond: (unique_system_identifier = en.unique_system_identifier)
  • Filter: (license_status = 'A'::text)
  • Rows Removed by Filter: 0
13. 0.336 0.336 ↑ 1.0 1 1

Seq Scan on rwk (cost=0.00..11.26 rows=1 width=6) (actual time=0.245..0.336 rows=1 loops=1)

  • Filter: (callsign = 'K5CG'::text)
  • Rows Removed by Filter: 340
14. 0.097 0.097 ↓ 0.0 0 1

Seq Scan on darc (cost=0.00..4.28 rows=1 width=6) (actual time=0.096..0.097 rows=0 loops=1)

  • Filter: (callsign = 'K5CG'::text)
  • Rows Removed by Filter: 182
15.          

SubPlan (forResult)

16. 0.217 2.370 ↑ 1.0 1 1

Nested Loop (cost=0.86..1,079.67 rows=1 width=11) (actual time=1.023..2.370 rows=1 loops=1)

17. 0.398 0.398 ↑ 3.7 117 1

Index Scan using ladidx on hd hd_2 (cost=0.43..16.19 rows=438 width=6) (actual time=0.144..0.398 rows=117 loops=1)

  • Index Cond: (last_action_date = hd.effective_date)
18. 1.755 1.755 ↓ 0.0 0 117

Index Scan using enusiidx on en en_1 (cost=0.43..2.42 rows=1 width=17) (actual time=0.015..0.015 rows=0 loops=117)

  • Index Cond: (unique_system_identifier = hd_2.unique_system_identifier)
  • Filter: (frn = en.frn)
  • Rows Removed by Filter: 1
Planning time : 10.171 ms
Execution time : 4.576 ms