explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z86k

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

Limit (cost=1.99..15,705.73 rows=1 width=23) (actual time=0.001..0.001 rows=0 loops=1)

2. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.99..2,167,118.65 rows=138 width=23) (never executed)

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

Nested Loop (cost=1.84..2,166,618.48 rows=6,559 width=31) (never executed)

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

Nested Loop (cost=1.28..2,165,568.89 rows=59,027 width=39) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.99..2,147,268.67 rows=59,027 width=31) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Index Scan using customers_lastname_idx on customers (cost=0.43..678,506.27 rows=8,087 width=15) (never executed)

  • Filter: ((lastname ~~ 'KIM%'::text) AND (customertypeid = 1))
7. 0.000 0.000 ↓ 0.0 0

Index Scan using alignments_customerid_idx on alignments (cost=0.56..179.91 rows=171 width=24) (never executed)

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

Index Scan using pk_orgunits_orgunitid on orgunits (cost=0.28..0.30 rows=1 width=24) (never executed)

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

Materialize (cost=0.56..16.62 rows=1 width=8) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..16.61 rows=1 width=8) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Index Scan using userorgunitmapping_userid_idx on userorgunitmapping uom (cost=0.28..8.30 rows=1 width=8) (never executed)

  • Index Cond: (userid = 5910)
12. 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)
13. 0.000 0.000 ↓ 0.0 0

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

14. 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)
Planning time : 1.236 ms