explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cgbQ : test

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

Hash Join (cost=6.18..46.14 rows=1 width=1,497) (actual rows= loops=)

  • Hash Cond: (nodes.id = equipment_detail.id)
2. 0.000 0.000 ↓ 0.0

Index Scan using nodes_system_node_type_id_idx on nodes (cost=0.42..21.68 rows=184 width=1,308) (actual rows= loops=)

  • Index Cond: (system_node_type_id = 8)
3. 0.000 0.000 ↓ 0.0

Hash (cost=3.67..3.67 rows=167 width=109) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on equipment_detail (cost=0.00..3.67 rows=167 width=109) (actual rows= loops=)

5.          

SubPlan (for Hash Join)

6. 0.000 0.000 ↓ 0.0

Seq Scan on system_node_types (cost=0.00..1.48 rows=1 width=32) (actual rows= loops=)

  • Filter: (id = nodes.system_node_type_id)
7. 0.000 0.000 ↓ 0.0

Index Scan using nodes_pkey on nodes td (cost=0.42..8.44 rows=1 width=33) (actual rows= loops=)

  • Index Cond: (id = nodes.type_id)
8. 0.000 0.000 ↓ 0.0

Index Scan using fqns_pkey on fqns f (cost=0.29..8.31 rows=1 width=123) (actual rows= loops=)

  • Index Cond: (id = nodes.fqn_id)