explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9KX9

Settings
# exclusive inclusive rows x rows loops node
1. 4.883 1,225.801 ↑ 1.3 2,209 1

Nested Loop (cost=209.97..163,285.03 rows=2,884 width=157) (actual time=4.287..1,225.801 rows=2,209 loops=1)

2. 1.441 10.386 ↑ 1.3 2,209 1

Hash Join (cost=153.47..234.55 rows=2,884 width=155) (actual time=4.243..10.386 rows=2,209 loops=1)

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

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

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

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

5. 1.413 4.130 ↑ 1.0 4,035 1

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

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

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

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

Hash (cost=1.81..1.81 rows=131 width=61) (actual time=0.083..0.083 rows=154 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
8. 0.042 0.042 ↓ 1.2 154 1

Seq Scan on custominfo (cost=0.00..1.81 rows=131 width=61) (actual time=0.009..0.042 rows=154 loops=1)

9. 629.565 1,210.532 ↑ 1.0 1 2,209

Aggregate (cost=56.50..56.51 rows=1 width=40) (actual time=0.548..0.548 rows=1 loops=2,209)

10. 580.967 580.967 ↑ 1.3 287 2,209

Index Only Scan using opendoorrecord_lockid_opentime_idx on opendoorrecord (cost=0.42..42.89 rows=363 width=20) (actual time=0.008..0.263 rows=287 loops=2,209)

  • Index Cond: (lockid = (lockinfo.lockid)::text)
  • Heap Fetches: 633662
Planning time : 0.740 ms
Execution time : 1,226.135 ms