explain.depesz.com

PostgreSQL's explain analyze made readable

Result: veQn

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 5.318 ↑ 1.0 1 1

Limit (cost=1.13..2,383.46 rows=1 width=210) (actual time=5.315..5.318 rows=1 loops=1)

2. 0.004 5.315 ↑ 1.0 1 1

Nested Loop (cost=1.13..2,383.46 rows=1 width=210) (actual time=5.315..5.315 rows=1 loops=1)

  • Join Filter: (ft.tag_id = tag.id)
3. 0.002 5.268 ↑ 1.0 1 1

Nested Loop (cost=1.13..2,370.25 rows=1 width=69) (actual time=5.268..5.268 rows=1 loops=1)

4. 0.012 5.247 ↑ 1.0 1 1

Nested Loop (cost=0.84..2,369.61 rows=1 width=93) (actual time=5.247..5.247 rows=1 loops=1)

5. 5.199 5.199 ↑ 1.0 1 1

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

  • Index Cond: (threat_id = 95780)
6. 0.036 0.036 ↑ 1.0 1 1

Index Scan using files_pkey on file (cost=0.42..8.44 rows=1 width=53) (actual time=0.036..0.036 rows=1 loops=1)

  • Index Cond: (id = e.file_id)
7. 0.019 0.019 ↑ 13.0 1 1

Index Only Scan using file_tag_unique on file_tag ft (cost=0.29..0.51 rows=13 width=24) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (file_id = file.id)
  • Heap Fetches: 1
8. 0.043 0.043 ↑ 325.0 1 1

Seq Scan on tag (cost=0.00..9.15 rows=325 width=29) (actual time=0.043..0.043 rows=1 loops=1)

  • Filter: (name ~~ 'SDD:%'::text)
  • Rows Removed by Filter: 11
Planning time : 2.428 ms