explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cjFV

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

Limit (cost=1.13..396.19 rows=1 width=234) (actual time=2.513..2.515 rows=1 loops=1)

2. 0.002 2.512 ↑ 6.0 1 1

Nested Loop (cost=1.13..2,371.50 rows=6 width=234) (actual time=2.512..2.512 rows=1 loops=1)

3. 0.001 2.497 ↑ 6.0 1 1

Nested Loop (cost=0.98..2,370.48 rows=6 width=93) (actual time=2.497..2.497 rows=1 loops=1)

4. 0.009 2.485 ↑ 1.0 1 1

Nested Loop (cost=0.70..2,369.47 rows=1 width=117) (actual time=2.485..2.485 rows=1 loops=1)

5. 2.454 2.454 ↑ 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=2.454..2.454 rows=1 loops=1)

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

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

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

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

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

Index Scan using tags_pkey on tag (cost=0.15..0.17 rows=1 width=29) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (id = ft.tag_id)
  • Filter: (name ~~ 'SDD:%'::text)
Planning time : 2.180 ms