explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UbnT

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 0.360 ↑ 1.0 1 1

Aggregate (cost=11.84..11.85 rows=1 width=32) (actual time=0.360..0.360 rows=1 loops=1)

2. 0.001 0.339 ↑ 1.2 5 1

Append (cost=1.50..11.82 rows=6 width=19) (actual time=0.047..0.339 rows=5 loops=1)

3. 0.001 0.047 ↑ 2.0 1 1

Subquery Scan on *SELECT* 1 (cost=1.50..4.48 rows=2 width=19) (actual time=0.046..0.047 rows=1 loops=1)

4. 0.002 0.046 ↑ 2.0 1 1

Nested Loop (cost=1.50..4.46 rows=2 width=117) (actual time=0.045..0.046 rows=1 loops=1)

5. 0.014 0.033 ↑ 4.0 1 1

Bitmap Heap Scan on lockkeyinfo (cost=1.09..1.91 rows=4 width=54) (actual time=0.032..0.033 rows=1 loops=1)

  • Recheck Cond: (('15067121276'::text = (keyholder)::text) OR ('15067121276'::text = (useraccount)::text))
  • Filter: (userrole <> 255)
  • Rows Removed by Filter: 3
  • Heap Blocks: exact=4
6. 0.000 0.019 ↓ 0.0 0 1

BitmapOr (cost=1.09..1.09 rows=7 width=0) (actual time=0.019..0.019 rows=0 loops=1)

7. 0.010 0.010 ↑ 3.0 1 1

Bitmap Index Scan on lockkeyinfo_keyholder_idx (cost=0.00..0.54 rows=3 width=0) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: ((keyholder)::text = '15067121276'::text)
8. 0.009 0.009 ↓ 1.3 4 1

Bitmap Index Scan on lockkeyinfo_useraccount_idx (cost=0.00..0.54 rows=3 width=0) (actual time=0.009..0.009 rows=4 loops=1)

  • Index Cond: ((useraccount)::text = '15067121276'::text)
9. 0.011 0.011 ↑ 1.0 1 1

Index Scan using houseinfo_pkey on houseinfo (cost=0.42..0.64 rows=1 width=35) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: ((houseid)::text = (lockkeyinfo.houseid)::text)
  • Filter: ((xzqhdm)::text ~~ '330522%'::text)
10. 0.001 0.291 ↑ 1.0 4 1

Subquery Scan on *SELECT* 2 (cost=1.53..7.31 rows=4 width=19) (actual time=0.117..0.291 rows=4 loops=1)

11. 0.029 0.290 ↑ 1.0 4 1

Nested Loop (cost=1.53..7.27 rows=4 width=117) (actual time=0.117..0.290 rows=4 loops=1)

12. 0.079 0.105 ↓ 4.9 39 1

Bitmap Heap Scan on keyhistoryinfo (cost=1.11..2.17 rows=8 width=50) (actual time=0.034..0.105 rows=39 loops=1)

  • Recheck Cond: (('15067121276'::text = (keyholder)::text) OR ('15067121276'::text = (useraccount)::text))
  • Filter: (userrole <> 255)
  • Rows Removed by Filter: 21
  • Heap Blocks: exact=44
13. 0.001 0.026 ↓ 0.0 0 1

BitmapOr (cost=1.11..1.11 rows=9 width=0) (actual time=0.026..0.026 rows=0 loops=1)

14. 0.014 0.014 ↓ 14.8 59 1

Bitmap Index Scan on keyhistoryinfo_keyholder_idx (cost=0.00..0.55 rows=4 width=0) (actual time=0.014..0.014 rows=59 loops=1)

  • Index Cond: ((keyholder)::text = '15067121276'::text)
15. 0.011 0.011 ↓ 12.0 60 1

Bitmap Index Scan on keyhistoryinfo_useraccount_idx (cost=0.00..0.56 rows=5 width=0) (actual time=0.011..0.011 rows=60 loops=1)

  • Index Cond: ((useraccount)::text = '15067121276'::text)
16. 0.156 0.156 ↓ 0.0 0 39

Index Scan using houseinfo_pkey on houseinfo houseinfo_1 (cost=0.42..0.64 rows=1 width=35) (actual time=0.004..0.004 rows=0 loops=39)

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