explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jXpU

Settings
# exclusive inclusive rows x rows loops node
1. 0.050 0.950 ↓ 5.8 23 1

WindowAgg (cost=0.00..69.67 rows=4 width=40) (actual time=0.936..0.950 rows=23 loops=1)

2. 0.327 0.900 ↓ 5.8 23 1

Nested Loop (cost=0.00..69.61 rows=4 width=32) (actual time=0.251..0.900 rows=23 loops=1)

  • Join Filter: (info.sobat_id = sobat.id)
  • Rows Removed by Join Filter: 1746
3. 0.141 0.141 ↑ 1.0 1 1

Seq Scan on ws_mitra_sobat_mitra sobat (cost=0.00..10.93 rows=1 width=8) (actual time=0.054..0.141 rows=1 loops=1)

  • Filter: ((status = 1) AND (user_id = '49842546'::bigint))
  • Rows Removed by Filter: 324
4. 0.432 0.432 ↓ 1.0 1,769 1

Seq Scan on ws_mitra_warung info (cost=0.00..36.64 rows=1,764 width=32) (actual time=0.015..0.432 rows=1,769 loops=1)

Planning time : 0.459 ms
Execution time : 1.037 ms