explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xhcL

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

Sort (cost=2,498.30..2,498.30 rows=1 width=792) (actual rows= loops=)

  • Sort Key: a1.valor_campo, a5.valor_campo, a4.valor_campo
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.92..2,498.29 rows=1 width=792) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.36..2,489.81 rows=1 width=104) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.80..2,481.33 rows=1 width=88) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.24..2,472.85 rows=1 width=72) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.68..2,464.37 rows=1 width=56) (actual rows= loops=)

  • Join Filter: (a2.numero_fila = a1.numero_fila)
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..2,455.80 rows=1 width=48) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using scc_resultados_reportes_pkey on scc_resultados_reportes a2 (cost=0.56..2,051.95 rows=47 width=24) (actual rows= loops=)

  • Index Cond: ((reporte_id = '1570623371082'::bigint) AND ((campo_id)::text = 'CAMPO2_N'::text))
9. 0.000 0.000 ↓ 0.0

Index Scan using scc_resultados_reportes_pkey on scc_resultados_reportes a6 (cost=0.56..8.58 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((reporte_id = '1570623371082'::bigint) AND (numero_fila = a2.numero_fila) AND ((campo_id)::text = 'CAMPO6_N'::text))
10. 0.000 0.000 ↓ 0.0

Index Scan using scc_resultados_reportes_pkey on scc_resultados_reportes a1 (cost=0.56..8.56 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((reporte_id = '1570623371082'::bigint) AND (numero_fila = a6.numero_fila) AND ((campo_id)::text = 'CAMPO1_S'::text))
11. 0.000 0.000 ↓ 0.0

Index Scan using scc_resultados_reportes_pkey on scc_resultados_reportes a3 (cost=0.56..8.47 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((reporte_id = '1570623371082'::bigint) AND (numero_fila = a1.numero_fila) AND ((campo_id)::text = 'CAMPO3_N'::text))
12. 0.000 0.000 ↓ 0.0

Index Scan using scc_resultados_reportes_pkey on scc_resultados_reportes a4 (cost=0.56..8.47 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((reporte_id = '1570623371082'::bigint) AND (numero_fila = a1.numero_fila) AND ((campo_id)::text = 'CAMPO4_S'::text))
13. 0.000 0.000 ↓ 0.0

Index Scan using scc_resultados_reportes_pkey on scc_resultados_reportes a5 (cost=0.56..8.47 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((reporte_id = '1570623371082'::bigint) AND (numero_fila = a1.numero_fila) AND ((campo_id)::text = 'CAMPO5_S'::text))
14. 0.000 0.000 ↓ 0.0

Index Scan using scc_resultados_reportes_pkey on scc_resultados_reportes a7 (cost=0.56..8.47 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((reporte_id = '1570623371082'::bigint) AND (numero_fila = a1.numero_fila) AND ((campo_id)::text = 'CAMPO7_S'::text))