explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L1xG : teste

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

Limit (cost=0.28..45.14 rows=100 width=2,867) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..23,372.11 rows=52,098 width=2,867) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on venta (cost=0.00..6,527.98 rows=52,098 width=1,676) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using ind_clt_c_cpd_unique on clt (cost=0.28..0.31 rows=1 width=1,191) (actual rows= loops=)

  • Index Cond: (c_cpd = venta.c_cpdclt)