explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Mt8

Settings
# exclusive inclusive rows x rows loops node
1. 4.587 1,350.018 ↑ 1.3 2,209 1

Nested Loop (cost=209.80..162,797.50 rows=2,884 width=129) (actual time=4.401..1,350.018 rows=2,209 loops=1)

2. 1.564 11.195 ↑ 1.3 2,209 1

Hash Join (cost=153.47..234.55 rows=2,884 width=127) (actual time=4.361..11.195 rows=2,209 loops=1)

  • Hash Cond: ((houseinfo.customid)::text = (custominfo.customid)::text)
3. 3.968 9.560 ↑ 1.4 2,231 1

Hash Join (cost=150.03..222.48 rows=3,192 width=159) (actual time=4.285..9.560 rows=2,231 loops=1)

  • Hash Cond: ((lockinfo.houseid)::text = (houseinfo.houseid)::text)
4. 1.322 1.322 ↑ 1.0 4,508 1

Seq Scan on lockinfo (cost=0.00..60.56 rows=4,526 width=43) (actual time=0.004..1.322 rows=4,508 loops=1)

5. 1.469 4.270 ↑ 1.0 4,035 1

Hash (cost=98.60..98.60 rows=4,114 width=140) (actual time=4.270..4.270 rows=4,035 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 726kB
6. 2.801 2.801 ↑ 1.0 4,035 1

Seq Scan on houseinfo (cost=0.00..98.60 rows=4,114 width=140) (actual time=0.005..2.801 rows=4,035 loops=1)

  • Filter: ((housecategory)::text = '2'::text)
  • Rows Removed by Filter: 1797
7. 0.033 0.071 ↓ 1.2 154 1

Hash (cost=1.81..1.81 rows=131 width=33) (actual time=0.071..0.071 rows=154 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
8. 0.038 0.038 ↓ 1.2 154 1

Seq Scan on custominfo (cost=0.00..1.81 rows=131 width=33) (actual time=0.006..0.038 rows=154 loops=1)

9. 711.298 1,334.236 ↑ 1.0 1 2,209

Aggregate (cost=56.33..56.34 rows=1 width=40) (actual time=0.604..0.604 rows=1 loops=2,209)

10. 622.938 622.938 ↑ 1.3 287 2,209

Index Scan using opendoorrecord_lockid_idx on opendoorrecord (cost=0.42..42.72 rows=363 width=20) (actual time=0.009..0.282 rows=287 loops=2,209)

  • Index Cond: ((lockid)::text = (lockinfo.lockid)::text)
Planning time : 0.581 ms
Execution time : 1,350.371 ms