explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OEGe

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.006 7.307 ↓ 0.0 0 1

Limit (cost=1.13..198.37 rows=1 width=234) (actual time=7.306..7.307 rows=0 loops=1)

2. 0.001 7.301 ↓ 0.0 0 1

Nested Loop (cost=1.13..2,368.02 rows=12 width=234) (actual time=7.301..7.301 rows=0 loops=1)

3. 0.001 7.300 ↓ 0.0 0 1

Nested Loop (cost=0.98..2,365.98 rows=12 width=93) (actual time=7.300..7.300 rows=0 loops=1)

4. 0.013 7.299 ↓ 0.0 0 1

Nested Loop (cost=0.69..2,364.59 rows=1 width=117) (actual time=7.299..7.299 rows=0 loops=1)

5. 7.261 7.261 ↑ 1.0 1 1

Index Scan using threat_event_pkey on threat_event e (cost=0.42..2,356.28 rows=1 width=40) (actual time=1.241..7.261 rows=1 loops=1)

  • Index Cond: (threat_id = 13859)
6. 0.025 0.025 ↓ 0.0 0 1

Index Scan using files_pkey on file (cost=0.28..8.29 rows=1 width=77) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (id = e.file_id)
7. 0.000 0.000 ↓ 0.0 0

Index Only Scan using file_tag_unique on file_tag ft (cost=0.29..1.26 rows=13 width=24) (never executed)

  • Index Cond: (file_id = file.id)
  • Heap Fetches: 0
8. 0.000 0.000 ↓ 0.0 0

Index Scan using tags_pkey on tag (cost=0.15..0.17 rows=1 width=29) (never executed)

  • Index Cond: (id = ft.tag_id)