explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sgf6

Settings
# exclusive inclusive rows x rows loops node
1. 111.089 1,720.018 ↓ 3.0 3 1

Hash Right Join (cost=46,221.53..145,652.92 rows=1 width=180) (actual time=280.351..1,720.018 rows=3 loops=1)

  • Hash Cond: ("Extent3".roadworkrequestmaterialid = "Extent1".id)
2. 1,238.906 1,608.890 ↑ 1.0 2,108,830 1

Hash Join (cost=46,174.48..137,697.74 rows=2,108,830 width=73) (actual time=275.747..1,608.890 rows=2,108,830 loops=1)

  • Hash Cond: ("Extent3".combipartnerid = "Extent4".id)
3. 101.955 101.955 ↑ 1.0 2,108,830 1

Seq Scan on materialcostbreakdown "Extent3" (cost=0.00..32,488.30 rows=2,108,830 width=14) (actual time=0.009..101.955 rows=2,108,830 loops=1)

4. 214.060 268.029 ↑ 1.0 1,099,799 1

Hash (cost=20,611.99..20,611.99 rows=1,099,799 width=59) (actual time=268.029..268.029 rows=1,099,799 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 2972kB
5. 53.969 53.969 ↑ 1.0 1,099,799 1

Seq Scan on combipartners "Extent4" (cost=0.00..20,611.99 rows=1,099,799 width=59) (actual time=0.005..53.969 rows=1,099,799 loops=1)

6. 0.007 0.039 ↓ 3.0 3 1

Hash (cost=47.04..47.04 rows=1 width=107) (actual time=0.039..0.039 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.005 0.032 ↓ 3.0 3 1

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

8. 0.015 0.015 ↓ 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.011..0.015 rows=6 loops=1)

  • Index Cond: (roadworkrequestid = 106346)
9. 0.012 0.012 ↑ 1.0 1 6

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

  • Index Cond: (id = "Extent1".organisationid)
  • Filter: (organisationroleid = 2)
  • Rows Removed by Filter: 1