explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eQnl

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.040 ↑ 1.0 1 1

"Limit (cost=1.26..16.24 rows=1 width=1,068) (actual time=0.039..0.040 rows=1 loops=1)

2. 0.003 0.039 ↑ 11,950,157.0 1 1

Nested Loop Left Join (cost=1.26..179,081,295.82 rows=11,950,157 width=1,068) (actual time=0.039..0.039 rows=1 loops=1)

  • Join Filter: (pmve.""PMVE_ID"" = ve.""VE_K_PMVE_ID"")
  • Rows Removed by Join Filter: 13
3. 0.001 0.018 ↑ 11,950,157.0 1 1

Nested Loop (cost=1.26..176,571,761.67 rows=11,950,157 width=836) (actual time=0.018..0.018 rows=1 loops=1)

4. 0.001 0.016 ↑ 11,950,157.0 1 1

Nested Loop (cost=0.99..127,848,721.02 rows=11,950,157 width=789) (actual time=0.016..0.016 rows=1 loops=1)

5. 0.001 0.013 ↑ 11,950,157.0 1 1

Nested Loop (cost=0.71..76,381,428.46 rows=11,950,157 width=789) (actual time=0.013..0.013 rows=1 loops=1)

6. 0.010 0.010 ↑ 11,950,157.0 1 1

Index Scan using ""UNIQUE_T_EVENT_VE_EVVE_ID"" on ""T_EVENT_VE"" v_evve (cost=0.44..26,037,374.57 rows=11,950,157 width=755) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (""EVVE_ID"" > 1)
7. 0.002 0.002 ↑ 1.0 1 1

Index Scan using ""PK_T_VE_VE_ID"" on ""T_VE"" ve (cost=0.28..4.20 rows=1 width=38) (actual time=0.002..0.002 rows=1 loops=1)

  • Index Cond: (""VE_ID"" = v_evve.""EVVE_K_VE_ID"")
8. 0.002 0.002 ↑ 1.0 1 1

Index Scan using ""PK_T_GROUPEMENT_GRPM_ID"" on ""T_GROUPEMENT"" grpm (cost=0.27..4.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1)

  • Index Cond: (""GRPM_ID"" = ve.""VE_K_GRPM_ID"")
9. 0.001 0.001 ↑ 1.0 1 1

Index Scan using ""PK_T_SITE_SITE_ID"" on ""T_SITE"" site (cost=0.27..4.07 rows=1 width=51) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (""SITE_ID"" = grpm.""GRPM_K_SITE_ID"")
10. 0.005 0.018 ↑ 1.0 14 1

Materialize (cost=0.00..1.21 rows=14 width=240) (actual time=0.015..0.018 rows=14 loops=1)

11. 0.013 0.013 ↑ 1.0 14 1

Seq Scan on ""T_PARAM_MODELE_VE"" pmve (cost=0.00..1.14 rows=14 width=240) (actual time=0.012..0.013 rows=14 loops=1)

Planning time : 0.631 ms
Execution time : 0.131 ms