explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C0wt

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 0.138 ↑ 109.0 14 1

Hash Join (cost=5.04..43.69 rows=1,526 width=8) (actual time=0.133..0.138 rows=14 loops=1)

  • Hash Cond: (tmp_auditlognotreferenced_30625.adhoccheckid = tbladhoccheck.adhoccheckid)
2. 0.031 0.031 ↑ 161.4 14 1

Seq Scan on tmp_auditlognotreferenced_30625 (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.030..0.031 rows=14 loops=1)

3. 0.029 0.072 ↑ 1.0 135 1

Hash (cost=3.35..3.35 rows=135 width=4) (actual time=0.072..0.072 rows=135 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
4. 0.043 0.043 ↑ 1.0 135 1

Seq Scan on tbladhoccheck (cost=0.00..3.35 rows=135 width=4) (actual time=0.019..0.043 rows=135 loops=1)

Planning time : 0.989 ms
Execution time : 0.224 ms