explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WFh8y

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.096 ↓ 3.0 3 1

Nested Loop Left Join (cost=1.57..55.97 rows=1 width=180) (actual time=0.063..0.096 rows=3 loops=1)

2. 0.008 0.056 ↓ 3.0 3 1

Nested Loop (cost=0.71..47.04 rows=1 width=107) (actual time=0.035..0.056 rows=3 loops=1)

3. 0.030 0.030 ↓ 1.5 6 1

Index Scan using ix_roadworkrequestid_organisationid on roadworkrequestmaterial "Extent1" (cost=0.43..13.81 rows=4 width=103) (actual time=0.021..0.030 rows=6 loops=1)

  • Index Cond: (roadworkrequestid = 106346)
4. 0.018 0.018 ↑ 1.0 1 6

Index Scan using pk_organisation on organisation "Extent2" (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=6)

  • Index Cond: (id = "Extent1".organisationid)
  • Filter: (organisationroleid = 2)
  • Rows Removed by Filter: 1
5. 0.003 0.036 ↑ 1.0 1 3

Nested Loop (cost=0.86..8.92 rows=1 width=73) (actual time=0.012..0.012 rows=1 loops=3)

6. 0.018 0.018 ↑ 1.0 1 3

Index Scan using ix_dks_1 on materialcostbreakdown "Extent3" (cost=0.43..8.45 rows=1 width=14) (actual time=0.006..0.006 rows=1 loops=3)

  • Index Cond: ("Extent1".id = roadworkrequestmaterialid)
7. 0.015 0.015 ↑ 1.0 1 3

Index Scan using pk_roadwordrequestorganisationresolving on combipartners "Extent4" (cost=0.43..0.47 rows=1 width=59) (actual time=0.005..0.005 rows=1 loops=3)

  • Index Cond: (id = "Extent3".combipartnerid)