explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sy9R

Settings
# exclusive inclusive rows x rows loops node
1. 0.038 0.212 ↑ 360.0 3 1

Seq Scan on _concern (cost=0.00..11,714,026.13 rows=1,080 width=129) (actual time=0.115..0.212 rows=3 loops=1)

  • Filter: (now() <@ validity)
2.          

SubPlan (for Seq Scan)

3. 0.033 0.174 ↑ 1.0 1 3

Aggregate (cost=10,846.27..10,846.28 rows=1 width=32) (actual time=0.058..0.058 rows=1 loops=3)

4. 0.006 0.141 ↑ 1.0 1 3

Nested Loop (cost=10,845.98..10,846.26 rows=1 width=218) (actual time=0.046..0.047 rows=1 loops=3)

5. 0.003 0.075 ↑ 1.0 1 3

Nested Loop (cost=8.38..8.63 rows=1 width=186) (actual time=0.025..0.025 rows=1 loops=3)

6. 0.039 0.039 ↑ 1.0 1 3

Index Scan using "pk_houseinfo_1570385679_119 " on houseinfo (cost=0.42..0.64 rows=1 width=146) (actual time=0.012..0.013 rows=1 loops=3)

  • Index Cond: ((houseid)::text = _concern.houseid)
  • Filter: ((xzqhdm)::text ~~ '330522%'::text)
7. 0.006 0.033 ↑ 1.0 1 3

Aggregate (cost=7.97..7.98 rows=1 width=40) (actual time=0.011..0.011 rows=1 loops=3)

8. 0.027 0.027 ↓ 0.0 0 3

Index Scan using opendoorrecord_houseid_idx on opendoorrecord opendoorrecord_2 (cost=0.43..6.17 rows=48 width=20) (actual time=0.009..0.009 rows=0 loops=3)

  • Index Cond: ((houseid)::text = (houseinfo.houseid)::text)
9. 0.015 0.060 ↑ 1.0 1 3

Aggregate (cost=10,837.60..10,837.61 rows=1 width=32) (actual time=0.020..0.020 rows=1 loops=3)

10. 0.007 0.045 ↓ 0.0 0 3

Hash Join (cost=0.95..5,576.92 rows=1,221 width=188) (actual time=0.015..0.015 rows=0 loops=3)

  • Hash Cond: ((appuseraccount.account)::text = (COALESCE(lockkeyinfo.keyholder, lockkeyinfo.useraccount))::text)
11. 0.000 0.005 ↑ 122,097.0 1 1

Append (cost=0.00..3,884.92 rows=122,097 width=154) (actual time=0.005..0.005 rows=1 loops=1)

12. 0.005 0.005 ↑ 118,258.0 1 1

Seq Scan on appuseraccount (cost=0.00..1,999.68 rows=118,258 width=71) (actual time=0.005..0.005 rows=1 loops=1)

13. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2 (cost=0.00..92.18 rows=3,839 width=78) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on bluekeyuserinfo (cost=0.00..53.79 rows=3,839 width=104) (never executed)

15. 0.003 0.033 ↓ 0.0 0 3

Hash (cost=0.92..0.92 rows=2 width=58) (actual time=0.011..0.011 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
16. 0.030 0.030 ↓ 0.0 0 3

Index Scan using lockkeyinfo_houseid_idx on lockkeyinfo (cost=0.42..0.92 rows=2 width=58) (actual time=0.010..0.010 rows=0 loops=3)

  • Index Cond: ((houseid)::text = (houseinfo.houseid)::text)
  • Filter: ((userrole <> 255) AND (keystate = 0) AND ((expireddate)::text > (timezone('PRC'::text, now()))::text))
17.          

SubPlan (for Aggregate)

18. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=2.14..2.15 rows=1 width=32) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on opendoorrecord (cost=2.03..2.14 rows=1 width=20) (never executed)

  • Recheck Cond: (((userid)::text = (appuseraccount.account)::text) AND ((houseid)::text = (lockkeyinfo.houseid)::text))
20. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=2.03..2.03 rows=1 width=0) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_openrecord_opendoorre_1578489340_20 (cost=0.00..0.89 rows=48 width=0) (never executed)

  • Index Cond: ((userid)::text = (appuseraccount.account)::text)
22. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on opendoorrecord_houseid_idx (cost=0.00..0.89 rows=48 width=0) (never executed)

  • Index Cond: ((houseid)::text = (lockkeyinfo.houseid)::text)
23. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=2.14..2.15 rows=1 width=32) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on opendoorrecord opendoorrecord_1 (cost=2.03..2.14 rows=1 width=20) (never executed)

  • Recheck Cond: (((userid)::text = (appuseraccount.account)::text) AND ((houseid)::text = (lockkeyinfo.houseid)::text))
25. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=2.03..2.03 rows=1 width=0) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_openrecord_opendoorre_1578489340_20 (cost=0.00..0.89 rows=48 width=0) (never executed)

  • Index Cond: ((userid)::text = (appuseraccount.account)::text)
27. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on opendoorrecord_houseid_idx (cost=0.00..0.89 rows=48 width=0) (never executed)

  • Index Cond: ((houseid)::text = (lockkeyinfo.houseid)::text)
Planning time : 1.570 ms
Execution time : 0.341 ms