explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VLCj

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 125.232 ↑ 1.0 1 1

Aggregate (cost=56,295.11..56,295.12 rows=1 width=8) (actual time=125.232..125.232 rows=1 loops=1)

2. 0.048 125.214 ↑ 1.0 207 1

Group (cost=28,172.87..56,292.52 rows=207 width=18) (actual time=125.153..125.214 rows=207 loops=1)

  • Group Key: properties_client.id, ((SubPlan 1)), people_contactdetails.name
3. 0.182 125.166 ↑ 1.0 207 1

Sort (cost=28,172.87..28,173.38 rows=207 width=18) (actual time=125.152..125.166 rows=207 loops=1)

  • Sort Key: properties_client.id, ((SubPlan 1)), people_contactdetails.name
  • Sort Method: quicksort Memory: 41kB
4. 0.510 124.984 ↑ 1.0 207 1

Hash Join (cost=13.41..28,164.90 rows=207 width=18) (actual time=1.601..124.984 rows=207 loops=1)

  • Hash Cond: (people_contactdetails.id = properties_client.primary_contact_id)
5. 0.115 0.115 ↑ 1.0 1,152 1

Seq Scan on people_contactdetails (cost=0.00..27.52 rows=1,152 width=10) (actual time=0.005..0.115 rows=1,152 loops=1)

6. 0.039 0.159 ↑ 1.0 207 1

Hash (cost=10.82..10.82 rows=207 width=8) (actual time=0.159..0.159 rows=207 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
7. 0.120 0.120 ↑ 1.0 207 1

Seq Scan on properties_client (cost=0.00..10.82 rows=207 width=8) (actual time=0.005..0.120 rows=207 loops=1)

  • Filter: is_active
  • Rows Removed by Filter: 175
8.          

SubPlan (for Hash Join)

9. 0.828 124.200 ↑ 1.0 1 207

GroupAggregate (cost=0.27..135.83 rows=1 width=12) (actual time=0.600..0.600 rows=1 loops=207)

  • Group Key: u0.id
10. 0.828 123.372 ↓ 10.0 10 207

Nested Loop Left Join (cost=0.27..135.82 rows=1 width=11) (actual time=0.274..0.596 rows=10 loops=207)

  • Join Filter: (u0.id = u1.client_id)
11. 0.414 0.414 ↑ 1.0 1 207

Index Only Scan using properties_client_pkey on properties_client u0 (cost=0.27..4.29 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=207)

  • Index Cond: (id = properties_client.id)
  • Heap Fetches: 0
12. 122.130 122.130 ↓ 1.1 10 207

Seq Scan on properties_property u1 (cost=0.00..131.41 rows=9 width=11) (actual time=0.270..0.590 rows=10 loops=207)

  • Filter: (client_id = properties_client.id)
  • Rows Removed by Filter: 2343
Planning time : 1.271 ms
Execution time : 125.340 ms