explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yne2

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.054 ↑ 351.0 1 1

HashAggregate (cost=1,055.93..1,059.44 rows=351 width=24) (actual time=0.053..0.054 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.045 ↑ 351.0 1 1

Append (cost=0.43..1,051.55 rows=351 width=24) (actual time=0.021..0.045 rows=1 loops=1)

3. 0.022 0.022 ↑ 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.021..0.022 rows=1 loops=1)

  • Index Cond: (k00_numpre = 66314539)
4. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (k00_numpre = 66314539)
5. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

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

Bitmap Heap Scan on arresusp (cost=4.29..9.76 rows=2 width=24) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (k00_numpre = 66314539)
7. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on arresusp_numpre_in (cost=0.00..4.29 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (k00_numpre = 66314539)
Planning time : 0.332 ms
Execution time : 0.129 ms