explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WrGM

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

Limit (cost=30.41..30.41 rows=1 width=3,386) (actual time=0.035..0.035 rows=0 loops=1)

2. 0.006 0.035 ↓ 0.0 0 1

Sort (cost=30.41..30.41 rows=1 width=3,386) (actual time=0.035..0.035 rows=0 loops=1)

  • Sort Key: issue.created_ts DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.029 ↓ 0.0 0 1

Nested Loop (cost=22.45..30.40 rows=1 width=3,386) (actual time=0.029..0.029 rows=0 loops=1)

4. 0.003 0.030 ↓ 0.0 0 1

HashAggregate (cost=22.02..22.03 rows=1 width=8) (actual time=0.029..0.030 rows=0 loops=1)

  • Group Key: isin.issue_id
5. 0.000 0.027 ↓ 0.0 0 1

Nested Loop (cost=9.01..22.02 rows=1 width=8) (actual time=0.027..0.027 rows=0 loops=1)

6. 0.001 0.027 ↓ 0.0 0 1

Bitmap Heap Scan on interaction inte (cost=8.87..12.88 rows=1 width=8) (actual time=0.027..0.027 rows=0 loops=1)

  • Recheck Cond: ((created_by_person_id = 1) OR (behalf_of_person_id = 1))
7. 0.001 0.026 ↓ 0.0 0 1

BitmapOr (cost=8.87..8.87 rows=1 width=0) (actual time=0.026..0.026 rows=0 loops=1)

8. 0.018 0.018 ↓ 0.0 0 1

Bitmap Index Scan on interaction_created_by_person_id_idx (cost=0.00..4.43 rows=1 width=0) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (created_by_person_id = 1)
9. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on interaction_behalf_of_person_id_idx (cost=0.00..4.43 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (behalf_of_person_id = 1)
10. 0.000 0.000 ↓ 0.0 0

Index Only Scan using issue_interaction_issue_id_interaction_id_idx on issue_interaction isin (cost=0.14..9.13 rows=1 width=16) (never executed)

  • Index Cond: (interaction_id = inte.id)
  • Heap Fetches: 0
11. 0.000 0.000 ↓ 0.0 0

Index Scan using issue_pkey on issue (cost=0.42..8.35 rows=1 width=3,386) (never executed)

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