explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eVEh

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.01..21.11 rows=1 width=51) (actual rows= loops=)

  • Join Filter: (res_1.id = resbase_1.id)
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.87..20.88 rows=1 width=75) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..20.64 rows=1 width=59) (actual rows= loops=)

  • Join Filter: (so_beard.id = execcurr.executorcurr)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.59..20.35 rows=1 width=59) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.45..20.11 rows=1 width=51) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.31..19.46 rows=3 width=24) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using i534141r7agnhmaaqkh6mtn1m on f_dp_resltnbase resbase (cost=0.14..8.15 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (isdeleted = 0)
8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on f_dp_resltnbase_execcurr execcurr_1 (cost=4.17..11.28 rows=3 width=16) (actual rows= loops=)

  • Recheck Cond: (owner = resbase.id)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on i_5346_1 (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (owner = resbase.id)
10. 0.000 0.000 ↓ 0.0

Index Scan using u_5131_0 on so_beard (cost=0.14..0.21 rows=1 width=27) (actual rows= loops=)

  • Index Cond: (id = execcurr_1.executorcurr)
11. 0.000 0.000 ↓ 0.0

Index Only Scan using u_5342_0 on f_dp_resolution res (cost=0.14..0.22 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = execcurr_1.owner)
12. 0.000 0.000 ↓ 0.0

Index Scan using i_5346_1 on f_dp_resltnbase_execcurr execcurr (cost=0.15..0.28 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (owner = execcurr_1.owner)
  • Filter: (execcurr_1.executorcurr = executorcurr)
13. 0.000 0.000 ↓ 0.0

Index Scan using u_5342_0 on f_dp_resolution res_1 (cost=0.14..0.22 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = execcurr_1.owner)
14. 0.000 0.000 ↓ 0.0

Index Only Scan using u_5341_0 on f_dp_resltnbase resbase_1 (cost=0.14..0.22 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = execcurr_1.owner)