explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dniv

Settings

Optimization(s) for this plan:

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

Aggregate (cost=0.00..1,351.13 rows=1 width=8) (actual rows= loops=)

  • Optimizer status: PQO version 3.21.0
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,351.13 rows=1 width=1) (actual rows= loops=)

  • Hash Cond: endpoint_application_months.application_id::bigint = public.applicationgroup0.app_id
3. 0.000 0.000 ↓ 0.0

Gather Motion 3:1 (slice1; segments: 3) (cost=0.00..489.13 rows=1 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Table Scan on endpoint_application_months (cost=0.00..489.13 rows=1 width=4) (actual rows= loops=)

  • Filter: org_id = 160090 AND endpoint_id > 0
5. 0.000 0.000 ↓ 0.0

Hash (cost=862.00..862.00 rows=1 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.00 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: public.applicationgroup0.export_id = (max((max(public.applicationgroup0.export_id))))
7. 0.000 0.000 ↓ 0.0

Gather Motion 3:1 (slice2; segments: 3) (cost=0.00..431.00 rows=1 width=16) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Table Scan on applicationgroup0 (cost=0.00..431.00 rows=1 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Aggregate (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Gather Motion 3:1 (slice3; segments: 3) (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Aggregate (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Table Scan on applicationgroup0 (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)