explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XpSw

Settings
# exclusive inclusive rows x rows loops node
1. 0.177 2.342 ↓ 16.5 611 1

Hash Join (cost=1.38..117.37 rows=37 width=8) (actual time=0.049..2.342 rows=611 loops=1)

  • Hash Cond: (datas_part_0000008825.idstatustype = statustypes.idstatustype)
2. 0.078 2.150 ↓ 1.4 611 1

Append (cost=0.00..114.81 rows=440 width=12) (actual time=0.026..2.150 rows=611 loops=1)

3. 2.072 2.072 ↓ 1.4 611 1

Seq Scan on datas_part_0000008825 (cost=0.00..112.61 rows=440 width=12) (actual time=0.024..2.072 rows=611 loops=1)

  • Filter: ((idevent <> 45678) AND (idaccount = 8825))
4. 0.007 0.015 ↑ 1.0 17 1

Hash (cost=1.17..1.17 rows=17 width=8) (actual time=0.014..0.015 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.008 0.008 ↑ 1.0 17 1

Seq Scan on statustypes (cost=0.00..1.17 rows=17 width=8) (actual time=0.005..0.008 rows=17 loops=1)

Planning time : 1,658.750 ms