explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R7g3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.153 ↑ 1.0 10 1

Limit (cost=0.00..2.74 rows=10 width=1,129) (actual time=0.127..0.153 rows=10 loops=1)

2. 0.000 0.153 ↑ 76,451.3 10 1

Nested Loop (cost=0.00..209,411.67 rows=764,513 width=1,129) (actual time=0.127..0.153 rows=10 loops=1)

  • Join Filter: (pv.product_id = p.id)
  • Rows Removed by Join Filter: 28
3. 0.004 0.143 ↑ 76,451.3 10 1

Nested Loop (cost=0.00..163,539.84 rows=764,513 width=617) (actual time=0.121..0.143 rows=10 loops=1)

  • Join Filter: (tp.product_version_id = pv.id)
  • Rows Removed by Join Filter: 37
4. 0.009 0.129 ↑ 76,451.3 10 1

Nested Loop (cost=0.00..106,200.30 rows=764,513 width=343) (actual time=0.117..0.129 rows=10 loops=1)

  • Join Filter: (s.id = tp.status_id)
  • Rows Removed by Join Filter: 45
5. 0.110 0.110 ↑ 89,193.2 10 1

Seq Scan on threat_product tp (cost=0.00..25,925.32 rows=891,932 width=89) (actual time=0.109..0.110 rows=10 loops=1)

6. 0.004 0.010 ↑ 1.0 6 10

Materialize (cost=0.00..1.12 rows=6 width=262) (actual time=0.001..0.001 rows=6 loops=10)

7. 0.006 0.006 ↑ 1.0 6 1

Seq Scan on status s (cost=0.00..1.09 rows=6 width=262) (actual time=0.005..0.006 rows=6 loops=1)

  • Filter: (id <> 2)
  • Rows Removed by Filter: 1
8. 0.008 0.010 ↑ 1.0 5 10

Materialize (cost=0.00..1.07 rows=5 width=282) (actual time=0.000..0.001 rows=5 loops=10)

9. 0.002 0.002 ↑ 1.0 5 1

Seq Scan on product_version pv (cost=0.00..1.05 rows=5 width=282) (actual time=0.002..0.002 rows=5 loops=1)

10. 0.008 0.010 ↑ 1.0 4 10

Materialize (cost=0.00..1.06 rows=4 width=520) (actual time=0.000..0.001 rows=4 loops=10)

11. 0.002 0.002 ↑ 1.0 4 1

Seq Scan on product p (cost=0.00..1.04 rows=4 width=520) (actual time=0.001..0.002 rows=4 loops=1)