explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eVf

Settings
# exclusive inclusive rows x rows loops node
1. 9.305 87.749 ↑ 2.8 9,967 1

Hash Join (cost=1,918.63..2,857.45 rows=27,817 width=45) (actual time=64.598..87.749 rows=9,967 loops=1)

  • Hash Cond: (dclm.locid = gl.id)
2.          

CTE doc_control_location_mapping

3. 21.017 58.934 ↑ 2.8 9,967 1

HashAggregate (cost=1,111.90..1,390.07 rows=27,817 width=8) (actual time=53.964..58.934 rows=9,967 loops=1)

  • Group Key: dc.soldbylocid
4. 21.449 37.917 ↓ 1.0 27,857 1

Append (cost=0.00..1,042.36 rows=27,817 width=8) (actual time=0.008..37.917 rows=27,857 loops=1)

5. 4.808 4.808 ↓ 1.0 9,286 1

Seq Scan on document_control dc (cost=0.00..254.73 rows=9,273 width=8) (actual time=0.007..4.808 rows=9,286 loops=1)

  • Filter: (soldbylocid IS NOT NULL)
6. 4.715 4.715 ↓ 1.0 9,286 1

Seq Scan on document_control dc_1 (cost=0.00..254.73 rows=9,272 width=8) (actual time=0.003..4.715 rows=9,286 loops=1)

  • Filter: (soldtolocid IS NOT NULL)
7. 6.945 6.945 ↓ 1.0 9,285 1

Seq Scan on document_control dc_2 (cost=0.00..254.73 rows=9,272 width=8) (actual time=0.005..6.945 rows=9,285 loops=1)

  • Filter: (shiptolocid IS NOT NULL)
  • Rows Removed by Filter: 1
8. 67.853 67.853 ↑ 2.8 9,967 1

CTE Scan on doc_control_location_mapping dclm (cost=0.00..556.34 rows=27,817 width=8) (actual time=53.968..67.853 rows=9,967 loops=1)

9. 5.515 10.591 ↑ 1.0 10,012 1

Hash (cost=400.47..400.47 rows=10,247 width=45) (actual time=10.591..10.591 rows=10,012 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 891kB
10. 5.076 5.076 ↑ 1.0 10,012 1

Seq Scan on geo_location gl (cost=0.00..400.47 rows=10,247 width=45) (actual time=0.011..5.076 rows=10,012 loops=1)

Planning time : 0.295 ms
Execution time : 91.424 ms