explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y4c3

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.113 ↑ 351.0 1 1

HashAggregate (cost=1,065.20..1,068.71 rows=351 width=24) (actual time=0.113..0.113 rows=1 loops=1)

  • Group Key: arrecad.k00_numpre, arrecad.k00_numpar, arrecad.k00_receit, arrecad.k00_dtvenc, arrecad.k00_valor
2. 0.000 0.108 ↑ 351.0 1 1

Append (cost=0.43..1,060.81 rows=351 width=24) (actual time=0.011..0.108 rows=1 loops=1)

3. 0.012 0.012 ↑ 96.0 1 1

Index Scan using arrecad_numpre_receit_in on arrecad (cost=0.43..362.94 rows=96 width=24) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: (k00_numpre = 66314539)
4. 0.005 0.005 ↓ 0.0 0 1

Index Scan using arrecant_numpre_numpar_in on arrecant (cost=0.44..245.75 rows=84 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (k00_numpre = 66314539)
5. 0.010 0.010 ↓ 0.0 0 1

Index Scan using arreold_numpre_numpar_receit_in on arreold (cost=0.56..429.59 rows=169 width=24) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (k00_numpre = 66314539)
6. 0.081 0.081 ↓ 0.0 0 1

Seq Scan on arresusp (cost=0.00..19.02 rows=2 width=24) (actual time=0.081..0.081 rows=0 loops=1)

  • Filter: (k00_numpre = 66314539)
  • Rows Removed by Filter: 642
Planning time : 0.190 ms
Execution time : 0.153 ms