explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dt7u

Settings
# exclusive inclusive rows x rows loops node
1. 5.677 14.446 ↑ 1.0 1 1

HashAggregate (cost=1,920.98..1,920.99 rows=1 width=54) (actual time=14.446..14.446 rows=1 loops=1)

  • Group Key: u.title
2. 5.598 8.769 ↑ 1.0 24,697 1

Nested Loop (cost=0.00..1,550.53 rows=24,697 width=66) (actual time=0.036..8.769 rows=24,697 loops=1)

3. 0.026 0.026 ↑ 1.0 1 1

Seq Scan on ""user"" u (cost=0.00..3.59 rows=1 width=46) (actual time=0.021..0.026 rows=1 loops=1)

  • Filter: (id = 1,658,881)
  • Rows Removed by Filter: 47
4. 3.145 3.145 ↑ 1.0 24,697 1

Seq Scan on req_package2 rp (cost=0.00..1,299.97 rows=24,697 width=20) (actual time=0.008..3.145 rows=24,697 loops=1)

Planning time : 0.378 ms
Execution time : 14.524 ms