explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XPFH : Test

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Update on temp_seperated_08072019012846_71924 (cost=16.00..28.00 rows=80 width=471) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on temp_seperated_08072019012846_71924 (cost=16.00..28.00 rows=80 width=471) (actual rows= loops=)

  • Filter: (NOT (hashed SubPlan 1))
3.          

SubPlan (forSeq Scan)

4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=14.00..15.60 rows=160 width=168) (actual rows= loops=)

  • Group Key: temp_seperated_08072019012846_71924_1.splitfields, temp_seperated_08072019012846_71924_1.field, temp_seperated_08072019012846_71924_1.workproduct, temp_seperated_08072019012846_71924_1.parentlabel, temp_seperated_08072019012846_71924_1.parentgroup
5. 0.000 0.000 ↓ 0.0

Seq Scan on temp_seperated_08072019012846_71924 temp_seperated_08072019012846_71924_1 (cost=0.00..11.60 rows=160 width=168) (actual rows= loops=)