explain.depesz.com

PostgreSQL's explain analyze made readable

Result: io4s

Settings
# exclusive inclusive rows x rows loops node
1. 71.635 320.223 ↓ 1.1 74,272 1

Hash Join (cost=2,555.76..4,635.49 rows=66,242 width=176) (actual time=95.279..320.223 rows=74,272 loops=1)

  • Hash Cond: ((li.houseid)::text = (hi.houseid)::text)
2. 67.940 188.790 ↓ 1.1 78,818 1

Hash Right Join (cost=962.85..2,854.70 rows=71,567 width=162) (actual time=35.423..188.790 rows=78,818 loops=1)

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

Seq Scan on billrecord bi (cost=0.00..1,703.97 rows=71,567 width=111) (actual time=0.022..85.500 rows=69,790 loops=1)

4. 15.617 35.350 ↑ 1.0 36,428 1

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

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

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

6. 18.713 59.798 ↑ 1.0 48,097 1

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

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

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

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