explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9yZZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.445 ↑ 3.0 1 1

Result (cost=0.00..55.72 rows=3 width=2,461) (actual time=0.438..0.445 rows=1 loops=1)

2. 0.008 0.438 ↑ 3.0 1 1

Append (cost=0.00..55.72 rows=3 width=2,461) (actual time=0.433..0.438 rows=1 loops=1)

3. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on activity (cost=0.00..0.00 rows=1 width=3,189) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (activity_key = 356193735)
4. 0.370 0.370 ↓ 0.0 0 1

Index Scan using pk_product_activity_old on activity_old activity (cost=0.00..47.45 rows=1 width=1,004) (actual time=0.370..0.370 rows=0 loops=1)

  • Index Cond: (activity_key = 356193735)
5. 0.057 0.057 ↑ 1.0 1 1

Index Scan using activity_35_pkey on activity_35 activity (cost=0.00..8.27 rows=1 width=3,189) (actual time=0.055..0.057 rows=1 loops=1)

  • Index Cond: (activity_key = 356193735)