explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DKSY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather Motion 1:1 (slice1; segments: 1) (cost=203.04..316.76 rows=298 width=57) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Append-Only Row-Oriented Scan on jiagu_loc_bs1_hk (cost=203.04..316.76 rows=3 width=57) (actual rows= loops=)

  • Recheck Cond: m1::text = '4a1659c90af44990bf16c9b259b3ee60'::text
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on id_jiagu_loc_bs1_hk_m1 (cost=0.00..202.96 rows=3 width=0) (actual rows= loops=)

  • Index Cond: m1::text = '4a1659c90af44990bf16c9b259b3ee60'::text