explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gsCd : Optimization for: test; plan #of1G

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 12,288.063 ↓ 0.0 0 1
→

Update on temp_seperated_08082019010440_71924 (cost=513,059.88..881,934.91 rows=5,767,202 width=122) (actual time=12,288.063..12,288.063 rows=0 loops=1)

2. 3,492.332 12,288.061 ↓ 0.0 0 1
→

Seq Scan on temp_seperated_08082019010440_71924 (cost=513,059.88..881,934.91 rows=5,767,202 width=122) (actual time=12,288.061..12,288.061 rows=0 loops=1)

  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 11534336
3.          

SubPlan (forSeq Scan)
4. 6,649.106 8,795.729 ↑ 34.9 11 1
→

HashAggregate (cost=513,055.08..513,058.92 rows=384 width=46) (actual time=8,795.724..8,795.729 rows=11 loops=1)

  • Group Key: temp_seperated_08082019010440_71924_1.splitfields, temp_seperated_08082019010440_71924_1.field, temp_seperated_08082019010440_71924_1.workproduct, temp_seperated_08082019010440_71924_1.parentlabel, temp_seperated_08082019010440_71924_1.parentgroup
5. 2,146.623 2,146.623 ↑ 1.0 11,534,336 1
→

Seq Scan on temp_seperated_08082019010440_71924 temp_seperated_08082019010440_71924_1 (cost=0.00..340,039.03 rows=11,534,403 width=46) (actual time=0.002..2,146.623 rows=11,534,336 loops=1)

Planning time : 0.159 ms