explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lrzf

Settings
# exclusive inclusive rows x rows loops node
1. 7.293 25.290 ↓ 0.0 0 1

Gather (cost=1,002.31..7,263.48 rows=1 width=37) (actual time=21.717..25.290 rows=0 loops=1)

  • Workers Planned: 2
  • Params Evaluated: $0
  • Workers Launched: 2
2.          

Initplan (forGather)

3. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ws_mitra_warung_mitra_id_unq on ws_mitra_warung (cost=0.29..2.31 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (mitra_id = 528788)
4. 17.985 17.985 ↓ 0.0 0 3

Parallel Seq Scan on ws_mitra_warung_answer (cost=0.00..6,261.07 rows=1 width=37) (actual time=17.985..17.985 rows=0 loops=3)

  • Filter: ((question_id = 26) AND (warung_id = $0))
  • Rows Removed by Filter: 113763
Planning time : 0.080 ms
Execution time : 25.317 ms