explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z9oW

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 23.643 ↑ 1.0 1 1

Nested Loop (cost=1.55..1,921.44 rows=1 width=1,275) (actual time=23.249..23.643 rows=1 loops=1)

2. 0.010 23.625 ↑ 1.0 1 1

Nested Loop (cost=1.13..1,920.59 rows=1 width=1,282) (actual time=23.231..23.625 rows=1 loops=1)

  • Join Filter: (bob.assoc_id = rltn.bk_of_busn_id)
3. 0.007 0.049 ↑ 1.0 1 1

Nested Loop (cost=0.71..8.75 rows=1 width=1,282) (actual time=0.046..0.049 rows=1 loops=1)

4. 0.021 0.021 ↑ 1.0 1 1

Index Scan using bk_of_busn_assoc_2ix on bk_of_busn_assoc bob (cost=0.29..4.31 rows=1 width=1,256) (actual time=0.020..0.021 rows=1 loops=1)

  • Index Cond: (serv_assoc_id = '005HN2SJ000'::bpchar)
5. 0.021 0.021 ↑ 1.0 1 1

Index Scan using assoc_id_1ix on assoc_id id (cost=0.42..4.44 rows=1 width=26) (actual time=0.020..0.021 rows=1 loops=1)

  • Index Cond: (assoc_id = bob.assoc_id)
6. 23.566 23.566 ↑ 1.0 1 1

Index Scan using bk_of_busn_rltn_1ix on bk_of_busn_rltn rltn (cost=0.42..1,911.82 rows=1 width=24) (actual time=23.177..23.566 rows=1 loops=1)

  • Index Cond: (bk_of_busn_id = id.assoc_id)
  • Filter: (natr_id = 3,504)
  • Rows Removed by Filter: 9
7. 0.015 0.015 ↑ 1.0 1 1

Index Scan using assoc_id_1ix on assoc_id terr (cost=0.42..0.84 rows=1 width=17) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (assoc_id = rltn.assoc_id)
Planning time : 3.333 ms
Execution time : 23.745 ms