explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X31

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

Nested Loop (cost=1.14..10,121.63 rows=1,062 width=336) (actual time=0.015..0.015 rows=0 loops=1)

2. 0.015 0.015 ↓ 0.0 0 1

Index Only Scan using unique_service_group_member on nst_service_groups members0_ (cost=0.57..988.43 rows=1,062 width=16) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (group_id = 580005809::bigint)
  • Heap Fetches: 0
3. 0.000 0.000 ↓ 0.0 0

Index Scan using nst_services_pkey on nst_services service1_ (cost=0.57..8.59 rows=1 width=320) (never executed)

  • Index Cond: (id = members0_.member_id)