explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XyOg

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

Update on dag_node (cost=411,159.22..470,388.01 rows=271,730 width=178) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=411,159.22..470,388.01 rows=271,730 width=178) (actual rows= loops=)

  • Hash Cond: (dag_node.object_id = t.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on dag_node (cost=0.00..50,963.54 rows=1,479,454 width=166) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=407,358.16..407,358.16 rows=304,085 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on term t (cost=0.00..407,358.16 rows=304,085 width=16) (actual rows= loops=)

  • Filter: (has_genes OR has_diseases OR has_chems OR has_marrays OR has_phenotypes OR has_comps)