explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sfpW

Settings
# exclusive inclusive rows x rows loops node
1. 0.202 24.037 ↓ 16.5 611 1

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

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

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

3. 23.741 23.741 ↓ 1.4 611 1

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

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

Hash (cost=1.17..1.17 rows=17 width=8) (actual time=0.019..0.020 rows=17 loops=1)

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

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

Planning time : 3,574.916 ms