explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RnId

Settings
# exclusive inclusive rows x rows loops node
1. 4,963.534 4,963.534 ↑ 1.3 17,780,059 1

Hash Join (cost=831205.33..2077668.92 rows=433962 width=8) (actual time=6471.631..8102.799 rows=1 loops=1)Hash Cond: (node.id = aspect.node_id)-> Seq Scan on alf_node node (cost=0.00..1,156,770.14 rows=22,527,673 width=8) (actual time=0.013..4,963.534 rows=17,780,059 loops=1)

Planning time : 0.538 ms