explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 68AM

Settings
# exclusive inclusive rows x rows loops node
1. 1.906 3.509 ↓ 1.0 2,201 1

Hash Right Join (cost=4.21..96.67 rows=2,195 width=199) (actual time=0.159..3.509 rows=2,201 loops=1)

  • Hash Cond: (ph.gv_id = g.id)
2. 1.471 1.471 ↑ 1.0 2,195 1

Seq Scan on plugging_history ph (cost=0.00..64.95 rows=2,195 width=64) (actual time=0.010..1.471 rows=2,195 loops=1)

3. 0.062 0.132 ↑ 1.0 98 1

Hash (cost=2.98..2.98 rows=98 width=135) (actual time=0.132..0.132 rows=98 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
4. 0.070 0.070 ↑ 1.0 98 1

Seq Scan on gv g (cost=0.00..2.98 rows=98 width=135) (actual time=0.036..0.070 rows=98 loops=1)

Planning time : 0.927 ms
Execution time : 3.857 ms