explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qog8

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.001 ↓ 0.0 0 1

Limit (cost=487.05..5,012.14 rows=1 width=23) (actual time=0.001..0.001 rows=0 loops=1)

2. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=487.05..9,537.23 rows=2 width=23) (never executed)

  • Hash Cond: (alignments.customerid = customers.customerid)
3. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.27..8,754.51 rows=79,181 width=16) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..193.53 rows=12 width=8) (never executed)

  • Join Filter: (orgunits.orgunitlevelid = ol.orgunitlevelid)
5. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..142.83 rows=566 width=16) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..102.81 rows=1 width=8) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Seq Scan on userorgunitmapping uom (cost=0.00..94.50 rows=1 width=8) (never executed)

  • Filter: (userid = 5910)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_orgunits_orgunitid on orgunits orgunits_1 (cost=0.28..8.30 rows=1 width=16) (never executed)

  • Index Cond: (orgunitid = uom.orgunitid)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using orgunits_treeright_idx on orgunits (cost=0.28..34.36 rows=566 width=24) (never executed)

  • Index Cond: (treeright <= orgunits_1.treeright)
  • Filter: (treeleft >= orgunits_1.treeleft)
10. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.14..8.26 rows=5 width=8) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Index Scan using orgunitlevel_salesforceid_idx on orgunitlevel ol (cost=0.14..8.23 rows=5 width=8) (never executed)

  • Index Cond: (salesforceid = 313)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using alignments_orgunitid_idx on alignments (cost=0.56..580.22 rows=13,320 width=24) (never executed)

  • Index Cond: (orgunitid = orgunits.orgunitid)
13. 0.000 0.000 ↓ 0.0 0

Hash (cost=484.25..484.25 rows=122 width=15) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on customers (cost=5.38..484.25 rows=122 width=15) (never executed)

  • Recheck Cond: (lastname = 'KI'::text)
  • Filter: (customertypeid = 1)
15. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on customers_lastname_idx (cost=0.00..5.34 rows=122 width=0) (never executed)

  • Index Cond: (lastname = 'KI'::text)
Planning time : 1.277 ms