explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h9L7

Settings
# exclusive inclusive rows x rows loops node
1. 6.721 6.721 ↓ 11.2 34,052 1

Index Scan using customer_network_transitive_closure_parent_id on customer_network_transitive_closure a1 (cost=0.56..118.64 rows=3,033 width=48) (actual time=0.048..6.721 rows=34,052 loops=1)

  • Index Cond: (parent_customer_id = 1)