explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MWQT

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

Limit (cost=25.10..48.25 rows=1 width=2,101) (actual time=0.008..0.008 rows=0 loops=1)

2. 0.001 0.008 ↓ 0.0 0 1

Nested Loop (cost=25.10..48.25 rows=1 width=2,101) (actual time=0.008..0.008 rows=0 loops=1)

  • Join Filter: (tp.id = pc.threat_product_id)
3. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=24.67..39.97 rows=1 width=1,657) (actual time=0.007..0.007 rows=0 loops=1)

  • Join Filter: (tp.status_id = s.id)
4. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=24.67..38.81 rows=1 width=1,403) (actual time=0.007..0.007 rows=0 loops=1)

  • Join Filter: (pv.product_id = p.id)
5. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=24.67..37.72 rows=1 width=891) (actual time=0.007..0.007 rows=0 loops=1)

  • Join Filter: (tp.product_version_id = pv.id)
6. 0.001 0.007 ↓ 0.0 0 1

Hash Join (cost=24.67..36.61 rows=1 width=617) (actual time=0.007..0.007 rows=0 loops=1)

  • Hash Cond: (pf.threat_product_id = tp.id)
7. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on product_file pf (cost=0.00..11.40 rows=140 width=520) (actual time=0.006..0.006 rows=0 loops=1)

8. 0.000 0.000 ↓ 0.0 0

Hash (cost=24.61..24.61 rows=5 width=97) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Scan using threat_product_idx on threat_product tp (cost=0.55..24.61 rows=5 width=97) (never executed)

  • Index Cond: (threat_sha256 = 'D22BBC6EAEBF3CFE2A5C60B6B03C0E7EDCC972B255997763BBD2786B77135993'::bpchar)
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on product_version pv (cost=0.00..1.05 rows=5 width=282) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Seq Scan on product p (cost=0.00..1.04 rows=4 width=520) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Seq Scan on status s (cost=0.00..1.07 rows=7 width=262) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using product_content_threat_product_idx on product_content pc (cost=0.42..8.27 rows=1 width=460) (never executed)

  • Index Cond: (threat_product_id = pf.threat_product_id)