explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cnR4

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.400 ↓ 1.5 23 1

WindowAgg (cost=10.93..52.16 rows=15 width=40) (actual time=0.383..0.400 rows=23 loops=1)

2.          

Initplan (forWindowAgg)

3. 0.002 0.034 ↑ 1.0 1 1

Limit (cost=0.00..10.93 rows=1 width=8) (actual time=0.033..0.034 rows=1 loops=1)

4. 0.032 0.032 ↑ 1.0 1 1

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

  • Filter: ((user_id = '49842546'::bigint) AND (status = 1))
  • Rows Removed by Filter: 75
5. 0.361 0.361 ↓ 1.5 23 1

Seq Scan on ws_mitra_warung info (cost=0.00..41.05 rows=15 width=32) (actual time=0.144..0.361 rows=23 loops=1)

  • Filter: (sobat_id = $0)
  • Rows Removed by Filter: 1746
Planning time : 0.180 ms
Execution time : 0.456 ms