explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ll1P

Settings
# exclusive inclusive rows x rows loops node
1. 0.416 13.890 ↓ 6.0 6 1

Nested Loop (cost=1.82..7.93 rows=1 width=2,567) (actual time=0.064..13.890 rows=6 loops=1)

2. 0.456 7.912 ↓ 1,854.0 1,854 1

Nested Loop (cost=1.40..7.30 rows=1 width=1,474) (actual time=0.051..7.912 rows=1,854 loops=1)

3. 0.656 1.894 ↓ 1,854.0 1,854 1

Nested Loop (cost=0.98..6.65 rows=1 width=204) (actual time=0.040..1.894 rows=1,854 loops=1)

4. 0.005 0.107 ↓ 6.5 39 1

Append (cost=0.42..1.91 rows=6 width=67) (actual time=0.024..0.107 rows=39 loops=1)

5. 0.024 0.024 ↑ 2.0 1 1

Index Scan using lockkeyinfo_keyholder_idx on lockkeyinfo (cost=0.42..0.88 rows=2 width=70) (actual time=0.023..0.024 rows=1 loops=1)

  • Index Cond: ((keyholder)::text = '15067121276'::text)
  • Filter: (userrole <> 255)
6. 0.078 0.078 ↓ 9.5 38 1

Index Scan using keyhistoryinfo_keyholder_idx on keyhistoryinfo (cost=0.42..1.00 rows=4 width=66) (actual time=0.013..0.078 rows=38 loops=1)

  • Index Cond: ((keyholder)::text = '15067121276'::text)
  • Filter: (userrole <> 255)
  • Rows Removed by Filter: 21
7. 1.131 1.131 ↓ 48.0 48 39

Index Scan using opendoorrecord_userid_lockid_idx on opendoorrecord (cost=0.56..0.78 rows=1 width=137) (actual time=0.008..0.029 rows=48 loops=39)

  • Index Cond: (((userid)::text = '15067121276'::text) AND ((lockid)::text = (lockkeyinfo.lockid)::text))
8. 5.562 5.562 ↑ 1.0 1 1,854

Index Scan using appuseraccount_pkey on appuseraccount (cost=0.42..0.64 rows=1 width=1,270) (actual time=0.002..0.003 rows=1 loops=1,854)

  • Index Cond: ((account)::text = '15067121276'::text)
9. 5.562 5.562 ↓ 0.0 0 1,854

Index Scan using houseinfo_pkey on houseinfo (cost=0.42..0.64 rows=1 width=1,128) (actual time=0.003..0.003 rows=0 loops=1,854)

  • Index Cond: ((houseid)::text = (lockkeyinfo.houseid)::text)
  • Filter: ((xzqhdm)::text ~~ '330522%'::text)
  • Rows Removed by Filter: 1
Planning time : 0.654 ms
Execution time : 13.959 ms