explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b9uF

Settings
# exclusive inclusive rows x rows loops node
1. 205.436 476.440 ↓ 1.1 74,272 1

Sort (cost=10,457.57..10,623.18 rows=66,242 width=296) (actual time=442.182..476.440 rows=74,272 loops=1)

  • Sort Key: bi.createtime DESC NULLS LAST
  • Sort Method: external merge Disk: 20,688kB
2. 66.394 271.004 ↓ 1.1 74,272 1

Hash Join (cost=2,555.76..4,635.49 rows=66,242 width=296) (actual time=64.590..271.004 rows=74,272 loops=1)

  • Hash Cond: ((li.houseid)::text = (hi.houseid)::text)
3. 62.979 164.108 ↓ 1.1 78,818 1

Hash Right Join (cost=962.85..2,854.70 rows=71,567 width=282) (actual time=24.028..164.108 rows=78,818 loops=1)

  • Hash Cond: ((bi.lockid)::text = (li.lockid)::text)
4. 77.168 77.168 ↑ 1.0 69,790 1

Seq Scan on billrecord bi (cost=0.00..1,703.97 rows=71,567 width=231) (actual time=0.021..77.168 rows=69,790 loops=1)

5. 9.766 23.961 ↑ 1.0 36,428 1

Hash (cost=505.71..505.71 rows=36,571 width=70) (actual time=23.960..23.961 rows=36,428 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 4,199kB
6. 14.195 14.195 ↑ 1.0 36,428 1

Seq Scan on lockinfo li (cost=0.00..505.71 rows=36,571 width=70) (actual time=0.008..14.195 rows=36,428 loops=1)

7. 12.556 40.502 ↑ 1.0 48,097 1

Hash (cost=990.79..990.79 rows=48,170 width=45) (actual time=40.502..40.502 rows=48,097 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 4,176kB
8. 27.946 27.946 ↑ 1.0 48,097 1

Seq Scan on houseinfo hi (cost=0.00..990.79 rows=48,170 width=45) (actual time=0.007..27.946 rows=48,097 loops=1)

  • Filter: ((xzqhdm)::text ~~ '330522%'::text)
  • Rows Removed by Filter: 3,822
Planning time : 0.600 ms
Execution time : 486.039 ms