explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YcKe

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

Insert on topcountries (cost=43.96..60.96 rows=850 width=662) (actual time=0.126..0.126 rows=0 loops=1)

2. 0.002 0.100 ↑ 170.0 5 1

Subquery Scan on *SELECT* (cost=43.96..60.96 rows=850 width=662) (actual time=0.096..0.100 rows=5 loops=1)

3. 0.008 0.098 ↑ 170.0 5 1

HashAggregate (cost=43.96..52.46 rows=850 width=178) (actual time=0.095..0.098 rows=5 loops=1)

  • Group Key: its.panjivacountrytrading, x0.countryname, x0.country, its.cik, its.totalshipments, its.totalshipmentweight, its.totalshipmentvolume
4. 0.005 0.090 ↑ 170.0 5 1

Hash Left Join (cost=8.32..29.09 rows=850 width=82) (actual time=0.088..0.090 rows=5 loops=1)

  • Hash Cond: ((its.panjivacountrytrading)::text = (x0.panjivacountry)::text)
5. 0.004 0.004 ↑ 170.0 5 1

Seq Scan on sudeep its (cost=0.00..18.50 rows=850 width=68) (actual time=0.003..0.004 rows=5 loops=1)

6. 0.041 0.081 ↑ 1.0 253 1

Hash (cost=5.16..5.16 rows=253 width=17) (actual time=0.081..0.081 rows=253 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
7. 0.040 0.040 ↑ 1.0 253 1

Seq Scan on panjivacountry x0 (cost=0.00..5.16 rows=253 width=17) (actual time=0.005..0.040 rows=253 loops=1)

  • Filter: (updoperation < 2)
Planning time : 0.223 ms