explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wKT4 : kejadian_1

Settings
# exclusive inclusive rows x rows loops node
1. 700.774 286,055.633 ↓ 7.2 185,957 1

Nested Loop (cost=1.00..272,875.75 rows=25,950 width=64) (actual time=173.281..286,055.633 rows=185,957 loops=1)

2. 166,714.293 166,714.293 ↓ 7.2 185,957 1

Index Scan using kejadian_tipe_date_del on kejadian k (cost=0.56..63,376.63 rows=25,950 width=16) (actual time=172.914..166,714.293 rows=185,957 loops=1)

  • Index Cond: (((createdon)::date >= '2018-07-01'::date) AND ((createdon)::date <= '2018-07-30'::date) AND (idtipekejadian = 1))
3. 118,640.566 118,640.566 ↑ 1.0 1 185,957

Index Scan using hewan_pkey on hewan h (cost=0.44..7.57 rows=1 width=8) (actual time=0.638..0.638 rows=1 loops=185,957)

  • Index Cond: (id = k.idhewan)
Planning time : 0.222 ms
Execution time : 286,067.140 ms