explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1X9J

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.872 ↑ 4.0 1 1

Nested Loop Left Join (cost=330.69..342.02 rows=4 width=1,521) (actual time=0.865..0.872 rows=1 loops=1)

2. 0.001 0.868 ↑ 4.0 1 1

Nested Loop Left Join (cost=330.55..341.07 rows=4 width=1,494) (actual time=0.863..0.868 rows=1 loops=1)

3. 0.003 0.861 ↑ 4.0 1 1

Nested Loop Left Join (cost=330.40..339.82 rows=4 width=1,466) (actual time=0.857..0.861 rows=1 loops=1)

4. 0.003 0.853 ↑ 4.0 1 1

Nested Loop Left Join (cost=330.26..338.09 rows=4 width=1,406) (actual time=0.850..0.853 rows=1 loops=1)

5. 0.004 0.850 ↑ 4.0 1 1

Nested Loop Left Join (cost=330.11..336.16 rows=4 width=1,384) (actual time=0.847..0.850 rows=1 loops=1)

6. 0.029 0.840 ↑ 4.0 1 1

Hash Semi Join (cost=329.97..332.98 rows=4 width=940) (actual time=0.838..0.840 rows=1 loops=1)

  • Hash Cond: (issue.id = "ANY_subquery".id)
7. 0.074 0.074 ↑ 1.0 77 1

Seq Scan on issue (cost=0.00..2.77 rows=77 width=940) (actual time=0.031..0.074 rows=77 loops=1)

8. 0.003 0.737 ↑ 4.0 1 1

Hash (cost=329.92..329.92 rows=4 width=8) (actual time=0.737..0.737 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.000 0.734 ↑ 4.0 1 1

Subquery Scan on ANY_subquery (cost=329.87..329.92 rows=4 width=8) (actual time=0.733..0.734 rows=1 loops=1)

10. 0.001 0.734 ↑ 4.0 1 1

Limit (cost=329.87..329.88 rows=4 width=16) (actual time=0.733..0.734 rows=1 loops=1)

11. 0.011 0.733 ↑ 4.0 1 1

Sort (cost=329.87..329.88 rows=4 width=16) (actual time=0.732..0.733 rows=1 loops=1)

  • Sort Key: issue_1.created_ts DESC
  • Sort Method: quicksort Memory: 25kB
12. 0.114 0.722 ↑ 4.0 1 1

Seq Scan on issue issue_1 (cost=0.00..329.83 rows=4 width=16) (actual time=0.721..0.722 rows=1 loops=1)

  • Filter: ((created_ts > '2019-01-01 00:00:00+02'::timestamp with time zone) AND (SubPlan 1))
  • Rows Removed by Filter: 76
13.          

SubPlan (forSeq Scan)

14. 0.088 0.608 ↓ 0.0 0 8

Hash Join (cost=2.09..4.25 rows=1 width=0) (actual time=0.076..0.076 rows=0 loops=8)

  • Hash Cond: (inte.id = isin.interaction_id)
15. 0.288 0.288 ↑ 1.7 22 8

Seq Scan on interaction inte (cost=0.00..2.00 rows=38 width=8) (actual time=0.005..0.036 rows=22 loops=8)

  • Filter: ((created_by_person_id = 1) OR (behalf_of_person_id = 1))
  • Rows Removed by Filter: 37
16. 0.048 0.232 ↓ 2.0 2 8

Hash (cost=2.08..2.08 rows=1 width=8) (actual time=0.029..0.029 rows=2 loops=8)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 0.184 0.184 ↓ 2.0 2 8

Seq Scan on issue_interaction isin (cost=0.00..2.08 rows=1 width=8) (actual time=0.019..0.023 rows=2 loops=8)

  • Filter: (issue_id = issue_1.id)
  • Rows Removed by Filter: 84
18. 0.006 0.006 ↓ 0.0 0 1

Index Scan using issue_external_reference_issue_id_type_external_id_idx on issue_external_reference iser (cost=0.14..0.78 rows=1 width=452) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (issue_id = issue.id)
19. 0.000 0.000 ↓ 0.0 0 1

Index Scan using person_pkey on person pers_next_inte (cost=0.14..0.47 rows=1 width=22) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (id = issue.next_interaction_person_id)
20. 0.005 0.005 ↑ 1.0 1 1

Index Scan using customer_pkey on customer cust (cost=0.14..0.42 rows=1 width=60) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (id = issue.customer_id)
21. 0.006 0.006 ↑ 1.0 1 1

Index Scan using person_pkey on person pers_owner (cost=0.14..0.30 rows=1 width=36) (actual time=0.005..0.006 rows=1 loops=1)

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

Index Scan using legal_entity_pkey on legal_entity leen (cost=0.14..0.23 rows=1 width=35) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (id = cust.legal_entity_id)