explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kw8B

Settings
# exclusive inclusive rows x rows loops node
1. 756,777.097 1,033,861.040 ↓ 0.0 0 1

Update on "mt_transactions_SICAR_b_table" gta (cost=0.00..956,803.21 rows=1,245,353 width=1,000) (actual time=1,033,861.040..1,033,861.040 rows=0 loops=1)

2. 8,327.102 277,083.943 ↓ 2.0 2,455,745 1

Nested Loop (cost=0.00..956,803.21 rows=1,245,353 width=1,000) (actual time=0.095..277,083.943 rows=2,455,745 loops=1)

3. 28,093.831 28,093.831 ↓ 1.4 2,455,745 1

Seq Scan on "mt_transactions_SICAR_b_table" gta (cost=0.00..910,366.27 rows=1,751,150 width=990) (actual time=0.062..28,093.831 rows=2,455,745 loops=1)

  • Filter: ((sellercar IS NOT NULL) AND (sellercar IS NOT NULL))
  • Rows Removed by Filter: 1006682
4. 240,663.010 240,663.010 ↑ 1.0 1 2,455,745

Index Scan using idx_a_propriedades_unicas_car on a_propriedades_unicas fromprop (cost=0.00..0.03 rows=1 width=54) (actual time=0.098..0.098 rows=1 loops=2,455,745)

  • Index Cond: ((car)::text = (gta.sellercar)::text)
Planning time : 156.992 ms