explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kUF5

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

Limit (cost=1.14..356.18 rows=1 width=23) (actual time=0.000..0.000 rows=0 loops=1)

2. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.14..47,221.04 rows=133 width=23) (never executed)

3. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..9,216.20 rows=79,181 width=16) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.14..655.21 rows=12 width=8) (never executed)

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

Nested Loop (cost=0.00..604.51 rows=566 width=16) (never executed)

  • Join Filter: ((orgunits.treeleft >= orgunits_1.treeleft) AND (orgunits.treeright <= orgunits_1.treeright))
6. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..343.14 rows=1 width=8) (never executed)

  • Join Filter: (orgunits_1.orgunitid = uom.orgunitid)
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

Seq Scan on orgunits orgunits_1 (cost=0.00..184.95 rows=5,095 width=16) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Seq Scan on orgunits (cost=0.00..184.95 rows=5,095 width=24) (never executed)

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

Index Scan using pk_customers_customerid on customers (cost=0.43..0.47 rows=1 width=15) (never executed)

  • Index Cond: (customerid = alignments.customerid)
  • Filter: ((customertypeid = 1) AND (lastname = 'KIM'::text))