explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MntY

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

Nested Loop Left Join (cost=25.93..58.22 rows=14 width=6,766) (actual time=0.011..0.011 rows=0 loops=1)

2. 0.000 0.011 ↓ 0.0 0 1

Nested Loop Left Join (cost=25.79..51.48 rows=2 width=6,322) (actual time=0.011..0.011 rows=0 loops=1)

3. 0.000 0.011 ↓ 0.0 0 1

Nested Loop Left Join (cost=25.65..50.17 rows=2 width=5,714) (actual time=0.011..0.011 rows=0 loops=1)

4. 0.001 0.011 ↓ 0.0 0 1

Nested Loop Left Join (cost=25.51..48.85 rows=2 width=5,186) (actual time=0.011..0.011 rows=0 loops=1)

5. 0.001 0.010 ↓ 0.0 0 1

Nested Loop Left Join (cost=25.36..42.11 rows=2 width=4,982) (actual time=0.010..0.010 rows=0 loops=1)

6. 0.000 0.009 ↓ 0.0 0 1

Hash Semi Join (cost=25.22..35.37 rows=2 width=4,538) (actual time=0.009..0.009 rows=0 loops=1)

  • Hash Cond: (issue.id = "ANY_subquery".id)
7. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on issue (cost=0.00..10.10 rows=10 width=4,538) (actual time=0.009..0.009 rows=0 loops=1)

8. 0.000 0.000 ↓ 0.0 0

Hash (cost=25.20..25.20 rows=2 width=8) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Subquery Scan on ANY_subquery (cost=25.17..25.20 rows=2 width=8) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Limit (cost=25.17..25.18 rows=2 width=16) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Sort (cost=25.17..25.18 rows=2 width=16) (never executed)

  • Sort Key: issue_1.created_ts DESC
12. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=22.73..25.16 rows=2 width=16) (never executed)

13. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=22.59..22.64 rows=5 width=8) (never executed)

  • Group Key: isin.issue_id
14. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=10.78..22.58 rows=5 width=8) (never executed)

  • Hash Cond: (isin.interaction_id = inte.id)
15. 0.000 0.000 ↓ 0.0 0

Seq Scan on issue_interaction isin (cost=0.00..11.30 rows=130 width=16) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.75..10.75 rows=2 width=8) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on interaction inte (cost=0.00..10.75 rows=2 width=8) (never executed)

  • Filter: ((created_by_person_id = 1) OR (behalf_of_person_id = 1))
18. 0.000 0.000 ↓ 0.0 0

Index Scan using issue_pkey on issue issue_1 (cost=0.14..0.49 rows=1 width=16) (never executed)

  • Index Cond: (id = isin.issue_id)
  • Filter: (created_ts > '2019-01-01 00:00:00+02'::timestamp with time zone)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person pers_next_inte (cost=0.14..3.36 rows=1 width=444) (never executed)

  • Index Cond: (id = issue.next_interaction_person_id)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using customer_pkey on customer cust (cost=0.14..3.36 rows=1 width=204) (never executed)

  • Index Cond: (id = issue.customer_id)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person pers_owner (cost=0.14..0.65 rows=1 width=536) (never executed)

  • Index Cond: (id = cust.owner_person_id)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using legal_entity_pkey on legal_entity leen (cost=0.14..0.65 rows=1 width=616) (never executed)

  • Index Cond: (id = cust.legal_entity_id)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using issue_external_reference_issue_id_type_external_id_idx on issue_external_reference iser (cost=0.14..3.36 rows=1 width=452) (never executed)

  • Index Cond: (issue_id = issue.id)
Planning time : 2.898 ms
Execution time : 0.303 ms