explain.depesz.com

PostgreSQL's explain analyze made readable

Result: omVa

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 88.336 ↑ 1.0 1 1

Nested Loop (cost=3.26..84.13 rows=1 width=4,293) (actual time=88.334..88.336 rows=1 loops=1)

2. 0.005 88.220 ↑ 1.0 1 1

Nested Loop (cost=2.98..75.83 rows=1 width=3,660) (actual time=88.218..88.220 rows=1 loops=1)

3. 0.005 56.872 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.69..67.52 rows=1 width=3,541) (actual time=56.870..56.872 rows=1 loops=1)

4. 0.007 56.844 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.26..59.07 rows=1 width=3,513) (actual time=56.843..56.844 rows=1 loops=1)

5. 0.008 56.809 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.99..42.76 rows=1 width=3,256) (actual time=56.807..56.809 rows=1 loops=1)

6. 0.010 36.984 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.70..34.46 rows=1 width=3,184) (actual time=36.983..36.984 rows=1 loops=1)

7. 0.005 36.862 ↑ 1.0 1 1

Nested Loop (cost=1.42..26.16 rows=1 width=2,551) (actual time=36.860..36.862 rows=1 loops=1)

8. 0.009 0.217 ↑ 1.0 1 1

Nested Loop (cost=1.13..25.19 rows=1 width=2,486) (actual time=0.215..0.217 rows=1 loops=1)

9. 0.006 0.024 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..16.88 rows=1 width=1,853) (actual time=0.023..0.024 rows=1 loops=1)

10. 0.017 0.017 ↑ 1.0 1 1

Index Scan using pk_request on roadworkrequest "Extent24" (cost=0.43..8.45 rows=1 width=1,184) (actual time=0.016..0.017 rows=1 loops=1)

  • Index Cond: (id = 1243203)
11. 0.001 0.001 ↓ 0.0 0 1

Index Scan using pk_permit on permit "Extent25" (cost=0.42..8.44 rows=1 width=669) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ("Extent24".permitid = id)
12. 0.184 0.184 ↑ 1.0 1 1

Index Scan using pk_organisation on organisation "Extent26" (cost=0.28..8.30 rows=1 width=633) (actual time=0.184..0.184 rows=1 loops=1)

  • Index Cond: (id = "Extent24".roadworkrequestownerorganisationid)
13. 36.640 36.640 ↑ 1.0 1 1

Index Scan using pk_organisationaddress on organisationaddress "Extent27" (cost=0.29..0.97 rows=1 width=65) (actual time=36.640..36.640 rows=1 loops=1)

  • Index Cond: (id = "Extent26".visitingaddressid)
14. 0.112 0.112 ↑ 1.0 1 1

Index Scan using pk_organisation on organisation "Extent28" (cost=0.28..8.30 rows=1 width=633) (actual time=0.112..0.112 rows=1 loops=1)

  • Index Cond: ("Extent24".roadworkrequestownercontractororganisationid = id)
15. 19.817 19.817 ↑ 1.0 1 1

Index Scan using pk_foreman on foreman "Extent29" (cost=0.28..8.30 rows=1 width=72) (actual time=19.817..19.817 rows=1 loops=1)

  • Index Cond: ("Extent24".foremanid = id)
16. 0.028 0.028 ↓ 0.0 0 1

Index Scan using pk_project on project "Extent30" (cost=0.28..8.29 rows=1 width=257) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: ("Extent24".projectid = id)
17. 0.023 0.023 ↑ 1.0 1 1

Index Scan using pk_roadworkrequestdates on roadworkrequestdates "Extent31" (cost=0.43..8.45 rows=1 width=28) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ("Extent24".actualroadworkrequestdatesid = id)
18. 31.343 31.343 ↑ 1.0 1 1

Index Scan using pk_contract on roadworkcontract "Extent32" (cost=0.29..8.30 rows=1 width=119) (actual time=31.343..31.343 rows=1 loops=1)

  • Index Cond: (id = "Extent24".roadworkcontractid)
19. 0.109 0.109 ↑ 1.0 1 1

Index Scan using pk_organisation on organisation "Extent33" (cost=0.28..8.30 rows=1 width=633) (actual time=0.109..0.109 rows=1 loops=1)

  • Index Cond: (id = "Extent24".roadworkrequestpsmorganisationid)
Planning time : 2,788.037 ms